How do you run a t test?
To run the t-test, arrange your data in columns as seen below. Click on the Data menu, and then choose the Data Analysis tab. You will now see a window listing the various statistical tests that Excel can perform. Scroll down to find the t-test option and click OK.
What is the T value in at test?
The t-value measures the size of the difference relative to the variation in your sample data. Put another way, T is simply the calculated difference represented in units of standard error. The greater the magnitude of T, the greater the evidence against the null hypothesis.
What does the P value of 0.01 mean?
A P-value of 0.01 infers, assuming the postulated null hypothesis is correct, any difference seen (or an even bigger “more extreme” difference) in the observed results would occur 1 in 100 (or 1%) of the times a study was repeated. The P-value tells you nothing more than this.
What does P value of 0.08 mean?
A small P-value signifies that the evidence in favour of the null hypothesis is weak and that the likelihood of the observed differences due to chance is so small that the null hypothesis is unlikely to be true. For example, a P-value of 0.08, albeit not significant, does not mean ‘nil’.