We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Default Delta Degrees of Freedom of standard deviation

Eric_Liu_signify
5 - Atom

Hi!

 

Could anyone please tell me what's the Default Delta Degrees of Freedom of standard deviation in summarize tool and how can I change it?

 

Thanks,

Eric

Screen Shot 2021-04-26 at 11.49.26 AM.png

2 REPLIES 2
RithiS
Alteryx
Alteryx

Hi @Eric_Liu_signify,

 

The degrees of freedom in the Summarize tool's standard deviation calculation uses the population so it is n. If there are nulls, then it is n - nulls. If the Ignore 0's option is selected then it is n - nulls - zeroes.

 

Thank you,

apathetichell
20 - Arcturus

Here's a macro I built for ST Dev which should allow customization of counting zeros/nulls and DOF. It takes in ONE field so any results have to be appended. It works for me but let me know if you encounter problems.

Labels
Top Solution Authors