INSTRUCTIONS: Use MINITAB 17 to complete the following questions. You are to work independently on this assignment. All data sets for this assignment have been provided. Please submit your completed...

Multiple Regression
INSTRUCTIONS: Use MINITAB 17 to complete the following questions. You are to work
independently on this assignment. All data sets for this assignment have been provided.
Please submit your completed assignment that includes relevant MINITAB output and
comments (make sure to comment on your results when asked) as ONE WORD document.
You are to use MINITAB 17 statistical software in completing this assignment. Please paste
relevant MINITAB output into ONE WORD document. Insert your comments as
appropriate. You are to submit the entire assignment as ONE WORD document.
1. Use the data set ConsumerCreditCounseling.MTW. These data are from Consumer
Credit Counseling (CCC), a company that provides consumers with assistance in
planning andfollowing budgets. The most important variable that CCC needs to
forecast is the number of clients to be seen per month (Clients). It believes that the
following variables are related to the forecast variable:Stamps = number of people on
food stamps, Index= business activity index by the local Economic Development
Council, and Bankruptcies = number of bankruptcies filed. All of these variables are
measured in the region in which CCC operates.
(a) Use stepwise regression to fit a multiple regression model forforecasting number of new
clients (Clients) using all potential independent variables. Change the default values for the
alpha to enter and alpha to remove from 0.15 to 0.05.What is the resulting model?
Regression Analysis: Clients versus Stamps, Index, Bankruptcies

Method
Rows unused 48
Stepwise Selection of Terms
Candidate terms: Stamps, Index, Bankruptcies
-----Step 1---- -----Step 2----
Coef P Coef P
Constant -105.3 -216.7
Index 2.131 0.000 2.493 0.000
Bankruptcies 0.452 0.003
S 20.9152 19.1831
R-sq 36.49% 47.73%
R-sq(adj) 35.11% 45.41%
R-sq(pred) 31.22% 40.96%
Mallows’ Cp 13.44 5.27
α to enter = 0.05, α to remove = 0.05
Analysis of Variance
Source DF Adj SS Adj MS F-Value P-Value
Regression 2 15124 7561.8 20.55 0.000
Index 1 14470 14470.2 39.32 0.000
Bankruptcies 1 3563 3563.0 9.68 0.003
Error 45 16560 368.0
Total 47 31683
Model Summary
S R-sq R-sq(adj) R-sq(pred)
19.1831 47.73% 45.41% 40.96%
Coefficients
Term Coef SE Coef T-Value P-Value VIF
Constant -216.7 56.0 -3.87 0.000
Index 2.493 0.398 6.27 0.000 1.09
Bankruptcies 0.452 0.145 3.11 0.003 1.09
Regression Equation
Clients = -216.7 + 2.493 Index + 0.452 Bankruptcies
The model with independent variables Index and Bankruptcies has the highest adjusted R
2
at
45.41%, a lowest Mallows’ Cp value at 5.27. This will be the best and final model.
(b) How much of the variability in Clients is explained by the final model found using the
Stepwise Regression approach?
47.73% of the variability in Clients is explained by the final model found using the
Stepwise Regression approach.
(c) ...