statistics.js
statistics.js copied to clipboard
How settings StudentsTtestTwoSample for same result of T.TEST from Excel
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