Scribd
Upload
115 views9 pages

SPSS LAB Assignment 3

This document contains a report submitted by Nikita Shakya analyzing inferential statistics related to employee data. The report includes t-tests, crosstabs, correlations, and regression analyses examining relationships between gender, employment category, beginning salary, job time, and previous experience. Key findings are that male employees on average earn significantly more than female employees, and that beginning salary is positively correlated with employment category and previous experience.

Uploaded by

Nikita Shakya
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
115 views9 pages

SPSS LAB Assignment 3

This document contains a report submitted by Nikita Shakya analyzing inferential statistics related to employee data. The report includes t-tests, crosstabs, correlations, and regression analyses examining relationships between gender, employment category, beginning salary, job time, and previous experience. Key findings are that male employees on average earn significantly more than female employees, and that beginning salary is positively correlated with employment category and previous experience.

Uploaded by

Nikita Shakya
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
You are on page 1/ 9

RAJASTHAN TECHNICAL UNIVERSITY

KOTA

REPORT ON
“INFERENTIAL ANALYSIS”

SUBMITTED TO

STATISTICAL LAB OF MECHANICAL ENGG


DEPARTMENT OF RAJASTHAN TECHNICAL
UNIVERSITY KOTA

SUBMITTED BY

NIKITA SHAKYA (17/237)


BATCH- P2
REPORT CONTENT

LIST OF TABLES

➢ T-TEST
• Group Statics
• Independent Samples test

➢ Crosstabs
• Case Processing Summary
• Gender * Employment Category Crosstabulation
• Chi-Square Tests

➢ Correlations: Employment Category & Beginning Salary


• Descriptive Statistics
• Correlations

➢ Correlations: Beginning salary, job time and previous experience


• Descriptive Statistics
• Correlations

➢ Regression
• Variables Entered/Removed
• Model Summary
• Anova
• Coefficients
T-Test

Group Statistics
Std. Error
Gender N Mean Std. Deviation Mean
Beginning Salary Female 216 $13,091.97 $2,935.599 $199.742

Male 258 $20,301.40 $9,111.781 $567.275

Independent Samples Test

Levene's Test for Equality of t-test for Equality of

Variances Means

F Sig. t df
Beginning Equal variances assumed 105.969 .000 -11.152 472
Salary
Equal variances not
assumed 318.818
-11.987

Independent Samples Test

t-test for Equality of Means


Std. Error

Sig. (2-tailed) Mean Difference Difference

Beginning Salary Equal variances assumed . -$7,209.428


000 . $646.447
Equal variances not assumed 000 -$7,209.428 $601.413

Independent Samples Test

t-test for Equality of Means

95% Confidence Interval of the Difference

Lower Upper
Beginning Salary Equal variances assumed -$8,479.698 -$5,939.158

Equal variances not assumed -$8,392.667 -$6,026.188

Crosstabs

Case Processing Summary

Cases
V
a lid Missing Total

N Percent N Percent N Percent

Gender * Employment 47
100.0% 0 0.0% 474 100.0%
4
Category

Gender * Employment Category Crosstabulation


Employment Category
Cleric Custodia Manage Total
al l r
GenderFemale
Count 206 0 10 216
Expected Count 165.4 12.3 38.3 216.0

% within Gender 95.4% 0.0% 4.6% 100.0%

% within Employment
56.7% 0.0% 11.9% 45.6%
Category
% of Total
43.5% 0.0% 2.1% 45.6%
Male Count 157 27 74 258

Expected Count 197.6 14.7 45.7 258.0

% within Gender 60.9% 10.5% 28.7% 100.0%

% within Employment
43.3% 100.0% 88.1% 54.4%
Category
% of Total
33.1% 5.7% 15.6% 54.4%
Total Count 363 27 84 474

Expected Count 363.0 27.0 84.0 474.0

% within Gender 76.6% 5.7% 17.7% 100.0%

% within Employment
100.0% 100.0% 100.0% 100.0%
Category

% of Total
76.6% 5.7% 17.7% 100.0%

Chi-Square Tests

Asymp. Sig.

Value df (2-sided)

a
Pearson Chi-Square 79.277 2 .000
Likelihood Ratio 95.463 2 .000

N of Valid Cases 474

a. 0 cells (0.0%) have expected count less than 5. The minimum


expected count is 12.30.

Correlations

Descriptive Statistics

Mean Std. Deviation N


Employment Category 1.41 .773 474

Beginning Salary $17,016.09 $7,870.638 474

Correlations
Employment Beginning

Category Salary
Employment
**
Category Pearson Correlation 1 .755
Sig. (2-tailed) .000

Sum of Squares and


282.778 2172283.133
Cross-products
Covariance
.598 4592.565

N 474 474
Beginning Salary **
.755
Pearson Correlation 1
Sig. (2-tailed) .000

Sum of Squares and 29300904965.4


2172283.133
Cross-products 54
Covariance 4592.565 61946944.959

N 474 474
**. Correlation is significant at the 0.01 level (2-tailed).
Correlations

Descriptive Statistics

Mean Std. Deviation N


Beginning Salary $17,016.09 $7,870.638 474

Months since Hire 81.11 10.061 474


Previous Experience
95.86 104.586 474
(months)

Correlations
Previous

Beginning Months since Experience


Salary Hire (months)
Beginning Salary Pearson Correlation 1 -.020 .045

Sig. (2-tailed) .668 .327

2930090496
Sum of Squares and
5.4 -739866.498 17573776.709
Cross-products 54
Covariance 61946944.959 -1564.200 37153.862

N 474 474 474


Months since
Pearson Correlation -.020 .003
Hire
Sig. (2-tailed) .668 .948

Sum of Squares and


-739866.498 47878.295 1482.241
Cross-products
Covariance
-1564.200 101.223 3.134
N 474 474 474
Previous
Pearson Correlation .045 .003 1
Experience
Sig. (2-tailed) .327 .948
(months)
Sum of Squares and
17573776.709 1482.241 5173806.810
Cross-products
Covariance
37153.862 3.134 10938.281
N 474 474 474

Regression

a
Variables Entered/Removed
Variables Variables

Model Entered Removed Method


Employment
1
Category,
Months since
Enter
Hire, Previous
Experience
b
(months)

a. Dependent Variable: Beginning Salary

b. All requested variables entered.

Model Summary
Adjusted R Std. Error of the

Model R R Square Square Estimate


a
1 .755 .570 .567 $5,177.056

a. Predictors: (Constant), Employment Category, Months since


Hire, Previous Experience (months)

ANOVA

Sum of
Model Squares df Mean Square F Sig.
1 Regression 16704006172. 5568002057.
5 09 50 3 .000
b
207.746
Residual 12596898792.
9
470 26801912.325
44
Total
29300904965. 473
4 54

a. Dependent Variable: Beginning Salary

b. Predictors: (Constant), Employment Category, Months since Hire, Previous Experience (months) Coefficients
Standardized

Unstandardized Coefficients Coefficients

Model B Std. Error Beta t Sig.


1 (Constant) 7693.480 1988.472 3.869 .000
Previous Experience
-.157 2.281 -.002 -.069 .945
(months)

Months since Hire -18.595 23.660 -.024 -.786 .432

Employment Category 7684.544 308.475 .755 24.911 .000

a. Dependent Variable: Beginning Salary


SUMMARY

In this report we have taken data of Employee on the basis of Employee


Code, Gender, Date of Birth, Educational Level (years), Employment
Category, Current Salary, Beginning Salary, Months since Hire, Previous
Experience (months), Minority Classification.

First we have calculated T test in which we found STD error mean for
male and female employees from group statistics. Then from
inndependent sample test we found STD. error difference,& 95%
confidence interval of difference for lower & upper.

Then we have calculated crostabs in which there is a result of case


processing summary and gender employment category crosstabulation
in which we found total count %.

Then we have calculated correlation between employment category


and beginning salary in and then correlation between beginning salary
month since hire, previous experience.

Then we have calculated regression of dependent variable and all


requested variables entered then there is a model summary of
predictors , previous experience (months) , month since hire ,
employment category.

At last we have calculated ANOVA of the dependent variable ,


predictors employment category , months since hire , previous
experience and coffecient

You might also like