diff options
| author | xuri <xuri.me@gmail.com> | 2022-04-15 00:27:47 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-04-15 00:27:47 +0800 |
| commit | 66776730b605dfef2d01dd8a59afc45d98272eb1 (patch) | |
| tree | 108c40279cc38ab52b5024060bd808c1aad9e407 /calc_test.go | |
| parent | c0d341706d7e6d568bb94444d58799f001a97c3f (diff) | |
ref #65, new formula functions: PEARSON and RSQ
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 52bc061..a7f88b0 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1095,6 +1095,8 @@ func TestCalcCellValue(t *testing.T) { "=MINA(A1:B4,MUNIT(1),INT(0),1,E1:F2,\"\")": "0", // MINIFS "=MINIFS(F2:F4,A2:A4,\">0\")": "22100", + // PEARSON + "=PEARSON(A1:A4,B1:B4)": "1", // PERCENTILE.EXC "=PERCENTILE.EXC(A1:A4,0.2)": "0", "=PERCENTILE.EXC(A1:A4,0.6)": "2", @@ -1149,6 +1151,8 @@ func TestCalcCellValue(t *testing.T) { "=RANK.EQ(1,A1:B5)": "5", "=RANK.EQ(1,A1:B5,0)": "5", "=RANK.EQ(1,A1:B5,1)": "2", + // RSQ + "=RSQ(A1:A4,B1:B4)": "1", // SKEW "=SKEW(1,2,3,4,3)": "-0.404796008910937", "=SKEW(A1:B2)": "0", @@ -2974,6 +2978,10 @@ func TestCalcCellValue(t *testing.T) { // MINIFS "=MINIFS()": "MINIFS requires at least 3 arguments", "=MINIFS(F2:F4,A2:A4,\"<0\",D2:D9)": "#N/A", + // PEARSON + "=PEARSON()": "PEARSON requires 2 arguments", + "=PEARSON(A1:A2,B1:B1)": "#N/A", + "=PEARSON(A4,A4)": "#DIV/0!", // PERCENTILE.EXC "=PERCENTILE.EXC()": "PERCENTILE.EXC requires 2 arguments", "=PERCENTILE.EXC(A1:A4,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", @@ -3047,6 +3055,10 @@ func TestCalcCellValue(t *testing.T) { "=RANK.EQ(-1,A1:B5)": "#N/A", "=RANK.EQ(\"\",A1:B5)": "strconv.ParseFloat: parsing \"\": invalid syntax", "=RANK.EQ(1,A1:B5,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + // RSQ + "=RSQ()": "RSQ requires 2 arguments", + "=RSQ(A1:A2,B1:B1)": "#N/A", + "=RSQ(A4,A4)": "#DIV/0!", // SKEW "=SKEW()": "SKEW requires at least 1 argument", "=SKEW(\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", |