QUESTION 5 Use Excel to develop a regression model for the Consumer Food Database (using the "Excel Databases.xls" file on Blackboard) to predict Annual Food Spending by Annual Household Income for...

Link to the excel file. Thank you for the help.

EXCEL DATA:

https://drive.google.com/file/d/1TQG5r2wzLGk--75whZXyb0SDTHZTWS0S/view?usp=sharing

Extracted text: QUESTION 5 Use Excel to develop a regression model for the Consumer Food Database (using the "Excel Databases.xls" file on Blackboard) to predict Annual Food Spending by Annual Household Income for those living in the Metro area only. Suppose a household in the metro area has an annual income of $60,000. Predict how much they spend on food per year. Write your answer as a number (do not include the $ sign or comma) and round to 2 decimal places.