Use regression to explore data
◦ Download Regression_project.xlsx from the Session 9 Folder under Files. This file contains the performance data of all the franchise stores of your client last year.
◦ Run a regression using sales as the dependent variable.
What to submit:
A short report to your client, including:
◦ Regression output(s)
◦ Interpretation of the results
◦ Managerial advice to your client
You may use Excel or any other statistical package to run the regression. Make sure to copy-paste the output table(s) into the document that you submit. 400 words max, excluding the table(s).