Question: Solve it using minitab software and excel, and provide me with all the steps you did and the outputs The following data represent prescription sales

Solve it using minitab software and excel, and provide me with all the steps you did and the outputs
The following data represent prescription sales data (volume per month) obtained for a random sample of 20 independent pharmacies. These data, along with data on the total floor space, percentage of floor space allocated to the prescription department, number of parking spaces available for the store, whether the pharmacy is in a shopping center, and per capita income for the surrounding community are recorded in the following table: a. fit the regression model. [3] b. perform stepwise regression to select the best fit model. [3] c. test at the 0.05 level if the unselected variables could be dropped from the model. [3]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
