This content has been marked as final.
Show 2 replies

1. Re: To achieve T.Dist() function of Excel in Tableau to get the pvalue of a TTest
Jonathan Drummey Jul 17, 2012 9:07 AM (in response to rochelle.sun)I'm pinging Scott Tennican for help on this one...

2. Re: To achieve T.Dist() function of Excel in Tableau to get the pvalue of a TTest
Scott Tennican Jul 23, 2012 5:33 PM (in response to rochelle.sun)Tableau does not provide calculated field access to the equivalent of the T.DIST() function which provides the studentt distribution. In fact, none of the standard distributions are accessible in this way. However, you don't actually need to use a studentt 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