ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   [XL 2003/07] Standard Error of Moving Average (https://www.excelbanter.com/excel-worksheet-functions/203438-%5Bxl-2003-07%5D-standard-error-moving-average.html)

Vincent Isoz

[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.


All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com