Use inverse normal for percentiles

Press these keys

Walkthrough

1. 1
   Convert to left area

   invNorm uses the area to the left. A top 10% cutoff therefore uses area 0.90.

2. 2
   Enter parameters

   Use invNorm(area,μ,σ) and select LEFT/CENTER/RIGHT if your OS wizard presents a tail option.

3. 3
   Verify

   Substitute the result into normalcdf to confirm the intended probability.

Worked example