Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books