test suite

math-longtail

190 tests · 74 with documented divergences

Test	Subject	Formula	Category	DVs
`sin-at-0`	SIN	`=SIN(0)`	value
`sin-at-pi-2`	SIN	`=SIN(PI()/2)`	value
`sin-at-pi`	SIN	`=SIN(PI())`	value
`sin-at-1-radian`	SIN	`=SIN(1)`	value
`sin-negative`	SIN	`=SIN(-PI()/2)`	value
`cos-at-0`	COS	`=COS(0)`	value
`cos-at-pi-2`	COS	`=COS(PI()/2)`	value
`cos-at-pi`	COS	`=COS(PI())`	value
`cos-at-1-radian`	COS	`=COS(1)`	value
`cos-negative-symmetric`	COS	`=COS(-PI())`	value
`tan-at-0`	TAN	`=TAN(0)`	value
`tan-at-pi`	TAN	`=TAN(PI())`	value
`tan-at-1-radian`	TAN	`=TAN(1)`	value
`tan-negative`	TAN	`=TAN(-1)`	value
`sec-at-0`	SEC	`=SEC(0)`	value	1
`sec-at-pi`	SEC	`=SEC(PI())`	value	1
`sec-at-1-radian`	SEC	`=SEC(1)`	value
`sec-negative`	SEC	`=SEC(-PI())`	value	1
`csc-at-pi-2`	CSC	`=CSC(PI()/2)`	value	1
`csc-at-1-radian`	CSC	`=CSC(1)`	value
`csc-negative`	CSC	`=CSC(-PI()/2)`	value	1
`csc-at-0-error`	CSC	`=CSC(0)`	error-code
`cot-at-pi-2`	COT	`=COT(PI()/2)`	value
`cot-at-1-radian`	COT	`=COT(1)`	value
`cot-negative`	COT	`=COT(-1)`	value
`cot-at-0-error`	COT	`=COT(0)`	error-code
`sinh-at-0`	SINH	`=SINH(0)`	value
`sinh-at-1`	SINH	`=SINH(1)`	value
`sinh-negative`	SINH	`=SINH(-1)`	value
`cosh-at-0`	COSH	`=COSH(0)`	value
`cosh-at-1`	COSH	`=COSH(1)`	value
`cosh-negative-symmetric`	COSH	`=COSH(-1)`	value
`tanh-at-0`	TANH	`=TANH(0)`	value
`tanh-at-1`	TANH	`=TANH(1)`	value
`tanh-negative`	TANH	`=TANH(-1)`	value
`sech-at-0`	SECH	`=SECH(0)`	value	1
`sech-at-1`	SECH	`=SECH(1)`	value
`sech-negative`	SECH	`=SECH(-1)`	value
`csch-at-1`	CSCH	`=CSCH(1)`	value
`csch-negative`	CSCH	`=CSCH(-1)`	value
`csch-at-0-error`	CSCH	`=CSCH(0)`	error-code
`coth-at-1`	COTH	`=COTH(1)`	value
`coth-negative`	COTH	`=COTH(-1)`	value
`coth-at-0-error`	COTH	`=COTH(0)`	error-code
`asin-at-0`	ASIN	`=ASIN(0)`	value
`asin-at-1`	ASIN	`=ASIN(1)`	value
`asin-negative`	ASIN	`=ASIN(-1)`	value
`asin-out-of-domain`	ASIN	`=ASIN(2)`	value
`acos-at-1`	ACOS	`=ACOS(1)`	value
`acos-at-0`	ACOS	`=ACOS(0)`	value
`acos-negative`	ACOS	`=ACOS(-1)`	value
`acos-out-of-domain`	ACOS	`=ACOS(2)`	value
`atan-at-0`	ATAN	`=ATAN(0)`	value
`atan-at-1`	ATAN	`=ATAN(1)`	value
`atan-negative`	ATAN	`=ATAN(-1)`	value
`atan2-on-x-axis`	ATAN2	`=ATAN2(1, 0)`	value
`atan2-on-y-axis`	ATAN2	`=ATAN2(0, 1)`	value
`atan2-diagonal`	ATAN2	`=ATAN2(1, 1)`	value
`atan2-negative`	ATAN2	`=ATAN2(-1, -1)`	value
`asinh-at-0`	ASINH	`=ASINH(0)`	value
`asinh-at-1`	ASINH	`=ASINH(1)`	value
`asinh-negative`	ASINH	`=ASINH(-1)`	value
`acosh-at-1`	ACOSH	`=ACOSH(1)`	value
`acosh-greater-than-1`	ACOSH	`=ACOSH(2)`	value
`acosh-out-of-domain`	ACOSH	`=ACOSH(0)`	value	1
`atanh-at-0`	ATANH	`=ATANH(0)`	value
`atanh-positive`	ATANH	`=ATANH(0.5)`	value
`atanh-negative`	ATANH	`=ATANH(-0.5)`	value
`atanh-out-of-domain`	ATANH	`=ATANH(1)`	value	1
`acot-at-0`	ACOT	`=ACOT(0)`	value
`acot-at-1`	ACOT	`=ACOT(1)`	value
`acot-negative`	ACOT	`=ACOT(-1)`	value
`acoth-greater-than-1`	ACOTH	`=ACOTH(2)`	value
`acoth-less-than-1`	ACOTH	`=ACOTH(-2)`	value
`acoth-out-of-domain`	ACOTH	`=ACOTH(1)`	value	1
`radians-of-180`	RADIANS	`=RADIANS(180)`	value	3
`radians-of-0`	RADIANS	`=RADIANS(0)`	value
`radians-of-90`	RADIANS	`=RADIANS(90)`	value	3
`radians-negative`	RADIANS	`=RADIANS(-180)`	value	3
`degrees-of-pi`	DEGREES	`=DEGREES(PI())`	value
`degrees-of-0`	DEGREES	`=DEGREES(0)`	value
`degrees-of-pi-2`	DEGREES	`=DEGREES(PI()/2)`	value
`degrees-negative`	DEGREES	`=DEGREES(-PI())`	value
`base-to-hex`	BASE	`=BASE(10, 16)`	value	1
`base-to-binary`	BASE	`=BASE(5, 2)`	value	1
`base-zero`	BASE	`=BASE(0, 2)`	value	1
`base-with-min-length-padding`	BASE	`=BASE(5, 2, 8)`	value	1
`decimal-from-hex`	DECIMAL	`=DECIMAL("A", 16)`	value	1
`decimal-from-binary`	DECIMAL	`=DECIMAL("101", 2)`	value	1
`decimal-from-hex-larger`	DECIMAL	`=DECIMAL("FF", 16)`	value	1
`decimal-base-36`	DECIMAL	`=DECIMAL("Z", 36)`	value	1
`ceiling-precise-positive`	CEILING.PRECISE	`=CEILING.PRECISE(4.3)`	value	1
`ceiling-precise-negative`	CEILING.PRECISE	`=CEILING.PRECISE(-4.3)`	value	2
`ceiling-precise-with-significance`	CEILING.PRECISE	`=CEILING.PRECISE(4.3, 2)`	value	1
`ceiling-precise-negative-significance-ignored`	CEILING.PRECISE	`=CEILING.PRECISE(-4.3, -2)`	value	1
`floor-precise-positive`	FLOOR.PRECISE	`=FLOOR.PRECISE(4.8)`	value	1
`floor-precise-negative`	FLOOR.PRECISE	`=FLOOR.PRECISE(-4.3)`	value	2
`floor-precise-with-significance`	FLOOR.PRECISE	`=FLOOR.PRECISE(4.8, 2)`	value	1
`floor-precise-negative-significance-ignored`	FLOOR.PRECISE	`=FLOOR.PRECISE(-4.3, -2)`	value	1
`iso-ceiling-positive`	ISO.CEILING	`=ISO.CEILING(4.3)`	value	1
`iso-ceiling-negative`	ISO.CEILING	`=ISO.CEILING(-4.3)`	value	2
`iso-ceiling-with-significance`	ISO.CEILING	`=ISO.CEILING(4.3, 2)`	value	1
`iso-ceiling-negative-significance-ignored`	ISO.CEILING	`=ISO.CEILING(-4.3, -2)`	value	1
`combin-basic`	COMBIN	`=COMBIN(5, 2)`	value	1
`combin-n-equals-k`	COMBIN	`=COMBIN(8, 8)`	value	1
`combin-k-zero`	COMBIN	`=COMBIN(8, 0)`	value	1
`combin-k-greater-than-n`	COMBIN	`=COMBIN(3, 5)`	value	2
`combina-basic`	COMBINA	`=COMBINA(5, 2)`	value	1
`combina-k-zero`	COMBINA	`=COMBINA(8, 0)`	value	1
`combina-larger`	COMBINA	`=COMBINA(4, 3)`	value	1
`multinomial-two`	MULTINOMIAL	`=MULTINOMIAL(2, 3)`	value	2
`multinomial-three`	MULTINOMIAL	`=MULTINOMIAL(2, 3, 4)`	value	2
`multinomial-single`	MULTINOMIAL	`=MULTINOMIAL(5)`	value	2
`gcd-basic`	GCD	`=GCD(12, 18)`	value
`gcd-coprime`	GCD	`=GCD(7, 13)`	value
`gcd-with-zero`	GCD	`=GCD(0, 8)`	value
`gcd-multiple-args`	GCD	`=GCD(24, 36, 60)`	value
`lcm-basic`	LCM	`=LCM(4, 6)`	value
`lcm-coprime`	LCM	`=LCM(3, 5)`	value
`lcm-with-one`	LCM	`=LCM(1, 7)`	value
`lcm-multiple-args`	LCM	`=LCM(2, 3, 4)`	value
`iseven-even`	ISEVEN	`=ISEVEN(4)`	value
`iseven-odd`	ISEVEN	`=ISEVEN(3)`	value
`iseven-zero`	ISEVEN	`=ISEVEN(0)`	value
`iseven-negative-even`	ISEVEN	`=ISEVEN(-2)`	value
`isodd-odd`	ISODD	`=ISODD(3)`	value
`isodd-even`	ISODD	`=ISODD(4)`	value
`isodd-zero`	ISODD	`=ISODD(0)`	value
`isodd-negative-odd`	ISODD	`=ISODD(-3)`	value	1
`odd-positive-integer`	ODD	`=ODD(3)`	value
`odd-rounds-up`	ODD	`=ODD(1.5)`	value
`odd-of-2`	ODD	`=ODD(2)`	value
`odd-negative`	ODD	`=ODD(-1.5)`	value
`factdouble-of-7`	FACTDOUBLE	`=FACTDOUBLE(7)`	value	1
`factdouble-of-6`	FACTDOUBLE	`=FACTDOUBLE(6)`	value	1
`factdouble-of-0`	FACTDOUBLE	`=FACTDOUBLE(0)`	value
`factdouble-negative`	FACTDOUBLE	`=FACTDOUBLE(-1)`	value	2
`erfc-at-0`	ERFC	`=ERFC(0)`	value
`erfc-at-1`	ERFC	`=ERFC(1)`	value
`erfc-negative`	ERFC	`=ERFC(-1)`	value
`erfc-precise-at-0`	ERFC.PRECISE	`=ERFC.PRECISE(0)`	value	1
`erfc-precise-at-1`	ERFC.PRECISE	`=ERFC.PRECISE(1)`	value
`erfc-precise-at-2`	ERFC.PRECISE	`=ERFC.PRECISE(2)`	value
`gammaln-at-1`	GAMMALN	`=GAMMALN(1)`	value	2
`gammaln-at-2`	GAMMALN	`=GAMMALN(2)`	value	2
`gammaln-at-5`	GAMMALN	`=GAMMALN(5)`	value
`gammaln-non-positive`	GAMMALN	`=GAMMALN(0)`	value	2
`gammaln-precise-at-1`	GAMMALN.PRECISE	`=GAMMALN.PRECISE(1)`	value	2
`gammaln-precise-at-2`	GAMMALN.PRECISE	`=GAMMALN.PRECISE(2)`	value	2
`gammaln-precise-at-5`	GAMMALN.PRECISE	`=GAMMALN.PRECISE(5)`	value
`imln-of-real`	IMLN	`=IMLN("1")`	value
`imln-of-i`	IMLN	`=IMLN("i")`	value
`imln-of-complex`	IMLN	`=IMLN("3+4i")`	value
`impower-squared`	IMPOWER	`=IMPOWER("2+3i", 2)`	value
`impower-of-i-squared`	IMPOWER	`=IMPOWER("i", 2)`	value
`impower-zeroth`	IMPOWER	`=IMPOWER("2+3i", 0)`	value
`imsqrt-of-real`	IMSQRT	`=IMSQRT("4")`	value
`imsqrt-of-i`	IMSQRT	`=IMSQRT("i")`	value
`imsqrt-of-complex`	IMSQRT	`=IMSQRT("3+4i")`	value
`product-scalars`	PRODUCT	`=PRODUCT(2, 3, 4)`	value	1
`product-with-zero`	PRODUCT	`=PRODUCT(5, 0, 3)`	value	1
`product-single`	PRODUCT	`=PRODUCT(7)`	value	1
`product-with-grid-range`	PRODUCT	`=PRODUCT(A1:A3)`	value	1
`countifs-single-criterion`	COUNTIFS	`=COUNTIFS(A1:A4, ">2")`	value
`countifs-two-criteria`	COUNTIFS	`=COUNTIFS(A1:A4, ">1", B1:B4, "x")`	value
`countifs-exact-match`	COUNTIFS	`=COUNTIFS(A1:A3, 5)`	value
`countifs-no-match`	COUNTIFS	`=COUNTIFS(A1:A2, ">10")`	value
`countunique-distinct`	COUNTUNIQUE	`=COUNTUNIQUE(A1:A3)`	value	1
`countunique-with-dupes`	COUNTUNIQUE	`=COUNTUNIQUE(A1:A5)`	value	1
`countunique-text`	COUNTUNIQUE	`=COUNTUNIQUE(A1:A3)`	value	1
`subtotal-average`	SUBTOTAL	`=SUBTOTAL(1, A1:A3)`	value	1
`subtotal-count`	SUBTOTAL	`=SUBTOTAL(2, A1:A3)`	value	1
`subtotal-max`	SUBTOTAL	`=SUBTOTAL(4, A1:A3)`	value	1
`subtotal-min`	SUBTOTAL	`=SUBTOTAL(5, A1:A3)`	value	1
`subtotal-sum`	SUBTOTAL	`=SUBTOTAL(9, A1:A3)`	value	1
`seriessum-constant-coef`	SERIESSUM	`=SERIESSUM(1, 0, 1, {1, 1, 1})`	value	1
`seriessum-x-squared-series`	SERIESSUM	`=SERIESSUM(2, 0, 1, {1, 1, 1})`	value	1
`seriessum-x-equals-one`	SERIESSUM	`=SERIESSUM(1, 1, 1, {2, 3, 4})`	value	1
`seriessum-small`	SERIESSUM	`=SERIESSUM(2, 0, 2, {1, 1})`	value	1
`munit-2x2`	MUNIT	`=MUNIT(2)`	value	2
`munit-3x3`	MUNIT	`=MUNIT(3)`	value	2
`munit-1x1`	MUNIT	`=MUNIT(1)`	value	1
`munit-zero-error`	MUNIT	`=MUNIT(0)`	error-code
`sqrtpi-of-1`	SQRTPI	`=SQRTPI(1)`	value
`sqrtpi-of-0`	SQRTPI	`=SQRTPI(0)`	value	1
`sqrtpi-of-2`	SQRTPI	`=SQRTPI(2)`	value
`sqrtpi-negative`	SQRTPI	`=SQRTPI(-1)`	value	2
`rand-smoke`	RAND	`=RAND()`	volatile
`randbetween-smoke`	RANDBETWEEN	`=RANDBETWEEN(1, 10)`	volatile
`randarray-smoke`	RANDARRAY	`=RANDARRAY(2, 2)`	volatile	1