Consider the monthly sales data for the following questions. You may need to use Paste Special >
Fantastic news! We've Found the answer you've been seeking!
Question:
Consider the monthly sales data for the following questions.
You may need to use Paste Special > text to copy properly into Excel.
Time, t | Price = Yt |
1 | 5.80 |
2 | 5.87 |
3 | 5.79 |
4 | 5.96 |
5 | 5.96 |
6 | 6.51 |
7 | 6.41 |
8 | 6.43 |
9 | 6.56 |
10 | 6.56 |
11 | 6.87 |
12 | 7.39 |
13 | 7.63 |
14 | 7.62 |
15 | 7.50 |
16 | 7.73 |
17 | 8.10 |
18 | 8.16 |
19 | 8.18 |
20 | 8.13 |
Use the forecasting formula (trend line) to forecast month 21.
Use the rounded intercept and slope answers in part four to calculate your answer.
Round the answer to two decimal places.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: