ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Question No: 1 ( Marks: 10 )
2
3
4
Question Instructions:
5
·         Enter or Copy/Paste the given question data into MS Excel.
6
·         Then, apply the appropriate functions / calculations to get the required results.
7
·         For more clarity, HIGHLIGHT your answers
8
·         In the end, Copy/Paste your answers/results into this Word file.
9
10
11
==============
12
Which tool you should use?
13
·         In this question, PREFERABLY use RealStat or Analysis ToolPakExcel Addin to get the required results.
14
15
===============
16
Question Statement/Data: (Marks = 2+2+2+2+2 = 10)
17
18
Following is the match history of a University Cricket team.
19
Find/calculate: the following summary of scores.
20
1.      Mean
21
2.      Median
22
3.      Mode
23
4.      Standard Deviation
24
5.      Variance
25
26
HistoryScore
27
Match 1241
28
Match 2266
29
Match 3250
30
Match 4272
31
Match 5273
32
Match 6309
33
Match 7302
34
Match 8305
35
Match 9309
36
Match 10281
37
Match 11317
38
Match 12227
39
Match 13224
40
Match 14266
41
Match 15250
42
Match 16250
43
Match 17284
44
Match 18266
45
Match 19250
46
Match 20238
47
48
============= END OF THIS QUESTION ===========
49
50
Solution/Answer:(Post your results/answer of this question below)
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100