MATH144 GCU Module 2 American male and female heights spreadsheet

User Generated

Puevfglenira

Business Finance

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

minus3.5

00.02

minus1.00

15.87

0.00

50.00

1.1

86.43

minus3.0

00.13

minus0.95

17.11

0.05

51.99

1.2

88.49

minus2.9

00.19

minus0.90

18.41

0.10

53.98

1.3

90.32

minus2.8

00.26

minus0.85

19.77

0.15

55.96

1.4

91.92

minus2.7

00.35

minus0.80

21.19

0.20

57.93

1.5

93.32

minus2.6

00.47

minus0.75

22.66

0.25

59.87

1.6

94.52

minus2.5

00.62

minus0.70

24.20

0.30

61.79

1.7

95.54

minus2.4

00.82

minus0.65

25.78

0.35

63.68

1.8

96.41

minus2.3

01.07

minus0.60

27.43

0.40

65.54

1.9

97.13

minus2.2

01.39

minus0.55

29.12

0.45

67.36

2.0

97.72

minus2.1

01.79

minus0.50

30.85

0.50

69.15

2.1

98.21

minus2.0

02.28

minus0.45

32.64

0.55

70.88

2.2

98.61

minus1.9

02.87

minus0.40

34.46

0.60

72.57

2.3

98.93

minus1.8

03.59

minus0.35

36.32

0.65

74.22

2.4

99.18

minus1.7

04.46

minus0.30

38.21

0.70

75.80

2.5

99.38

minus1.6

05.48

minus0.25

40.13

0.75

77.34

2.6

99.53

minus1.5

06.68

minus0.20

42.07

0.80

78.81

2.7

99.65

minus1.4

08.08

minus0.15

44.04

0.85

80.23

2.8

99.74

minus1.3

09.68

minus0.10

46.02

0.90

81.59

2.9

99.81

minus1.2

11.51

minus0.05

48.01

0.95

82.89

3.0

99.87

minus1.1

13.57

minus0.00

50.00

1.00

84.13

3.5

99.98


User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags