assay
test suite

statistical-descriptive

180 tests · 134 with documented divergences

Test Subject Formula Category DVs
677838 AVEDEV =AVEDEV(A1:A5) value 1
d90cd6 AVEDEV =AVEDEV(1, 2, 3, 4, 5) value 1
7b6e94 AVEDEV =AVEDEV(7) value 1
30b618 AVEDEV =AVEDEV(1, 3) value 1
cc1eea AVERAGE =AVERAGE(A1:A5) value
c366d7 AVERAGE =AVERAGE(2, 4, 6) value
ebfba4 AVERAGE =AVERAGE(A1:A3) value
ff6bdd AVERAGE =AVERAGE(A1:A3) value
a84e6c AVERAGE.WEIGHTED =AVERAGE.WEIGHTED({1,2,3}, {1,1,1}) value 2
702ac0 AVERAGE.WEIGHTED =AVERAGE.WEIGHTED({1,2,3}, {1,2,3}) value 2
772ab9 AVERAGE.WEIGHTED =AVERAGE.WEIGHTED(A1:A3, B1:B3) value 2
561510 AVERAGEA =AVERAGEA(A1:A5) value 1
f76912 AVERAGEA =AVERAGEA(C1:C5) value 1
233a00 AVERAGEA =AVERAGEA(1, 2, TRUE) value
66c508 AVERAGEA =AVERAGEA(1, "hello", 2) value 2
f6219d AVERAGEIF =AVERAGEIF(D1:D5, "A", E1:E5) value
531836 AVERAGEIF =AVERAGEIF(A1:A5, ">2") value
0bd219 AVERAGEIF =AVERAGEIF(A1:A3, ">100") value
a8a40f AVERAGEIF =AVERAGEIF(A1:A4, 2) value
3d2419 AVERAGEIFS =AVERAGEIFS(E1:E5, D1:D5, "A") value 1
649843 AVERAGEIFS =AVERAGEIFS(E1:E5, D1:D5, "A", E1:E5, ">15") value 1
35c785 AVERAGEIFS =AVERAGEIFS(A1:A3, B1:B3, "q") value 1
7af6f0 COUNT =COUNT(1, 2, 3, 4, 5) value
f7bd4b COUNT =COUNT(A1:A5) value
3fe7ef COUNT =COUNT(C1:C5) value 1
48300b COUNT =COUNT(A1:A3) value
c0685f COUNTA =COUNTA(C1:C5) value 1
495afd COUNTA =COUNTA(A1:A3) value 1
cd8f6b COUNTA =COUNTA(1, "x", TRUE) value 2
36c14a COUNTA =COUNTA(A1:A3) value
89c826 DEVSQ =DEVSQ(A1:A5) value 1
5dfa19 DEVSQ =DEVSQ(1, 2, 3, 4, 5) value 1
a7c259 DEVSQ =DEVSQ(7) value 1
4fa5e7 DEVSQ =DEVSQ(2, 4) value 1
c1a95c GEOMEAN =GEOMEAN(1, 1, 1) value 1
3243f6 GEOMEAN =GEOMEAN(2, 8) value 2
72a864 GEOMEAN =GEOMEAN(A1:A5) value
493753 GEOMEAN =GEOMEAN(0, 2, 4) value 2
4bda6d HARMEAN =HARMEAN(1, 1, 1) value 1
931849 HARMEAN =HARMEAN(2, 6) value 1
decad9 HARMEAN =HARMEAN(A1:A5) value
571170 HARMEAN =HARMEAN(0, 2, 4) value 2
26d355 LARGE =LARGE(A1:A5, 1) value
e01cb8 LARGE =LARGE(A1:A5, 3) value
d1fd5a LARGE =LARGE({1,2,3}, 5) value 1
e75a30 LARGE =LARGE({1,2,3}, 0) value 1
cd30c0 MAX =MAX(A1:A5) value
3760fe MAX =MAX(-3, -1, -7) value
f155a4 MAX =MAX(A1:A3) value
1f7e2a MAX =MAX(A1:A3) value
ec8668 MIN =MIN(A1:A5) value
3868ba MIN =MIN(-3, -1, -7) value
f8529b MIN =MIN(A1:A3) value
476b67 MIN =MIN(A1:A3) value
b47dcc MAXA =MAXA(A1:A5) value 1
59fc6a MAXA =MAXA(C1:C5) value 1
19e7f4 MAXA =MAXA(A1:A3) value 1
fb527d MAXA =MAXA(-2, -1, TRUE) value 1
db9d7d MINA =MINA(A1:A5) value 1
34a45e MINA =MINA(C1:C5) value 1
5279f5 MINA =MINA(A1:A3) value 1
19590a MINA =MINA(2, 3, FALSE) value 1
1a9885 MAXIFS =MAXIFS(E1:E5, D1:D5, "A") value 1
e3db27 MAXIFS =MAXIFS(A1:A5, A1:A5, "<4") value 1
1fab07 MAXIFS =MAXIFS(A1:A3, A1:A3, ">100") value 1
acd654 MINIFS =MINIFS(E1:E5, D1:D5, "A") value 1
43b830 MINIFS =MINIFS(A1:A5, A1:A5, ">2") value 1
a504c3 MINIFS =MINIFS(A1:A3, A1:A3, ">100") value 1
4f7c54 MEDIAN =MEDIAN(A1:A5) value 1
3fca02 MEDIAN =MEDIAN(1, 2, 3, 4) value 1
725e84 MEDIAN =MEDIAN(7) value 1
fb2ef6 MEDIAN =MEDIAN(5, 1, 3, 2, 4) value 1
e925fa MODE =MODE(B1:B5) value 1
49de3f MODE =MODE(1, 2, 2, 3, 4) value 1
2901e2 MODE =MODE(1, 2, 3, 4, 5) value 2
d6e804 MODE.SNGL =MODE.SNGL(1, 2, 2, 3, 4) value 1
b20a94 MODE.SNGL =MODE.SNGL(B1:B5) value 1
5f2bed MODE.SNGL =MODE.SNGL(1, 2, 3) value 1
54edd7 MODE.MULT =MODE.MULT(B1:B5) value
004bde MODE.MULT =MODE.MULT(1, 2, 2, 3, 4) value
e396cf MODE.MULT =MODE.MULT(1, 2, 3) value
e48203 PERCENTILE =PERCENTILE(A1:A5, 0.25) value 1
55fff9 PERCENTILE =PERCENTILE(A1:A5, 0.5) value 1
d6bb83 PERCENTILE =PERCENTILE({1,2,3,4,5}, 0) value 1
5f77f1 PERCENTILE =PERCENTILE({1,2,3,4,5}, 1) value 1
8c97c1 PERCENTILE.INC =PERCENTILE.INC(A1:A5, 0.25) value 1
afee9f PERCENTILE.INC =PERCENTILE.INC(A1:A5, 0.5) value 1
18a8d3 PERCENTILE.INC =PERCENTILE.INC(A1:A5, 0.75) value 1
d9e298 PERCENTILE.EXC =PERCENTILE.EXC(A1:A5, 0.25) value 1
05fac7 PERCENTILE.EXC =PERCENTILE.EXC(A1:A5, 0.5) value 1
b5b7df PERCENTILE.EXC =PERCENTILE.EXC(A1:A5, 0.75) value 1
46e6cc PERCENTILE.EXC =PERCENTILE.EXC({1,2,3,4,5}, 0) value 1
2afe7a PERCENTRANK =PERCENTRANK(A1:A5, 3) value 1
44dc6c PERCENTRANK =PERCENTRANK(A1:A5, 1) value 1
9b0b3b PERCENTRANK =PERCENTRANK(A1:A5, 5) value 1
8f43b3 PERCENTRANK.INC =PERCENTRANK.INC(A1:A5, 3) value 1
f7ea56 PERCENTRANK.INC =PERCENTRANK.INC(A1:A5, 1) value 1
83c86b PERCENTRANK.INC =PERCENTRANK.INC(A1:A5, 2) value 1
23df54 PERCENTRANK.EXC =PERCENTRANK.EXC(A1:A5, 3) value 1
a5ea86 PERCENTRANK.EXC =PERCENTRANK.EXC(A1:A5, 1) value
9dbae2 PERCENTRANK.EXC =PERCENTRANK.EXC(A1:A5, 2) value 1
ff34c1 PERMUT =PERMUT(5, 2) value 1
90763e PERMUT =PERMUT(5, 5) value 1
e78c8d PERMUT =PERMUT(5, 0) value 1
66de41 PERMUT =PERMUT(3, 5) value 2
d72bba PERMUTATIONA =PERMUTATIONA(5, 2) value 1
e79506 PERMUTATIONA =PERMUTATIONA(3, 3) value 1
310b1c PERMUTATIONA =PERMUTATIONA(5, 0) value 2
979049 PERMUTATIONA =PERMUTATIONA(-1, 2) value 1
ea4957 QUARTILE =QUARTILE(A1:A5, 1) value 1
fe31e2 QUARTILE =QUARTILE(A1:A5, 2) value 1
2b9567 QUARTILE =QUARTILE(A1:A5, 3) value 1
035450 QUARTILE =QUARTILE({1,2,3,4,5}, 5) value 2
81de18 QUARTILE.INC =QUARTILE.INC(A1:A5, 1) value 1
ffa479 QUARTILE.INC =QUARTILE.INC(A1:A5, 2) value 1
962395 QUARTILE.INC =QUARTILE.INC(A1:A5, 3) value 1
44aa7a QUARTILE.EXC =QUARTILE.EXC(A1:A5, 1) value 1
8bfbeb QUARTILE.EXC =QUARTILE.EXC(A1:A5, 2) value 1
0877d6 QUARTILE.EXC =QUARTILE.EXC(A1:A5, 3) value 1
e4844c QUARTILE.EXC =QUARTILE.EXC({1,2,3,4,5}, 0) value 1
9669eb RANK =RANK(20, A1:A4) value 1
50b24a RANK =RANK(20, A1:A4, 1) value 1
f3f5c6 RANK =RANK(5, A1:A5) value 1
38a306 RANK =RANK(5, A1:A3) value 1
d9740d RANK.EQ =RANK.EQ(20, A1:A4) value 1
202ba7 RANK.EQ =RANK.EQ(3, A1:A5, 1) value 1
2e53c2 RANK.EQ =RANK.EQ(5, A1:A5) value 1
594c3c RANK.AVG =RANK.AVG(20, A1:A4) value 1
7e3942 RANK.AVG =RANK.AVG(3, A1:A5) value 1
ac52d6 RANK.AVG =RANK.AVG(20, A1:A5) value 1
ac4ba7 SMALL =SMALL(A1:A5, 1) value
fecf62 SMALL =SMALL(A1:A5, 3) value
509b18 SMALL =SMALL({1,2,3}, 5) value 1
da8c51 SMALL =SMALL({1,2,3}, 0) value 1
c40ea3 STANDARDIZE =STANDARDIZE(10, 10, 2) value 1
9981d6 STANDARDIZE =STANDARDIZE(12, 10, 2) value 1
43e42c STANDARDIZE =STANDARDIZE(6, 10, 2) value 1
46bfe5 STANDARDIZE =STANDARDIZE(5, 10, 0) value 2
f6230a STDEV =STDEV(A1:A5) value
546175 STDEV =STDEV(1, 3) value
ec6deb STDEV =STDEV(5, 5, 5) value 1
f4d5c5 STDEV =STDEV(5) value 1
28a9b2 STDEV.S =STDEV.S(A1:A5) value
44b2fb STDEV.S =STDEV.S(5, 5, 5) value 1
4768d6 STDEV.S =STDEV.S(5) value 1
699660 STDEV.P =STDEV.P(A1:A5) value
ee1669 STDEV.P =STDEV.P(2, 6) value 1
68e086 STDEV.P =STDEV.P(5, 5, 5) value 1
fd8823 STDEVP =STDEVP(A1:A5) value
7937fd STDEVP =STDEVP(2, 6) value 1
c61ac0 STDEVP =STDEVP(5, 5, 5) value 1
b5df53 STDEVA =STDEVA(A1:A5) value
44edd3 STDEVA =STDEVA(C1:C5) value
bcd716 STDEVA =STDEVA(1, 2, TRUE) value
596652 STDEVPA =STDEVPA(A1:A5) value
d93d80 STDEVPA =STDEVPA(C1:C5) value
d54764 STDEVPA =STDEVPA(1, 2, TRUE) value
95a64d TRIMMEAN =TRIMMEAN(A1:A5, 0.4) value 1
66f1cb TRIMMEAN =TRIMMEAN(A1:A5, 0) value 1
99fb7d TRIMMEAN =TRIMMEAN({1,2,3,4,100}, 0.4) value 1
585f54 TRIMMEAN =TRIMMEAN({1,2,3}, 1) value 2
81698e VAR =VAR(A1:A5) value 1
6cb13d VAR =VAR(1, 3) value 1
d31acb VAR =VAR(5, 5, 5) value 1
c9b44a VAR =VAR(5) value 1
7f544d VAR.S =VAR.S(A1:A5) value 1
6f3293 VAR.S =VAR.S(5, 5, 5) value 1
d30956 VAR.S =VAR.S(5) value 1
4fe005 VAR.P =VAR.P(A1:A5) value 1
99090b VAR.P =VAR.P(2, 6) value 1
f79d1f VAR.P =VAR.P(5, 5, 5) value 1
9a46e4 VARP =VARP(A1:A5) value 1
8a831f VARP =VARP(2, 6) value 1
0910af VARP =VARP(5, 5, 5) value 1
507d4d VARA =VARA(A1:A5) value 1
639e21 VARA =VARA(C1:C5) value
aad060 VARA =VARA(1, 2, TRUE) value
d0a5b8 VARPA =VARPA(A1:A5) value 1
5ba804 VARPA =VARPA(C1:C5) value
961592 VARPA =VARPA(1, 2, TRUE) value