LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
URL Encode Dave Excel Worksheet Functions 0 June 6th 07 04:11 PM
URL encode a string Marcelo P Excel Programming 0 May 15th 07 04:10 PM
encode in UTF-8 from macro? [email protected] Excel Discussion (Misc queries) 0 February 9th 07 03:07 AM
A rather difficult statistical search formula needed (Part 2) Vasilis Tergen Excel Worksheet Functions 4 January 11th 07 06:14 AM
A rather difficult & complex statistical search formula needed Vasilis Tergen Excel Worksheet Functions 4 January 7th 07 07:31 PM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"