I am writing a program in C# that requires me to use the Ttest formula. I have to effectively interpret the Excel formula:
I am using the formula given here
and have interpreted into code as such:
double TStatistic = (mean1 - mean2) / Math.Sqrt((Math.Pow(variance1, 2) / count1) + (Math.Pow(variance2, 2) / count2));
However, I don't fully understand t-test and the values I am getting are completely different than those calculated within Excel.
I have been using the following ranges:
R1: 91.17462277, 118.3936425, 96.6746393, 102.488785, 91.26831043 R2: 17.20546254, 19.56969811, 19.2831241, 13.03360631, 13.86577314
The value I am getting using my attempt is 1.8248, however that from Excel is 1.74463E-05. Could somebody please point me in the right direction?