As a public health personnel, you conducted a survey and collected economic and health data on households in a township that is known to have a high prevalence of heart disease. (See the Excel Household Data). The Household Data file contains data for 100 households surveyed including race, household income, family size, home price, number of bedrooms, and family history of heart disease.
Analyze the 100 survey responses and write a final report of your observation. Complete your report in a Word document, copying in the relevant output and graphics you need to support your report. Two parts Preliminary reports are due on Week 3 and Week 5 and Final Lab report is due on Week 7. Your final report must be a complete report describing your findings from the data to include parts 1 and 2. Your report should be in APA format.
Exercise Part 1:
(i) Describe the household data using the appropriate descriptive statistics technique for each variable. Hint: Calculate the mean, median, mode, proportion, range, and standard deviation, etc, as appropriate.
(ii) Construct a frequency table and histogram of household income in increments of $50,000 (for example, $0-$50,000, $50,001-$100,000, $100,001-$150,000, and so on).
Exercise Part 2:
You have already compute sample parameters for the data.
(i) Test the hypotheses that the average household income in the township is greater than $100,000. Hint: Start by stating the null and alternative hypotheses.
(ii) Construct a 95% CI for the proportion of households with family history of heart disease, separately for each race. Would you say the proportion of households with history of heart disease differ by race?
Lab Exercise Part 3:
You believe that income distribution differ by race.
(i) Formulate the null and alternative hypotheses you would use to for the test this claim.
(ii) Conduct the test and appropriately accept or reject your null hypotheses using ANOVA.