Hint(s) Consider the following time series data. 1 2 3 4 5 6 12 10 13 15 Excel File: data17-17.xIs a. Construct a time series plot. 1. Time Series _Value 16 -14 12 10 -8 6 -4 2 2 3 4 5 Time Period (t) 2. Time Series _Value 16 14 12 -82. Time _Series __Value -16 -14 12 10 -8 6 3 4 5 Time Period (t) 3. Time Series _Value -16 -14 -12 -10 -8 - 6 -4 .2 2 3 5 Time Period (t) time series plot #1 What type of pattern exists in the data? - Select your answer - + b. Develop the linear trend equation for this time series (to 1 decimal).- Select your answer - \\l time series plot #1 me series plot #2 time series plot #3 51's in the data? b. Develop the linear trend equation for this time series (to 1 decimal). c. What is the forecast for t = 6 (to 1 decimal)? [j Hint(s) 0* Icon Key Exercise 17.17 Algo (Trend Projection) Question 1 of 6 D 3. Time Series _Value 16 14 -12 10 -8 6 -4 -2 3 4 5 Time Period (t) time series plot #1 What type of pattern exists in the data? v - Select your answer - linear trend end equation for this time series (to 1 decimal). curvilinear trend horizontal c. What is the forecast for t = 6 (to 1 decimal)? - Icon Key Exercise 17.17 Algo (Trend Projection) Question 1 of 6