ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   NORMDIST (https://www.excelbanter.com/excel-worksheet-functions/120235-normdist.html)

Tschuß

NORMDIST
 
Hi All,

I have a question according the Normal (or Gauss curve).
The function NORMDIST(x; mean; stdev;true) gives me the pourcent.

What is the function that gives me x when I want to select 95% of my
population.
NORMDIST(x; mean; stdev;true) =0.95

Thanks, it's urgent


bj

NORMDIST
 
norminv()

"Tschuß" wrote:

Hi All,

I have a question according the Normal (or Gauss curve).
The function NORMDIST(x; mean; stdev;true) gives me the pourcent.

What is the function that gives me x when I want to select 95% of my
population.
NORMDIST(x; mean; stdev;true) =0.95

Thanks, it's urgent



Tschuß

NORMDIST
 
Yes, simple
Thanks

bj wrote:
norminv()

"Tschuß" wrote:

Hi All,

I have a question according the Normal (or Gauss curve).
The function NORMDIST(x; mean; stdev;true) gives me the pourcent.

What is the function that gives me x when I want to select 95% of my
population.
NORMDIST(x; mean; stdev;true) =0.95

Thanks, it's urgent





All times are GMT +1. The time now is 02:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com