Chapter 15 Question 19 Consider the following time series:
t 1 2 3 4 5 6 7
Yt 120 110 100 96 94 92 88
a. construct a time series plot. What type of pattern exists in the data?
b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this times series
c. What is the forecast for t = 8
PLEASE SHOW ME HOW YOU DO THIS IN EXCEL
Categories: