0% found this document useful (0 votes)
20 views10 pages

Regression Analysis Results Summary

The document describes the results of a regression analysis with Y as the response variable and X1, X2, X3, and X4 as predictor variables. It finds that X1 has a significant effect on Y based on its low p-value, while the other predictors do not have significant effects. Three different variable selection methods - regression, forward selection, and backward elimination - all identify X1 as the sole significant predictor variable.

Uploaded by

deer xxx
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
20 views10 pages

Regression Analysis Results Summary

The document describes the results of a regression analysis with Y as the response variable and X1, X2, X3, and X4 as predictor variables. It finds that X1 has a significant effect on Y based on its low p-value, while the other predictors do not have significant effects. Three different variable selection methods - regression, forward selection, and backward elimination - all identify X1 as the sole significant predictor variable.

Uploaded by

deer xxx
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Regression Analysis: Y versus X1, X2, X3, X4

Analysis of Variance
D
Source F Adj SS Adj MS F-Value P-Value

Regression 4 1.42759E+12 3.56898E+11 4.34 0.006


  X1 1 1.19049E+12 1.19049E+12 14.48 0.001
  X2 1 1329806535 1329806535 0.16 0.690
1 1
  X3 1 4796662060 4796662060 0.58 0.450
5 5
  X4 1 2224077141 2224077141 0.27 0.606
1 1
Error 35 2.87724E+12 8220672106    
6
  Lack-of-Fit 25 1.88734E+12 7549376282 0.76 0.722
5
  Pure Error 10 9.89891E+11 9898911666    
7
Total 39 4.30483E+12      

Model Summary
S R-sq R-sq(adj) R-sq(pred)

286717 33.16% 25.52% 14.68%

Coefficients
P-
Term Coef SE Coef T-Value Value VIF

Constant -20049 241354 -0.08 0.934  


X1 0.1444 0.0379 3.81 0.001 1.12
X2 -40216 99991 -0.40 0.690 1.14
X3 13713 179522 0.76 0.450 1.09
0
X4 90991 174935 0.52 0.606 1.03
Regression Equation
Y = -20049 + 0.1444 X1 - 40216 X2 + 137130 X3 + 90991 X4

Fits and Diagnostics for Unusual Observations


Obs Y Fit Resid Std Resid

17 500000 654441 -154441 -0.71   X


21 100000 352466 647534 2.31 R  
0
24 80000 713451 -633451 -2.39 R  
27 300000 817629 -517629 -2.02 R  
30 200000 153179 46821 0.21   X
35 150000 601038 898962 3.30 R  
0
R  Large residual
X  Unusual X

Normal Probability Plot


(response is Y)
99

95

90

80
70
Percent

60
50
40
30
20

10
5

1
-500000 -250000 0 250000 500000 750000 1000000
Residual
Versus Fits
(response is Y)
1000000

750000

500000
Residual

250000

-250000

-500000

0 100000 200000 300000 400000 500000 600000 700000 800000 900000


Fitted Value
Regression Analysis: Y versus X1, X2, X3, X4
Stepwise Selection of Terms
Candidate terms: X1, X2, X3, X4

----Step 1----
Coef P

Constant 174819  
X1 0.1452 0.000
     
S   278903
R-sq   31.34%
R-sq(adj)   29.53%
R-sq(pred)   19.70%
Mallows’ Cp   -0.04
α to enter = 0.05, α to remove = 0.05

Analysis of Variance
Source DF Adj SS Adj MS F-Value P-Value

Regression 1 1.34893E+1 1.34893E+12 17.34 0.000


2
  X1 1 1.34893E+1 1.34893E+12 17.34 0.000
2
Error 38 2.95590E+1 7778674026    
2 2
  Lack-of- 28 1.96600E+1 7021446297 0.71 0.773
Fit 2 5
  Pure Error 10 9.89891E+1 9898911666    
1 7
Total 39 4.30483E+1      
2
Model Summary
S R-sq R-sq(adj) R-sq(pred)

278903 31.34% 29.53% 19.70%


Coefficients
P-
Term Coef SE Coef T-Value Value VIF
Constant 17481 64159 2.72 0.010  
9
X1 0.1452 0.0349 4.16 0.000 1.00
Regression Equation
Y = 174819 + 0.1452 X1
Fits and Diagnostics for Unusual Observations
Obs Y Fit Resid Std Resid

21 100000 320008 679992 2.47 R  


0
24 80000 682981 -602981 -2.28 R  
27 300000 828170 -528170 -2.09 R X
35 150000 610386 889614 3.30 R  
0
R  Large residual
X  Unusual X
Regression Analysis: Y versus X1, X2, X3, X4
Forward Selection of Terms
Candidate terms: X1, X2, X3, X4

----Step 1----
Coef P

Constant 174819  
X1 0.1452 0.000
     
S   278903
R-sq   31.34%
R-sq(adj)   29.53%
R-sq(pred)   19.70%
Mallows’ Cp   -0.04
α to enter = 0.05

Analysis of Variance
Source DF Adj SS Adj MS F-Value P-Value

Regression 1 1.34893E+1 1.34893E+12 17.34 0.000


2
  X1 1 1.34893E+1 1.34893E+12 17.34 0.000
2
Error 38 2.95590E+1 7778674026    
2 2
  Lack-of- 28 1.96600E+1 7021446297 0.71 0.773
Fit 2 5
  Pure Error 10 9.89891E+1 9898911666    
1 7
Total 39 4.30483E+1      
2
Model Summary
S R-sq R-sq(adj) R-sq(pred)

278903 31.34% 29.53% 19.70%


Coefficients
P-
Term Coef SE Coef T-Value Value VIF
Constant 17481 64159 2.72 0.010  
9
X1 0.1452 0.0349 4.16 0.000 1.00
Regression Equation
Y = 174819 + 0.1452 X1
Fits and Diagnostics for Unusual Observations
Obs Y Fit Resid Std Resid

21 100000 320008 679992 2.47 R  


0
24 80000 682981 -602981 -2.28 R  
27 300000 828170 -528170 -2.09 R X
35 150000 610386 889614 3.30 R  
0
R  Large residual
X  Unusual X
Regression Analysis: Y versus X1, X2, X3, X4
Backward Elimination of Terms
Candidate terms: X1, X2, X3, X4

----Step 1---- ----Step 2---- ----Step 3---- ----Step 4----


Coef P Coef P Coef P Coef P

Constant -20049   -29332   72490   17481  


9
X1 0.1444 0.001 0.1408 0.000 0.1395 0.000 0.1452 0.000
X2 -40216 0.690            
X3 137130 0.450 12559 0.478 11883 0.497    
9 8
X4 90991 0.606 10140 0.557        
2
                 
S   28671   283359   280866   278903
7
R-sq   33.16%   32.85%   32.20%   31.34%
R-sq(adj)   25.52%   27.26%   28.53%   29.53%
R-sq(pred)   14.68%   19.16%   20.27%   19.70%
Mallows’   5.00   3.16   1.51   -0.04
Cp
α to remove = 0.05

Analysis of Variance
Source DF Adj SS Adj MS F-Value P-Value

Regression 1 1.34893E+1 1.34893E+12 17.34 0.000


2
  X1 1 1.34893E+1 1.34893E+12 17.34 0.000
2
Error 38 2.95590E+1 7778674026    
2 2
  Lack-of- 28 1.96600E+1 7021446297 0.71 0.773
Fit 2 5
  Pure Error 10 9.89891E+1 9898911666    
1 7
Total 39 4.30483E+1      
2
Model Summary
S R-sq R-sq(adj) R-sq(pred)

278903 31.34% 29.53% 19.70%


Coefficients
P-
Term Coef SE Coef T-Value Value VIF

Constant 17481 64159 2.72 0.010  


9
X1 0.1452 0.0349 4.16 0.000 1.00
Regression Equation
Y = 174819 + 0.1452 X1
Fits and Diagnostics for Unusual Observations
Obs Y Fit Resid Std Resid

21 100000 320008 679992 2.47 R  


0
24 80000 682981 -602981 -2.28 R  
27 300000 828170 -528170 -2.09 R X
35 150000 610386 889614 3.30 R  
0
R  Large residual
X  Unusual X
Best Subsets Regression: Y versus X1, X2, X3, X4
Response is Y
Mallow X
Var R-Sq R-Sq s X X X
s R-Sq (adj) (pred) Cp S 1 2 3 4

1 31.3 29.5 19.7 -0.0 278903 X      


1 4.8 2.3 0.0 13.9 328414     X  
1 1.2 0.0 0.0 15.8 334634   X    
1 0.1 0.0 0.0 16.3 336418       X
2 32.2 28.5 20.3 1.5 280866 X   X  
2 31.9 28.2 18.3 1.7 281493 X     X
2 31.6 27.9 15.6 1.8 282122 X X    
2 5.2 0.0 0.0 15.7 332181   X X  
3 32.9 27.3 19.2 3.2 283359 X   X X
3 32.6 27.0 16.2 3.3 283797 X X X  
3 32.0 26.4 13.8 3.6 285054 X X   X
3 5.5 0.0 0.0 17.5 336143   X X X
4 33.2 25.5 14.7 5.0 286717 X X X X

Common questions

Powered by AI

The R-square values for models including X1 vary slightly across different model selection methods. For the stepwise selection, the R-sq is 31.34%, R-sq(adj) is 29.53%, and R-sq(pred) is 19.70% . In the backward elimination approach, the R-sq starts at 33.16% and slightly decreases through the steps until reaching 31.34% in the final step which includes only X1 . These values demonstrate that while X1 is a crucial predictor, the addition of other variables may not substantially increase the explanatory power of the model, as the R-squared values remain relatively stable or even decrease in extended models .

In a simplified model, only the predictor X1 should be included, as it significantly affects the response variable Y with a strong T-value of 4.16 and a very low p-value of 0.000, indicating its statistical significance . The inclusion of X1 maintains a reasonably high R-sq value of 31.34% in simpler models . Other predictors such as X2, X3, and X4 have higher p-values and do not significantly contribute to improving the explanatory power of the model, as observed in the regression diagnostic statistics and their exclusion in various model selection evaluations .

The variable X1 is significantly important in the regression model as it shows a high F-value of 14.48 with a p-value of 0.001 in the regression analysis summary, indicating strong evidence against the null hypothesis that the coefficient of X1 is zero . Moreover, in the stepwise selection and backward elimination methods, X1 consistently remains in the model, emphasizing its contribution to explaining the variance in Y . The coefficient for X1 also has a low standard error, a high T-value of 4.16, and a low p-value of 0.000, reinforcing its significance .

The residual versus fits plot highlights potential issues such as heteroscedasticity or non-linearity, as evidenced by no uniform spread of residuals across the fitted values . The presence of systematic patterns in the residual distribution suggests the model might not adequately capture all aspects of the data structure. This can be addressed by transforming variables, adding interaction terms, or experimenting with different types of regression models such as polynomial regression to better capture the underlying relationships between predictors and the response .

The diagnostics for unusual observations indicate large residuals and potentially influential points. Observation 35 shows a large residual and is flagged as unusual, with a residual of 898,962 and a standardized residual of 3.30, which is significantly large . This indicates that observation 35 might be an outlier or influential point that could disproportionately affect the regression analysis results. Such observations can skew the regression coefficients, leading to an inaccurate model fit and predictions .

Removing the variables X2, X3, and X4 from the model would decrease its complexity and enhance interpretability without substantially sacrificing explanatory power. The R-squared change is minor, as the inclusion of these variables does not improve the model significantly, seen from their high p-values and low T-values, lacking statistical significance . Simplifying the model to only include X1 increases interpretability, making it easier to explain and justify, focusing on a major predictive factor without the noise introduced by less impactful variables .

The lack-of-fit test does not show a significant rejection of the null hypothesis, suggesting that the model's specified functional form fits the data reasonably well within the variability captured by the error term. The lack-of-fit p-value is 0.722 , indicating no evidence to suggest that the model fits poorly beyond random error variation. Thus, while the R-squared values might not be very high, indicating moderate explanatory power overall, the model form itself is appropriate based on the lack-of-fit test .

The predicted R-squared value being notably lower than the adjusted R-squared value suggests potential overfitting in the regression model. While the adjusted R-squared accounts for the number of predictors relative to the sample size, providing a more realistic measure of model fit on the given data, the predicted R-squared indicates how well the model is expected to perform on new, unseen data. A low predicted R-squared, such as 19.70% compared to an adjusted R-squared of 29.53% , implies that the model may not generalize well due to capturing noise specific to the training dataset rather than underlying patterns, suggesting a need for model simplification or cross-validation techniques to improve generalizability .

In the regression equation Y = -20049 + 0.1444 X1 - 40216 X2 + 137130 X3 + 90991 X4, each coefficient represents the change in the dependent variable Y for a one-unit increase in the respective predictor, assuming all other predictors are held constant. Specifically, X1 has a positive coefficient of 0.1444, indicating that Y tends to increase as X1 increases . Conversely, the negative coefficient of X2 (-40216) suggests a decrease in Y with an increase in X2. For X3 and X4, the positive coefficients (137130 and 90991, respectively) imply a positive association with Y. However, the impacts of X2, X3, and X4 are not statistically significant, as indicated by their high p-values, and thus their practical influence on Y should be interpreted cautiously .

The variance inflation factor (VIF) values indicate that multicollinearity among the predictors X1, X2, X3, and X4 is not a concern in this regression model. The VIF values for all predictors are around 1, specifically 1.12 for X1, 1.14 for X2, 1.09 for X3, and 1.03 for X4 . These values are well below the commonly accepted threshold of 10, suggesting that the predictors are not highly correlated with one another and do not inflate the standard errors of the coefficients significantly .

You might also like