1St Step- Create Simple Linear Regression Model FOR EACH
SALES and SQFT
• SALES and Inventory
•SALES and Advertising
• SALES and Stores
•Use linear regression to build models to answer these questions.
2nd Step – •Build a multivariate regression model that can be used to predict store sales
Create a multivariate model for all the mentioned relationships above
SALES and SQFT
• SALES and Inventory
•SALES and Advertising
• SALES and Stores
3RD STEP – Write a ½-1Page Conclusion Answering “Do you have a recommendation on which to use”
-Excel Model
– 3/4-1 page of the CONCLUSION PART