how to encode statistical formula
Two ways are
=SUM(data-AVERAGE(data))^4)/VARP(data)^2/n
array entered (Ctrl-Shift-Enter), or wrapped in a VBA Evaluate() function.
=(KURT(data)*(n-2)*(n-3)+3*(n-1)^2)/(n-1)/(n-2)
Jerry
"Anastasia Gryaznov" wrote:
Hello,
Could you please help me to encode (make it in one function) the following
formula:
[SUM[(X(i) - Mean(X))^4] / ( ((SUM[(X(i) - Mean(X))^2] / N)^2) ] / N
where X(i) is group of numbers stored in cell range A1:A100.
Thanks.
|