2 Replies Latest reply on Jul 23, 2012 5:33 PM by Scott Tennican

# To achieve T.Dist() function of Excel in Tableau to get the p-value of a T-Test

Hello.

I'm wondering if anyone knows how to do a similiar calculation in Tableau to achieve the T.DIST() function in excel to get p-value of a T-test.

I attached an excel file with sample calculation here.

Please let me know if you have any insights. Thanks!

Rochelle

• ###### 1. Re: To achieve T.Dist() function of Excel in Tableau to get the p-value of a T-Test

I'm pinging Scott Tennican for help on this one...

• ###### 2. Re: To achieve T.Dist() function of Excel in Tableau to get the p-value of a T-Test

Tableau does not provide calculated field access to the equivalent of the T.DIST() function which provides the student-t distribution. In fact, none of the standard distributions are accessible in this way. However, you don't actually need to use a student-t distribution since your sample size is big enough that a normal distribution is nearly identical. So, you could use an approximation of the normal distribution coded in a calculated field instead. (For a survey of various methods see http://web2.uwindsor.ca/math/hlynka/zogheibhlynka.pdf).

The simplest would be:

.5+(.1*[z Score])*(4.4-[z Score])

Scott