”

Price($)

Promotional exp(K)

Qualityof Service

City:1/Suburban:0

Monthly Sales(K)

904

5

9.5

1

168

909

4.3

4.5

0

168

915

3

8.5

1

162

921

2

5.5

0

160

934

0.75

6.5

1

154

941

4.8

10

0

152

949

3.6

4.25

1

150

953

3

5.5

1

146

955

1.5

7.5

0

146

962

0.7

9.5

0

144

978

4.7

9

1

134

990

3.5

7

0

130

1006

2.8

5

1

122

1014

1.3

4

0

118

1018

0.25

9

1

116

1021

4.5

6

1

114

1022

3.2

5

0

114

1038

2.4

8

0

106

1040

1.2

4

1

104

1050

0

9

0

100

Please consider the data presented above for the monthly
sales of Ever-cool brand of refrigerators in 1,000s of dollars and answer the
following questions:
Independent variables are as follows.
Price(in dollars); Promotional Expenditure (in 1,000s of
dollars); Quality of service ( scale of 1-10); location (categorical variable:
city area : 1; suburban area : 0) .
a. Based on 4 in 1 plot and the plots of independent
variables vs. residuals, do you see any evidence of violation of assumptions?
b. State the
multiple regression equation and interpret the meaning of the slopes, b1,
b2, b3, and b4.
c. At the 0.05
level of significance, determine whether each independent variable makes a
significant contribution to the regression model. On the basis of these
results, indicate the independent variables to include in this model. (Based on
t – test results)
d. Construct a
95% confidence interval estimate of the population slope between price and the
monthly sales (.gif””>)
e. Perform the
overall F- test and comment on the significance of the model.
Please follow the following instructions:

Use MINITAB
to run the analysis.

Copy/Paste MINITAB results to justify your answers.
Price($)Promotional exp(K)Qualityof ServiceCity:1/Suburban:0Monthly Sales(K)90459.511689094.34.5016891538.5116292125.501609340.756.511549414.81001529493.64.25115095335.511469551.57.501469620.79.501449784.7911349903.57013010062.85112210141.34011810180.259111610214.56111410223.25011410382.48010610401.2411041050090100Please consider the data presented above for the monthly
sales of Ever-cool brand of refrigerators in 1,000s of dollars and answer the
following questions:Independent variables are as follows.Price(in dollars); Promotional Expenditure (in 1,000s of
dollars); Quality of service ( scale of 1-10); location (categorical variable:
city area : 1; suburban area : 0) .a. Based on 4 in 1 plot and the plots of independent
variables vs. residuals, do you see any evidence of violation of assumptions?b. State the
multiple regression equation and interpret the meaning of the slopes, b1,
b2, b3, and b4.c. At the 0.05
level of significance, determine whether each independent variable makes a
significant contribution to the regression model. On the basis of these
results, indicate the independent variables to include in this model. (Based on
t – test results)d. Construct a
95% confidence interval estimate of the population slope between price and the
monthly sales (.gif””>)e. Perform the
overall F- test and comment on the significance of the model.Please follow the following instructions:
Use MINITAB
to run the analysis.
Copy/Paste MINITAB results to justify your answers.”