Reference no: EM13725654

Please provide calculation in Excel and provide detailed solution for all questions.

Answer questions 1-4 based on your analysis of utility expenditures for home-owners and renters.

1.
F-critical is
A) 1.24 so we cannot accept the null.
B) 1.24 so we cannot reject the null.
C) 1.09 so we cannot reject the null.
D) none of the above

2.
The F-statistic is calculated as approximately
A) 0.25
B) 1.24
C) 1.09
D) none of the above

3.
The absolute value of the t-statistic > t-critical, so we can reject the null at the 5% significance level.
A) True
B) False

4.
Which of the following represents the alternative hypothesis for this scenario?
A) HA: rent exp ≠ own exp
B) HA: rent exp = own exp
C) HA: rent exp ≥ own exp
D) none of the above

Answer questions 5-8 based on your analysis of first-income earners in the SW and NE.

5.
First-income earners in location 1 (SW) earn more than first income earners in location 3 (NE).
A) True
B) False

6.
The t-critical for the one-tailed test conducted in this situation is approximately
A) 3.25
B) 1.97
C) 1.35
D) none of the above

7.
Which of the following represents the null hypothesis for this scenario?
A) H0: income1 ≤ income 3
B) H0: income1 ≥ income 3
C) H0: income1 = income 3
D) none of the above

8.
The F-statistic is
A) 1.98
B) 1.35
C) 0.42
D) none of the above

Answer questions 9-12 based on your analysis of the mean indebtedness levels of households in the SW and NW.

9.
The following test was used for this scenario: t-Test: Two-Sample Assuming Equal Variances.
A) True
B) False

10.
We can conclude that debt levels are the same in the two regions.
A) True
B) False

11.
For the t-test, the p-value for this scenario is approximately
A) .01000
B) 0.0528
C) 0.0013
D) 0.1000

12.
The appropriate null hypothesis can be written as H0: debt location1 = debt location2.
A) True
B) False

Attachment:- exercise_data.xls