Question

Calculate the following probabilities using the standard normal distribution. PLEASE SHOW HOW TO DO IN MICROSOFT EXCEL. (Round your answers to four decimal places.)

(a)    

P(0.0 ≤ Z ≤ 1.4)

(b)    

P(−0.9 ≤ Z ≤ 0.0)

(c)    

P(0.0 ≤ Z ≤ 1.47)

Answer 1

a) the area between z = 0.0 and z = 1.4
In a blank cell type: =NORMSDIST(1.4) − NORMSDIST(0.0)
Answer: 0.419243341
b)  the area between z = -0.9 and z = 0.0
In a blank cell type: =NORMSDIST(0.0) − NORMSDIST(-0.9)
Answer: 0.315939875

c)  the area between z = 0.0 and z = 1.47
In a blank cell type: =NORMSDIST(1.47) − NORMSDIST(0.0)
Answer: 0.429219123