View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anastasia Gryaznov Anastasia Gryaznov is offline
external usenet poster
 
Posts: 1
Default how to encode statistical formula

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.