MARKS

68
68
68
68
68
68
68
68
68
68
68
68
68
68
59
45
39
80
59
62
49
76
54
60
53
55
62
58
67
55
86
56
63
64
67
50
51
78
56
62
57
69
58
52
42
66
42
56
58
57
 DATA Adding constant tiplying with constant
35 68 73 27.2
38 79 84 31.6
47 38 43 15.2
58 68 73 27.2
61 35 40 14
66 70 75 28
68 61 66 24.4
68 47 52 18.8
70 58 63 23.2
79 66 71 26.4
TOTAL 590 640 236
MEAN 59 64 23.6
MEDIAN 63.5 68.5 25.4
MODE 68 73 27.2
VARIANCE 210.8888889 210.888888888889 33.7422222222222
N 10 10 10
n 10 10 10
Population variance 189.8 189.8 30.368
Sample variance 210.888888888889 210.888888888889 33.7422222222222
Standard deviation 14.522013940528 14.522013940528 5.80880557621119
14.522013940528 14.522013940528 5.80880557621119
59 23.6
63.5
5.808805576

33.74222222
5.808805576

79
 Squared Deviations
81 81 12.96
400 400 64
441 441 70.56
81 81 12.96
576 576 92.16
121 121 19.36
4 4 0.64
144 144 23.04
1 1 0.16
49 49 7.84
1898 1898 303.68

210.8888889

33.74222222

5.808805576

0
 Percentile Rank Int part Frac part Elementvalue
1 35 0.1 1.9 1 0.9 35
2 38 0.25 3.25 3 0.25 47
3 47 0.3 3.7 3 0.7 47
4 58 0.4 4.6 4 0.6 58
5 61 0.5 5.5 5 0.5 61
6 66 0.6 6.4 6 0.4 66
7 68 0.75 7.75 7 0.75 68
8 68 0.8 8.2 8 0.2 68
9 70 0.9 9.1 9 0.1 70
10 79 1 10 10 0 79
10

Q1 49.75
Q3 68
IQR 18.25
Elementplusonevalue Percentile val Percentile funciton
38 37.7 37.7
58 49.75 49.75
58 54.7 54.7
61 59.8 59.8
66 63.5 63.5
68 66.8 66.8
68 68 68
70 68.4 68.4
79 70.9 70.9
79 79 79
 2 2 2
12 105 105
5 5 5
7 7 7
6 6 6
7 7 3
3 3
Mean 6 19.28571429 21.33333333
Median 6.5 6.5 5.5
Mode 7 7 #VALUE!
42 135 128
2

4 10 1 35 37.7 37.7

5 9 2 38 45.2 45.2

2 8 3 47 54.7 54.7

3 7 4 58 59.8 59.8

3 6 5 61 63.5 63.5

3 5 6 66 66.8 66.8

4 4 7 68 68 68

4 3 8 68 68.4 68.4
1 2 9 70 70.9 70.9
2 1 10 79 79 79
3
4
10 percentile 37.7
20 percentile 45.2
25 percentile 49.75 49.75
30 percentile 54.7

47.77 71.71
57.67 76.57
78.19
 36.35 Mod 1 percentile

35 37.7 0 35

41.15 1 38

36.35 38 45.2 2 47

41.15 49.75 3 58
58 - 11*(0.21)
49.75 47 54.7 4 61

58.45 58.45 5 66

61.25 58 59.8 6 68

65.75 61.25 7 68

67.7 61 63.5 8 70

68 65.75 9 79
69.3 66 66.8 10
74.95 67.7
68 68
68
68 68.4
69.3
70 70.9
74.95
79 79

34.5
Mod 1 percentile
Mod 2 percentile
Mod 3 percentile
Mod 4 percentile
Mod 5 percentile
Mod 6 percentile
Mod 7 percentile

35.27 35.54 35.81 36.08 36.35 36.62 36.89

38 - 3*(0.91) 38 - 3*(0.82) 38 - 3*(0.73) 38 - 3*(0.64) 38 - 3*(0.55) 38 - 3*(0.46) 38 - 3*(0.37)
37.97 38.72 39.53 40.34 41.15 41.96 42.77
38 - 3*(0.01) 47 - 9*(0.92) 47 - 9*(0.83) 47 - 9*(0.74) 47 - 9*(0.65) 47 - 9*(0.56) 47 - 9*(0.47)
46.01 46.82 47.77 48.76 49.75 50.74 51.73
47 - 9*(0.11) 47 - 9*(0.02)58 - 11*(0.93)58 - 11*(0.84)58 - 11*(0.75)58 - 11*(0.66)58 - 11*(0.57)
55.69 56.68 57.67 58.18 58.45 58.72 58.99
58 - 11*(0.21)58 - 11*(0.12)58 - 11*(0.03)61 - 3*(0.94) 61 - 3*(0.85) 61 - 3*(0.76) 61 - 3*(0.67)
60.07 60.34 60.61 60.88 61.25 61.7 62.15
61 - 3*(0.31) 61 - 3*(0.22) 61 - 3*(0.13) 61 - 3*(0.04) 66 - 5*(0.95) 66 - 5*(0.86) 66 - 5*(0.77)
63.95 64.4 64.85 65.3 65.75 66.08 66.26
66 - 5*(0.41) 66 - 5*(0.32) 66 - 5*(0.23) 66 - 5*(0.14) 66 - 5*(0.05) 68 - 2*(0.96) 68 - 2*(0.87)
66.98 67.16 67.34 67.52 67.7 67.88 68
68 - 2*(0.51) 68 - 2*(0.42) 68 - 2*(0.33) 68 - 2*(0.24) 68 - 2*(0.15) 68 - 2*(0.06) 68 - 0*(0.97)
68 68 68 68 68 68 68
68 - 0*(0.61) 68 - 0*(0.52) 68 - 0*(0.43) 68 - 0*(0.34) 68 - 0*(0.25) 68 - 0*(0.16) 68 - 0*(0.07)
68.58 68.76 68.94 69.12 69.3 69.48 69.66
70 - 2*(0.71) 70 - 2*(0.62) 70 - 2*(0.53) 70 - 2*(0.44) 70 - 2*(0.35) 70 - 2*(0.26) 70 - 2*(0.17)
71.71 72.52 73.33 74.14 74.95 75.76 76.57
79 - 9*(0.81) 79 - 9*(0.72) 79 - 9*(0.63) 79 - 9*(0.54) 79 - 9*(0.45) 79 - 9*(0.36) 79 - 9*(0.27)

90

80

70 Column O
Column P
60 Column Q
Column R
50 Column S
Column T
40 Column U
Column V
30
Column W
Column X
20
Column Y

10

0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
 Column X
20
Column Y

10

0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
 Mod 8 percentile
Mod 9 percentile tens percentile
35
37.16 37.43 37.7
38 - 3*(0.28) 38 - 3*(0.19) 38 - 3*(0.1)
43.58 44.39 45.2
47 - 9*(0.38) 47 - 9*(0.29) 47 - 9*(0.2)
52.72 53.71 54.7
58 - 11*(0.48)58 - 11*(0.39)
59.26 59.53 59.8
61 - 3*(0.58) 61 - 3*(0.49)
62.6 63.05 63.5
66 - 5*(0.68) 66 - 5*(0.59)
66.44 66.62 66.8
68 - 2*(0.78) 68 - 2*(0.69)
68 68 68
68 - 2*(0.88) 68 - 2*(0.79)
68.04 68.22 68.4
70 - 2*(0.98) 70 - 2*(0.89)
69.84 70.09 70.9
70 - 2*(0.08) 79 - 9*(0.99)
77.38 78.19 79
79 - 9*(0.18) 79 - 9*(0.09)

Column O
Column P
Column Q
Column R
Column S
Column T
Column U
Column V
Column W
Column X
Column Y

17 18 19 20
 Column X
Column Y

17 18 19 20
35 37.97 2
38 1
47 3
58 4
61 5 15
66 2 25
68 68 3 35
68 3 23
70 3 54
79 4 37
4 42
1 31
2 29
3
4
2.933333333
 35
20.76 38
47
58 49.75
61
66
68
68
70
79