Reference no: EM133386762

Case

You are the manager for a company that sells outdoor grills. You've recently earned your MBA, and you want to apply what you've learned to your position to help with decision-making. You have developed the following estimated regression equation to help make data-driven decisions for the store. This will help you to better see how the unemployment rate, temperature, gas prices, and the price of steak impact weekly outdoor grill sales.

Y = 22,100 - 412x1 + 818x2 - 93x3 - 71x4

Where:

• Y = weekly sales
• x1 = local unemployment rate
• x2 = weekly average high temperature
• x3 = number of activities in the local community
• x4 = average price of gasoline per gallon

INSTRUCTIONS

Use the above equation and information to answer the following questions in a Word document, and create a guideline to use for future business decisions:

1. Based on the equation above, please provide the value for x1, x2, x3, and x4. Also, explain what these values mean in the context of this question. For example: What does the value of 818 mean in the equation above (specify if it is x1 or x2 or x3 or x4, and explain what those values mean based on the equation and context)?
2. What are the estimated weekly sales if the unemployment rate is 3.7%, the average high temperature is 670, there are 10 activities, and the average price of gasoline is $3.39 per gallon?
3. What recommendations or decisions could you make based on the predictive analysis in question 2?