Repeat Example 9.11, but this time use the Excel function INTERCEPT() and SLOPE() to calculate these values

Question:

Repeat Example 9.11, but this time use the Excel function INTERCEPT() and SLOPE() to calculate these values in Cells H3 and H4. Figure 9.19 illustrates the change to cells H3 and H4 in the Excel solution given in Figure 9.17

3 5 H a=13.30575-INTERCEPT(C4 b 1.808231 SLOPE(C4 C33.84 B33) C33 84 833) Figure 9.19

Data from Example 9.11

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