Question

In this​ exercise, you will investigate the relationship between earnings and height. These data are taken...

In this​ exercise, you will investigate the relationship between earnings and height. These data are taken from the US National Health Interview Survey for 1994. Download the data from the table by clicking the download table icon . A detailed description of the variables used in the dataset is available here LOADING... . Use a statistical package of your choice to answer the following questions. What is the median value of height in the​ sample? The median value of height in the sample is nothing. ​(Round your response to two decimal places​)

Earnings and Height
Earnings Height
84054.75 66
84054.75 66
49430.10938 66
38925.33594 66
84054.75 66
23362.87305 66
84054.75 67
38925.33594 67
84054.75 67
28560.38672 67
23362.87305 67
44152.16016 67
84054.75 67
33712.96875 67
84054.75 67
33712.96875 67
49430.10938 67
49430.10938 67
84054.75 67
44152.16016 67
84054.75 67
44152.16016 67
49430.10938 67
19237.19531 67
84054.75 67
33712.96875 67
84054.75 67
44152.16016 67
38925.33594 67
33712.96875 67
33712.96875 67
84054.75 67
23362.87305 67
28560.38672 67
49430.10938 67
20305.50977 67
38925.33594 67
84054.75 67
20305.50977 67
9857.505859 67
84054.75 67
23362.87305 67
38925.33594 67
20305.50977 67
33712.96875 67
84054.75 67
84054.75 67
5675.895508 67
28560.38672 68
38925.33594 68
44152.16016 68
49430.10938 68
84054.75 68
84054.75 68
84054.75 68
84054.75 68
84054.75 68
28560.38672 68
49430.10938 68
33712.96875 68
28560.38672 68
84054.75 68
49430.10938 68
84054.75 68
84054.75 68
28560.38672 68
84054.75 68
44152.16016 68
84054.75 68
84054.75 68
33712.96875 68
38925.33594 68
84054.75 68
84054.75 68
84054.75 68
84054.75 68
44152.16016 68
44152.16016 68
84054.75 68
84054.75 68
49430.10938 68
84054.75 68
84054.75 68
84054.75 68
10865.42871 68
84054.75 68
33712.96875 68
84054.75 68
44152.16016 68
84054.75 68
84054.75 68
84054.75 68
84054.75 68
44152.16016 68
28560.38672 68
84054.75 68
84054.75 68
17171.26367 68
23362.87305 68
84054.75 68

Please show me step by step through the Excel.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
EARNINGS HEIGHTS MEDIAN ROUNDUP
84054.75 66 2871.947754 2871.95
84054.75 66
49430.10938 66
38925.33594 66
84054.75 66
23362.87305 66
84054.75 67
38925.33594 67
84054.75 67
28560.38672 67
23362.87305 67
44152.16016 67
84054.75 67
33712.96875 67
84054.75 67
33712.96875 67
49430.10938 67
49430.10938 67
84054.75 67
44152.16016 67
84054.75 67
44152.16016 67
49430.10938 67
19237.19531 67
84054.75 67
33712.96875 67
84054.75 67
44152.16016 67
38925.33594 67
33712.96875 67
33712.96875 67
84054.75 67
23362.87305 67
28560.38672 67
49430.10938 67
20305.50977 67
38925.33594 67
84054.75 67
20305.50977 67
9857.505859 67
84054.75 67
23362.87305 67
38925.33594 67
20305.50977 67
33712.96875 67
84054.75 67
84054.75 67
5675.895508 67
28560.38672 68
38925.33594 68
44152.16016 68
49430.10938 68
84054.75 68
84054.75 68
84054.75 68
84054.75 68
84054.75 68
28560.38672 68
49430.10938 68
33712.96875 68
28560.38672 68
84054.75 68
49430.10938 68
84054.75 68
84054.75 68
28560.38672 68
84054.75 68
44152.16016 68
84054.75 68
84054.75 68
33712.96875 68
38925.33594 68
84054.75 68
84054.75 68
84054.75 68
84054.75 68
44152.16016 68
44152.16016 68
84054.75 68
84054.75 68
49430.10938 68
84054.75 68
84054.75 68
84054.75 68
10865.42871 68
84054.75 68
33712.96875 68
84054.75 68
44152.16016 68
84054.75 68
84054.75 68
84054.75 68
84054.75 68
44152.16016 68
28560.38672 68
84054.75 68
84054.75 68
17171.26367 68
23362.87305 68
84054.75 68

TO FIND OUT THE MEDIAN USE THE FORMULA=MEDIAN(A3:B102), SELECT ALL THE EARNINGS AND HEIGHTS TO GET THE MEDIAN   USE FORMULA=ROUND(C3,2) TO GET 2 DECIMAL PLACES

Add a comment
Know the answer?
Add Answer to:
In this​ exercise, you will investigate the relationship between earnings and height. These data are taken...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Empirical Exercise 5.2 Quostion Holp In this exercise, you will investigate the relationship betw...

    Please explain step by step on how to do this in excel. Empirical Exercise 5.2 Quostion Holp In this exercise, you will investigate the relationship between growth and trade. The following table contains data on average growth rates from 1960 through 1995 for 20 countries along with variables that are potentially related to growth. Download the data from the table by clicking the download table icon p . A detailed description of the variables used in the data set is...

  • In this exercise, you will investigate the relationship between growth and trade. The following table contains...

    In this exercise, you will investigate the relationship between growth and trade. The following table contains data on average growth rates from 1960 through 1995 for 20 countries along with variables that are potentially related to growth. Download the data from the table by clicking the download table icon . A detailed description of the variables used in the data set is available here . Use a statistical package of your choice to answer the following questions. Run a regression...

  • In this exercise, you will investigate the relationship between a worker's age and earnings. (Generally, older...

    In this exercise, you will investigate the relationship between a worker's age and earnings. (Generally, older workers have more job experience, leading to higher productivity and earnings.) The following table contains data for full-time, full-years workers, age 25-34, with a high school diploma or B.A./B.S. as their highest degree. Download the data from the table by clicking the download table icon 0 . A detailed description of the variables used in the data set is available here Use a statistical...

  • Use the accompanying data set on the pulse rates​ (in beats per​ minute) of males to...

    Use the accompanying data set on the pulse rates​ (in beats per​ minute) of males to complete parts​ (a) and​ (b) below. LOADING... Click the icon to view the pulse rates of males. a. Find the mean and standard​ deviation, and verify that the pulse rates have a distribution that is roughly normal. The mean of the pulse rates is 71.871.8 beats per minute. ​(Round to one decimal place as​ needed.) The standard deviation of the pulse rates is 12.212.2...

  • In this exercise, you will investigate the relationship between growth and trade. The following table contains...

    In this exercise, you will investigate the relationship between growth and trade. The following table contains data on average growth rates from 1960 through 1995 for 20 countries along with variables that are potentially related to growth. Use a statistical package of your choice to answer the following questions. Run a regression of Growthon TradeShare. Test the null hypothesis Upper H 0 : beta 1 equals 0 nbspH0: β1=0 versus a two-sided alternative hypothesis Upper H 1 : beta 1...

  • f you are male, use the men’s heights and shoe sizes as your data. If you...

    f you are male, use the men’s heights and shoe sizes as your data. If you are female, use the women’s heights and shoe sizes as your data. Student # Gender Height Shoe Age Hand 1 F 68 8.5 20 R 2 F 60 5.5 27 R 3 F 64 7 31 R 4 F 67 7.5 19 R 5 F 65 8 20 R 6 F 66 9 29 R 7 F 62 9.5 30 L 8 F 63...

  • First, read the article on "The Delphi Method for Graduate Research." ------ Article is posted below...

    First, read the article on "The Delphi Method for Graduate Research." ------ Article is posted below Include each of the following in your answer (if applicable – explain in a paragraph) Research problem: what do you want to solve using Delphi? Sample: who will participate and why? (answer in 5 -10 sentences) Round one questionnaire: include 5 hypothetical questions you would like to ask Discuss: what are possible outcomes of the findings from your study? Hint: this is the conclusion....

  • HELP needed urgently....Data and question is attacted below..... Thank you in advance there is no data...

    HELP needed urgently....Data and question is attacted below..... Thank you in advance there is no data link fir this data it’s all in photos.... thank you i have already posted the question We were unable to transcribe this imageNo. 2 3 4 5 6 7 8 Working Sector Public Own Public Public Private Public Private Private Own Own Private Public Public Public Private 9 10 11 12 13 Public IS 16 17 18 19 20 21 22 23 24 25...

  • explaim the mechanisms amd toxological effects if type 1 diabetes in this article Exposure to arsenic...

    explaim the mechanisms amd toxological effects if type 1 diabetes in this article Exposure to arsenic in drinking water is associated with increased prevalence of diabetes. We previously reported an association of diabetes and urinary concentration of dimethylarsinite (DMAS"), a toxic product of arsenic methylation by arsenic (+ 3 oxidation state) methyltransferase (AS3MT). Here we examine associations between AS3MT polymorphism, arsenic metabolism and diabetes. Fasting blood glucose, oral glucose tolerance and self-reported diagnoses were used to identify diabetic individuals. Inorganic...

  • 10. The Beck & Watson article is a Group of answer choices quantitative study qualitative study...

    10. The Beck & Watson article is a Group of answer choices quantitative study qualitative study 11. Beck & Watson examined participants' experiences and perceptions using what type of research design? Group of answer choices particpant obersvation phenomenology 12. Select the participants in the Beck & Watson study Group of answer choices Caucasian women with 2-4 children Caucasian pregnant women 13. In the Beck & Watson study, data was collected via a(n) Group of answer choices internet study focus group...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT