ASSIGNMENT OF SPSS
ANOUSHKA SHARMA , Enrolment No. A0403423058
1.0 LISTING OF DATA AND VARIABLES IN SPSS
(Data Imported from Excel File Respondents for data analysis.xls to SPSS
file employee_survey_data.sav).
There are 7 variables in all and 50 respondents. The variables reflected in
“Variable view” in SPSS are taken as below with their definitions and numerical
number attached are follows:-
ID Employee ID
Age Age
G GENDER
0- Male , 1- Female
D Department
HR-0, Sales-1,Mkt-2, Operation-3, Quality- 4, Delivery-5
JS Job Satisfaction (Scale of 1 to 5)
Disagree-1, Somewhat Agree -2 , Neutral-3, Agree-4, Strongly Agree-5
WLS Work Life Balance (Scale of 1 to 5)
Disagree-1, Somewhat Agree -2 , Neutral-3, Agree-4, Strongly Agree-5
1
YOS Year of service
Salary Salary
Data tabulated in Excel
DATA FOR SPSS ASSIGNMENT
id aGE
R Respondent ID Age G D JS WLS YOS Salary
1 66560 36 0 0 4 2 14 15
2 66561 38 1 1 3 2 15 15
3 66562 49 1 2 4 2 26 22
4 66563 46 0 3 3 2 23 20
5 66564 47 0 4 4 3 20 20
6 66565 42 0 5 3 3 14 15
7 66566 38 0 4 3 3 17 18
8 66567 40 0 3 3 3 22 15
9 66568 37 0 2 3 3 15 15
10 66569 37 0 1 3 3 19 19
11 66570 40 1 5 4 2 18 19
12 66571 41 0 3 4 3 16 15
13 66572 41 0 4 4 2 16 15
14 66573 47 0 5 5 2 50 30
15 66574 36 0 2 3 3 14 13
16 66575 41 0 1 4 2 16 16
17 66576 49 1 0 5 2 25 25
18 66577 29 0 0 2 3 5 3
19 66578 50 0 2 4 2 23 25
20 66579 36 0 3 4 3 15 15
21 66580 52 1 4 4 2 29 28
22 66581 34 1 5 3 3 12 12
23 66582 37 0 1 3 3 13 12
24 66583 50 1 2 3 2 26 22
25 66584 27 1 1 4 2 4 5
26 66585 31 1 0 3 3 8 6
27 66586 32 1 3 2 4 9 6
28 66587 51 1 5 4 2 26 22
29 66588 52 1 4 4 2 25 25
30 66589 26 1 1 4 2 3 2
2
31 66590 28 1 0 2 2 4 5
32 66591 45 1 2 4 3 23 21
33 66592 39 1 5 2 2 8 10
34 66593 52 1 3 4 2 30 28
35 66594 52 1 4 3 2 7 10
36 66595 40 0 1 4 3 16 16
37 66596 45 0 2 4 2 18 17
38 66597 49 1 3 4 2 25 23
39 66598 50 0 4 3 3 25 23
40 66599 35 0 5 3 2 10 12
41 66600 40 0 0 4 2 15 11
42 66601 47 0 4 3 2 14 11
43 66602 49 1 1 2 2 20 16
44 66603 47 0 2 3 3 14 12
45 66604 45 0 3 4 2 21 19
46 66605 44 0 5 4 2 20 16
47 66606 31 1 4 2 2 9 9
48 66607 34 1 0 3 4 9 9
49 66608 38 1 1 3 2 14 10
50 66609 33 1 2 2 4 10 12
3
Data imported in SPSS can be looked like this in “Data view” (Screen Shot)
4
2. Descriptive Statistics
Descriptive Statistics
Std.
N Minimum Maximum Mean Deviation
Age 50 26 52 41.10 7.396
JS 50 2 5 3.38 .780
WLS 50 2 4 2.46 .613
YOS 50 3 50 17.00 8.364
Salary 50 2 30 15.60 6.661
Valid N 50
(listwise)
Interpretation of Results
From above mean data (3.48) it is clear that the Job satisfaction level of employee is
more skewed towards satisfaction in the company. However Work Life balance mean
data( 2.46) is more towards unbalanced life.
Average age mean data (41.10) shows that most people are in middle level management
level in the company. Average salary per annum is around 15.60 lacs which is quite
good.
Standard deviations shows the variability or spread of data around mean. Age ,YOS and
Salary showing wide gap.
5
3. Histograms and Box plots
Frequencies
Statistics
Age G JS WLS YOS Salary D
N Valid 50 50 50 50 50 50 50
Missin 0 0 0 0 0 0 0
g
Interpretation of Results
From above age profile it is clear that most of the employee is in the middle ranging
from 30-40 years.
6
Interpretation of Results
From above gender profile it is clear that no. of male and female employee are almost
same. Gender equality is good.
Interpretation of Results
From above Job Satisfaction it is clear that most employees are satisfied as more
employees are giving score of 3 (neutral) and 4 (Agreed).
7
Interpretation of Results
From above Job Satisfaction it is clear that most employees are having work-life balance
not balanced as data is positively skewed.
Interpretation of Results
From above Year of Service it is clear that most employees are in the middle and
experienced having in the range of 10-30 years with one outlier 50 years.
8
Interpretation of Results
From above Salary data it is clear that there is a vide variation in the salary of employee
with maximum employee (12 in no.) getting 13 lacs per annum and highest salary is 30
lacs .
Box Plots
9
Interpretation of Results
• From the box plot, it shows the distribution between upper (Q1)& lower
quartiles(Q3) referred as the whiskers alongwith the median. The smallest
and largest values are shown as the hinges .
• From the above box plot, Median is pulled towards the lower hinges in case
of Age ,YOS and salary. In most cases , Positive Skew is represented by box
plot. One outliers is found at sl no. 14 of the respondent in the YOS.
______________________________________________________________________
3. Correlations
Hypothesis (Null)
Ho: There exists no correlation between Job Satisfaction Work_Life_Balance,
Years_At_Company, and Salary
H1: There exists a correlation between Job Satisfaction Work_Life_Balance,
Years_At_Company, and Salary.
Correlations
JS WLS YOS Salary
JS Pearson 1 -.373** .566** .580**
Correlation
Sig. (2-tailed) .008 <.001 <.001
N 50 50 50 50
WLS Pearson -.373 ** 1 -.267 -.274
Correlation
Sig. (2-tailed) .008 .061 .054
N 50 50 50 50
YOS Pearson .566 ** -.267 1 .923**
Correlation
Sig. (2-tailed) <.001 .061 <.001
N 50 50 50 50
Salary Pearson .580 ** -.274 .923** 1
Correlation
Sig. (2-tailed) <.001 .054 <.001
N 50 50 50 50
**. Correlation is significant at the 0.01 level (2-tailed).
10
Interpretation of Results
From above as the Pearson co-efficient r = (-) 0.373 (between JS -WLS) ; r = (+) 0.566
(between JS -YOS); r = (+) 0.580 (between JS -Salary), it was clear that Year of
Service and Salary has a positive and direct link with Job Satisfaction where as Work
Life balance has a negative co-relation with Job Satisfaction. The result obtained was
very much significant at 0.01 level (p=0.008 and p<0.001).- Null hypothesis rejected in
this case.
From above Work life balance has insignificant co-relation with Year of service
(r = (-).267 ) and Salary (r = (-).274)- Null Hypothesis accepted in this case
Also Year of service has significant positive corelation with salary ( r = (+)0.923)- Null
hypothesis rejected in this case.
4. One way ANOVA was constructed to find out any significant difference in
mean Job Satisfaction scores across different departments.
Ho: There is No significant difference in mean Job Satisfaction scores across different
departments.
H1: There is significant difference in mean Job Satisfaction scores across different
departments.
ANOVA
JS
Sum of Mean
Squares df Square F Sig.
Between .351 5 .070 .105 .991
Groups
Within Groups 29.429 44 .669
Total 29.780 49
11
ANOVA Effect Sizesa,b
95% Confidence
Point Interval
Estimate Lower Upper
JS Eta-squared .012 .000 .000
Epsilon-squared -.100 -.114 -.114
Omega-squared Fixed- -.098 -.111 -.111
effect
Omega-squared -.018 -.020 -.020
Random-effect
a. Eta-squared and Epsilon-squared are estimated based on the fixed-
effect model.
b. Negative but less biased estimates are retained, not rounded to zero.
Interpretation of Results
From above table the results reveal that there is no significant difference in mean across
departments in the employees on the basis of Job Satisfaction levels, as F value 0.105 is
less than the F critical value at 0.05 significance levels (F=2.427) and also at 0.01
significance levels (F= 3.465). Null hypothesis is accepted.
_______________________________________________________________________
12
5. MAJOR FINDINGS AND CONCLUSION
The survey and findings suggest that there was a significant and direct connection
between Job satisfaction and Salary and also more year of service brings more Job
Satisfaction as evident from the Pearson co-relation co-efficient ; r = (+) 0.566
(between JS -YOS) and r = (+) 0.580 (between JS -Salary).
Work life Balance has nothing to do with Job satisfaction , Salary, year of service as
evident from correlation results , however it depends on individual how it handles
the situation both at work and life front.
As mean Job satisfaction is same cutting across department basis ANOVA findings
which suggests that company is having good retention policy.
It is therefore concluded that Better pay package is strong motivator along with
experience in a company for Job satisfaction.
_________________________________________________________________________
13
