I need step by step instructions on using Excel to do this assignment and the values...

50.1K

Verified Solution

Question

Basic Math

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.

Answer & Explanation Solved by verified expert
3.7 Ratings (585 Votes)
SolutionHere we have to construct the frequency table for the weightsby using excel and again we have to construct the correspondinghistogram by using excel Required steps    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students