Please go into detail about how you solved! Thankyou A researcher studying Total
ID: 3134147 • Letter: P
Question
Please go into detail about how you solved! Thankyou
A researcher studying Total Serious Crimes (TSC) obtained a data set from the U.S. Bureau of Census (see the Minitab data file named TSC.mtw). The data set provides information for 109 Standard Metropolitan Statistical Areas (SMSAs) in the United States. The data set contains five variables: TP, PPCC, PP65, PH, and TPI. Descriptions of the variables can be found in the table below. The researcher believes that all these five variables can be used to predict TSC. 14 points
Variable
Definition
Description
TP
Total population
Estimated population (in thousands)
PPCC
Percent of population in central cities
Percent of SMSA population in central city or cities.
PP65
Percent of population 65 or older
Percent of SMSA population 65 years old or older
PH
Percent high school graduates
Percent of adult population who completed 12 or more years of school
TPI
Total personal income
Total current income received by residents of the SMSA from all sources (in millions of dollars)
TSC
Total serious crimes
Total number of serious crimes
Perform a regression analysis. Report the initial model. 2 points
Does the initial model contain insignificant predictors? What are the two main reasons why a model contains insignificant predictors? 3 points
Is the initial model plagued with multi-collinearity? How do you know? 3 points
How would you deal with the multi-collinearity issue? 2 points
After dealing with the multi-collinearity issue, are the remaining predictors all significant? 1 point
What is your final regression model? 3 points
Variable
Definition
Description
TP
Total population
Estimated population (in thousands)
PPCC
Percent of population in central cities
Percent of SMSA population in central city or cities.
PP65
Percent of population 65 or older
Percent of SMSA population 65 years old or older
PH
Percent high school graduates
Percent of adult population who completed 12 or more years of school
TPI
Total personal income
Total current income received by residents of the SMSA from all sources (in millions of dollars)
TSC
Total serious crimes
Total number of serious crimes
Explanation / Answer
answer 1) the paratemer-estimate of the model are given as
answer of part 2)
there are two predictors TP and PH which are insignifican at 5% level of significant
multicollinarity and redundant predictors are the reasons for modle having insignificant predictors
answer of part 3)
initial model plagued with multi-collinearity as the some of pair-wise correlation coefficient are highly significant.
answer 4) dealing with mulitcolinearity
answer 5) yes after removing PH and TP remainings predictors are significant
Parameter Estimates Variable DF ParameterEstimate Standard
Error t Value Pr > |t| Intercept 1 -910.28788 315.10928 -2.89 0.0047 TP 1 -1.35208 1.66104 -0.81 0.4175 PPCC 1 6.39040 0.22745 28.10 <.0001 PP65 1 -3.00636 1.51471 -1.98 0.0498 PH 1 29.62508 15.03547 1.97 0.0515 TPI 1 14.11317 3.29074 4.29 <.0001