When using the NORMINV function, common questions usually involve parameter errors, unexpected results, and filling formulas across multiple cells; this FAQ includes 3 common questions and a glossary of key terms.
FAQ
What should I do if NORMINV returns an error value?
- Check whether all parameters in the formula are valid numbers or valid cell references.
- Confirm that the probability, mean, and standard deviation are in the correct order.
- Check whether referenced cells contain spaces, text, or other non-numeric content.
- If needed, re-enter the formula through the Insert Function dialog and verify each parameter one by one.
Why does the NORMINV result not match what I expected?
- Confirm that the probability, mean, and standard deviation match your calculation scenario.
- Check whether you used the wrong distribution function or referenced the wrong cells.
- Review the syntax again and verify the meaning of each parameter.
- Test the formula with a simple sample first, then replace it with your actual data.
How do I use NORMINV in multiple cells?
- Enter the full NORMINV formula in the first cell.
- Set relative references or absolute references as needed.
- Move the pointer to the fill handle at the lower-right corner of the cell.
- Drag down or across to copy the formula to the target range.
- Check whether the copied references behave as expected.
Glossary
| Term | Definition |
|---|---|
| NORMINV | The inverse of the normal cumulative distribution, used to return a value from a specified probability. |
| Probability | In NORMINV, the input value representing the cumulative probability of the normal distribution. |
| Mean | The average level of a dataset and one of the main parameters in a normal distribution. |
| Standard deviation | A parameter that measures how spread out the data is and affects the width of the distribution curve. |