Microsoft Office Tutorials and References
In Depth Information
Displaying a Moving Average
Figure 5-15: A chart displaying a third-polynomial trendline
Formulas to generate the values for other orders of polynomial trendlines
follow a pattern similar to the formulas listed previously. For example, a
fifthorder polynomial has five coefficients and one constant. The first coefficient
for a fifth-order polynomial is calculated with the following formula:
=INDEX(LINEST(B2:B11,A2:A11^{1,2,3,4,5}),1,1)
Displaying a Moving Average
The Add Trendline dialog box lists Moving Average as an option. But as I noted
earlier, a moving average is not really a trendline. A moving average displays a line
that depicts the data series, averaged over a specified number of data points.
Adding a moving average line
To add a moving average line, select the chart series and choose Chart
Add
Trendline. Click the Type tab, choose the Moving Average option, and specify a
period. The period is the number of consecutive data points that are averaged. If
you like, click the Options tab and enter a name for the moving average line. This
is the text that will be displayed in the chart’s legend.
Search JabSto ::




Custom Search