diff options
Diffstat (limited to 'test/04-function-median.txt')
| -rw-r--r-- | test/04-function-median.txt | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/test/04-function-median.txt b/test/04-function-median.txt new file mode 100644 index 0000000..c840053 --- /dev/null +++ b/test/04-function-median.txt @@ -0,0 +1,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 |