Create a cross-tabulation table with health status

Reference no: EM131138359

Question-

This question is based on the data used in Assignment 1. The sheet "obesity" contains the data from about 100,000 respondents of the survey regarding health in the year of 2009 In the United States. The data have eight variables: race (1="White", 2="Black", 3="Hispanic", 4="Other"), education (educational attainment: 0="less than high school", 1="High school dropout", 2="high school graduates", 3="some graduate", 4="college degree"), sex (0-"female", 1= "male"), BMI (Body Mass Index measured as weight(kg)/(height(m)²): smoking (smoking status: 1 ="current smoker", 2="former smoker", 3="never smoker"), exercise (physical activity status: 0="no physical activity", 1="physical activity"), working (working status: 0="not working" 1="working"), age (in years), and weight (health status, 0="underweight" if BMI < 18.5, 1="Normal or Healthy Weight" if 18.5 ≤ BMI < 25, 2="Overweight" if 25 ≤ BMI < 30, and 3= "Obese" if EMI ≥ 30).

1. Create a cross-tabulation (pivot) table with health status in row and physical activity status in column (polish a table as much as possible, that is, add labels and titles properly). The number in each cell should be % of grand total.

2. Do the data provide sufficient evidence to infer chat whether physical activity status is related to health status? To answer this question, conduct a relevant hypothesis testing.

(a) State the null and alternative hypotheses.

(b) Obtain the test statistic and the p-value. (You don't need to show me how to calculate these.)

(d) "Do the data provide sufficient evidence to infer that whether physical activity status is related to health status?"

3. Does the difference in BMI exist between those who exercise and who do not? To answer this question,

(a) First, conduct the hypothesis testing of variances. Specify the null and alternative hypotheses, obtain the test statistic and the p-value. State whether you reject the null hypothesis test at the 5% level of significance.

(b) Based on the result above, conduct the hypothesis testing on the means of BMI. Specify the null and alternative hypotheses; obtain the test statistic and the p-value. State whether you reject the null hypothesis test at the 5% level of significance.

4. Do the BMI differences exist across smoking status? To answer this question, conduct the one-way ANOVA.

(a) State the null and alternatives hypotheses.

(b) Obtain the test statistic and the p-value.

(d) "Do the BMI differences exist across smoking status?"

5. Do the BMI differences exist across educational attainment? To answer this question, conduct the one-way ANOVA.

(a) State the null and alternatives hypotheses.

(b) Obtain the test statistic and the p-value.

(d) "Do the BMI differences exist across educational attainment?"

Data - https://www.dropbox.com/s/jv2jbzsoquxyyiw/STAT.rar?dl=0

Reference no: EM131138359

Questions Cloud

Analyze primary ways in which key federal initiatives impact : Provide at least three (3) various reasons why some health care organizations have been reluctant to implement electronic medical records. Discuss the essential manner in which the Health Insurance Portability and Accountability Act (HIPAA) impact..

Summarize the main arguments on both sides of the issue : The globalizing economy of the late 20th and early 21st century has been characterized by regional trade agreements and global trade liberalization. Summarize and contrast the main arguments on both sides of the issue.

What volume of output would two locations have total cost : A small producer of machine tools wants to move to a larger building, and has identified two alternatives. Location A has annual fixed costs of $125,000 and variable costs of $16,000 per unit; location B has annual fixed costs of $325,000 and variabl..

Employment is made to the applicants of private sector : Suppose that before any offer of employment is made to the applicants of a private sector, non-unionized employer with more than 20 employees, the applicants are (1) provided a written copy of the employer’s mandatory arbitration policy, which must b..

Create a cross-tabulation table with health status : Create a cross-tabulation (pivot) table with health status in row and physical activity status in column (polish a table as much as possible, that is, add labels and titles properly). The number in each cell should be % of grand total

What knowledge management tools does organization utilize : What personal knowledge management tools does this organization utilize? What steps has this organization taken in securing their information and knowledge?

Why inaccurate trade statistics cause problems : Conventional trade statistics may no longer be as reliable as they once were because:- Inaccurate trade statistics cause problems because they:

What option strategy could you follow in order to make money : What option strategy could you follow in order to make money if Merck shares rise OR fall by a significant amount - Calculate the out-of-pocket cost today of the alternative strategy you described in part (c)

What''s interesting or helpful about this view : Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

User Account

All Pages