Question 1:Market planning, Inc. a marketing research firm, has obtained the prescription sales data for 20 independent pharmacies (attached).In this table y is the average weekly prescription sales over the past year (in units of $1,000), x₁ is the floor space (in square feet), x₂ is the percentage of floor space allocated to the prescription department, x₃ is the number of parking spaces available to the store, x₄ is the weekly per capita income for the surrounding community (in units of $100), and x₅ is a dummy variable that equals 1 if the pharmacy is located in a shopping center and 0 otherwise.Regress average weekly prescription sales against different combinations of the independent variables.What is the best model?Discuss what the parameter coefficients say about prescription sales.

Please upload breadown in Excel or attach commands for Stata.

pharmacysalesfloorspprespctparkingincomeshopctr

1224900940181

21958001050201

32450001155171

42844001230190

51838501342100

62153001520221

7294100202580

81547002260151

91256002445161

101449002782141

111837002856120

12193800313880

13152400363560

14221800372840

15133100404360

16162300412050

1784400424671

1863300421540

1972900453091

20172400461630