find a zscore call it z0 such that a PZ Zo 05 b PZ Zo0025

find a z-score call it z0 such that :

a) P(Z Zo) = 0.5

b) P(Z Zo)=0.025

c) P(Z Zo) = 0.025

d) P(Z Zo)= 0.0228
e) P(0 Z Zo) = 0.4803

f) P(Z < Zo) = 0.0401

Solution

Excel function

Zo

a

normsinv(1-0.5)

0.00

b

normsinv(1-0.025

1.96

c

normsinv(0.025)

-1.96

d

normsinv(1-0.228)

2.00

e

normsinv(1-0.4803)

0.05

f

normsinv(0.040)

-1.75