University regression for Basic monthly pay for March 2004 and Age
Descriptive Statistics
Mean
Std. Deviation
N
Basic monthly pay for March 2004
1.2893E3
381.54125
400
Age
38.0400
8.97523
400
The above table provide descriptive statistic for the Basic monthly pay for March 2004 and age.
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
.365a
.133
.131
355.66373
a. Predictors: (Constant), Age
The Model Summary part of the output is most useful when we are performing multiple regression. Capital R is the multiple correlation coefficient that tells us how strongly the multiple independent variables are related to the dependent variable.
Coefficientsa
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
699.084
77.532
9.017
.000
Age
15.516
1.984
.365
7.821
.000
a. Dependent Variable: Basic monthly pay for March 2004
The Coefficients part of the output gives us the values that we need in order to write the regression equation. The regression equation will take the form:Predicted variable (dependent variable) = slope * independent variable + intercept
The model would be
Basic monthly pay for March 2004= 699.084 + 15.516* Age
University regression for Basic monthly pay for March 2004 and The number of complete years the worker has been employed by SCP
Descriptive Statistics
Mean
Std. Deviation
N
Basic monthly pay for March 2004
1.2886E3
381.77866
399
Yrsserv
10.0276
6.66399
399
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
.408a
.167
.165
348.96326
a. Predictors: (Constant), Yrsserv
Coefficientsa
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
1054.151
31.591
33.369
.000
Yrsserv
23.385
2.625
.408
8.909
.000
a. Dependent Variable: Basic monthly pay for March 2004
Basic monthly pay for March 2004= 1054.151+ 23.385 * The number of complete years the worker has been employed by SCP
University regression for Basic monthly pay for March 2004 and The level of education attained by the worker
Descriptive Statistics
Mean
Std. Deviation
N
Basic monthly pay for March 2004
1.2826E3
386.78117
373
Edlevel
2.4987
1.18600
373
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
.321a
.103
.101
366.77145
a. Predictors: (Constant), Edlevel
Coefficientsa
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
1020.814
44.337
23.024
.000
Edlevel
104.771
16.034
.321
6.534
.000
a. Dependent Variable: Basic monthly pay for March 2004
Basic monthly pay for March 2004= 1020.814 + 104.771* The level of education attained by the worker
University regression for Basic monthly pay for March 2004 and Number of days' training attended in twelve months to 28 February 2004
Descriptive Statistics
Mean
Std. Deviation
N
Basic monthly pay for March 2004
1.2893E3
381.54125
400
Daytrain
3.4575
2.68537
400
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
.064a
.004
.002
381.24708
a. Predictors: (Constant), Daytrain
Coefficientsa
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
1320.564
31.101
42.461
.000
Daytrain
-9.035
7.107
-.064
-1.271
.204
a. Dependent Variable: Basic monthly pay for March 2004
Basic monthly pay for March 2004= 1320.564 + -9.035 * Number of days' training attended in twelve months to 28 February 2004
Question 4:
From above scatter plot it can be figured out that there is strong correlation between Basic monthly pay for march 2004 and “Number of days' training attended in twelve months to 28 February 2004” and there is also a strong correlation between “Basic monthly pay for march 2004” and “The level of education attained by the worker”.
Regression Analysis
Variables Entered/Removedb
Model
Variables Entered
Variables Removed
Method
1
Daytrain, Edlevel, Yrsserv, Agea
.
Enter
a. All requested variables entered.
b. Dependent Variable: Basic monthly pay for March 2004
The above table tells us about the predictor variables and the method used. Here we can see that all of our predictor variables were entered simultaneously (because we selected the Enter method.
Descriptive Statistics
Mean
Std. Deviation
N
Basic monthly pay for March 2004
1.2819E3
387.03350
372
Age
37.3065
8.61314
372
Yrsserv
9.5108
6.34306
372
Edlevel
2.4973
1.18731
372
Daytrain
3.5161
2.69716
372
Correlations
Basic monthly pay for March 2004
Age
Yrsserv
Edlevel
Daytrain
Pearson Correlation
Basic monthly pay for March 2004
1.000
.370
.401
.321
-.060
Age
.370
1.000
.772
-.142
-.032
Yrsserv
.401
.772
1.000
-.127
-.064
Edlevel
.321
-.142
-.127
1.000
-.009
Daytrain
-.060
-.032
-.064
-.009
1.000
Sig. (1-tailed)
Basic monthly pay for March 2004
.
.000
.000
.000
.124
Age
.000
.
.000
.003
.271
Yrsserv
.000
.000
.
.007
.111
Edlevel
.000
.003
.007
.
.433
Daytrain
.124
.271
.111
.433
.
N
Basic monthly pay for March 2004
372
372
372
372
372
Age
372
372
372
372
372
Yrsserv
372
372
372
372
372
Edlevel
372
372
372
372
372
Daytrain
372
372
372
372
372
The above table gives details of the correlation between each ...