Open a blank Excel worksheet. Go to cell A1 and type the following=RANDBETWEEN(57, 76)then press ENTER. Make sure to start with an equal sign, and Excel should generate a random integer between the values of 57 and 76 inclusively. Then use the value you obtain to answer the questions below:

A.Male Heights: Assume adult male heights are normally distributed with a mean of 69 inches and a standard deviation of 2.5 inches. What value did you obtain from your Excel spreadsheet? If this was the height of a male, what z-score would this height be (SHOW WORK)? What percentage of male heights are at orbelowthis value? Is this height an unusual height for a male? Explain.

B.Female Heights: Assume adult female heights are normally distributed with a mean of 65 inches and a standard deviation of 2.7 inches. What value did you obtain from your Excel spreadsheet? If this was the height of a female, what z-score would this height be (SHOW WORK)? What percentage of female heights are at orabovethis value? Is this height an unusual height for a female? Explain.

C.Based on the z-scores you got in parts a and b of the discussion, is the height from your Excel spreadsheet closer to the male mean height or the female mean height? Explain.

D. Based on your z-scores and percentages, is the height from your Excel spreadsheet most likely a male or female? Explain.

E.Suppose you took a sample of 40 males and calculated the mean height. If that sample mean height was the value you obtained from your Excel spreadsheet, what would the z-score be (SHOW WORK)? Hint: Since this is a sample of heights, you'll need to use the mean and standard deviation of the sampling distribution of means to calculate the z-score. Would this sample mean be unusual? Explain.