Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Is there an inverse Chi Square formula - Same as Excel CHIINV function?

Metabrit
7 - Meteor

Hi,

 

I'm trying to migrate one of our analysis tools into an alteryx workflow and part of the analysis tool uses the CHIINV function in Excel.

 

 

Does anyone know of a way to do the CHIINV function from Excel in Alteryx formula tools?

 

 

9 REPLIES 9
Metabrit
7 - Meteor

@MarqueeCrew Do you guys have any solution to this? Love the formula addons you created and could do with you're help on a CHIINV function.

MarqueeCrew
20 - Arcturus
20 - Arcturus

My friend, @jdunkerley79 created the formula pack.  He's copied here to hear the request.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Metabrit
7 - Meteor

Thanks, I've just realised I also need to be able to do a TINV function as well (two-tailed inverse of the Student's t-distribution). 

jdunkerley79
ACE Emeritus
ACE Emeritus
Give me a weekend. Will add to the Abacus library and release.
MarqueeCrew
20 - Arcturus
20 - Arcturus

@jdunkerley79 == "SuperACE"

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Metabrit
7 - Meteor

Awesome! Thanks a lot, I'll await the next release

patrick_digan
17 - Castor
17 - Castor

@Metabrit If you have the predictive tools installed (http://downloads.alteryx.com/predictive.html if you're on 11.3 or http://downloads.alteryx.com/changes.html if you're on a previous version) you can use R functions like qchisq and qt. I put together a quick macro for the Inverse ChiSquared and Inverse T.

Metabrit
7 - Meteor

Thanks Patrick,

 

That's definitely a great solution! I'll use this macro until @jdunkerley79 adds the formulas to his bundle.

jdunkerley79
ACE Emeritus
ACE Emeritus

Added to the new version 1.3 release: https://github.com/jdunkerley/AlteryxFormulaAddOns/releases/latest

 

- TInv, TDist for the 2 tailed Student T

- ChiInv and ChiDist for the right hand of the Chi squared distribution

 

Both based on the Boost C++ library and tested against Excel's functions

 

 

Labels