Default Delta Degrees of Freedom of standard deviation

Question

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

apathetichell · Answer

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.

manual DOF STDEV.yxzp

RithiS · Answer

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,