Question

For the measurement of weight of a structure, the following values were obtained from 30 samples. Calculate the statistical parameters (e.g. mean, mode, median and standard deviation) and plot a histogram. Measurement Data 100,09 101,13 101,13 99,73 100,54 95,75 98,63 96,75 104,22 108,85 101,89 93,55 103,02 99,33 101,24 92,75 107,09 94,57 103,25 103,46 100,04 100,09 98,71 103,11 95,83 103,49 101,25 98,11 106,16 98,95

Answer 1

Information given in the question is as under:

Sample	Weight of Structure
1	100.09
2	101.13
3	100.54
4	98.63
5	104.22
6	101.89
7	103.02
8	101.24
9	107.09
10	103.25
11	100.04
12	98.71
13	95.83
14	101.25
15	106.16
16	101.13
17	99.73
18	95.75
19	96.75
20	108.85
21	93.55
22	99.33
23	92.75
24	94.57
25	103.46
26	100.09
27	103.11
28	103.49
29	98.11
30	98.95

Comma (,) representing the decimal has been replaced by dot (.)

Insert the above data in MS Excel:

Use the Excel formulas as displayed under:

Mean	=AVERAGE(C2:C31)	100.42
Mode	=MODE(C2:C31)	100.09
Median	=MEDIAN(C2:C31)	100.32
Standard Deviation	=STDEV(C2:C31)	3.81

Select the values of weights for all samples.

Click on “Line” Tab and then “Column”

Select a column graph to create the Histogram: