Question: what is the x value, mean value, and standard deviation from the following? How would you convert the x values into z-scores? What is the
what is the x value, mean value, and standard deviation from the following? How would you convert the x values into z-scores? What is the lowest z-score? What is the highest z-score? How do you use the =norm.s.dist function to create the values so that you can graph the probability density function? Please help also explain how to do this in Excel.
| X |
| -0.43 |
| -0.42 |
| -0.41 |
| -0.40 |
| -0.39 |
| -0.38 |
| -0.37 |
| -0.36 |
| -0.34 |
| -0.33 |
| -0.32 |
| -0.31 |
| -0.30 |
| -0.29 |
| -0.28 |
| -0.27 |
| -0.26 |
| -0.25 |
| -0.23 |
| -0.22 |
| -0.21 |
| -0.20 |
| -0.19 |
| -0.18 |
| -0.17 |
| -0.16 |
| -0.15 |
| -0.14 |
| -0.12 |
| -0.11 |
| -0.10 |
| -0.09 |
| -0.08 |
| -0.07 |
| -0.06 |
| -0.05 |
| -0.04 |
| -0.03 |
| -0.01 |
| 0.00 |
| 0.01 |
| 0.02 |
| 0.03 |
| 0.04 |
| 0.05 |
| 0.06 |
| 0.07 |
| 0.09 |
| 0.10 |
| 0.11 |
| 0.12 |
| 0.13 |
| 0.14 |
| 0.15 |
| 0.16 |
| 0.17 |
| 0.18 |
| 0.20 |
| 0.21 |
| 0.22 |
| 0.23 |
| 0.24 |
| 0.25 |
| 0.26 |
| 0.27 |
| 0.28 |
| 0.29 |
| 0.31 |
| 0.32 |
| 0.33 |
| 0.34 |
| 0.35 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
