[XL 2003/07] Standard Error of Moving Average

V

Vincent Isoz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of time spent monthly getting DIV/0 error 2
Moving Average of values within an array 2
Average of % in pivot table 1
Standard Error Formula 1
Pivot Table - Average of counts 0
Regression - Standard Error X Variable 1 2
Excel 03 to Excel 07 1
back transforming log10 of standard error 0

Top