STUDENT T-TEST PAIRED/ Discrepancies in calculation with MS Excel

[tp-development]

Plugin Name with version

3.2.2

JSpreadsheet version

v9.x

Describe the bug

See a spreadsheet with an example - there is still a discrepancy between Excel and stat package: https://docs.google.com/spreadsheets/d/1oBX-outkj2eX-kpwMW_bfOlwV_PCm6y3/edit?usp=sharing&ouid=105291088824732366674&rtpof=true&sd=true

• "@progidev/jss-formulas-statistics": "2.2.1"
• "@progidev/jss-plugin-formula": "2.3.5"
• "@jspreadsheet/formula-pro": "3.2.2"

Reproduction steps

1.
2.
3.
...

[GBonnaire]

Hi,

It's a difference because you compare paired result with unpaired result, on plugin, i have implemented only unpaired values. i search to implement paired

[GBonnaire]

I found a solution 😊 i will be available on 2.2.2

Warning : New syntax of formula TTEST =TTEST.TWOSAMPLES.T(A1:A100,B1:B100,FALSE)

TTEST.TWOSAMPLES.T(firstColumn → Range, secondColumn → Range, [pairedValue = FALSE])

[tp-development]

Do we need the additional parameter? There was already a parameter dependant which was to indicate that samples are paired(?), wasn't it?

[GBonnaire]

dependance is replace by pairedValue

You have now 3 parameters : firstColumn : Sample1 SecondColumn: Sample2 pairedValue : Indicate if values are dependant or not

[tp-development]

Ok, that makes sense. I was wondering if the name shouldn't be pairedSamples instead of pairedValue (because we have multiple values here, and the user might not be sure which value is meant here).

[GBonnaire]

Ok, i will change 👍 You prefere :

• pairedSample ?
• Dependant ?

[tp-development]

my vote goes to: pairedSamples (true/false) :)

[GBonnaire]

It's on line on v2.2.3 😊

[tp-development]

After attaching 2.2.3 the changes are not visible (lack of the new parameter).