DATA SET
The data set that has been used to Analyze is for employee salary of the firm including
employees ID, Gender, Birthday dates, educational level, job category, current salary, beginning
salary, months since hire, previous experience.
In this specific data set we will try to analyze the data through descriptive, frequency
distribution and apply one sample T-Test and Independent T-Test.
Descriptive data
Descriptive Statistics
N Minimum Maximum Sum Mean Std. Deviation Skewness
Statistic Statistic Statistic Statistic Statistic Statistic Statistic Std. Error
Beginning Salary 15 $9,750 $27,000 $233,250 $15,550.00 $4,393.624 1.345 .580
Current Salary 15 $21,450 $57,000 $476,250 $31,750.00 $9,777.598 1.360 .580
Valid N (listwise) 15
The data set presented above is the descriptive data analyze to show the minimum, maximum,
sum, mean, Std. Deviation, skewness, for the beginning and current salary of the firm
employees.
Frequency table
For the frequency table as it presented below shows the frequency distribution of the data set
plus the pie charts for the beginning and current salary of the firm employees which includes
the mean , Std. Deviation , skewness, minimum, maximum and the sum of the data.
Statistics
Beginning Salary Current Salary
Valid 15 15
N
Missing 0 0
Mean $15,550.00 $31,750.00
Std. Deviation $4,393.624 $9,777.598
Skewness 1.345 1.360
Std. Error of Skewness .580 .580
Minimum $9,750 $21,450
Maximum $27,000 $57,000
Sum $233,250 $476,250
One sample T-test
One-Sample Statistics
N Mean Std. Deviation Std. Error Mean
Current Salary 15 $31,750.00 $9,777.598 $2,524.565
One-Sample Test
Test Value = 20000
t df Sig. (2-tailed) Mean Difference 95% Confidence Interval of the Dif-
ference
Lower Upper
Current Salary 4.654 14 .000 $11,750.000 $6,335.35 $17,164.65
In the tables above we see the one sample T-test which has been tested as follows.
I predicted that the average monthly salary for the current salary of the employee working for the firm
is 20,000 US dollars. And I would like to test whether there is a difference between the average monthly
salary predicted by their current salary by collecting data from 20 employee of the firm this district
through a questionnaire. (α=0.05)
H0: µ = 20000 H1: µ ≠ 20000
Test Value: The number we entered as the test value in the One-Sample T Test window.
t Statistic: The test statistic of the one-sample t test, denoted t. In this example for the price, t = 4.654
df: The degrees of freedom for the test. For a one-sample t test, df = n - 1; so here for both data set,
df = 15- 1 = 14. There for df= 14
Sig. (2-tailed): The two-tailed p-value corresponding to the test statistic.
p < 0.05 Null hypothesis is rejected because p=.000
Mean Difference: The difference between the "observed" sample mean (from the One Sample Statistics
box) and the "expected" mean (the specified test value). The sign of the mean difference corresponds to
the sign of the t value.
Independent-sample T-test
Group Statistics
Gender N Mean Std. Deviation Std. Error Mean
male 8 $30,637.50 $11,771.417 $4,161.824
Current Salary
female 7 $33,021.43 $7,607.445 $2,875.344
male 8 $14,906.25 $5,275.918 $1,865.319
Beginning Salary
female 7 $16,285.71 $3,374.008 $1,275.255
Independent Samples Test
Levene's Test for t-test for Equality of Means
Equality of Variances
F Sig. t df Sig. (2- Mean Dif- Std. Error 95% Confidence Inter-
tailed) ference Difference val of the Difference
Lower Upper
- -
Equal variances $5,209.62 $8,870.77
.287 .601 -.458- 13 .655 $2,383.92 $13,638.6
assumed 3 8
Current 9 35
Salary - -
Equal variances 12.06 $5,058.49 $8,630.57
-.471- .646 $2,383.92 $13,398.4
not assumed 9 6 8
9 35
- -
Equal variances $2,328.53 $3,651.02
.205 .658 -.592- 13 .564 $1,379.46 $6,409.95
assumed 2 4
Beginning 4 2
Salary - -
Equal variances 12.01 $2,259.57 $3,543.21
-.610- .553 $1,379.46 $6,302.14
not assumed 1 7 2
4 0
As we calculated the beginning salary and the current salary of our firms male and females
differences and applied independent sample t test on both variables and as a conclusion we see
that p >.05 is bigger than our chosen significance level α = 0.05, we can accept the null
hypothesis.
