assay
test suite

array-longtail

65 tests · 32 with documented divergences

Test Subject Formula Category DVs
transpose-row-to-col TRANSPOSE =TRANSPOSE({1,2,3}) value 2
transpose-col-to-row TRANSPOSE =TRANSPOSE({1;2;3}) value 2
transpose-2x2 TRANSPOSE =TRANSPOSE({1,2;3,4}) value 2
transpose-from-grid TRANSPOSE =TRANSPOSE(A1:C1) value 2
flatten-row FLATTEN =FLATTEN({1,2,3}) value
flatten-col FLATTEN =FLATTEN({1;2;3}) value
flatten-2x2-order FLATTEN =FLATTEN({1,2;3,4}) value
flatten-multiple-args FLATTEN =FLATTEN({1;2}, {3;4}) value 2
tocol-row TOCOL =TOCOL({1,2,3}) value
tocol-2x2-scan-by-row TOCOL =TOCOL({1,2;3,4}, 0, FALSE) value
tocol-2x2-scan-by-column TOCOL =TOCOL({1,2;3,4}, 0, TRUE) value
tocol-ignore-blanks TOCOL =TOCOL(A1:A3, 1) value
torow-col TOROW =TOROW({1;2;3}) value
torow-2x2-scan-by-row TOROW =TOROW({1,2;3,4}, 0, FALSE) value
torow-2x2-scan-by-column TOROW =TOROW({1,2;3,4}, 0, TRUE) value
torow-ignore-blanks TOROW =TOROW(A1:C1, 1) value
wrapcols-basic WRAPCOLS =WRAPCOLS({1,2,3,4}, 2) value
wrapcols-with-pad WRAPCOLS =WRAPCOLS({1,2,3}, 2, "x") value
wrapcols-exact-fit WRAPCOLS =WRAPCOLS({1,2,3,4,5,6}, 3) value
wrapcols-single-col WRAPCOLS =WRAPCOLS({1,2,3}, 3) value
wraprows-basic WRAPROWS =WRAPROWS({1,2,3,4}, 2) value
wraprows-with-pad WRAPROWS =WRAPROWS({1,2,3}, 2, "x") value
wraprows-exact-fit WRAPROWS =WRAPROWS({1,2,3,4,5,6}, 3) value
wraprows-single-row WRAPROWS =WRAPROWS({1,2,3}, 3) value
array-constrain-clip-rows ARRAY_CONSTRAIN =ARRAY_CONSTRAIN({1,2;3,4;5,6}, 2, 2) value 1
array-constrain-clip-cols ARRAY_CONSTRAIN =ARRAY_CONSTRAIN({1,2,3;4,5,6}, 2, 2) value 1
array-constrain-identity ARRAY_CONSTRAIN =ARRAY_CONSTRAIN({1,2;3,4}, 2, 2) value 1
array-constrain-to-scalar ARRAY_CONSTRAIN =ARRAY_CONSTRAIN({1,2;3,4}, 1, 1) value 1
mdeterm-2x2-identity MDETERM =MDETERM({1,0;0,1}) value 1
mdeterm-2x2-generic MDETERM =MDETERM({1,2;3,4}) value 1
mdeterm-3x3-identity MDETERM =MDETERM({1,0,0;0,1,0;0,0,1}) value 1
mdeterm-singular MDETERM =MDETERM({1,2;2,4}) value 1
minverse-2x2-identity MINVERSE =MINVERSE({1,0;0,1}) value 2
minverse-2x2-generic MINVERSE =MINVERSE({1,2;3,4}) value 3
minverse-singular-error MINVERSE =MINVERSE({1,2;2,4}) error-code
minverse-3x3-identity MINVERSE =MINVERSE({1,0,0;0,1,0;0,0,1}) value 2
mmult-a-times-identity MMULT =MMULT({1,2;3,4}, {1,0;0,1}) value 2
mmult-2x2-generic MMULT =MMULT({1,2;3,4}, {5,6;7,8}) value 2
mmult-row-by-col MMULT =MMULT({1,2,3}, {4;5;6}) value 1
mmult-dimension-mismatch MMULT =MMULT({1,2}, {1,2}) value 2
sumx2my2-canonical SUMX2MY2 =SUMX2MY2({1,2,3}, {4,5,6}) value 1
sumx2my2-equal-arrays SUMX2MY2 =SUMX2MY2({1,2,3}, {1,2,3}) value 1
sumx2my2-singletons SUMX2MY2 =SUMX2MY2({3}, {2}) value 1
sumx2py2-canonical SUMX2PY2 =SUMX2PY2({1,2,3}, {4,5,6}) value 1
sumx2py2-zeros SUMX2PY2 =SUMX2PY2({0,0,0}, {0,0,0}) value 1
sumx2py2-singleton SUMX2PY2 =SUMX2PY2({3}, {4}) value 1
sumxmy2-canonical SUMXMY2 =SUMXMY2({1,2,3}, {4,5,6}) value 1
sumxmy2-equal-arrays SUMXMY2 =SUMXMY2({1,2,3}, {1,2,3}) value 1
sumxmy2-singletons SUMXMY2 =SUMXMY2({5}, {2}) value 1
frequency-basic-bins FREQUENCY =FREQUENCY(A1:A5, B1:B2) value 2
frequency-all-below FREQUENCY =FREQUENCY(A1:A3, B1) value 2
frequency-single-bin FREQUENCY =FREQUENCY(A1:A3, B1) value 2
frequency-inline FREQUENCY =FREQUENCY({1;2;3;4;5}, {2;4}) value
linest-simple-line LINEST =LINEST({1,2,3}, {1,2,3}) value
linest-with-stats LINEST =LINEST({1,2,3,4}, {1,2,3,4}, TRUE, TRUE) value
linest-y-only LINEST =LINEST({2,4,6,8}) value
logest-exponential LOGEST =LOGEST({2,4,8,16}, {1,2,3,4}) value
logest-with-stats LOGEST =LOGEST({2,4,8,16}, {1,2,3,4}, TRUE, TRUE) value
logest-y-only LOGEST =LOGEST({2,4,8,16}) value
trend-simple TREND =TREND({1,2,3}, {1,2,3}, {4,5}) value
trend-inferred-x TREND =TREND({2,4,6,8}) value
trend-new-x TREND =TREND({1,2,3,4}, {1,2,3,4}, {5;6;7}) value
growth-exponential GROWTH =GROWTH({2,4,8,16}, {1,2,3,4}, {5}) value
growth-inferred-x GROWTH =GROWTH({2,4,8,16}) value
growth-new-x GROWTH =GROWTH({2,4,8,16}, {1,2,3,4}, {5;6}) value