Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 14 4 pts Suppose you estimate a regression as follows: foodexp; a B1income B2*peoplej where 'foodexp' is the annual number of dollars spent (in
Question 14 4 pts Suppose you estimate a regression as follows: foodexp; a B1income B2*peoplej where 'foodexp' is the annual number of dollars spent (in thousands), 'income' is annual household income (in thousands), and 'people' is the number of household residents. Excel produces the following output . According to the output, the proportion of variations in food expenditure that can be explained by variations in income and in the number of household residents is: 44.95% 0%, because the model is not valid. 2.91E-05 0.164 and 1.145 2.24 H 1 SUMMARY OUTPUT 2 3 Regression Statistics 4 Multiple R 0.67042681 5 R Square 0.449472108 0.418013371 6 Adjusted R Square 4.290699764 7 Standard Error 8 Observations 38 10 ANOVA df SS MS F Significance F 11 12 Regression 2 526.0750633 263.0375317 14.28767187 2.90829E-05 13 Residual 35 644.3536564 18.41010447 14 Total 1170.42872 37 15 Upper 95 % Upper 95.0 % 16 Coefficients Standard Error t Stat P.value Lower 95% Lower 95.0 % 17 Intercept 2.243233652 2.668783692 0.840545324 0.406308473 3.174685245 7.661152549 -3.174685245 7.661152549 18 X Variable 1 0.164455057 0.035402031 4.645356617 4.66028E-05 0.092585115 0.236325 0.092585115 0.236325 19 x Variable 2 1.145061407 0.414424205 2.763017681 0.009067219 0.303735547 1.986387266 0.303735547 1.986387266
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started