CAN SOMEONE ANSWER The excel command normdist xmeanstdDev1 r

CAN SOMEONE ANSWER:??????

The excel command normdist (x,mean,stdDev,1) returns the value of P(X lessthanorequal to x) where X is normally distributed with the given mean and standard deviation. Use the NormDist Function to answer the following: The mean weight of male students at a certain university is 164 Pounds with a standard deviation of 9.4 Pounds.

1. What is the probability that a male student weighs at MOST 178 pounds?

2. What is the probability that a male student weighs at least 158 Pounds?

3. What is the probability that a male student weighs between 171 and 191 pounds?

Please Write out excel formula and equation. I am unsure how to type this into excel.. Thanks. Need HELP FAST

Solution

1.Normdist(178,164,9.4,1)=.93318

2. 1-Normdist(158,164,9.4,1)=1-.26164=.7383

3.Normdist(191,164,9.4,1)-Normdist(171,164,9.4,1)=.99796-.771768=.2261

CAN SOMEONE ANSWER:?????? The excel command normdist (x,mean,stdDev,1) returns the value of P(X lessthanorequal to x) where X is normally distributed with the g

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site