Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Chi-Square Distribution Tables to Find P-Values

jaredme
5 - Atom

I'm wondering if there is a way to find p-values when you have a chi-square value and the degrees of freedom? This would be similar to the function CHISQ.DIST.RT(x,df) in Excel or pchisq(chisq,df,lower.tail=FALSE) in R.

 

Business case is, I have a 2x2 contingency table that I needed to see if the phi coefficient were significant using chi-square. I manually calculated the chi-square but if you know of a way to easily calculate that over 100+ iterations I would be very grateful (or a method to get both chi-square/p-values in one-go).

 

 

Thank you!

1 REPLY 1
michelle_mathews
Alteryx Alumni (Retired)

Hi @jaredme , check out the Distribution Analysis tool . I'd right click on it and open the underlying example to see how it works, but it will give you the Chi-Square and significance. 

Labels
Top Solution Authors