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?
@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.
@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.
My friend, @jdunkerley79 created the formula pack. He's copied here to hear the request.
Cheers,
Mark
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).
