Question

income consumption 16 14.00 30 24.55 43 36.78 70 63.25 56 40.18 50 49.55 16 17.00 26 22.39 14 16.03 12 12.00 24 20.77 30 34.78 16 34.78 16 17.00 70 63.25 16 20.77 30 24.55 12 34.78 16 20.77 43 16.03 56 34.78 14 20.77 14 27.07 43 16.03 24 10.77

          income
consumption
16 14.00
30 24.55
43 36.78
70 63.25
56 40.18
50 49.55
16 17.00
26 22.39
14 16.03
12 12.00
24 20.77
30 34.78
16 34.78
16 17.00
70 63.25
16 20.77
30 24.55
12 34.78
16 20.77
43 16.03
56 34.78
14 20.77
14 27.07
43 16.03
24 10.77

income
consumption
16 14.00
30 24.55
43 36.78
70 63.25
56 40.18
50 49.55
16 17.00
26 22.39
14 16.03
12 12.00
24 20.77
30 34.78
16 34.78
16 17.00
70 63.25
16 20.77
30 24.55
12 34.78
16 20.77
43 16.03
56 34.78
14 20.77
14 27.07
43 16.03
24 10.77

Added by Melinda L.

Elementary Statistics a Step by Step Approach

Allan G. Bluman 9th Edition

Instant Answer

Solved by Expert Rakesh Singhi

05/28/2022

Step 1

Step 1: Calculate the mean of the independent variable (Income) and the dependent variable (consumption). Show more…

Show all steps

Thanks for your feedback!

Question 16 1pts The data is Income (available in the quiz directions), have two variables, consumption, and Income (in 1,000 dollars). We want to predict consumption based on Income, i.e., Income is the independent variable. Use Excel to calculate the regression equation to answer the question. The degrees of freedom for SS Regression (Source Model) is equal to: income consumption 16 14.00 30 24.55 43 36.78 70 63.25 56 40.18 50 49.55 16 17.00 26 22.39 14 16.03 12 12.00 24 20.77 30 34.78 16 34.78 16 17.00 70 63.25 16 20.77 30 24.55 12 34.78 16 20.77 43 16.03 56 34.78 14 20.77 14 27.07 43 16.03 24 10.77