ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
X
2
15Note:
3
20
Binomial parameter: n and p
4
50
Poisson parameter: λ
5
35
Normal distribution parameter: µ and σ
6
10
7
∑x=130
8
9
N=5
10
∑X=130
11
12
13
Mean=26
Average(A2:A6)
14
median=20
Median(A2:A6)
15
standard deviation=
16.35542723
Stdeva(A2:A6)
16
mode=50
17
Variance=267.5
16.35543^2
18
skewness=0.8485565357
Skew(A2:A6)
19
kurtosis=-0.6664337497
Kurt(A2:A6)
20
Q1=15
quartile(A2:A6,1)
21
Q2=20
22
Q3=35
23
P10=12
24
D10=10*(n+1)/10 th item=10*(5+1)/10 th item
6
25
the value of decile cannot be obtained because there is no 6th item
26
D5=5*(n+1)/10 th item=
3
27
D5=50
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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