Annual Amount Spent on Organic Food = ? +b₁Age + b₂AnnualIncome
+ b₃Number of People in Household +b₄Gender

After you have reviewed the results from the estimation, write areport to your boss that interprets the results that you obtained.Please include the following in your report:

1. The regression output you generated in Excel.
2. Your interpretation of the coefficient of determination(r-squared).
3. Your interpretation of the global test for statisticalsignificance (the F-test).
4. Your interpretation of the coefficient estimates for all theindependent variables.
5. Your interpretation of the statistical significance of thecoefficient estimates for all the independent variables.
6. The regression equation with estimates substituted into theequation. (Note: Once the estimates are substituted into theregression equation, it should take a form similar to this: y = 10+2x₁ +1x₂ +4x₃+0.9x₄)
7. An estimate of “Annual Amount Spent on Organic Food” for theaverage consumer. (Note: You will need to substitute the averagesfor all the independent variables into the regression equation forx, the intercept for ?, and solve for y.)
8. A discussion of whether or not the coefficient estimate on theAge variable in this estimation is different than it was in thesimple linear regression model from Module 3 Case. Be sure toexplain why it did/did not change.
9. You decide you want to generate an elasticity coefficient, soyou log the following variables in Excel: Annual Amount Spent onOrganic Food, Annual Income.
10. Using Excel, generate regression estimates for the followingmodel:

Log(Annual Amount Spent on Organic Food) = ?+b₁Age + b₂Log(AnnualIncome)
+ b₃Number of People in Household +b₄Gender

11. Your interpretation of the coefficient estimate forLog(AnnualIncome).
12. Your interpretation of the coefficient of determination(r-squared) for this new model.

Annual Amount Spent on Organic Food	Age	Annual Income	Number of People in Household	Gender (0 = Male; 1 = Female)
7348	77	109688	3	1
11598	47	109981	5	1
9224	23	112139	4	1
12991	38	113420	5	1
16556	58	114101	5	0
11515	44	115100	5	0
10469	34	116330	5	0
17933	75	116339	6	0
18173	32	117907	7	0
12305	39	119071	5	1
9080	65	58603	5	1
9113	48	58623	4	1
6185	48	61579	2	1
6470	49	62180	2	0
6000	57	62202	5	1