a. Option 1
Trend pattern
b.
x | Y |
1 | 5 |
2 | 12 |
3 | 10 |
4 | 13 |
5 | 16 |
Intercept | INTERCEPT(known Y's,known X's) | 4.30 |
Slope | SLOPE(known Y's,known X's) | 2.30 |
x | Y | linear trend Forecast, Y= Intercept + slope*x | Absolute deviation= |Forecast - Actual| | squared deviation= (absolute deviation)^2 |
1 | 5 | 6.6 | 1.60 | 2.6 |
2 | 12 | 8.9 | 3.10 | 9.6 |
3 | 10 | 11.2 | 1.20 | 1.4 |
4 | 13 | 13.5 | 0.50 | 0.3 |
5 | 16 | 15.8 | 0.20 | 0.0 |
6 | 18.1 | |||
2.78 | ||||
MSE |
Intercept= 4.30
Slope= 2.30
MSE= 2.78
c. Forecast for x=6
Y= 4.3+ 2.3*x = 18.1
Consider the following time series: Yt5 12 10 13 16 a. Choose the correct time series...
Consider the following time series. t 1 2 3 4 5 yt 5 11 8 14 15 (b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. If required, round your answers to two decimal places. y-intercept, b0 = Slope, b1 = MSE = (c) What is the forecast for t = 6? If required, round your answer to one decimal place.
Consider the following time series data. Week Value 1 16 2 14 3 15 4 12 5 16 6 13 (a) Choose the correct time series plot. (1) Time Series Value 5 6 4 Week (t) Time Series Value 1 2 3 5 4 Week (t) (iii) Time Series Value 1 2 3 5 4 Week (t) (iv) Time Series Value 1 2 3 5 6 4 Week (t) Graph (ii) What type of pattern exists in the data? Horizontal...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 11 16 1017 15 (a) Construct a time series plot. 20 20 20 18 16 14 12 10 c 14 12 12 0 23 4 5 67 0 23 4 5 67 Week Weck Week 20 18 0 1 2345 6 7 Week What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a...
Consider the following time series data. 15 13 10 12 a. Which of the following is a correct time series plot for this data? TimeSeries Value 14 12 10 TimePeriod (t) TimeSeries Value 14 12 10 TimePeriod(t) TimeSeries Value 14 12 10 TimePeriod (t) 2 TimePeriod(t) select your answer- What type of pattern exists in the data? -select your answer b. Develop the linear trend equation for this time series (to 1 decimal). Tt = c. What is the forecast...
Year Cost/Unit ($) Year Cost/Unit ($) 20.00 24.50 28.20 27.50 26.60 30.00 31.00 36.00 6 4 (a) Choose the correct time series plot. 40.00 $2500 5.00 Year (r) Year(t) (iv) 535.00 525.00 $20.00 $15.00 510.00 520.00 Year (e) Plot (ii) What type of pattern exists in the data? Trend Pattern (b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series If required, round your answers to two decimal places y-intercept,...
Problem 08-06 Algo (Moving Averages and Exponential Smoothing) Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 (a) Choose the correct time series plot Month (iv) Month Select your answer What type of pattern exists in the data? Select your answer- (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal...
Consider the following time series data. Week 1 2 3 4 5 6 Value 17 13 15 11 15 13 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1 What type of pattern exists in the data? - Select your answer -Horizontal PatternTrend PatternItem 2 (b) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required, round your answers...
The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firm's leading product over the past eight years. Click on the datafile logo to reference the data. DATA Year Cost/Unit () Year Cost/Unit (s) 20.00 24.50 28.20 27.50 26.60 30.00 31.00 36.00 (a) Choose the correct time series plot. Plot (ii) What type of pattern...
Please help Consider the following time series data. Week 1 N 3 4 5 6 Value 19 11 13 10 14 12 (a) Construct a time series plot. 20 18 20 18 14 12 10 Week 3 4 Week D 20 18+ 16 Time Series Value Time Series Value 5 Week 0 Wook What type of pattem exists in the data? The data appear to follow a cyclical pattern. The data appear to follow a trend pattem. The data appear...
Year Period (t) Enrollment (1000s) 2001 1 6.5 2002 2 8.1 2003 3 8.4 2004 4 10.2 2005 5 12.5 2006 6 13.3 2007 7 13.7 2008 8 17.2 2009 9 18.1 a. The data shows the enrollment for the college for the nine most recent years. 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 time series. (using Period...