Question

Via Excel please

11. Weights of Coke. Construct a frequency table for the weights (in pounds) given below of 36 cans of regular Coke.

Answer 1

Class width is 0.005 and starting value of first class is 0.79

smallest value in the given data set is 0.7901 and largest value is 0.8295

Hence we get total of 8 class intervals. (Here class interval is exclusive type. i.e. include lower limit but exclude upper limit)

0.79 - 0.795, 0.795 - 0.8, 0.8 - 0.805, 0.805 - 0.81, 0.81 - 0.815, 0.815 - 0.82, 0.82 - 0.825, 0.825 - 0.83

Below is the frequency table along with ordered data set.

Data set is shaded with different colors to show the values lying in different classes.

Data set: (ordered from smallest to largest)

0.7901
0.8044
0.8062
0.8073
0.8079
0.811
0.8126
0.8128
0.8143
0.815
0.815
0.8152
0.8152
0.8161
0.8161
0.8165
0.817
0.8172
0.8176
0.8181
0.8189
0.8192
0.8192
0.8194
0.8194
0.8207
0.8211
0.8229
0.8244
0.8244
0.8247
0.8251
0.8263
0.8264
0.8284
0.8295

Frequency table:

Class	Frequency
0.79 - 0.795	1
0.795 - 0.8	0
0.8 - 0.805	1
0.805 - 0.81	3
0.81 - 0.815	4
0.815 - 0.82	16
0.82 - 0.825	6
0.825 - 0.83	5
Total	36