STATS - As a public health personnel, you conducted a survey

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.

Part 1: Preliminary Report 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).

Part 2: Preliminary Report 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?

Part 3: Final Report
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.
(iii) Is there any statistically significant difference in the average household income based on race?

Your final report must be a complete report putting together and describing your findings from the analysis of the data from part 1 through part 3. Your report should be in APA format.
Household Data
Household Race Annual Household Income Home Price No. Bedrooms Household Size History of Heart Disease
1=Black, 2=Hispanic, 3=White ($1000s) ($1000s) yes=1; no=0
1 2 134.2 273.7 3 4 0
2 2 172.4 348.9 4 6 1
3 3 137.9 301.6 3 3 1
4 1 124.8 301.3 3 3 1
5 1 131.3 286.9 4 3 1
6 2 106.6 228.1 3 2 0
7 3 128.5 228 5 2 0
8 3 100.5 253.6 3 4 0
9 3 125.1 302.6 2 4 1
10 1 126.0 279.3 3 5 0
11 2 95.8 266.1 3 3 0
12 2 166.6 320.9 4 5 1
13 1 136.8 278.4 2 7 0
14 1 86.7 235.5 3 2 0
15 1 169.1 321.1 4 3 1
16 1 148.3 327.6 3 3 1
17 3 138.1 279.2 4 4 1
18 3 142.1 331.6 3 2 1
19 2 114.9 253.5 4 3 1
20 3 124.5 306.4 3 3 0
21 1 157.7 271.8 4 5 1
22 1 215.5 274.1 3 4 0
23 2 119.3 296.6 5 3 0
24 1 112.0 271.4 3 3 0
25 3 106.5 298.6 4 2 0
26 3 132.9 287.1 4 2 1
27 3 117.5 262.8 3 3 1
28 3 131.4 287.6 2 3 1
29 3 121.6 294.9 3 4 0
30 2 146.3 286.6 4 5 1
31 1 146.1 281.9 3 7 1
32 2 100.6 232.7 4 2 0
33 1 127.5 273 3 2 1
34 1 141.1 331.2 4 4 1
35 1 135.9 323.7 3 3 1
36 3 105.8 253.7 2 4 0
37 3 140.7 301.6 3 5 1
38 3 123.0 279.8 3 2 1
39 3 140.9 321.2 4 4 1
40 2 133.5 262.3 2 7 1
41 1 146.5 283.2 3 6 1
42 1 111.8 295.1 4 2 0
43 1 134.4 349.7 3 1 1
44 1 121.9 296.6 4 2 1
45 1 137.5 279.7 3 3 0
46 3 113.8 300.1 5 2 0
47 3 153.8 308.4 3 6 1
48 3 133.7 274.6 2 6 0
49 2 142.5 294.5 4 4 1
50 3 141.2 283.6 3 2 1
51 3 133.6 309.1 4 2 1
52 3 121.2 295.8 3 2 1
53 2 99.4 210.3 2 3 0
54 1 118.0 276.9 3 4 0
55 2 137.0 291.8 3 2 1
56 3 120.2 271 3 3 0
57 3 175.4 350.2 4 5 1
58 1 170.7 355.6 4 5 1
59 1 148.6 306.2 3 6 1
60 3 117.9 255.3 3 2 0
61 3 120.4 278.3 4 1 1
62 3 141.6 317.4 3 2 1
63 3 149.1 319.5 3 3 1
64 3 119.1 297.7 3 2 0
65 2 158.8 346.9 4 4 1
66 3 127.7 309.9 3 4 0
67 3 128.7 283.2 2 5 0
68 3 114.0 291.3 3 3 0
69 3 116.8 273.7 4 3 0
70 3 160.6 281.5 3 5 1
71 1 108.8 257.9 3 4 0
72 3 126.2 255.1 5 5 0
73 3 121.6 305.7 3 4 0
74 3 135.3 282.4 3 4 0
75 2 143.8 259.3 3 6 1
76 2 149.1 287.9 4 5 1
77 1 121.4 268.7 3 3 1
78 2 98.9 267.4 3 2 1
79 1 120.9 287.5 4 4 1
80 3 123.1 292.2 3 5 0
81 3 125.2 296.9 3 4 1
82 3 127.4 301.6 4 3 1
83 3 129.5 306.3 3 3 1
84 3 131.7 211 5 3 0
85 2 133.8 315.7 3 4 1
86 2 136.0 220.4 4 5 0
87 2 138.1 225.1 3 4 1
88 1 140.3 329.8 3 3 1
89 1 72.4 334.5 3 4 1
90 3 94.5 239.2 3 5 0
91 3 146.7 243.9 4 3 1
92 3 98.9 248.6 5 4 0
93 3 151.0 353.3 5 5 0
94 3 83.2 358 6 4 0
95 2 155.3 262.7 4 4 1
96 1 87.5 367.4 4 3 1
97 3 159.6 272.1 3 3 0
98 3 261.8 376.8 4 4 1
99 3 133.9 381.5 5 5 0
100 1 96.1 286.2 3 3 1