ExcelBanter

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

[email protected]

NORMDIST function
 
I really am not sure how to use this funtion in relation to the
question I have been given. If anybody could help me that would be
great.

mean = 178.5
Stdev = 6.32

The question is What proportion of male university students are
expected to have a height between 170 and 180cm?

If anyone could lead me in the right direction that'd be sweet!

Thanks.


pdberger

NORMDIST function
 
bigwags --

I think this works:

A
1 178.5
2 6.32
3 170
4 180

=normdist(a4,a1,a2,true)-normdist(a3,a1,a2,true)

Hope that helps.

" wrote:

I really am not sure how to use this funtion in relation to the
question I have been given. If anybody could help me that would be
great.

mean = 178.5
Stdev = 6.32

The question is What proportion of male university students are
expected to have a height between 170 and 180cm?

If anyone could lead me in the right direction that'd be sweet!

Thanks.



[email protected]

NORMDIST function
 
you are right it does work! I figured it out right after I posted but
thanks for the help!!



All times are GMT +1. The time now is 04:18 AM.

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