🌐
Exceljet
exceljet.net › norm.s.inv function
Excel NORM.S.INV function | Exceljet
June 27, 2020 - The Excel NORM.S.INV function returns the inverse of the standard normal cumulative distribution. Get inverse of the standard normal cumulative distribution · Returns the threshold value of a probability.
🌐
Excel Tip
exceltip.com › home › excel functions list
How to use the NORM.S.INV function in Excel
October 20, 2021 - How to use Excel NORM.INV Function : Calculate the inverse of Z score for the normal cumulative distribution for the pre-specified probability values using the NORM.INV function in Excel.
🌐
Aiexcelbot
aiexcelbot.com › formulas › statistical › norm-s-inv
Aiexcelbot
The NORM.S.INV function in Excel is used to calculate the inverse of the standard normal cumulative distribution. It returns the z-score corresponding to a given probability. The syntax for NORM.S.INV is: NORM.S.INV(probability) - probability: This is a required argument that represents the ...
🌐
Statistics How To
statisticshowto.com › home › probability and statistics topics index › z-score: definition, formula and calculation
Z-Score: Definition, Formula and Calculation - Statistics How To
June 26, 2025 - Step 6: Read the result: the calculator should state “Inverse = -2.25713“. This is your z score. Tip: If you are given a mean and standard deviation, enter them in place of 0 and 1 in Step 4. That’s how to find a z score on the TI 89! A z-score in Excel can quickly be calculated using a basic formula.
🌐
YouTube
youtube.com › prof derrf seitz
Microsoft Excel Inverse z-Score - YouTube
This video shows how to quickly calculate an inverse z-score using Microsoft Excel.
Published   February 10, 2023
Views   39
🌐
The Bricks
thebricks.com › resources › how-to-use-the-norm-s-inv-function-in-excel-a-step-by-step-guide
How to Use the NORM.S.INV Function in Excel: A Step-by-Step Guide
In Excel, this function is used to find the inverse of the standard normal cumulative distribution. Now, if you're scratching your head, that's okay. In simpler terms, it helps you find the z-score (a point on the standard normal distribution curve) for a given probability.
🌐
Reddit
reddit.com › r/mathhelp › confusion about the z-score for the norm inverse distribution.
r/MathHelp on Reddit: Confusion about the Z-Score for the norm inverse distribution.
October 9, 2022 -

I’m getting a little confused about finding X vales from a given probability.

Say you have a probability or 77% and you want to find the corresponding X value associated.

Using a standard normal table I can see the Z score that is closest to this area is 0.7704

When I input this value in either Excel or a calculator it gives an output of 143.86.

When I convert 143.86 to a Z score I get a Z score of 0.73 which has an area value of 0.7673.

Why is this area value less than 77%?

Should the Z score be the closest area value to 77%?

🌐
University of Washington
faculty.washington.edu › gloftus › P317-318 › Useful examples › ExcelNormalDist.html
Excel Basics – Finding areas under the normal distribution
Excel has some very useful functions for finding areas under the normal distribution. ... Z is the value for which you want the distribution. Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas. a) Pick a cell and enter a z score ...
🌐
CodePal
codepal.ai › excel-formula-generator › query › 5OCtg8AT › excel-formula-inverse-standard-normal-distribution
Excel Formula: Inverse Standard Normal Distribution - CodePal
In Excel, the NORM.S.INV formula takes a probability value as its argument and returns the corresponding z-score. The z-score represents the number of standard deviations a data point is from the mean.
Find elsewhere
🌐
Microsoft Support
support.microsoft.com › en-us › office › norm-s-inv-function-d6d556b4-ab7f-49cd-b526-5a20918452b1
NORM.S.INV function - Microsoft Support
Given a value for probability, NORM.S.INV seeks that value z such that NORM.S.DIST(z,TRUE) = probability. Thus, precision of NORM.S.INV depends on precision of NORM.S.DIST. NORM.S.INV uses an iterative search technique. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet.
🌐
Microsoft Support
support.microsoft.com › en-us › office › normsinv-function-8d1bce66-8e4d-4f3b-967c-30eed61f019d
NORMSINV function - Microsoft Support
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 · Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
Top answer
1 of 1
1

This is indeed a question about the inverse of a normal cumulative distribution function (CDF). Such inverse functions are often called quantile functions. The particulars of the computation depend on whether you are using software or printed normal tables.

Software: If you have software available, you can use your equation $P(X \le C) = 0.22,$ where $X \sim \mathsf{Norm}(\mu = 4,\, \sigma = 7).$ In R statistical software normal quantile functions are denoted qnorm, so the answer $-1.405$ can be obtained as:

qnorm(.22, 4, 7)
# [1] -1.405352

This is similar to @Henry's code, in which the argument lower.tail=F takes 22% of the probability from the upper tail, whereas qnorm without this argument takes 22% from the lower tail (according to the usual definition of the CDF).

Other statistical and mathematical software and calculators perform similar computations using different syntax.

The plot below shows the PDF and CDF of $\mathsf{Norm}(4, 7)$ with red dashed lines indicating key quantities.

Printed tables: If you doing this with printed standard normal CDF tables, then you need to 'standardize' much as you have done:

$$P(X \le C) = P\left(\frac{X - \mu}{\sigma} \le \frac{C - 4}{7}\right) = P\left(Z \le \frac{C-4}{7}\right) = 0.22,$$ where $Z \sim \mathsf{Norm}(0,1).$ Looking in the body of the table you can find a z-score that corresponds as nearly as possible to 0.22 (where the meaning of 'corresponds' depends on the format of the table). Here, the corresponding 'z-score' in the margin of the table is $-0.77.$ (Most tables allow no more than two-place accuracy).

Then $(C - 4)/7 = -0.77)$ so that $C \approx -1.39.$ But you can trust only two significant digits of the answer, so it amounts to $-1.4.$ By interpolation in the body of the table, you might get a little more accuracy. But your answer is about as close as you can reliably get using printed normal tables.

🌐
Microsoft Support
support.microsoft.com › en-us › topic › excel-statistical-functions-normsinv-3b33f03c-c50b-9d84-5269-0dc85692d349
Excel Statistical Functions: NORMSINV - Microsoft Support
It should be the case that z = NORMSINV(NORMSDIST(z)). If you re-format these entries to show many more decimal places, you might notice that the result is not exact because of imprecision of NORMSDIST, NORMSINV or both. However, errors appear only after a large enough number of decimal places ...
🌐
Calculator Academy
calculator.academy › home › inverse z score calculator
Inverse Z Score Calculator - Calculator Academy
September 11, 2023 - Use the formula X = μ + Zσ to calculate the raw score (X). After inserting the values of μ, Z, and σ into the formula, calculate the Inverse Z Score (X).
🌐
Coefficient
coefficient.io › home › how to calculate z-scores in excel: tips and tutorial
How to Calculate Z-Scores in Excel: Tips and Tutorial
October 17, 2024 - Open a new Excel worksheet. Enter your raw data in column A, starting from cell A2. Label cell A1 as “Raw Data” to identify the column. To calculate z-scores, you need to know the mean and standard deviation of your dataset.
🌐
TechCult
techcult.com › home › microsoft › microsoft office › how to calculate z score in excel
How to Calculate Z Score in Excel – TechCult
July 14, 2023 - It’s important to keep in mind ... which it is used. ... NORM.S.INV is a function in Microsoft Excel that returns the inverse z score in Excel of the standard normal cumulative distribution....
🌐
Wall Street Oasis
wallstreetoasis.com › home › free › learn excel › excel functions › norm.inv function
NORM.INV Function - Formula, Examples, Inverse Distribution | Wall Street Oasis
March 29, 2022 - The NORMINV Function (normal inverse function) is a tool in Excel to help users determine the inverse of the normal cumulative function. The normal cumulative function can be found using the normal distribution function, a similar Excel tool.
🌐
StatsKingdom
statskingdom.com › z_table.html
Z table - with chart
This is the 21st century! For any practical use, instead of tables, you can use the normal distribution calculator Simply select the appropriate value from "Probability (p) or percentile (𝑥)": 𝑥₁ for the Z-table or P(X≤𝑥₁) for the inverse Z-table.
🌐
Wall Street Mojo
wallstreetmojo.com › home › all blogs › excel resources › norm.s.inv function in excel
NORM.S.INV Function in Excel (Formula, Example) | How to Use?
December 20, 2024 - The z value (standard normal deviate) corresponds to a one-tailed probability P. Where P value must be between 0 and 1 (0<P<1). The syntax or formula for the NORM.S.INV function in Microsoft Excel is: Its syntax or formula has the below-mentioned ...