Posted on:

26 Aug 2023

1

the provided formulas in the video isn't correct

i have used the provided formulas but it give wrong result can you explain why ? 

- here the right one : S = (1/n) * SUM((x - mean) ^ 3) / (stdev ^ 3) ,or in excel function : =(1/COUNT(data)) * SUM((data - AVERAGE(data))^3) / (STDEV.P(data)^3)


which give similar result to skew() function 


- and i think that the error you had made is between 2 and 3 on the division ,here ur formula :

S = (1/n) * SUM((x - mean) ^ 3) / (variance ^ (1/3)) , or excel version : =(1/COUNT(Table1[Column1])) * SUM((Table1[Column1] - AVERAGE(Table1[Column1]))^3) / (VAR.P(B10:B39)^(1/3))


- and here the correction i have concluded : S = (1/n) * SUM((x - mean) ^ 3) / (variance ^ (3/2)) , or excel version : =(1/COUNT(Table1[Column1])) * SUM((Table1[Column1] - AVERAGE(Table1[Column1]))^3) / (VAR.P(B10:B39)^(3/2)) 


i hope you response to me in very short time because im waiting for your answer

0 answers ( 0 marked as helpful)

Submit an answer