What value did you obtain from your excel spreadsheet

Assignment Help Applied Statistics

Reference no: EM132626172

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: 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 or below this value? Is this height an unusual height for a male? Explain. 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 or above this value? Is this height an unusual height for a female? Explain.

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. Based on your z-scores and percentages, is the height from your Excel spreadsheet most likely a male or female? Explain.

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.

Reference no: EM132626172

Questions Cloud

Determine the values that would be appropriate : Determine the values that would be appropriate for each blank line. Provide a narrative of how you arrived at each value. the financial statement being complete

Explain the ethos of the putting lot : Explain the ethos of the Putting Lot in terms of the societal marketing concept.

To what extent has julia chosen the right approach : Required - To what extent has Julia chosen the right approach to lead the managers in her unit of the financial services firm

How the firm will pay for the investments : Capital budgeting is the process of determining how the firm will pay for its investments ?(true / false ). Company has ROE of 10.5%

What value did you obtain from your excel spreadsheet : 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)?

Examine the privacy policies of three internet retailers : Examine the privacy policies of three Internet retailers. What types of data does each retailer say it collects, and why?

What is the firms sustainable growth rate : What is the firms sustainable growth rate for 2019? What is the cash flow from assets for 2019 if net capital spending decreased by 10775.00 for the year

Make all necessary journal entries for both situations : At December 31, the market price of Martinez Fashion was $14 per share. Make all necessary journal entries in 2020 for both situations

What are some of the symptoms a clinician should look for : What are some of the symptoms a clinician should look for, or ask about when working with a client during the initial sessions? Explain each symptom.

User Account

All Pages