Which batsman is more consistent?

No. of matches X Y
1 49 5
2 84 7
3 144 35
4 97 47 X
5 99 54 MIN 10
6 140 55 MAX 150
7 95 61
8 10 63 Q1 48
9 147 65 Q2 92
10 33 75 Q3 109.25
11 150 76 quatile deviation 61.25
12 147 85 PERCENTILE P10 39.3
13 45 86 PERCENTILE P90 147
14 75 88
15 80 96
16 95 99
17 99 100
18 89 130
19 40 175
20 43 234

AVERAGE 88.05 81.8

STDEV 42.37983 52.61739
CV 48.13155 64.32443
Y
5
234

54.75
75.5
96.75
42
32.2
134.5
ANDROID Ios WINDOWS
12342 8909 2345

10%

52
38%
10%

ANDROID
Ios
52% WINDOWS
Q1. COEFFICIENT OF CORRELATION

X Y
25 10
40 25
30 40 -0.203121282455941
25 15
10 20
5 40
10 28
15 22
30 15
20 5

Q2. Find the correlation between the age and playing habits.

AGE (IN YEARS) MID POINTS NO. OF PEOPLE NO. OF PLAYERS

15 & LESS THAN 20 17.5 200 150
20 & LESS THAN 25 22.5 270 162
25 & LESS THAN 30 27.5 340 170
30 & LESS THAN 35 32.5 360 180
35 & LESS THAN 40 37.5 400 180
40 & LESS THAN 45 42.5 300 120
COEFFICIENT -0.939507728566654
%
75
60
50
50
45
40
 SPEARMAN'S RANK CORRELATION
S.NO. MARKS 1 MARKS 2 R1 R2
1 30 29 4.5 2 CORRELATION BETWEEN R1 & R2
2 38 27 1 4.5 -0.363638
3 28 22 7 6.5
4 27 29 9 2
5 28 20 7 9
6 23 29 10 2
7 30 18 4.5 10
8 33 21 3 8
9 28 27 7 4.5
10 35 22 2 6.5
WEEN R1 & R2
ADV. EXPESALES R1 R2 EST. Y EST. X
39 47 3 1 52.98 41.90
65 53 5 3 66.00 49.19 REGRESSION ANALYSIS
62 58 4 4 64.50 55.27 Y=A+BX
90 86 9 9 78.52 89.32 A 33.43979
82 62 8 6 74.52 60.14 B 0.500926
75 68 6 7 71.01 67.43
25 60 1 5 45.96 57.71 Y= 33.43979-0.500926X
98 91 10 10 82.53 95.40
36 51 2 2 51.47 46.76
78 84 7 8 72.51 86.88

RANK CORRELATION
0.818182
ON ANALYSIS
X=A+BY
A -15.2446
B 1.215827

33.43979-0.500926X X= 0-15.2446+1.215827Y
ADV. EXPESALES x on y
39 47
65 53 SUMMARY OUTPUT
62 58
90 86 Regression Statistics
82 62 Multiple R 0.740472
75 68 R Square 0.548298
25 60 Adjusted R 0.483769
98 91 Standard E 10.84568
36 51 Observatio 9
78 84
ANOVA
df SS MS F Significance F
Regression 1 999.4868 999.4868 8.496951 0.022501
Residual 7 823.4021 117.6289
Total 8 1822.889

Coefficients
Standard Error t Stat P-value Lower 95%
Intercept 36.62594 11.39022 3.21556 0.014744 9.692344
39 0.463775 0.159102 2.914953 0.022501 0.087558

RESIDUAL OUTPUT PROBABILITY OUTPUT

Observation
Predicted 47Residuals
Standard Residuals Percentile
1 66.77132 -13.77132 -1.357421 5.555556
2 65.37999 -7.379991 -0.727436 16.66667
3 78.36569 7.634307 0.752504 27.77778
4 74.65549 -12.65549 -1.247435 38.88889
5 71.40907 -3.409067 -0.336027 50
6 48.22031 11.77969 1.161108 61.11111
7 82.07589 8.924107 0.879638 72.22222
8 53.32184 -2.32184 -0.228861 83.33333
9 72.80039 11.19961 1.103931 94.44444
 39 Residual Plot
20
10

Residuals
0
-10 20 30 40 50 60 70 80 90 100 110

-20
39

39 Line Fit Plot

Significance F 80
Column C
40
47

Predicted 47
0
20 30 40 50 60 70 80 90 100 110
Upper 95%Lower 95.0%
Upper 95.0% 39
63.55953 9.692344 63.55953
0.839992 0.087558 0.839992
Normal Probability Plot
100
PROBABILITY OUTPUT
50
47

47
0
51 0 10 20 30 40 50 60 70 80 90 100
53 Sample Percentile
58
60
62
68
84
86
91
Fruit
habits Income
apple 1189
banana 1538
grapes 1089
dates 1919
mango 1022 mean 1471.863
juice 1214 median 1484.5
apple 1597 mode 1540
banana 1036
grapes 1178
dates 1900
mango 1567 count 380
juice 1202 countif 183
apple 1714 countifs 26
banana 1586
grapes 1406
dates 1485
mango 1658
juice 1045
apple 1960
banana 1565
grapes 1723
dates 1574
mango 1718
juice 1146
apple 1483
banana 1198
grapes 1035
dates 1292
mango 1373
juice 1531
apple 1201
banana 1964
grapes 1640
dates 1653
mango 1594
juice 1541
apple 1955
banana 1014
grapes 1157
dates 1828
mango 1390
juice 1163
apple 1343
banana 1484
grapes 1169
dates 1291
mango 1766
juice 1720
apple 1493
banana 1675
grapes 1220
dates 1419
mango 1640
juice 1287
apple 1818
banana 1662
grapes 1950
dates 1857
mango 1339
juice 1640
apple 1540
banana 1199
grapes 1604
dates 1823
mango 1082
juice 1299
apple 1814
banana 1372
grapes 1243
dates 1496
mango 1151
juice 1315
apple 1695
banana 1602
grapes 1364
dates 1034
mango 1108
juice 1818
apple 1123
banana 1776
grapes 1510
dates 1913
mango 1563
juice 1542
apple 1085
banana 1833
grapes 1570
dates 1771
mango 1701
juice 1971
apple 1375
banana 1438
grapes 1394
dates 1308
mango 1285
juice 1003
apple 1222
banana 1064
grapes 1465
dates 1002
apple 1397
banana 1542
grapes 1635
dates 1496
mango 1026
juice 1428
apple 1050
banana 1927
grapes 1158
dates 1855
mango 1509
juice 1547
apple 1484
banana 1075
grapes 1315
dates 1324
mango 1626
juice 1213
apple 1306
banana 1512
grapes 1267
dates 1237
mango 1748
juice 1167
apple 1886
banana 1073
grapes 1403
dates 1842
mango 1239
juice 1874
apple 1093
banana 1839
grapes 1947
dates 1526
mango 1100
juice 1404
apple 1540
banana 1232
grapes 1962
dates 1039
mango 1883
juice 1728
apple 1847
banana 1653
grapes 1216
dates 1234
mango 1937
juice 1678
apple 1045
banana 1655
grapes 1749
dates 1071
mango 1391
juice 1470
apple 1290
banana 1840
grapes 1458
dates 1715
mango 1768
juice 1024
apple 1798
banana 1444
grapes 1851
dates 1770
mango 1691
juice 1083
apple 1715
banana 1485
grapes 1374
dates 1859
mango 1637
juice 1252
apple 1549
banana 1820
grapes 1731
dates 1179
mango 1137
juice 1540
apple 1124
banana 1069
grapes 1479
dates 1223
mango 1784
juice 1917
apple 1306
banana 1670
grapes 1612
dates 1702
mango 1038
juice 1401
apple 1590
banana 1736
grapes 1940
dates 1170
mango 1623
juice 1070
apple 1540
banana 1143
grapes 1037
dates 1928
apple 1529
banana 1241
grapes 1015
dates 1538
mango 1013
juice 1576
apple 1884
banana 1751
grapes 1674
dates 1514
mango 1264
juice 1495
apple 1860
banana 1987
grapes 1599
dates 1739
mango 1971
juice 1595
apple 1095
banana 1223
grapes 1036
dates 1974
mango 1946
juice 1846
apple 1188
banana 1101
grapes 1916
dates 1194
mango 1350
juice 1585
apple 1469
banana 1660
grapes 1290
dates 1564
mango 1961
juice 1240
apple 1224
banana 1366
grapes 1595
dates 1345
mango 1810
juice 1208
apple 1618
banana 1936
grapes 1491
dates 1860
mango 1605
juice 1534
apple 1849
banana 1992
grapes 1095
dates 1017
mango 1342
juice 1213
apple 1912
banana 1072
grapes 1649
dates 1565
mango 1864
juice 1122
apple 1083
banana 1785
grapes 1278
dates 1335
mango 1630
juice 1924
apple 1138
banana 1767
grapes 1097
dates 1145
mango 1768
juice 1304
apple 1960
banana 1642
grapes 1242
dates 1536
mango 1273
juice 1081
apple 1158
banana 1378
grapes 1731
dates 1780
mango 1277
juice 1284
apple 1242
banana 1061
grapes 1467
dates 1726
mango 1219
juice 1062
apple 1604
banana 1108
grapes 1744
dates 1629
mango 1622
juice 1828
apple 1276
banana 1238
grapes 1479
dates 1170
apple 1807
banana 1257
grapes 1273
dates 1436
mango 1922
juice 1386
apple 1376
banana 1407
grapes 1075
dates 1632
mango 1199
juice 1013
apple 1813
banana 1426
grapes 1275
dates 1325
mango 1690
juice 1116
apple 1594
banana 1179
grapes 1704
dates 1663
mango 1286
juice 1239
apple 1185
banana 1477
grapes 1533
dates 1607
mango 1705
juice 1861
apple 1250
banana 1505
grapes 1631
dates 1437
mango 1418
juice 1305
apple 1025
banana 1001
grapes 1101
dates 1029
mango 1333
juice 1171
apple 1401
banana 1166
grapes 1545
dates 1473
mango 1710
juice 1442
apple 1238
banana 1655
grapes 1826
dates 1799
mango 1966
juice 1197
apple 1121
banana 1607
grapes 1857
dates 1637
mango 1564
juice 1085
apple 1814
banana 1745
grapes 1780
dates 1343
mango 1688
juice 1909
apple 1151
banana 1243
grapes 1663
dates 1100
mango 1131
juice 1535
apple 1117
banana 1961
grapes 1771
dates 1132
mango 1672
juice 1503
apple 1350
banana 1705
which student is more consistent in securing marks in an examination?

S.No Ram Shyam ORIGIN

1 23 27 25 22
2 21 20 23 15
3 26 27 28 22
4 25 26 27 21
5 20 22 22 17
6 21 28 23 23
7 30 23 32 18
8 29 26 31 21
9 30 25 32 20
10 21 23 23 18
11 27 27 29 22
12 22 25 24 20
13 23 25 25 20
14 28 29 30 24
15 26 25 28 20
16 22 24 24 19
17 21 24 23 19
18 22 20 24 15
19 27 21 29 16
20 21 29 23 24

Average 24.25 24.8 26.25 19.8

STDEV 3.354101966 2.706716792 3.354101966 2.706716792
Median 23 25
Mode 21 25
 SCALE
69 6.75
63 5
78 6.75
75 6.5
60 5.5
63 7
90 5.75
87 6.5
90 6.25
63 5.75
81 6.75
66 6.25
69 6.25
84 7.25
78 6.25
66 6
63 6
66 5
81 5.25
63 7.25

72.75 6.2
10.0623059 0.676679198
 No. of
matches X Y
1 19 6
2 27 49
3 21 22
4 44 24
5 79 95
6 2 66 X
7 95 73
8 18 10 Q1
9 70 39 Q3
10 47 21 Q3-Q1
11 61 45
12 36 57 P10
13 80 2 P90
14 97 75 P90-P10
15 100 88
16 31 83
17 60 49
18 95 59
19 46 40
20 35 11
 X
Quartile Range
30 Largest 100
79.25 Smallest 2
49.25 L-S 98

18.9
95.2
76.3
S no. Marks
1 16
2 16
3 6
4 18
5 4
6 4
7 19
8 11
9 0 Marks
10 0 0-9
11 0 10-19
12 20 20-29
13 17 Total Result
14 6
15 13 CI
16 11 0 -10
17 18 10-20
18 4 20-30
19 23
20 20
21 15
22 1
23 2
24 7
25 5
26 5
27 13
28 0
29 14
30 7
31 3
32 12
33 1
34 13
35 5
36 4
37 12
38 2
39 8
40 13
41 20
42 23
43 23
44 9
45 7
46 8
47 16
48 19
49 9
50 19
51 6
52 20
53 24
54 13
55 4
56 24
57 6
58 11
59 23
60 0
61 2
62 24
63 21
64 3
65 4
66 10
67 6
68 14
69 17
70 16
71 20
72 14
73 12
74 3
75 18
76 6
77 9
78 18
79 15
80 1
81 0
82 24
83 7
84 23
85 11
86 12
87 2
88 0
89 17
90 11
91 20
92 3
 93 21
94 21
95 11
96 4
97 5
98 19
99 7
100 1
101 10
102 5
103 13
104 17
105 1
106 15
107 24
108 15
109 12
110 1
111 20
112 5
113 3
114 3
115 4
116 15
117 22
118 5
119 22
120 7
121 3
122 20
123 3
124 5
125 17
126 1
127 24
128 25
129 13
130 22
131 6
132 11
133 2
134 11
135 17
136 6
137 7
138 8
139 5
140 18
141 6
142 14
143 10
144 22
145 21
146 23
147 18
148 21
149 1
150 0
151 24
152 25
153 10
154 19
155 25
156 20
157 16
158 4
159 10
160 25
161 23
162 14
163 11
164 25
165 6
166 4
167 22
168 1
169 10
170 21
171 12
172 18
173 24
174 7
175 22
176 1
177 4
178 15
179 15
180 22
181 7
182 21
183 14
184 14
185 6
186 10
187 23
188 17
189 12
190 12
191 11
192 7
193 10
194 6
195 4
196 11
197 15
198 6
199 2
200 3
Count of Marks2
83
73
44
200

BIN
10
20
30
 BIN Frequency
10 91
20 74
30 35
More 0
200

This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a d

will permanently break the chart.
able in your version of Excel.

saving this workbook into a different file format

ak the chart.
x y
Adv
expenses Sales
39 47 y on x
65 53 SUMMARY OUTPUT
62 58
90 86 Regression Statistics
82 62 Multiple R 0.78041
75 68 R Square 0.60904
25 60 Adjusted R 0.56017
98 91 Standard E 10.4253
36 51 Observatio 10
78 84
ANOVA
df SS MS F Significance F
Regression 1 1354.505 1354.505 12.46244 0.00773
Residual 8 869.4954 108.6869
Total 9 2224

Coefficients
Standard Error t Stat P-value Lower 95%
Intercept 33.43979 9.794777 3.414043 0.009168 10.853
Adv expens0.500926 0.141897 3.530219 0.00773 0.173712

RESIDUAL OUTPUT PROBABILITY OUTPUT

Observation
Predicted Sales
Residuals
Standard Residuals Percentile
1 52.97592 -5.975917 -0.607984 5
2 66 -13 -1.322607 15
3 64.49722 -6.497221 -0.661021 25
4 78.52316 7.476843 0.760687 35
5 74.51575 -12.51575 -1.27334 45
6 71.00926 -3.009263 -0.306159 55
7 45.96295 14.03705 1.428116 65
8 82.53057 8.469433 0.861672 75
9 51.47314 -0.473138 -0.048137 85
10 72.51204 11.48796 1.168774 95
 Adv expenses Residual Plot
20
15
10

Residuals
5
0
-5 20 30 40 50 60 70 80 90 100 110
-10
-15
Adv expenses

Adv expenses Line Fit Plot

Significance F 80
Sales
Sales

40 Predicted Sales
0
20 30 40 50 60 70 80 90 100110
Upper 95%Lower 95.0%
Upper 95.0% Adv expenses
56.02659 10.853 56.02659
0.828141 0.173712 0.828141

Normal Probability Plot

100
PROBABILITY OUTPUT
50
Sales

Sales
47 0
51 0 10 20 30 40 50 60 70 80 90 100
53 Sample Percentile
58
60
62
68
84
86
91
 Test Weekly
Salesman scores(x) sales(y) R1 R2 EST Y EST X
A 50 30 6 8.5 48.89764 45.69444
B 60 60 3.5 3 51.37795 58.81944
C 50 40 6 7 48.89764 50.06944
D 60 50 3.5 5.5 51.37795 54.44444
E 80 60 1.5 3 56.33858 58.81944
F 50 30 6 8.5 48.89764 45.69444
G 80 70 1.5 1 56.33858 63.19444
H 40 50 8 5.5 46.41732 54.44444
I 20 60 9 3 41.45669 58.81944

Y ON X X ON Y
Y=A+BX X=A+BY
A 36.49606 A 32.56944
B 0.248031 B 0.4375
KARL PEARSON 0.329414
SPEARMAN RANK 0.451754
QUES MEAN 550
STD 110

1. x will be more than 675

2.x will be less than 450
3. x will be between 425 and 750

1 0.872098 0.372097796 0.127902204

2 0.181651
3 0.127902 0.837579622 0.965481826
poisson distribution mean(np) 0.5 p 0.001
x p(x)
0 0.60653066
1 0.30326533
2 0.075816332
3 0.012636055
4 0.001579507
5 0.000157951
6 1.316256E-05
n 500