Statistical T-Test in Pivot Table

[CArmanie]

I have a large amount of data in a Pivot table and I am trying to perform a T-Test.

I am able to show the standard deviation and the variance but, I do not know how to go about getting to a t-test. Since the standard deviation is not listed as a calculated field, I can't write out the formula.

Any help would be greatly appreciated.

Thanks,

 

[nbrcrunch]

maybe this will help? http://www.bettersolutions.com/excel/EUN147/NA532728332.htm