diff options
| author | Takeshi Abe <tabe@fixedpoint.jp> | 2018-06-13 18:51:13 +0900 |
|---|---|---|
| committer | Markus Mohrhard <markus.mohrhard@googlemail.com> | 2018-07-13 21:59:19 +0200 |
| commit | 65b1990687ec261d10a96e58b9d476d4b23e11a0 (patch) | |
| tree | 00e589465ed15510500fd7afb69713f077159ae9 | |
| parent | 84ccbb5123fe976a105e97390141ed209c8b9bcc (diff) | |
sc: Add a test case for ZTEST() raising #DIV/0!
... when the sample stddev is 0.
This follows up d17e8faa13b1f8d943b602aa6ea754c1b22fdd76.
Change-Id: I4ce718f60f1dbcf58fdcbbb553c345c9c8907a2b
Reviewed-on: https://gerrit.libreoffice.org/55741
Tested-by: Jenkins
Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
| -rw-r--r-- | sc/qa/unit/data/functions/statistical/fods/ztest.fods | 20 |
1 files changed, 16 insertions, 4 deletions
diff --git a/sc/qa/unit/data/functions/statistical/fods/ztest.fods b/sc/qa/unit/data/functions/statistical/fods/ztest.fods index db8294fb98c1..94bb0a552958 100644 --- a/sc/qa/unit/data/functions/statistical/fods/ztest.fods +++ b/sc/qa/unit/data/functions/statistical/fods/ztest.fods @@ -4462,10 +4462,22 @@ <table:table-cell table:number-columns-repeated="5"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce32"/> - <table:table-cell table:number-columns-repeated="3"/> + <table:table-cell table:formula="of:=ZTEST([.F18:.G18]; 42)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#DIV/0!</text:p> + </table:table-cell> + <table:table-cell table:formula="of:#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#DIV/0!</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce28" table:formula="of:=ERROR.TYPE([.A18])=2" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce32" table:formula="of:=FORMULA([.A18])" office:value-type="string" office:string-value="=ZTEST(F18:G18, 42)" calcext:value-type="string"> + <text:p>=ZTEST(F18:G18, 42)</text:p> + </table:table-cell> + <table:table-cell/> + <table:table-cell table:number-columns-repeated="2" office:value-type="float" office:value="42" calcext:value-type="float"> + <text:p>42</text:p> + </table:table-cell> <table:table-cell table:style-name="ce58"/> <table:table-cell table:number-columns-repeated="3"/> <table:table-cell table:style-name="ce46"/> |