Posted to microsoft.public.excel.worksheet.functions

Vincent Isoz Vincent Isoz is offline

external usenet poster

Posts: 4

[XL 2003/07] Standard Error of Moving Average

Hi,

I just would like to know what some of you think about the calculation of
the "standard error" avalaible in the Moving Average tool visible in the
Analysis Toolpack.

For me the calculation is false because SUMXMY2 must be divided MMX-2 when X
is the ponderation of the moving average.

Thanks for your opinion.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
"moving average" Excel 2003 vs Excel 2007	LvB38	Excel Worksheet Functions	1	December 17th 07 06:36 AM
Weighted Average Standard Deviation	kthenning	Excel Worksheet Functions	4	October 2nd 05 05:03 PM
Error Handling #N/A with AVERAGE Function - Average of values in Row	Sam via OfficeKB.com	Excel Worksheet Functions	13	July 31st 05 03:59 PM
Standard Error	Maral	Excel Worksheet Functions	2	December 4th 04 06:45 PM
Histrogramms: Calculating average and standard deviation	Jens Eichelbaum	Excel Worksheet Functions	2	November 23rd 04 02:10 AM

All times are GMT +1. The time now is 09:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us