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)
11 years ago
5
Purchase the answer to view it

- statistics.xlsx
Purchase the answer to view it

- homework.xlsx
- I need 70 multiple choice question for biology answered by today 6/2/15 6:00pm CST
- Pro_Here I need help with HRM 370
- BUS445: Total Quality Management
- Life Cycles
- Economic Growth
- ECO 365 week 4 Learning Team Reflection Summary
- 1. What is a current liability? From the perspective of a user of financial statements, why do you believe current liabilities are separated from long-term liabilities? Based on your current experience as well as any additional research you may have do
- MIS 589 Week 4: Network and Transport Layers - Discussion IPv4 versus IPv6 (Graded)
- SCOR Model
- Assignment 3: Network Reconfiguration