Scribd
Upload
7 views3 pages

Salary Impact on Spending Regression Analysis

This document summarizes the results of a regression analysis with Spending as the dependent variable and Salary as the independent variable. The regression model was statistically significant and Salary explained 69.7% of the variance in Spending. For every 1 rupee increase in Salary, Spending increased by 0.211 rupees on average. The regression equation was: Spending = -1434 + 0.211 * Salary

Uploaded by

Adeel Nasir
Copyright
© Attribution Non-Commercial (BY-NC)
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
7 views3 pages

Salary Impact on Spending Regression Analysis

This document summarizes the results of a regression analysis with Spending as the dependent variable and Salary as the independent variable. The regression model was statistically significant and Salary explained 69.7% of the variance in Spending. For every 1 rupee increase in Salary, Spending increased by 0.211 rupees on average. The regression equation was: Spending = -1434 + 0.211 * Salary

Uploaded by

Adeel Nasir
Copyright
© Attribution Non-Commercial (BY-NC)
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

Notes

Output Created 04-Apr-2011 08:49:28

Comments

Input Active Dataset DataSet0

Filter <none>

Weight <none>

Split File <none>

N of Rows in Working Data


51
File

Missing Value Handling Definition of Missing User-defined missing values are


treated as missing.

Cases Used Statistics are based on cases with no


missing values for any variable used.

Syntax REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R
ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT Spending
/METHOD=ENTER Salary
/RESIDUALS DURBIN.

Resources Processor Time 00:00:00.047

Elapsed Time 00:00:00.046

Memory Required 1348 bytes

Additional Memory Required


0 bytes
for Residual Plots

[DataSet0] 
Variables Entered/Removedb

Variables Variables
Model Entered Removed Method

1 Salarya . Enter

a. All requested variables entered.

b. Dependent Variable: Spending

Model Summaryb

Adjusted R Std. Error of the


Model R R Square Square Estimate Durbin-Watson

1 .835a .697 .691 586.713 1.522

a. Predictors: (Constant), Salary

b. Dependent Variable: Spending

ANOVAb

Model Sum of Squares df Mean Square F Sig.

1 Regression 3.876E7 1 3.876E7 112.594 .000a

Residual 1.687E7 49 344232.410

Total 5.563E7 50

a. Predictors: (Constant), Salary

b. Dependent Variable: Spending

Coefficientsa

Standardized
Unstandardized Coefficients Coefficients

Model B Std. Error Beta t Sig.

1 (Constant) -1434.246 490.469 -2.924 .005

Salary .211 .020 .835 10.611 .000

a. Dependent Variable: Spending


Residuals Statisticsa

Minimum Maximum Mean Std. Deviation N

Predicted Value 2377.63 7303.90 3696.61 880.439 51

Residual -1.139E3 1246.634 .000 580.816 51

Std. Predicted Value -1.498 4.097 .000 1.000 51

Std. Residual -1.941 2.125 .000 .990 51

a. Dependent Variable: Spending

Regression Line

y = α + βx

Y= -1434 + .211x

S.E = (490.69) (0.020)

T = (-2.924) (10.611)

R2= .697

Where

Y = Spending

X= salary

Where α= -1434 indicate the autonomous effect on Salary without the effect of spending which is the
independent variable. β= .211 means that one rupee increase or decrease in salary will increase or decrease
salary by .211 rupee

R2= .697 indicate the overall good fit of the model, which means that 69.7% change in Spending is due to
Salary.

ESS = 3.876, means variation in the dependent variable due to the variation made in the independent variable,
which is spending

RSS = 1.687, Means variation in the dependent variable other the independent variable.

You might also like