Question

I need step by step instructions on using Excel to do this assignment and the values I need to enter to compute what is being asked of me. I don't know how to use Excel and you tube is no help right now because I can't find specifics of what I need done. I'll post part two of this assignment as a seperate question. I need to get through part one first. Thanks...

1. Exercise 11   Section 3-1

11. Weight of coke.  Using Microsoft Excel, construct a frequency table for the weights (in pounds) given below of 36 cans of regular coke. Start the first bin at 0.7900 pound and use a bin width of 0.0050 pound. Discuss your findings.

0.8192    0.8194    0.8211    0.8176

0.8062    0.8143    0.8110    0.8152

0.7901    0.8152    0.8079    0.8161

0.8161    0.8163    0.8194    0.8247

0.8165    0.8172    0.8150    0.8264

0.8207    0.8073    0.8294    0.8170

0.8150    0.8189    0.8181    0.8284

0.8128    0.8229    0.8251    0.8244

0.8244    0.8126    0.8044    0.8192

2. Exercise 15   Section 3-2

15. Weight of Coke: Exercise 11 in Section 3.1 required the construction of a frequency table from the weights (in pounds) of 36 cans of regular coke. Use that frequency table to construct the corresponding histogram.

Answer 1

Solution:

Here, we have to construct the frequency table for the weights by using excel and again we have to construct the corresponding histogram by using excel. Required steps are given as below:

Enter all data in the first column. (You can enter it in any column.)

In next column, enter bin values. Take first value as 0.7900 and then add 0.0050 for next values. Find the maximum value of data. Stop process of finding bin value when it crosses maximum value.

You will get as below:

X	Bin
0.8192	0.7900
0.8062	0.7950
0.7901	0.8000
0.8161	0.8050
0.8165	0.8100
0.8207	0.8150
0.8150	0.8200
0.8128	0.8250
0.8244	0.8300
0.8194
0.8143
0.8152
0.8163
0.8172
0.8073
0.8189
0.8229
0.8126
0.8211
0.8110
0.8079
0.8194
0.8150
0.8294
0.8181
0.8251
0.8044
0.8176
0.8152
0.8161
0.8247
0.8264
0.8170
0.8284
0.8244
0.8192

Then click on data > click on data analysis > select histogram > fill all ranges and then press OK.

You will get the following results for frequency table and corresponding histogram: