44
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + Line 27:
Line 27: − `=T.TEST(array1,array2,tails,type)` +
Is it chance? Use a T-Test to identify how likely an intervention worked (edit)
Revision as of 22:07, 24 February 2022
, 22:07, 24 February 2022no edit summary
Problem
== Problem ==
You tried an intervention and want to see if it worked. How likely is it that the results were chance?
You tried an intervention and want to see if it worked. How likely is it that the results were chance?
Solution
== Solution ==
One of the simplest tests is a “T-Test”, sometimes called a “Student T Test”.
One of the simplest tests is a “T-Test”, sometimes called a “Student T Test”.
See the screenshot for the exact formula in this case:
See the screenshot for the exact formula in this case:
<code>=T.TEST(array1,array2,tails,type)</code>
Enter a `1` for `tails` (because we’re only interested in one measurement, sleep) and a `2` for type (because in this case our samples are not of the same length).
Enter a `1` for `tails` (because we’re only interested in one measurement, sleep) and a `2` for type (because in this case our samples are not of the same length).
The P Value in this example, `0.24`, is above `0.05` and therefore we will assume that any difference in sleep between the nights is due to pure chance.
The P Value in this example, `0.24`, is above `0.05` and therefore we will assume that any difference in sleep between the nights is due to pure chance.