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. Suppose a...

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.

Suppose a households annual income is $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 1 decimal place.