Question

In: Math

Here are quarterly data for the past two years, from these data, prepare a forecast for...

Here are quarterly data for the past two years, from these data, prepare a forecast for the upcoming year using decompostion. foreccast years 9 to 12. FORECAST ERROR?

Period Actual period Actual
1 300 5 416
2 540 6 760
3 885 7 1191
4 580 8 760

Solutions

Expert Solution

By running regression of the form Y = a+bX

Where Y is actual and X is period, we get results of the form,

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.61
R Square 0.37
Adjusted R Square 0.27
Standard Error 241.49
Observations 8
ANOVA
df SS MS F Significance F
Regression 1         2,09,738.67      2,09,738.67                     3.60                      0.11
Residual 6         3,49,895.33          58,315.89
Total 7         5,59,634.00
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 361.00 188.17 1.92 0.10 -99.42 821.42
Period 70.67 37.26 1.90 0.11 -20.51 161.84
Period Actual
1 300
2 540
3 885
4 580
5 416
6 760
7 1191
8 760
9 997
10 1068
11 1138

Forecasts,

Period 9 = 361+70.67*9 = 997.03

Period 10 = 361+70.67*10 = 1067.7

Period 11 = 361+70.67*11 = 1138..37


Related Solutions

3.       Here are quarterly data for the past two years. From these data, prepare a forecast...
3.       Here are quarterly data for the past two years. From these data, prepare a forecast for the upcoming year using linear regression. Period Actual 1.00 300.00 2.00 540.00 3.00 885.00 4.00 580.00 5.00 416.00 6.00 760.00 7.00 1191.00 8.00 760.00 What are the forecasts for periods 9, 10, 11, and 12?
Suppose that the following are the quarterly sales data for the past 7 years. 1.Construct a...
Suppose that the following are the quarterly sales data for the past 7 years. 1.Construct a time series plot and develop linear trend equation using the original data (with seasonal components). 2.Calculate 4-quarter moving average values for this time series (column E). 3.Calculate centered moving average values and seasonal indexes (column F and G). 4.Calculate seasonal indexes (column J) for the four quarters. 5.Copy seasonal indexes (column J) to column O, and calculate deseasonalized number sold (column P). 6.Construct a...
The quarterly sales data (number of book sold) for Christian book over the past three years...
The quarterly sales data (number of book sold) for Christian book over the past three years in California follow:     Year 1               Year 2               Year 3   1690              1800                  1850   940                 900                   1100   2625              2900                  2930   2500             2360                   2615 1. Construct a time series plot. What type of pattern exists in the data? This was not shown in the WebEx example I provided. But you can simply create this graph in Excel (Go to INSERT and look for charts under INSERT...
2. Recent data from graduates of KU School of Medicine in the past two years found...
2. Recent data from graduates of KU School of Medicine in the past two years found that the mean starting salary for the 104 female physicians in their sample was $224,426.12 with a standard deviation of $27,792.73. For the 90 male physicians, the mean starting salary was $235,044.12 with a standard deviation of $33,509.25. a) Is this sufficient evidence at alpha=.01 that among graduates of KU School of Medicine in the past two years the mean starting salary for men...
Peagram Mine's 1st quarterly dividend is expected to be two years from today with an expected...
Peagram Mine's 1st quarterly dividend is expected to be two years from today with an expected amount of $1.50 per share. Each subsequent quarterly dividend is expected to grow by 4 percent. Following the quarterly dividend eight years from now, the quarterly dividends are expected to grow by 2 percent each quarter. Given the risk associated with Peagram's stock, the required expected return is 18 percent per year (effective).   What is the price of one share of Peagram's stock?
The quarterly sales (number of books sold) over the past 3 years are as shown below....
The quarterly sales (number of books sold) over the past 3 years are as shown below. Year Quarter Period Sales 1 1 1 1700 1 2 2 1000 1 3 3 2700 1 4 4 2500 2 1 5 1800 2 2 6 900 2 3 7 2900 2 4 8 2400 3 1 9 1800 3 2 10 1100 3 3 11 2900 3 4 12 2600 Construct a time series plot for this data. Paste the time series...
The quarterly sales data (number of copies sold) for a college textbook over the past three...
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow: Year Quarter Sales 1 1 1690 2 940 3 2625 4 2500 2 1 1800 2 900 3 2900 4 2360 3 1 1850 2 1100 3 4 2930 2615 a. Construct a time series plot. What type of pattern exists in the data?   b. Show the four‐quarter and centered moving average values for this time series. c. Compute the seasonal and...
The quarterly sales data (number of copies sold) for a college textbook over the past three...
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Quarter Year 1 Year 2 Year 3 1 1690 1800 1850 2 940 900 1100 3 2625 2900 2930 4 2500 2360 2615 a. Construct a time series plot. What type of pattern exists in the data? b. Show the four-quarter and centered moving average values for this time series. c. Compute the seasonal and adjusted seasonal indexes for the four quarters....
The quarterly sales data (number of copies sold) for a college textbook over the past three...
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Click on the datafile logo to reference the data. quarter year 1 year 2 year 3   1 1690 1800 1850 2 940 900 1100 3 2625 2900 2930 4 2500    2360    2615 e. Deseasonalize the time series (to 3 decimals). Year Quarter Deseasonalized Value 1 1 2 3 4 2 1 2 3 4 3 1 2 3 4 f....
The Millard Division's operating data for the past two years are provided below: Year 1 Year...
The Millard Division's operating data for the past two years are provided below: Year 1 Year 2 Return on investment 10 % 24 % Net operating income ? $ 380,000 Turnover ? 4 Margin ? ? Sales $ 3,210,000 ? Millard Division's margin in Year 2 was 120% of the margin in Year 1. The net operating income for Year 1 was: Garrison 16e Rechecks 2017-10-31 Multiple Choice $385,200 $160,500 $192,600 $190,000 Last year a company had sales of $370,000,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT