I need step by step instructions on using Excel to do thisassignment and the values I need to enter to compute what is beingasked of me. I don't know how to use Excel and you tube is no helpright now because I can't find specifics of what I need done. I'llpost part two of this assignment as a seperate question. I need toget 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 belowof 36 cans of regular coke. Start the first bin at 0.7900 pound anduse a bin width of 0.0050 pound. Discuss yourfindings.
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 requiredthe construction of a frequency table from the weights (in pounds)of 36 cans of regular coke. Use that frequency table to constructthe corresponding histogram.