• Home
  • Blog
  • Only need answer to one of these question using excel

Only need answer to one of these question using excel

0 comments

(1) Let Z follow the standard normal distribution. Show your manual work to find z such that P(Z>z)=0.95 (hint: we need to find the left area first then inversely find the z; be careful about the sign of z-value.).

(2) Let Z follow the standard normal distribution. Show your Excel stats function to find z such that P(Z>z)=0.95 (the same hint above).

(3) Let Z follow the standard normal distribution. Show your manual work to find z such that P(-z<Z<z)=0.95 (the same hint above, key to learn Ch. 7)

(4)  Let Z follow the standard normal distribution. Show your Excel stats function to find z such that P(-z<Z<z)=0.95 (the same hint above. key to learn Ch. 7).

(5) Let X follow a normal distribution with a mean of 10 and a standard deviation of 2.  Show your manual work to find x such that P(X<x)=0.95 (hint: x is an upper end “above” the mean)

(6) Let X follow a normal distribution with a mean of 10 and a standard deviation of 2.  Show your Excel Stats functional work to find x such that P(X<x)=0.95 (hint: x is an upper end “above” the mean)

(7)  Let X follow a normal distribution with a mean of 10 and a standard deviation of 2.  Show your manual work to find x such that P(X<x)=0.05 (hint: x is a lower end “below” the mean)

(8) Let X follow a normal distribution with a mean of 10 and a standard deviation of 2.  Show your Excel Stats functional work to find x such that P(X<x)=0.05 (hint: x is a lower end “below” the mean)

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}