Deliverable 4 - Hypothesis Tests
US2018
Normaldistribution2.xlsxSheet1
| calcluation of the Z-scores | |||||||||
| question 2<b> | |||||||||
| mean | std. | x | z-score | probabilities | difference of probabilities | percentage | |||
| 65 | 3.5 | 64 | -0.2857142857 Windows User: z-score for the lower value | 0.3875484811 Windows User: probabilty for z-score -0.28571 | 0.6121481355 | 61.2148135479 Windows User: percentage of the women that meeing height requirement |
|||
| 65 | 3.5 | 77 | 3.4285714286 Windows User: z-score for the higer value | 0.9996966166 Windows User: probabilty for the z-score 3.48571 |
|||||
| question 3< i> | |||||||||
| mean | std. | x | z-score | ||||||
| 69.4 | 11.3 | 66 | -0.3008849558 Windows User: the z-score |
||||||
|
Windows User: percentage of the women that meeing height requirement | z-score 5<i> | ||||||||
| area | difference | z-score | mean | std | |||||
| 0.6573 | 0.3427 | -0.4051054508 Windows User: the z-score | 0 | 1 | |||||
| questiin 6<p> | |||||||||
| mean | std. | x | z-score | p(x<22.5) | 1-p(x<22.5 | ||||
| 18.2 | 2.09 | 22.5 | 2.0574162679 | 0.9801768992 | 0.0198231008 |
