Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Use the Consumer Food database from “Excel Databases.xls” on Blackboard. Use Exc

ID: 3336106 • Letter: U

Question

Use the Consumer Food database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression model to predict Annual Food Spending by Annual Household Income and Non-Mortgage Household Debt. Assume a 5% level of significance.

What is the dependent variable in the study?

Annual Food Spending

Annual Household Income

200 households in the Consumer Food database

Non-Mortgage Household Debt

a.

Annual Food Spending

b.

Annual Household Income

c.

200 households in the Consumer Food database

d.

Non-Mortgage Household Debt

Explanation / Answer

Annual Food Spending needs to be predicted. Thus it is a dependent variable which needs to be predicted. Option A