For the value of x, if we wish to get the bottom 10% of the distribution, we can use the NORMINV function. As a financial analyst. Perform financial forecasting, reporting, and operational metrics tracking, analyze financial data, create financial models, NORMINV is useful in stock market analysis.

What does Norminv function do?

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. Note: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage.

What is inverse norm used for?

Use the invNorm command when you are given a probability or percentage and asked to find an x value or z score. This command is often used to find values corresponding to percentiles or quartiles.