In this example we will fit a trend line to a time series data set given the

Question:

In this example we will fit a trend line to a time series data set given the value of the slope of the trend line and its intercept. Figure 9.17 illustrates the manual calculation of the trend line using basic Excel formulae.

1 Example 911 2 3 7 8 9 10 11 12 13 14 16 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Perod 1 2 3 4

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics Using Excel

ISBN: 9780199659517

2nd Edition

Authors: Glyn Davis, Branko Pecar

Question Posted: