0% found this document useful (0 votes)
30 views34 pages

Group 11

Uploaded by

6531209073
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
30 views34 pages

Group 11

Uploaded by

6531209073
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 34

1 H0: µ=3

H1: µ≠3

3 T-test value p-value Result


-4.092 0.0001 refect H0

4 There is enough evidence to conclude that the average number of projects completed in the last year is sig
completed in the last year is significantly different from a normal value of 3.
t Test for Hypothesis of the Mean

Data
Null Hypothesis m= 3
Level of Significance 0.05
Sample Size 200
Sample Mean 2.52
Sample Standard Deviation 1.659

Intermediate Calculations
Standard Error of the Mean 0.1173
Degrees of Freedom 199
t Test Statistic -4.0918

Two-Tail Test
Lower Critical Value -1.9720
Upper Critical Value 1.9720
p-Value 0.0001
Reject the null hypothesis
1 H0:µD=0
H1:µD≠0
2
t-Test: Paired Two Sample for Means

4. Performance Score Before Training


Mean 5.16
Variance 8.53708542713568
Observations 200
Pearson Correlation 0.0966270473677615
Hypothesized Mean Difference 0
df 199
t Stat -1.47877358915675
P(T<=t) one-tail 0.0703909854040568
t Critical one-tail 1.65254674616656
P(T<=t) two-tail 0.140781970808114
t Critical two-tail 1.97195654425176
5. Performance Score After Training
5.575
8.89886934673367
200
1 H0:µ1=µ2=µ3
H1:µ1≠µ2≠µ3

2
D1 D2 D3 D4
4 8 5 9
3 7 6 5
5 5 6 5
10 5 6 10
1 1 2 3
6 5 3 7
5 10 8 10
10 8 3 10
9 5 5 2
5 2 7 9
5 3 3 6
7 3 3 8
4 3 5 5
3 8 10 6
8 7 6 8
4 10 10 5
2 3 2 10
1 4 8 3
3 6 2 4
5 3 6 8
10 1 2 5
9 3 3 7
10 8 4 1
6 1 8 9
1 10 10 5
4 3 9 8
5 6 4 3
9 1 4 7
6 4 8 5
9 1 5 2
3 7 2 6
2 6 9 9
7 1 2 9
10 5 7 5
2 5 4 8
5 8 4 4
1 2 5 7
1 7 2 5
9 10 4 2
2 3 4 10
3 10 1 10
4 8 6
3 1 8
6 6 4
6 9 6
8 6 10
7 7 6
10 2
8 10
6 8
1 6
4 8
9 4
4
2
8
3
8
5
Tukey-Kramer Multiple Comparisons

Sample Sample Absolute Std. Error Critical


Group Mean Size Comparison Difference of Difference Range
1: D1 5.355932 59 Group 1 to Group 2 0.282761 0.39385774 0
2: D2 5.073171 41 Group 1 to Group 3 0.035177 0.366608381 0
3: D3 5.320755 53 Group 1 to Group 4 1.027047 0.378734891 0
4: D4 6.382979 47 Group 2 to Group 3 0.247584 0.402894541 0
Group 2 to Group 4 1.309808 0.413959447 0
Other Data Group 3 to Group 4 1.062224 0.388123961 0
Level of significance 0.05
Numerator d.f. 4
Denominator d.f. 196
MSW 7.504895
Q Statistic
Results are NOT valid until Q Statistic is entered into B15
Means are different
Means are different
Means are different
Means are different
Means are different
Means are different
ANOVA: Single Factor Calculations
c 4
SUMMARY n 200
Groups Count Sum Average Variance
D1 59 316 5.355932203 8.2332
D2 41 208 5.073170732 8.4195
D3 53 282 5.320754717 6.8759
D4 47 300 6.382978723 6.5023

ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 46.8605 3 15.6202 2.0813 0.1040 2.6507
Within Groups 1470.9595 196 7.5049

Total 1517.8200 199


Level of significance 0.05
4. Performance Score Before Training
-6.078869
Mean 5.16 0.521738
Standard Error 0.206604518672
Median 5
Mode 1
Standard Deviation 2.922
Sample Variance 8.537085427136
Kurtosis -1.25592187329
Skewness 0.107793443719
Range 9
Minimum 1
Maximum 10
Sum 1032
Count 200
5. Performance Score After Training
-6.275872
Mean 5.575 0.096285
Standard Error 0.2109368311
Median 6
Mode 10
Standard Deviation 2.983
Sample Variance 8.8988693467
Kurtosis -1.3238124714
Skewness 0.0203100349
Range 9
Minimum 1
Maximum 10
Sum 1115
Count 200
6. Job Satisfaction Before Training
-5.805903
Mean 5.595 -0.04748
Standard Error 0.2043616732
Median 6
Mode 10
Standard Deviation 2.890
Sample Variance 8.3527386935
Kurtosis -1.1865040611
Skewness -0.0097031407
Range 9
Minimum 1
Maximum 10
Sum 1119
Count 200
7. Job Satisfaction After Training
-6.147379
Mean 5.47 0.446126
Standard Error 0.2021132077
Median 5
Mode 7
Standard Deviation 2.858
Sample Variance 8.1699497487
Kurtosis -1.242466512
Skewness 0.0901679031
Range 9
Minimum 1
Maximum 10
Sum 1094
Count 200
11. Team Cohesiveness

Mean 5.555 -5.666432


Standard Error 0.1965401106 0.340424
Median 5
Mode 5
Standard Deviation 2.7794968996
Sample Variance 7.7256030151
Kurtosis -1.1136812655
Skewness 0.0669069161
Range 9
Minimum 1
Maximum 10
Sum 1111
Count 200
1. Age 2. Gender 3. Department 4. Performance Score Before Training
30 1 1 9
36 1 3 10
42 1 3 1
33 1 3 10
39 1 1 8
41 1 2 4
45 2 3 6
31 2 1 3
35 2 1 8
33 2 1 6
29 1 4 3
42 2 2 9
34 1 1 4
40 1 3 1
44 2 1 6
34 2 1 1
41 2 3 7
31 1 3 10
28 1 4 4
30 1 4 3
35 1 3 1
44 2 3 8
37 2 2 8
37 1 1 5
44 1 3 6
35 1 2 6
45 2 1 4
37 2 2 6
30 2 1 1
30 2 2 1
36 2 2 3
38 2 1 6
28 2 2 9
30 2 3 4
37 1 1 3
43 1 4 2
33 1 2 3
36 1 3 2
36 2 3 5
45 2 4 2
32 1 4 4
35 1 4 6
36 2 2 2
39 1 1 2
43 1 4 6
34 1 1 1
39 2 1 9
28 1 4 8
45 2 3 1
44 2 2 9
35 1 3 5
28 1 3 5
34 1 3 2
41 1 1 2
44 2 2 8
44 1 3 1
34 1 3 2
41 1 2 5
43 1 1 5
37 1 4 1
40 2 1 1
41 2 3 10
43 1 4 3
41 1 2 5
28 2 4 7
39 1 4 8
42 2 3 3
30 1 1 9
35 2 3 8
30 2 3 1
36 2 1 5
33 2 1 5
43 2 1 2
41 1 2 4
29 1 1 1
42 2 2 7
42 2 3 3
39 1 1 3
28 2 4 9
38 2 2 9
40 1 3 8
41 1 1 9
30 1 3 6
39 1 1 9
36 1 4 7
45 2 4 1
31 2 1 6
44 1 4 9
40 1 2 1
44 2 2 2
44 2 2 4
41 2 3 9
44 1 3 7
40 1 1 2
42 2 1 1
37 1 1 3
38 1 3 10
34 2 3 4
43 2 1 2
42 1 1 1
42 2 1 6
40 1 4 4
37 1 1 9
38 2 4 10
43 1 1 7
28 1 3 1
31 2 4 6
29 1 3 1
33 2 4 3
44 2 4 3
33 1 1 3
30 1 1 5
45 1 1 4
41 2 4 3
45 1 2 9
35 2 3 3
40 2 1 8
38 1 4 1
36 2 3 5
37 1 2 10
33 1 3 5
43 2 3 4
32 2 3 7
36 1 2 10
35 2 2 1
32 2 4 2
30 1 2 7
44 1 2 6
28 2 1 9
36 1 2 2
33 1 2 10
30 1 3 7
40 1 3 7
40 1 4 4
33 2 3 4
30 2 3 7
36 2 1 5
39 2 4 5
35 1 2 10
29 1 2 6
39 1 4 8
31 1 4 3
28 1 1 1
33 1 4 7
28 1 2 9
33 2 4 10
36 2 1 8
45 2 1 3
42 1 2 4
29 1 2 4
42 1 1 7
33 1 3 5
38 2 3 10
37 2 4 9
44 2 4 9
39 1 4 9
43 2 4 2
31 2 3 8
38 1 4 1
30 2 1 8
40 2 1 6
32 2 1 6
31 1 2 4
28 1 1 1
42 2 1 4
34 2 1 3
42 2 3 3
35 1 1 3
43 1 3 6
42 1 3 6
36 2 4 2
42 1 2 1
41 2 4 4
32 2 4 3
29 2 3 7
30 2 4 9
40 1 3 2
33 2 1 5
41 2 1 9
40 2 2 3
41 2 4 2
41 2 2 8
31 1 1 1
43 1 4 1
43 2 3 10
31 2 4 7
29 1 1 2
44 2 4 6
30 2 3 10
28 2 1 1
30 2 2 10
41 1 2 5
28 1 4 7
28 2 2 7
41 1 4 2
42 1 4 7
30 1 2 8
42 2 3 6
34 1 3 6
31 1 1 9
5. Performance Score After Training 6. Job Satisfaction Before Training
6 8
10 1
6 7
10 10
9 1
2 10
8 4
9 6
1 2
4 5
3 6
10 2
2 6
6 6
9 5
3 5
1 6
7 5
9 10
10 10
6 9
6 4
2 7
8 7
3 2
3 9
10 6
8 10
4 2
3 7
2 10
9 8
9 7
1 6
10 10
5 6
2 8
3 3
5 9
4 4
10 1
8 1
2 1
2 6
4 8
2 3
10 3
10 4
3 6
6 2
1 9
4 5
4 3
2 7
3 4
10 2
3 3
8 5
10 5
3 9
9 9
4 3
2 9
7 8
5 8
7 5
10 2
6 1
4 8
5 6
3 7
6 1
10 5
1 5
7 10
1 10
2 7
4 9
10 8
9 9
2 3
10 1
1 2
9 3
5 2
7 4
3 8
2 5
7 10
3 8
3 9
2 4
5 10
3 10
8 2
8 5
2 9
2 6
1 2
6 10
3 9
10 9
7 8
2 10
10 5
4 1
1 8
6 8
3 6
10 8
7 9
4 4
9 2
8 6
7 7
6 7
7 4
2 5
7 1
3 8
6 1
9 6
6 6
5 6
1 10
10 4
5 7
4 10
6 5
2 1
4 8
1 4
5 9
1 4
1 10
6 10
3 2
4 1
8 5
8 3
8 10
9 3
2 2
3 8
1 1
8 9
5 7
9 4
9 10
3 7
7 4
6 7
8 5
10 4
8 1
5 1
9 2
8 2
10 7
5 4
9 6
10 4
6 4
9 4
2 2
2 1
7 5
3 2
9 2
9 9
1 5
5 5
7 5
8 10
10 1
4 3
1 6
6 6
5 5
6 6
8 6
9 3
10 1
5 9
2 4
2 10
8 2
1 5
6 10
7 8
10 3
10 7
4 3
8 9
6 6
7 8
4 2
1 4
4 4
6 10
7. Job Satisfaction After Training 8. Remote Work Availability 9. Health 10. Inter-
1 1 3 1
1 1 2 3
8 1 3 4
4 2 1 1
7 2 1 1
10 1 2 2
5 2 3 4
1 2 2 3
3 1 1 4
3 2 2 1
3 2 3 4
10 1 1 1
7 2 1 3
8 2 1 1
9 1 2 3
2 2 2 2
4 1 3 1
4 1 2 1
3 1 3 3
2 1 3 3
8 2 2 4
5 2 2 2
9 1 1 3
4 2 1 3
3 1 3 2
8 2 1 4
4 1 2 1
9 1 1 1
5 1 3 3
10 1 2 4
7 1 1 3
9 2 2 1
2 1 1 3
8 2 2 3
9 1 2 3
8 1 2 4
10 1 3 4
6 1 2 1
1 2 2 2
2 1 1 4
10 2 3 1
2 2 3 1
4 2 3 1
1 2 1 2
10 2 3 1
7 1 2 1
1 2 1 3
2 1 2 1
10 2 3 2
2 2 1 2
3 2 2 3
6 1 3 2
4 1 2 3
3 1 2 1
9 2 2 2
7 1 2 3
7 1 2 4
3 1 1 4
4 1 3 2
3 1 1 4
6 2 1 3
7 1 3 3
4 1 1 4
7 2 1 2
5 2 3 3
8 1 2 1
3 2 2 1
4 1 3 3
1 1 2 4
8 2 3 3
6 1 3 3
4 1 1 1
5 1 2 4
3 1 3 3
5 1 1 1
10 2 3 4
4 2 2 4
4 1 2 3
1 2 3 2
1 1 3 2
10 2 2 4
9 2 2 1
9 1 2 1
5 2 3 2
10 1 1 3
6 2 1 2
4 1 2 2
5 1 1 3
1 1 3 4
7 2 3 2
8 2 3 1
4 2 2 3
9 2 3 1
5 2 2 3
9 2 2 1
7 1 1 1
7 1 2 1
10 2 2 4
1 2 2 1
7 2 3 1
9 2 1 2
5 1 2 2
3 2 2 2
4 2 3 4
2 1 3 4
2 2 1 3
8 1 1 3
7 2 1 3
1 2 2 2
2 2 2 3
7 1 3 3
6 1 3 2
10 2 2 3
2 2 3 2
9 2 1 1
8 2 3 1
2 1 2 3
10 2 1 3
7 1 3 1
2 1 3 4
8 1 3 3
9 1 2 3
7 2 3 2
5 1 2 1
5 1 2 1
4 1 1 3
6 2 1 4
5 1 3 1
10 1 1 1
2 1 2 4
5 1 3 1
9 1 1 1
9 2 1 3
3 1 3 2
4 1 3 3
3 2 1 4
4 1 3 4
1 2 1 2
9 1 1 1
5 2 2 1
5 1 2 1
9 2 1 4
2 1 1 2
5 1 3 1
4 1 1 1
2 1 3 2
7 2 3 2
6 2 2 3
8 1 1 1
9 1 1 1
10 2 3 1
1 2 2 3
5 2 1 4
9 1 3 2
3 2 1 2
6 2 1 4
3 2 2 2
9 2 3 3
3 1 2 3
10 1 3 4
2 1 3 4
4 1 3 2
1 1 2 3
3 1 2 4
2 2 2 3
3 1 2 2
5 1 2 1
3 1 3 4
7 2 3 1
5 2 2 1
5 1 1 2
9 2 2 3
7 2 1 1
3 2 1 2
10 2 2 1
3 1 1 3
6 2 1 4
1 2 2 2
9 1 2 3
5 2 3 3
4 1 3 2
10 2 1 3
8 1 3 2
5 2 3 4
2 1 3 3
10 2 1 1
2 1 2 2
2 1 2 3
4 1 1 1
3 2 3 2
7 2 3 1
9 1 1 4
2 1 1 2
7 1 2 1
7 1 2 2
7 2 3 2
6 1 1 1
10 2 1 3
7 2 2 2
5 1 2 2
11. Team Cohesiveness 12. Feedback on Man 13. Number of Projects Completed in the Last Year
4 0
5 2
6 4
6 1
3 3
8 3
6 quick to respond 3
5 2
10 1
1 5
9 5
7 2
6 0
2 3
5 2
10 2
3 2
8 4
5 5
5 strong understanding 5
3 1
5 5
5 3
9 effective 2
7 1
5 3
5 1
1 0
5 5
5 5
10 4
7 5
8 5
3 2
4 5
10 0
5 2
3 0
5 1
3 2
7 2
10 4
2 1
3 3
10 2
8 5
4 3
2 4
10 3
3 3
6 3
10 0
2 1
2 2
3 1
8 easily accessible 5
2 1
3 4
1 engages with custome 2
9 5
3 4
6 2
6 0
8 2
8 0
5 1
2 1
5 4
3 1
4 1
10 2
9 1
10 5
7 3
6 3
10 3
8 0
1 2
6 0
3 1
10 3
4 2
9 1
5 1
8 clear and informative 1
5 1
9 5
10 5
4 5
6 5
3 0
4 3
4 4
6 5
9 3
3 4
8 3
5 0
2 4
7 good staff 1
10 3
3 5
2 4
4 3
5 4
2 4
8 3
9 3
5 3
7 2
1 5
1 2
9 2
1 3
1 0
2 1
2 2
9 0
7 5
3 2
4 2
4 4
5 5
8 1
1 5
5 2
10 3
3 5
3 0
6 4
1 3
2 4
4 0
8 4
4 2
1 2
4 2
3 0
4 4
1 2
7 5
5 0
3 0
2 0
7 2
6 1
6 5
6 3
6 4
1 3
8 3
8 0
1 4
9 3
9 5
5 4
8 1
6 2
4 1
7 4
10 good operates 1
8 1
5 1
6 5
1 5
4 2
9 0
9 5
6 3
7 3
7 0
5 3
5 0
2 3
2 1
10 4
10 5
4 0
2 4
8 2
10 3
2 4
8 0
6 3
8 2
8 0
3 5
4 3
6 1
8 0
7 3
10 5
6 0
3 4
10 well-organized 2
6 2
10 1
8 3
4 1
5 2
he Last Year

You might also like