Hypothesis Testing: Using Housing variable with marital status variable as the grouping variable for making two groups, select and run the appropriate method for making decisions about two parameters relative to observed statistics (i.e., two sample hypothesis testing method) and answer/discuss the following 7 items.

Two Sample Hypothesis Test AnalysisI'm confused about performing the ANOVA test in Excel please explain. don't know if I've done this right.

1. Research Question:

Do married families spend more money on housing than singles?

2. State the Random Variable and Parameters in Words:

3. State Null and Alternative Hypotheses and Level of Significance:

4. Two Sample Hypothesis Test that Will Be Used and Rationale for Using It:

5. Method Used to Analyze Data:

6. Find the sample statistic, test statistic, and p-value:

7. Conclusion Regarding Whether or Not to Reject the Null Hypothesis:

Part B: Results Write Up Discuss the following 3 items:

1. Confidence Interval Analysis:

2. Two Sample Hypothesis Test Analysis:

3. Discussion about the Analysis:

Housing Married:

22880

23407

22376

22621

22219

22852

26411

25531

23139

27164

23252

23374

22245

25671

26006

Housing Unmarried:

18391

18514

18502

18838

18633

18619

18312

18484

18576

18376

18520

18435

18648

18389

18483