In Excel, we will use the command/function NORM.INV to get the inverse cdf of no

Question

In Excel, we will use the command/function NORM.INV to get the inverse cdf of normal distributions. This command takes a left tail area (between 0 and 1) as it's first argument. The weights of bags of cookies are normally distributed with a mean of 15 ounces and a standard deviation of 0.85 ounces. Bags of cookies that have weights in the upper 7.5% are too heavy and must be repackaged. What is the most a bag of cookies can weigh and not need to be repackaged? Round to 2 decimal places. Use = NORM. INV(probability, mean, standard deviation). Some versions of Excel may have this command as NORMINV Probability is the probability to the left (when drawing the distribution) of the X value you are trying to obtain, similar to part A.

Explanation / Answer

Here mean=15 standard deviation=0.85 Probability =0.075 We use the excel formula Norm.INV(Probability,mean,sd) 13.77639825

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---