=NORM.INV(probability, mean, standard_dev)One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single NORM.INV formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
probability:
A value between 0 and 1 that represents the probability for which you want to find the corresponding value in the normal distribution.
mean:
The arithmetic mean of the distribution, which is the average value around which the data is centered.
standard_dev:
The standard deviation of the distribution, which measures the dispersion or spread of the data points around the mean.
The NORM.INV function in Excel is a statistical tool that allows you to find the inverse of the normal cumulative distribution for a specified mean and standard deviation. In simpler terms, it helps you determine the value of a variable for a given probability in a normal distribution, making it useful for various statistical analyses.
Imagine you are analyzing the test scores of students in a class, and you have the following data in an Excel spreadsheet:
| Student | Test Score |
|---|---|
| Alice | 85 |
| Bob | 90 |
| Charlie | 78 |
| David | 92 |
| Eve | 88 |
You want to find the test score that corresponds to the 90th percentile of the distribution of test scores.
To calculate the test score at the 90th percentile, you would use the NORM.INV formula as follows:
=NORM.INV(0.9, AVERAGE(B2:B6), STDEV.P(B2:B6))When you apply the formula, it calculates the test score that corresponds to the 90th percentile based on the average and standard deviation of the test scores. The output would be:
| Test Score at 90th Percentile |
|---|
| 90.4 |
Here, the calculated score indicates that a student would need to score approximately 90.4 to be in the top 10% of the class.
The NORM.INV function is particularly useful when you need to perform statistical analyses that involve normal distributions. It allows you to understand thresholds and cutoffs in your data, which can be essential for decision-making in fields such as education, finance, and quality control.
Understanding how to use the NORM.INV function can significantly enhance your statistical analysis capabilities in Excel, enabling you to extract meaningful insights from your datasets.
Happy analyzing!
You have a dataset where Column A contains the test scores of students in a standardized exam, and you want to determine the score that corresponds to the 90th percentile of the distribution. You can use the NORM.INV function to calculate this score based on the mean and standard deviation of the test scores. This allows educators to understand the performance threshold for top-performing students and helps in setting benchmarks for future assessments without needing to manually analyze the entire dataset.
Beyond the NORM.INV function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.