1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
%mode init
A1:5
A2:2
A3:3
A4=8
A5:1
A6=6
A7:7
A8=4
A9:9
A10:10
A12=MEDIAN(A$1:A1)
A13=MEDIAN(A$1:A2)
A14=MEDIAN(A$1:A3)
A15=MEDIAN(A$1:A4)
A16=MEDIAN(A$1:A5)
A17=MEDIAN(A$1:A6)
A18=MEDIAN(A$1:A7)
A19=MEDIAN(A$1:A8)
A20=MEDIAN(A$1:A9)
A21=MEDIAN(A$1:A10)
A22=MEDIAN(1,9,2,3,5)
A23=MEDIAN(4,2,1,3)
A24=MEDIAN(A1,A2,A3,A4,A5,A6,A7,A8,A9,A10)
A25=MEDIAN(42)
B1=TRUE()
B2=FALSE()
B3=TRUE()
B5=MEDIAN(B1:B3)
B6=MEDIAN(B1:B2)
%calc
%mode result
A12=5
A13=3.5
A14=3
A15=4
A16=3
A17=4
A18=5
A19=4.5
A20=5
A21=5.5
A22=3
A23=2.5
A24=5.5
A25=42
B5=1
B6=0.5
%check
|
