Statistics (normal distribution)

[Legacy 252697]

Problem:
X is a normally distributed variable with a mean=30 and standard deviation=4. Find
a) P(x < 40)
b) P(x > 21 )
c) P(30 < x < 35)

How do i input this in excel. I'm actually having problems on how to put "<" and ">".

 

[Legacy 252697]

I just figured it out. if "<", then normdist, if ">", then 1-normdist. Am I right?

 

[mirabeau]

Problem:
X is a normally distributed variable with a mean=30 and standard deviation=4. Find
a) P(x < 40)
b) P(x > 21 )
c) P(30 < x < 35)

How do i input this in excel. I'm actually having problems on how to put "<" and ">".

Sheet6

*	A	B
Problem:
X is a normally distributed variable with a mean=30 and standard deviation=4. Find
a) P(x < 40)	=NORMSDIST(STANDARDIZE(40,30,4))
b) P(x > 21 )	=1-NORMSDIST(STANDARDIZE(21,30,4))
c) P(30 < x < 35)	=NORMSDIST(STANDARDIZE(35,30,4))-NORMSDIST(STANDARDIZE(30,30,4))

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Legacy 252697]

this is what I did. the function normsdist willl be used if z is given. thanks though.

*	A	B	C	D
	μ	sd
	30	4
a)	<	40	=IF(B4="<",NORMDIST(C4,$B$2,$C$2,TRUE),1-NORMDIST(C4,$B$2,$C$2,TRUE))
b)	>	21	=IF(B5="<",NORMDIST(C5,$B$2,$C$2,TRUE),1-NORMDIST(C5,$B$2,$C$2,TRUE))

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

</tbody>