3 Replies Latest reply on Oct 18, 2012 10:41 AM by Nicholas Hermez

# Significance test

Anyone has done Significance test in Tableau?

I'm looking for ANOVA result.  Which compare result across different groups.  Say we survery 1000 customers and they belong to 4 groups.

How do you like the taste of ....                                                                                                                                                      A                    B               C               D

 Just right 87 85 92bd 83 Too Weak 5 5 5 7 Too Strong 8 11c 3 11c

92% of C group customer said "Just Right" which is Significance tested at the 95% confidence level between the c&b, c&d

Thanks,

Xiaodong

• ###### 1. Re: Significance test

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

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

This may not be what you are looking for, but I have an example of a two-proportion z-test 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%).

http://en.wikipedia.org/wiki/Statistical_hypothesis_testing

1 of 1 people found this helpful