Does anyone know how to do it on EXCEL? Does anyone know how to do it...

60.1K

Verified Solution

Question

Basic Math

Does anyone know how to do it on EXCEL?
Does anyone know how to do it on EXCEL?
Does anyone know how to do it on EXCEL?
Does anyone know how to do it on EXCEL? Anyone know how to do iton EXCEL?
The Statistical Abstract of the United States published by theU.S. Census Bureau reports that the average annual consumption offresh fruit per person is 99.9 pounds. The standard deviation offresh fruit consumption is about 30 pounds. Suppose a researchertook a random sample of 38 people and had them keep a record of thefresh fruit they ate for one year.
a) What is the probability that the sample average would be lessthan 90 pounds?
b) What is the probability that the sample average would bebetween 98 and 105 pounds?
c) What is the probability that the sample average would be lessthan 112 pounds?
d) What is the probability that the sample average would be morethan 93 pounds?

Answer & Explanation Solved by verified expert

4.0 Ratings (673 Votes)

We can use NORMDIST function in excel to answer all the fourpartsNORMDISTx mean standarddev cumulativeNORMDIST gives the probability that a number falls at or belowa 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