Analysis/ Statistical Decision

profilediana3612
RegressionOutcomes.xlsx

Sheet1

Model Summary b
Model R R Square Adjusted R Square Std. Error of the Estimate Change Statistics Durbin-Watson
R Square Change F Change df1 df2 Sig. F Change
1 .485 a 0.235 0.233 $144.70195 0.235 118.078 13 4986 0.000 1.946
a. Predictors: (Constant), CouponRedemption, HomeOwner, CommuteTime, TV_WatchingHours, NumberPets, EmploymentLengthYears, Region, EducationYears, HouseholdSize, CarValue, CardTenure, HouseholdIncome, Age
b. Dependent Variable: TotalAvgMonthlySpend
ANOVA a
Model Sum of Squares df Mean Square F Sig.
1 Regression 32141090.051 13 2472391.542 118.078 .000 b
Residual 104400124.977 4986 20938.653
Total 136541215.028 4999
a. Dependent Variable: TotalAvgMonthlySpend
b. Predictors: (Constant), CouponRedemption, HomeOwner, CommuteTime, TV_WatchingHours, NumberPets, EmploymentLengthYears, Region, EducationYears, HouseholdSize, CarValue, CardTenure, HouseholdIncome, Age
Coefficients a
Model Unstandardized Coefficients Standardized Coefficients t Sig. 95.0% Confidence Interval for B Collinearity Statistics
B Std. Error Beta Lower Bound Upper Bound Tolerance VIF
1 (Constant) -165.594 18.067 -9.166 0.000 -201.012 -130.175
Region 2.133 1.471 0.018 1.450 0.147 -0.750 5.017 0.958 1.044
Age -1.423 0.195 -0.153 -7.289 0.000 -1.806 -1.041 0.348 2.876
EducationYears 19.673 0.668 0.391 29.435 0.000 18.363 20.984 0.871 1.148
EmploymentLengthYears 0.361 0.337 0.021 1.072 0.284 -0.299 1.021 0.393 2.544
HouseholdSize 0.852 1.581 0.007 0.539 0.590 -2.248 3.951 0.862 1.160
HouseholdIncome 0.000 0.000 0.114 5.767 0.000 0.000 0.000 0.393 2.546
NumberPets 0.529 0.601 0.011 0.881 0.379 -0.649 1.706 0.996 1.004
HomeOwner 7.540 4.348 0.022 1.734 0.083 -0.984 16.063 0.950 1.053
CarValue -0.000 0.000 -0.022 -1.136 0.256 -0.000 0.000 0.409 2.447
CommuteTime -0.055 0.355 -0.002 -0.154 0.878 -0.751 0.642 0.960 1.042
CardTenure 4.438 0.271 0.323 16.367 0.000 3.906 4.970 0.394 2.537
TV_WatchingHours 0.070 0.398 0.002 0.177 0.860 -0.709 0.850 0.993 1.008
CouponRedemption -4.354 4.946 -0.011 -0.880 0.379 -14.050 5.341 0.998 1.002
a. Dependent Variable: TotalAvgMonthlySpend