Problem 1 (10 marks) File: MALL. XLS A national chain of women's clothing stores with locations in the large shopping malls thinks that it can do a better job of planning more renovations and expansions if it understands what variables impact sales. It plans a small pilot study on stores in 25 different mall locations. The data it collects consist of monthly sales, store size (sq. ft), number of linear feet of window display, number of competitors located in mall, size of the mall (sq. ft),and distance to nearest competitor (ft).

The store planners for the women's clothing chain want to find the best model that they can for understanding what store characteristics impact monthly sales.

1. Use stepwise regression to find the best model for the data.
2. Analyze the model you have identified to determine whether it has any problems.
3. Write a memo reporting your findings to your boss. Identify the strengths and weaknesses of the model you have chosen