statistics.js icon indicating copy to clipboard operation
statistics.js copied to clipboard

How settings StudentsTtestTwoSample for same result of T.TEST from Excel

Open GBonnaire opened this issue 1 year ago • 2 comments

Hi,

When i use StudentsTtestTwoSample, i don't have same result in Excel. How i can fix that ?

var treatmentResults = [
            { before: 204, after: 189 },
            { before: 212, after: 199 },
            { before: 199, after: 191 },
            { before: 209, after: 182 },
            { before: 191, after: 176 },
            { before: 190, after: 180 },
            { before: 223, after: 220 },
            { before: 185, after: 182 },
            { before: 206, after: 194 },
            { before: 212, after: 216 }
        ];

        var testVars = { before: 'metric', after: 'metric'  };
        var stats = new Statistics(treatmentResults, testVars, settings);
        var treatmentSuccess = stats.studentsTTestTwoSamples('before', 'after', { dependent: true });

Result with your lib : "pOneSided": 0.002119623339108534 Result with Excel : "=T.TEST(A1:A10;B1:B10;1;1)" 0,001512746

Thanks for your helps

GBonnaire avatar Jun 16 '23 11:06 GBonnaire