Trendline with moving average

R

RobertJ

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel When using a trendline with a moving average, what type of windowing is used. A square window is simple but generates harmonics that are artifacts; whereas, a raised cosine or Hamming window does not have this problem.

Does any one know what type of windowing is used for a trendline with a moving average?
 
R

RobertJ

Tested the window by using the equivalent of an impulse function. The windowing is a square window. Has a number of issues the most significant of which are the harmonic artifacts inversely proportional to the averaging window.

Will need to generate a template to generate a Hamming window.
 

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

Trendline problems 3
Remove Trendline 3
Trendline Equation 2
Add a trendline 2
Decimal places on trendline 1
Logarithmic scale + trendlines 6
Adjust the number of decimal points in Trendline equations 2
Excel 2008 0

Top