diff options
| author | xuri <xuri.me@gmail.com> | 2022-03-31 00:04:40 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-03-31 00:04:40 +0800 |
| commit | 18c48d829133ec395bda8440a04d9f25dcfe11f5 (patch) | |
| tree | 5584e1336d146dd5ba5305ac8d98c47b9bc6dfd9 /calc_test.go | |
| parent | 29d63f6ae0a3411be7e9799c80e6be41997c4f14 (diff) | |
ref #65, new formula functions: CHISQ.INV and CHISQ.INV.RT
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 30db8cf..43f6a29 100644 --- a/calc_test.go +++ b/calc_test.go @@ -865,6 +865,16 @@ func TestCalcCellValue(t *testing.T) { "=CHISQ.DIST.RT(8,3)": "0.0460117056892314", "=CHISQ.DIST.RT(40,4)": "4.32842260712097E-08", "=CHISQ.DIST.RT(42,4)": "1.66816329414062E-08", + // CHISQ.INV + "=CHISQ.INV(0,2)": "0", + "=CHISQ.INV(0.75,1)": "1.32330369693147", + "=CHISQ.INV(0.1,2)": "0.210721031315653", + "=CHISQ.INV(0.8,2)": "3.2188758248682", + "=CHISQ.INV(0.25,3)": "1.21253290304567", + // CHISQ.INV.RT + "=CHISQ.INV.RT(0.75,1)": "0.101531044267622", + "=CHISQ.INV.RT(0.1,2)": "4.60517018598809", + "=CHISQ.INV.RT(0.8,2)": "0.446287102628419", // CONFIDENCE "=CONFIDENCE(0.05,0.07,100)": "0.0137197479028414", // CONFIDENCE.NORM @@ -2565,6 +2575,21 @@ func TestCalcCellValue(t *testing.T) { "=CHISQ.DIST.RT()": "CHISQ.DIST.RT requires 2 numeric arguments", "=CHISQ.DIST.RT(\"\",3)": "strconv.ParseFloat: parsing \"\": invalid syntax", "=CHISQ.DIST.RT(0.5,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + // CHISQ.INV + "=CHISQ.INV()": "CHISQ.INV requires 2 numeric arguments", + "=CHISQ.INV(\"\",1)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=CHISQ.INV(0.5,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=CHISQ.INV(-1,1)": "#NUM!", + "=CHISQ.INV(1,1)": "#NUM!", + "=CHISQ.INV(0.5,0.5)": "#NUM!", + "=CHISQ.INV(0.5,10000000001)": "#NUM!", + // CHISQ.INV.RT + "=CHISQ.INV.RT()": "CHISQ.INV.RT requires 2 numeric arguments", + "=CHISQ.INV.RT(\"\",1)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=CHISQ.INV.RT(0.5,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=CHISQ.INV.RT(0,1)": "#NUM!", + "=CHISQ.INV.RT(2,1)": "#NUM!", + "=CHISQ.INV.RT(0.5,0.5)": "#NUM!", // CONFIDENCE "=CONFIDENCE()": "CONFIDENCE requires 3 numeric arguments", "=CONFIDENCE(\"\",0.07,100)": "strconv.ParseFloat: parsing \"\": invalid syntax", |