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.
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
2 answers
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.
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.
1 answer