#### Only need answer to one of these question using excel

Buy an essay today

Question

Submitted by jams_r1 on Tue, 2015-06-16 13:34

due on Tue, 2015-06-16 00:00

answered 2 time(s)

Hand shake with PROF .STAN: Complete ($2.00 paid)

Hand shake with Programmer one: In progress

Hand shake with duncanodunde: In progress

Hand shake with Dr. Joel A: In progress

Hand shake with DR.DEENNHEIGHT: In progress

jams_r1 is willing to pay $5.00

jams_r1 bought 33 out of 35 answered question(s)

Only need answer to one of these question using excel

(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)

We can offer a similar ASSIGNMENT at a reasonable price. All our papers are written from the scratch and 100% plagiarism free.