Many regions along the coast in North and South Carolina and |
Family | Food | Income | Size | |||
1 | $4.24 | $73.98 | 2.00 | |||
2 | 4.08 | 54.90 | 2.00 | |||
3 | 5.76 | 59.43 | 4.00 | |||
4 | 3.48 | 52.02 | 1.00 | |||
5 | 4.20 | 65.70 | 2.00 | |||
6 | 4.80 | 53.64 | 4.00 | |||
7 | 4.32 | 79.74 | 3.00 | |||
8 | 5.04 | 68.58 | 4.00 | |||
9 | 6.12 | 165.60 | 5.00 | |||
10 | 3.24 | 64.80 | 1.00 | |||
11 | 4.80 | 138.42 | 3.00 | |||
12 | 3.24 | 125.82 | 1.00 | |||
13 | 6.37 | 77.58 | 7.00 | |||
14 | 5.51 | 170.74 | 7.00 | |||
15 | 6.60 | 126.42 | 6.00 | |||
16 | 5.40 | 141.30 | 3.00 | |||
17 | 6.00 | 36.90 | 5.00 | |||
18 | 5.40 | 56.88 | 4.00 | |||
19 | 3.36 | 71.82 | 1.00 | |||
20 | 4.68 | 69.48 | 3.00 | |||
21 | 4.32 | 54.36 | 2.00 | |||
22 | 5.52 | 87.66 | 5.00 | |||
23 | 4.56 | 38.16 | 3.00 | |||
24 | 5.40 | 43.74 | 7.00 | |||
25 | 7.10 | 37.46 | 6.00 | |||
Click
here for the Excel Data File
Food and income are reported in thousands of dollars per year, |
a-1. |
Develop a correlation matrix. (Round your answers to 3 |
Food | Income | |
Income | ||
Size | ||
a-2. | Do you see any problems with multicollinearity? |
There is (Click to select)multicollinearityno multicollinearity. |
b-1. | Determine the regression equation. (Round your answer to 3 decimal places.) |
The regression equation is: Food = + Income + Size. |
b-2. |
How much does an additional family member add to the amount |
Another member of the family adds $ to the food bill. |
c-1. | What is the value of R2? (Round your answer to 3 decimal places.) |
R2 |
c-2. |
State the decision rule for 0.05 significance level. |
H0 is rejected if F > |
c-3. | Complete the ANOVA (Leave no cells blank – be certain to enter “0” wherever required. Round SS, MS, P to 3 decimal places and F to 2 decimal places.) |
Source | DF | SS | MS | F | p |
Regression | |||||
Error | |||||
Total | |||||
c-4. | Can we conclude that this value is greater than 0? |
(Click to select)RejectDo not reject H0. Some of the regression coefficients are (Click to select)zeronot zero. |
d-1. |
Complete the given below table. (Leave no cells blank – |
Predictor | Coef | SE Coef | T | P |
Constant | ||||
Income | ||||
Size | ||||
d-2. | Would you consider deleting either of the independent variables? |
There is (Click to select)no needa need to delete a variable. |
e. | State true or false. |
From the graph the residuals appear normally distributed. |
(Click to select)FalseTrue |
f. | Choose the right option from the following graph. |
(Click to select)There is no homoscedasticity problemThere is a homoscedasticity problem.
|