M6: Regression Analysis Mini-Case Assignment Scenario Script: Caption: Princess Foods wants to determine if there is a relationship in the amount a household spends on prepared foods to family size and income. Parthika: Well, we still have data collected from a previous marketing study. Let's use that. We have an Excel file. I am sure we can find the spreadsheet. It should have the exact information we need. Liwei: Yes, this could be interesting. We may find enough evidence to rethink the meal preparation kits again. Bonnie: Great idea. We need to know it the data is a good fit and what the exact relationship is between the dependent variable and the independent variables. We can use this information to help us design perhaps a new line of prepared frozen foods. Parthika Yes, what about the prepackaged salad bowls. We really need to see this data. Bonnie: Yes, let's get right on this. Mini-Case Assignment Please use the attached spreadsheet and Excel to determine the equation that represents the relationship and explain the goodness of fit. Based on the data, write a memo and interpret the results. How might this data be used? Due Dates 11:59pm ET, Sunday. Grading Criteria and Guidelines Grading criteria and detailed instructions for submission of assignments are available on the course website