Please show me how to use excel to work this problem Let X b

Please show me how to use excel to work this problem. Let X be normally distributed with mean u=120 and standard deviation o=20 . a. Find P(X 86) b. Find P(80 X 100)c. Find x such that P(X x) =0.40 d. Find x such that P(X > x) =0.90

Solution

Normal Distribution
Mean ( u ) =120
Standard Deviation ( sd )=20
Normal Distribution = Z= X- u / sd ~ N(0,1)                  
a)
P(X > 86) = (86-120)/20
= -34/20 = -1.7
= P ( Z >-1.7) From Standard Normal Table
= 0.9554                  
P(X < = 86) = (1 - P(X > 86)
= 1 - 0.9554 = 0.0446                  
b)
To find P(a < = Z < = b) = F(b) - F(a)
P(X < 80) = (80-120)/20
= -40/20 = -2
= P ( Z <-2) From Standard Normal Table
= 0.02275
P(X < 100) = (100-120)/20
= -20/20 = -1
= P ( Z <-1) From Standard Normal Table
= 0.15866
P(80 < X < 100) = 0.15866-0.02275 = 0.1359                  
c)
P ( Z < x ) = 0.4
Value of z to the cumulative probability of 0.4 from normal table is -0.253
P( x-u/s.d < x - 120/20 ) = 0.4
That is, ( x - 120/20 ) = -0.25
--> x = -0.25 * 20 + 120 = 114.94                  
d)
P ( Z > x ) = 0.9
Value of z to the cumulative probability of 0.9 from normal table is -1.28
P( x-u/ (s.d) > x - 120/20) = 0.9
That is, ( x - 120/20) = -1.28
--> x = -1.28 * 20+120 = 94.36                  

Please show me how to use excel to work this problem. Let X be normally distributed with mean u=120 and standard deviation o=20 . a. Find P(X 86) b. Find P(80 X

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site