用excel的normdist函数,-0.5与0.4之间的概率为
=NORMDIST(0.4,0,1,TRUE)-=NORMDIST(-0.5,0,1,TRUE)
=0.655421742-0.308537539
=0.346884203
也可查表Z(-0.5)=1-Z(0.5)
查出Z(0.5)算出Z(-0.5)值,再查出Z(0.4)的值
再两个相减也可以.
用excel的normdist函数,-0.5与0.4之间的概率为
=NORMDIST(0.4,0,1,TRUE)-=NORMDIST(-0.5,0,1,TRUE)
=0.655421742-0.308537539
=0.346884203
也可查表Z(-0.5)=1-Z(0.5)
查出Z(0.5)算出Z(-0.5)值,再查出Z(0.4)的值
再两个相减也可以.