Description
According to the National Center for Health Statistics, the mean height of an American male is 69.3 inches and the mean height of an American female is 63.8 inches. The standard deviation for both genders is 2.7 inches.
Assuming that heights among a single gender are normally distributed. Find the z-score for your height in inches using the mean of your own gender and then find the percentile at which you fall among people of your own gender using the percentile table from problem 25 of the Module 2 Homework.
A Microsoft Excel spreadsheet is required for this DQ.
Attempt Start Date: 18-Mar-2019 at 12:00:00 AM
Due Date:
22-Mar-2019 at 11:59:59 PM
z-score | Percentile | z-score | Percentile | z-score | Percentile | z-score | Percentile |
---|---|---|---|---|---|---|---|
minus−3.5 | 00.02 | minus−1.00 | 15.87 | 0.00 | 50.00 | 1.1 | 86.43 |
minus−3.0 | 00.13 | minus−0.95 | 17.11 | 0.05 | 51.99 | 1.2 | 88.49 |
minus−2.9 | 00.19 | minus−0.90 | 18.41 | 0.10 | 53.98 | 1.3 | 90.32 |
minus−2.8 | 00.26 | minus−0.85 | 19.77 | 0.15 | 55.96 | 1.4 | 91.92 |
minus−2.7 | 00.35 | minus−0.80 | 21.19 | 0.20 | 57.93 | 1.5 | 93.32 |
minus−2.6 | 00.47 | minus−0.75 | 22.66 | 0.25 | 59.87 | 1.6 | 94.52 |
minus−2.5 | 00.62 | minus−0.70 | 24.20 | 0.30 | 61.79 | 1.7 | 95.54 |
minus−2.4 | 00.82 | minus−0.65 | 25.78 | 0.35 | 63.68 | 1.8 | 96.41 |
minus−2.3 | 01.07 | minus−0.60 | 27.43 | 0.40 | 65.54 | 1.9 | 97.13 |
minus−2.2 | 01.39 | minus−0.55 | 29.12 | 0.45 | 67.36 | 2.0 | 97.72 |
minus−2.1 | 01.79 | minus−0.50 | 30.85 | 0.50 | 69.15 | 2.1 | 98.21 |
minus−2.0 | 02.28 | minus−0.45 | 32.64 | 0.55 | 70.88 | 2.2 | 98.61 |
minus−1.9 | 02.87 | minus−0.40 | 34.46 | 0.60 | 72.57 | 2.3 | 98.93 |
minus−1.8 | 03.59 | minus−0.35 | 36.32 | 0.65 | 74.22 | 2.4 | 99.18 |
minus−1.7 | 04.46 | minus−0.30 | 38.21 | 0.70 | 75.80 | 2.5 | 99.38 |
minus−1.6 | 05.48 | minus−0.25 | 40.13 | 0.75 | 77.34 | 2.6 | 99.53 |
minus−1.5 | 06.68 | minus−0.20 | 42.07 | 0.80 | 78.81 | 2.7 | 99.65 |
minus−1.4 | 08.08 | minus−0.15 | 44.04 | 0.85 | 80.23 | 2.8 | 99.74 |
minus−1.3 | 09.68 | minus−0.10 | 46.02 | 0.90 | 81.59 | 2.9 | 99.81 |
minus−1.2 | 11.51 | minus−0.05 | 48.01 | 0.95 | 82.89 | 3.0 | 99.87 |
minus−1.1 | 13.57 | minus−0.00 | 50.00 | 1.00 | 84.13 | 3.5 | 99.98 |
Explanation & Answer
Hi, Find attached the paper for your review. I have provided the percentiles for both the female and male gender. You will simply have to use the gender you belong to and delete the other one. Let me know if you need anything ed...