11.5 Finding Raw Scores from Probabilities

The function NORM.INV(probability,mean,standard_dev), where probability is in the percentage form, will provide the raw value corresponding to the probability (or percentile).

  1. Select cell M1 and type the label 90th Percentile.
  2. In cell M2, type the label 95th Percentile.
  3. In cell M3, type the label 99th Percentile.
  4. In cell N1, type = NORM.INV(90%, $H$2,$H$4).

Note: Remember to include the $ symbol.

  1. Repeat Step 4 above to obtain the other percentiles, 95th in cell N2 and 99th in cell N3.