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.

To find the weight corresponding to each percentile of weight using Excel, you can use the NORM.INV function, which calculates the inverse of the cumulative normal distribution for a specified percentile.

Here's how you can find the weights for each percentile using Excel:

a. 10th percentile:
In a cell in Excel, you can use the formula "=NORM.INV(0.1, 360, 9)" to find the weight corresponding to the 10th percentile. This formula uses the NORM.INV function, where:
- The first argument is the percentile value (0.1 for 10th percentile).
- The second argument is the mean (360 g).
- The third argument is the standard deviation (9 g).
The resulting value will be the weight corresponding to the 10th percentile.

b. 32nd percentile:
In a cell in Excel, you can use the formula "=NORM.INV(0.32, 360, 9)" to find the weight corresponding to the 32nd percentile. Similarly, you can replace the first argument with the desired percentile value.

c. 75th percentile:
In a cell in Excel, you can use the formula "=NORM.INV(0.75, 360, 9)" to find the weight corresponding to the 75th percentile.

d. 90th percentile:
In a cell in Excel, you can use the formula "=NORM.INV(0.9, 360, 9)" to find the weight corresponding to the 90th percentile.

e. 99.9th percentile:
In a cell in Excel, you can use the formula "=NORM.INV(0.999, 360, 9)" to find the weight corresponding to the 99.9th percentile.

f. 99.99th percentile:
In a cell in Excel, you can use the formula "=NORM.INV(0.9999, 360, 9)" to find the weight corresponding to the 99.99th percentile.

By entering these formulas into respective cells in Excel, you can obtain the weights corresponding to each percentile.