university of phoenix
posted by michelle .
The weight of a small Starbucks coffee is a random variable with a mean of 360 g and a standard
deviation of 9 g. Use Excel to find the weight corresponding to each percentile of weight.
a. 10th percentile b. 32nd percentile c. 75th percentile
d. 90th percentile e. 99.9th percentile f. 99.99th percentile
If you list the subject where is says "subject", instead of the university, you will usually get quicker results.
Since they are asking for a solution using Excel, I can't help you. There are many other ways to do this problem.
I don't use Excel.
Z = (score-mean)/SD
Find table in the back of your statistics text labeled something like "areas under normal distribution" to find the proportions and their corresponding Z scores. Insert values into equation above and calculate the scores.