Final Project Qam-II
Final Project Qam-II
Final Project Qam-II
HIGH
Sl. No.
SCHOOL INTERMEDIATE GRADUATION CAT %ILE SUBJECT GENDER
1 89 88 58 64 1 1
2 82 78 64 64 3 1
3 66.6 72 58 60 2 1
4 81.2 76 69 85 2 1
5 65 64 62 56 2 1
6 72 72 63 66 3 1
7 60 76 66 76 3 1
8 78 89 70 89 3 1
9 80 73 65 68 3 1
10 73 54 54 70 3 1
11 55 61 57 82 2 1
12 75 60 61 95.5 1 1
13 59 67 61 50 2 1
14 63 82 62 71 2 1
15 62 64 59 77 3 1
16 72 81 66 83 1 1
17 62 83 63 68 3 1
18 58 68 67 72 1 1
19 85 61 58 70 3 1
20 57 78 70 85 1 1
21 74 78 61 75 3 1
22 80 87 66 63 4 1
23 71 74 64 62 3 1
24 72 88 77 72 1 1
25 88 72 60 72 4 1
26 67 75 63 87 3 1
27 74 78 69 92 3 1
28 78 70 62 60 3 1
29 79 79 66 73 3 1
30 73 70 63 78 1 2
31 69 66 63 64 3 2
32 72 69 65 65 2 2
33 60 61 62 67 3 2
34 78 74 73 79 2 2
35 60 61 65 69 1 2
36 89 89 72 75 3 2
37 83 78 70 91 3 2
38 79 79 73 80 1 2
39 62 72 72 60 3 2
40 70 73 60 55 2 2
41 56 69 60 55 3 2
42 78 78 63 82 3 2
43 65 70 60 70 4 2
44 61 81 63 54 1 2
45 82 80 70 65 3 2
46 73 74 63 68 3 2
47 52 62 57 55 2 2
48 65 51 59 83 1 2
49 78 81 75 70 2 2
50 60 66 59 56 2 2
51 81 79 74 90 2 2
52 80 78 63 64 3 2
53 60 63 61 67 2 2
54 70 72 58 58 2 2
55 67 63 68 74 3 2
56 65 70 58 75 3 2
57 57 64 65 71 3 2
58 68 65 57 77 2 2
59 62 59 69 54 1 2
60 63 55 58 67 4 2
61 60 62 70 90 2 2
62 62 60 75 64 1 2
63 67 65 59 60 3 2
1
HIGH SCHOOL DATA STASTICIS OF D- SECTION
Mean 69.60967742
Standard Error 1.158688033
Median 69.5 Symmetry:
Mode 60
The Skew ness measure
Standard Deviation 9.123518693 indicates the level of non-
Sample Variance 83.23859334 symmetry. If the distribution
Kurtosis -0.960082856 of the data are symmetric then
Skewness 0.173562885 skew ness will be close to 0
Range 37
(zero). The further from 0, the
more skewed the data. A
Minimum 52
negative value indicates a
Maximum 89 skew to the left. The skew ness
Sum 4315.8 reported by Excel is .17356, so
Count 62 the data can be assumed to be
Largest(1) 89
fairly symmetric and it is
positively skewed
Smallest(1) 52
Kurtosis is a measure of the
Confidence Level(95.0%) 2.316939896 peaked ness of the data. Again,
for normally distribute data the
kurtosis is 0 (zero). The excel value for same is -.96.this shows that data is
quite peaked. Negative kurtosis indicates a relatively peaked distribution
Symmetry:
The Skewness measure indicates the level of non-symmetry. If the
distribution of the data are symmetric then skewness will be close to 0
(zero). The further from 0, the more skewed the data. A negative value
indicates a skew to the left. The skewness reported by Excel is -.0446, so
the data can be assumed to be fairly symmetric and it is negatively
skewed
Mean 64.27419355
Standard Error 0.679910933
Median 63
Mode 63
Standard Deviation 5.353624036
Sample Variance 28.66129032
Kurtosis -0.5147946
Skewness 0.493438425
Range 23
Minimum 54
Maximum 77
Sum 3985
Count 62
Largest(1) 77
Smallest(1) 54
Confidence
Level(95.0%) 1.359565924
Symmetry:
The Skewness measure indicates the level of non-symmetry. If the
distribution of the data are symmetric then skewness will be close to 0
(zero). The further from 0, the more skewed the data. A negative value
indicates a skew to the left. The skewness reported by Excel is .4934, so
the data can be assumed to be fairly symmetric and it is positively
skewed
Mean 70.89516129
Standard Error 1.401684466
Median 70
Mode 64
Standard Deviation 11.03687452
Sample Variance 121.8125992
Kurtosis -0.604687129
Skewness 0.287611654
Range 45.5
Minimum 50
Maximum 95.5
Sum 4395.5
Count 62
Largest(1) 95.5
Smallest(1) 50
Confidence
Level(95.0%) 2.80284129
Symmetry:
Arts and
Professional Science Commerce Humanities
58 62 63 58
64 59 65 70
58 66 62 75
69 63 73 59
62 67 65
63 58 72
66 70 70
70 61 73
65 66 72
54 64 60
57 77 60
61 60 63
61 63 60
69 63
62 70
66 63
63 57
59
75
59
74
63
61
58
68
58
65
57
69
SUMMARY
Groups Count Sum Average Variance
62.15384 22.141025
Professional 13 808 6 6
64.47058 21.514705
Science 17 1096 8 9
64.72413 32.064039
Commerce 29 1877 8 4
Arts and 69.666666
Humanities 4 262 65.5 7
ANOVA
Source of
Variation SS df MS F P-value F crit
23.45288 0.8060252 0.4955523 2.76076
Between Groups 70.35866 3 7 9 5 7
1716.720 29.09696
Within Groups 7 59 1
1787.079
Total 4 62
The most important result from the t-test is the probability, or P-value. Excel reports two; the
one that we need is the “two-tail” version. we see that P two-tail = 0.49555. Since this is less than α
= 0.05, we reject the null hypothesis and can say:
we conclude that the population means are different
we conclude that the samples are not “equivalent”