
1. Re: Significance test
Alex Kerin Oct 7, 2012 10:14 AM (in response to Xiaodong Han)You could manually create the equations and have lookup tables for significance testing. I would recommend using another program however  even Excel has pretty robust tests.

2. Re: Significance test
Xiaodong Han Oct 18, 2012 6:09 AM (in response to Alex Kerin)Is there any samples in Tableau? I hope to solve this problem in Tableau, not in other applications. We need to deliver the result to end users, I cannot ask them to use Excel, SAS, or SPSS to answer this type of questions. Then I need to send them all the data.....

3. Re: Significance test
Nicholas Hermez Oct 18, 2012 10:41 AM (in response to Xiaodong Han)1 of 1 people found this helpfulThis may not be what you are looking for, but I have an example of a twoproportion ztest in Tableau. I hope it helps:
Z =
[inc response rate]
/ SQRT(
[ttl response_rate]
*(1[ttl response_rate])
*((1/[test ttl_nbr_contacts])+(1/[ctrl ttl_nbr_contacts raw]))
)
All the metrics are aggregates. To keep things simple I said if Z > 1.96 or Z < 1.96 then 'Yes' else 'No' (95%).