feat(formula): add some statistical formulas

wpxp123456 commented 3 weeks ago

close https://github.com/dream-num/univer-pro/issues/2443

Pull Request Checklist

[ ] Related tickets or issues have been linked in the PR description (or missing issue).
[ ] Naming convention is followed (do please check it especially when you created new plugins, commands and resources).
[ ] Unit tests have been added for the changes (if applicable).
[ ] Breaking changes have been documented (or no breaking changes introduced in this PR).

github-actions[bot] commented 3 weeks ago

View Deployment

📑 Examples	📚 Storybook
🔗 Preview link	🔗 Preview link

github-actions[bot] commented 3 weeks ago

Playwright test results

passed 8 passed

Details

stats 8 tests across 3 suites
2 minutes, 3 seconds
commit e1e32e8
info For more information, see full report

codecov[bot] commented 3 weeks ago

Codecov Report

Attention: Patch coverage is 94.88400% with 86 lines in your changes missing coverage. Please review.

Files with missing lines	Patch %	Lines
packages/engine-formula/src/basics/statistical.ts	89.50%	34 Missing :warning:
...engine-formula/src/functions/logical/scan/index.ts	65.78%	13 Missing :warning:
.../engine-formula/src/functions/logical/map/index.ts	60.71%	11 Missing :warning:
...gine-formula/src/functions/logical/reduce/index.ts	70.00%	9 Missing :warning:
...ngine-formula/src/functions/lookup/offset/index.ts	75.00%	6 Missing :warning:
...ngine-formula/src/functions/logical/bycol/index.ts	66.66%	5 Missing :warning:
...ngine-formula/src/functions/logical/byrow/index.ts	66.66%	5 Missing :warning:
packages/engine-formula/src/basics/engineering.ts	85.71%	2 Missing :warning:
...la/src/functions/statistical/covariance-p/index.ts	97.77%	1 Missing :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## dev #3463 +/- ## ========================================== + Coverage 30.94% 31.84% +0.89% ========================================== Files 2161 2194 +33 Lines 113569 115184 +1615 Branches 24894 25374 +480 ========================================== + Hits 35148 36677 +1529 - Misses 78421 78507 +86 ``` | [Flag](https://app.codecov.io/gh/dream-num/univer/pull/3463/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=dream-num) | Coverage Δ | | |---|---|---| | [](https://app.codecov.io/gh/dream-num/univer/pull/3463/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=dream-num) | `31.84% <94.88%> (+0.89%)` | :arrow_up: | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=dream-num#carryforward-flags-in-the-pull-request-comment) to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

oumomomo commented 3 weeks ago

单元格内输入=BETA.INV(0.685470581,8,10,1,3)/=CHISQ.DIST.RT(0.1,2.1)，计算结果，计算结果相差一位

univer-bot[bot] commented 3 weeks ago

Enter =BETA.INV(0.685470581,8,10,1,3)/=CHISQ.DIST.RT(0.1,2.1) in the cell and calculate the result. The calculated result differs by one digit.

oumomomo commented 3 weeks ago

BETA.INV函数单元格内输入=BETA.INV(0.685470581,8,10,0,0)，计算结果未报错

univer-bot[bot] commented 3 weeks ago

BETA.INV function Enter =BETA.INV(0.685470581,8,10,0,0) in the cell, and no error is reported in the calculation result

oumomomo commented 3 weeks ago

CHISQ.INV.RT函数单元格内输入=CHISQ.INV.RT(0.1,500000000000000000)，计算不出结果

univer-bot[bot] commented 3 weeks ago

CHISQ.INV.RT function Enter =CHISQ.INV.RT(0.1,500000000000000000) in the cell, but the result cannot be calculated

oumomomo commented 3 weeks ago

CHISQ.TEST 1、单元格内输入=CHISQ.TEST(A2:B4,A6:B8)，A8&B8单元格为空时计算结果不对

2、单元格内输入=CHISQ.TEST(A2:B2,A6:B6)，计算结果不对

3、单元格输入=CHISQ.TEST(A:C,A:C)，计算结果不报错样张：https://1drv.ms/x/c/c874bd32de218f8c/EY2JyRdwVlFOqkPhsZ48y4MBu63H8xNVMQZ1UMfCRuQKbw?e=hoCaQ3

univer-bot[bot] commented 3 weeks ago

CHISQ.TEST

Enter =CHISQ.TEST(A2:B4,A6:B8) in the cell. When cells A8&B8 are empty, the calculation result is incorrect.
Enter =CHISQ.TEST(A2:B2,A6:B6) in the cell, and the calculation result is incorrect.
Cell input =CHISQ.TEST(A:C,A:C), the calculation result will not report an error Sample: https://1drv.ms/x/c/c874bd32de218f8c/EY2JyRdwVlFOqkPhsZ48y4MBu63H8xNVMQZ1UMfCRuQKbw?e=hoCaQ3

oumomomo commented 3 weeks ago

CONFIDENCE.T函数单元格内输入=CONFIDENCE.T(0.1,B2:A3,B5:A6:B4)，计算不出结果样张：https://1drv.ms/x/c/c874bd32de218f8c/EY2JyRdwVlFOqkPhsZ48y4MBu63H8xNVMQZ1UMfCRuQKbw?e=kqFcrg

univer-bot[bot] commented 3 weeks ago

CONFIDENCE.T function Enter =CONFIDENCE.T(0.1,B2:A3,B5:A6:B4) in the cell, but the result cannot be calculated Sample: https://1drv.ms/x/c/c874bd32de218f8c/EY2JyRdwVlFOqkPhsZ48y4MBu63H8xNVMQZ1UMfCRuQKbw?e=kqFcrg

oumomomo commented 3 weeks ago

CORREL 单元格内输入=CORREL("1+10","1+10" )，错误码不一致

univer-bot[bot] commented 3 weeks ago

CORREL Enter =CORREL("1+10","1+10" ) in the cell, the error codes are inconsistent

oumomomo commented 3 weeks ago

COVARIANCE.P函数 1、单元格内输入=COVARIANCE.P(1.2-5,0.2+1)，预期不报错

2、单元格内输入=COVARIANCE.P("12:2","0:1")，错误码不一致

univer-bot[bot] commented 3 weeks ago

COVARIANCE.P function

Enter =COVARIANCE.P(1.2-5,0.2+1) in the cell. No error is expected.
Enter =COVARIANCE.P("12:2","0:1") in the cell, but the error codes are inconsistent.

oumomomo commented 3 weeks ago

COVARIANCE.S函数 1、单元格内输入=COVARIANCE.S(A5:A7,B5:B7)，A6:B7单元格为空，预期应该报错

2、单元格内输入=COVARIANCE.S(A3:A5,B3:B5)，A3:A4为文本，预期应该报错

3、单元格内输入=COVARIANCE.S(A3:A3,B3:B3)/=COVARIANCE.S("3-1","2+5") ，错误码不一致

univer-bot[bot] commented 3 weeks ago

COVARIANCE.S function

Enter =COVARIANCE.S(A5:A7,B5:B7) in the cell. Cells A6:B7 are empty. It is expected that an error will be reported.
Enter =COVARIANCE.S(A3:A5,B3:B5) in the cell. A3:A4 is text. It is expected that an error will be reported.
Enter =COVARIANCE.S(A3:A3,B3:B3)/=COVARIANCE.S("3-1","2+5") in the cell, and the error codes are inconsistent.

oumomomo commented 3 weeks ago

以上bug已验收

univer-bot[bot] commented 3 weeks ago

The above bugs have been accepted

oumomomo commented 3 weeks ago

F.DIST函数

单元格内输入=F.DIST(A2:A3,A2:A4,A3:A4,FALSE)，计算结果不对

univer-bot[bot] commented 3 weeks ago

F.DIST function

Enter =F.DIST(A2:A3,A2:A4,A3:A4,FALSE) in the cell, and the calculation result is incorrect.

oumomomo commented 3 weeks ago

F.TEST函数

1、单元格内输入=F.TEST(A2:A6,B2:B6)，A2:B5单元格均为空计算结果未报错

2、单元格内输入=F.TEST(A2:A6,B2:B6)，A3单元格为数值外的其他字符串，计算结果不对样张：https://1drv.ms/x/c/c874bd32de218f8c/EZlUN5df4vhCiPIQNDscNJUB9cdFr0Ol1ARGGxBRzY-hPg?e=60yhoD

3、单元格内输入=F.TEST(A2:A4,B2:B6)，计算不出结果样张：https://1drv.ms/x/c/c874bd32de218f8c/EZlUN5df4vhCiPIQNDscNJUB9cdFr0Ol1ARGGxBRzY-hPg?e=CxwPO2

4、单元格内输入=F.TEST(A2:A6,B2:B6)，计算结果未报错样张：https://1drv.ms/x/c/c874bd32de218f8c/Ef0PWf4mZVRHk0Mii9SzBZ0B5DRhZn6uV24zih-j4k_PAw?e=buPhzC

univer-bot[bot] commented 3 weeks ago

F.TEST function

Enter =F.TEST(A2:A6,B2:B6) in the cell. Cells A2:B5 are all empty and the calculation result does not report an error.
Enter =F.TEST(A2:A6,B2:B6) in the cell. Cell A3 contains strings other than numerical values, and the calculation result is incorrect. Sample: https://1drv.ms/x/c/c874bd32de218f8c/EZlUN5df4vhCiPIQNDscNJUB9cdFr0Ol1ARGGxBRzY-hPg?e=60yhoD
Enter =F.TEST(A2:A4,B2:B6) in the cell, but the result cannot be calculated. Sample: https://1drv.ms/x/c/c874bd32de218f8c/EZlUN5df4vhCiPIQNDscNJUB9cdFr0Ol1ARGGxBRzY-hPg?e=CxwPO2
Enter =F.TEST(A2:A6,B2:B6) in the cell, and no error is reported in the calculation result. Sample: https://1drv.ms/x/c/c874bd32de218f8c/Ef0PWf4mZVRHk0Mii9SzBZ0B5DRhZn6uV24zih-j4k_PAw?e=buPhzC

oumomomo commented 3 weeks ago

FISHERINV函数

单元格内输入=FISHERINV(9999999.23658)，计算结果不对

univer-bot[bot] commented 3 weeks ago

FISHERINV function

Enter =FISHERINV(9999999.23658) into the cell, and the calculation result is incorrect.

oumomomo commented 3 weeks ago

FORECAST.LINEAR函数

单元格输入=FORECAST.LINEAR(1,2,B2:B6)，错误码不一致

univer-bot[bot] commented 3 weeks ago

FORECAST.LINEAR function

Cell input =FORECAST.LINEAR(1,2,B2:B6), error codes are inconsistent

dream-num / univer