6. Consider the following time series (Use Excel for this problem). t 1 2 3 4 5 6 7 8 9 10 Yt 120 110 100 96 94 92 88 84 82 78 a) Construct a time series plot. What type of pattern exists in the data? b) Develop the linear trend equation. What are the values for slope and intercept? c) What is the forecast for t = 11? Determine the Forecasts, Forecast Accuracy Measures. Prepare Time Series Plots. d) Is the linear trend statistically significant? Use a = .05 e) What is the Goodness of fit measure of this linear trend? 4