Using the time series data in the table, respond to the following items. Period Sales 1 $1,001 2 1,129 3 843 4 1,044 5 1
Posted: Wed May 04, 2022 12:53 pm
Using the time series data in the table, respond to the following items. Period Sales 1 $1,001 2 1,129 3 843 4 1,044 5 1,012 6 703 682 712 646 686 909 469 566 488 688 675 303 381 789C 10 11 12 13 14 15 16 17 18 345
d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 2 decimal places.) Period Sales Predicted Sales Absolute Error 1 1,001 2 1,129 843 1,044 1,012 703 682 712 646 686 909 469 566 488 688 675 303 381 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
d-3. What is the trend equation based on the regression analysis? (Round your answers to 2 decimal places.) Sales = time period.
f. Predict sales for the next three periods. (Round your answers to 2 decimal places.) Predicted sales Sales (19) Sales (20) Sales (21)
d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 2 decimal places.) Period Sales Predicted Sales Absolute Error 1 1,001 2 1,129 843 1,044 1,012 703 682 712 646 686 909 469 566 488 688 675 303 381 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
d-3. What is the trend equation based on the regression analysis? (Round your answers to 2 decimal places.) Sales = time period.
f. Predict sales for the next three periods. (Round your answers to 2 decimal places.) Predicted sales Sales (19) Sales (20) Sales (21)