You can not consider the t-statistic as a negative value even if it appears as a negative value, you need to take the t-statistic as an absolute value /t-statistic/ always even if it may appear as a negative value, t-statistic = 8.18919 therefore t-critical value < t-statistic in your example! Also, P < t-statistic and the hypothesis null is rejected.
This is a very nice description of using the ttest command in excel, however I am afraid your Interpretation of the results is wrong. You deleted the t-values for a one tailed test and interpreted the critical t-value for the two tailed. That means that your hypotheses (H1) only states that there is a difference between the means, but not in which direction. But if you do that there are actually two critical values, since the hypotheses tests in both directions. If the tables show a 2.26 you actually have to look in both directions (2.26/-2.26). Therefore there actually IS a significant effect (significant mean difference) in your data, since -8.19 is "bigger" that -2.26.The Interpretation you showed is for a one tailed ttest, so you should have kept the upper critical value.
Could you expand further on this? If I had a group of elevations, and separated the values into different populations (upthrown and downthrown) and used a Two-Sample Assuming Equal Variances t-Test, and my one tail and two tail t-Crit were less than my Calculated T-Value, then would I still have a significant difference in my results?
You can not consider the t-statistic as a negative value even if it appears as a negative value, you need to take the t-statistic as an absolute value /t-statistic/ always even if it may appear as a negative value, t-statistic = 8.18919 therefore t-critical value < t-statistic in your example! Also, P < t-statistic and the hypothesis null is rejected.
Thank you!
This is a very nice description of using the ttest command in excel, however I am afraid your Interpretation of the results is wrong. You deleted the t-values for a one tailed test and interpreted the critical t-value for the two tailed. That means that your hypotheses (H1) only states that there is a difference between the means, but not in which direction. But if you do that there are actually two critical values, since the hypotheses tests in both directions. If the tables show a 2.26 you actually have to look in both directions (2.26/-2.26). Therefore there actually IS a significant effect (significant mean difference) in your data, since -8.19 is "bigger" that -2.26.The Interpretation you showed is for a one tailed ttest, so you should have kept the upper critical value.
Could you expand further on this? If I had a group of elevations, and separated the values into different populations (upthrown and downthrown) and used a Two-Sample Assuming Equal Variances t-Test, and my one tail and two tail t-Crit were less than my Calculated T-Value, then would I still have a significant difference in my results?
are the units BPM please answer soon as have to hand a report soon
First!