Question

In: Statistics and Probability

What is the forecast and MSE using regression? 2019 is the holdout sample and "car sales"...

What is the forecast and MSE using regression? 2019 is the holdout sample and "car sales" is the independent variable.

Shipments Car Sales Fasteners
Jan-17 17680000 335798
Feb-17 17650000 297853
Mar-17 17130000 318399
Apr-17 17230000 311730
May-17 17200000 363876
Jun-17 17200000 296832
Jul-17 17180000 297513
Aug-17 17020000 321144
Sep-17 18380000 317677
Oct-17 18200000 325487
Nov-17 17860000 272937
Dec-17 17700000 276282
Jan-18 17550000 335439
Feb-18 17560000 310514
Mar-18 17690000 407754
Apr-18 17770000 356169
May-18 17780000 345322
Jun-18 17700000 331997
Jul-18 17380000 343059
Aug-18 17360000 350277
Sep-18 17840000 265205
Oct-18 18000000 389332
Nov-18 17880000 310474
Dec-18 17890000 308429
Jan-19 17240000 385807
Feb-19 17030000 332529
Mar-19 17770000 407606
Apr-19 17050000 361946
May-19 17930000 453432
Jun-19 17710000 412892
Jul-19 17440000 447359
Aug-19 17510000 363769
Sep-19 17720000 361232
Oct-19 17050000 451421
Nov-19 17450000 363724
Dec-19 17160000 331619

Solutions

Expert Solution

Holdout data is a data which doesnot include in actual data to find regression

Fasteners = Dependent

Car Sales = Independent

Excel > Data > Data Analysis > Regression

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.010917236
R Square 0.000119186
Adjusted R Square -0.045329942
Standard Error 35060.75612
Observations 24
ANOVA
df SS MS F Significance F
Regression 1 3223609.046 3223609.046 0.002622405 0.959620764
Residual 22 27043645639 1229256620
Total 23 27046869248
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 305683.6791 368727.7498 0.829022712 0.415996031 -459010.8707 1070378.229 -459010.8707 1070378.229
Car Sales(X) 0.001071567 0.020925192 0.051209426 0.959620764 -0.042324625 0.044467759 -0.042324625 0.044467759

Fasteners(Y) = 305683.6791 + 0.0011 * Car Sales(X)

MSE = 1229256620


Related Solutions

What is the forecast and MSE using Additive Seasonal Forecasting? 2019 is the holdout sample. Shipments...
What is the forecast and MSE using Additive Seasonal Forecasting? 2019 is the holdout sample. Shipments Fasteners Jan-17 335798 Feb-17 297853 Mar-17 318399 Apr-17 311730 May-17 363876 Jun-17 296832 Jul-17 297513 Aug-17 321144 Sep-17 317677 Oct-17 325487 Nov-17 272937 Dec-17 276282 Jan-18 335439 Feb-18 310514 Mar-18 407754 Apr-18 356169 May-18 345322 Jun-18 331997 Jul-18 343059 Aug-18 350277 Sep-18 265205 Oct-18 389332 Nov-18 310474 Dec-18 308429 Jan-19 385807 Feb-19 332529 Mar-19 407606 Apr-19 361946 May-19 453432 Jun-19 412892 Jul-19 447359 Aug-19...
(a) Develop a five month average forecast. Compute MSE and a forecast for month 13.
Consider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 90 89 86 91 90 91 88 86 91 93 90 88   (a) Develop a five month average forecast. Compute MSE and a forecast for month 13. (b) Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for month 13. ( c) Compare the result for the five month...
Predict and forecast what will happen in years to come using the regression method. This method...
Predict and forecast what will happen in years to come using the regression method. This method will help prove if crime rates have gone up or down given the correlation to education and gdp growth. We are trying to prove if crime has gone down as it relates to education and gdp growth. Test against levels of Education & GDP growth rates. Please provide the regression equation as it pertains to the data below. See Data Table Below: Year Population...
How can marketing managers use regression model to forecast sales?
How can marketing managers use regression model to forecast sales?
Here is a forecast of sales by National Bromide for the first 4 months of 2019...
Here is a forecast of sales by National Bromide for the first 4 months of 2019 (figures in thousands of dollars): Month: 1 2 3 4 Cash sales 25 34 28 24 Sales on credit 150 170 140 120 On average, 50% of credit sales are paid for in the current month, 30% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? (Enter your answers in...
Here is a forecast of sales by National Bromide for the first 4 months of 2019...
Here is a forecast of sales by National Bromide for the first 4 months of 2019 (figures in thousands of dollars): Month: 1 2 3 4 Cash sales 24 33 27 23 Sales on credit 145 165 135 115 On average, 60% of credit sales are paid for in the current month, 20% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? (Enter your answers in...
(a) Compute MSE using the most recent value as the forecast for the next period. If required, round your answer to one decimal place.
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 13 21 13 20 24 16 (a) Compute MSE using the most recent value as the forecast for the next period. If required, round your answer to one decimal place. What is the forecast for month 8? If required, round your answer to one decimal place. Do not round intermediate calculation. (b) Compute MSE using the average of all the data available as the...
Develop a three-week moving average for this time series. Compute MSE and a forecast for week...
Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. Week Time SeriesValue Forecast 1 18   2 13   3 16   4 11   5 17   6 14   MSE :The forecast for week 7 :Use = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places....
Compute the mean square error using equation s2 = MSE =
Consider the data. xi 1 2 3 4 5 yi 4 8 6 12 14 (a) Compute the mean square error using equation  s2 = MSE = SSE n − 2  . (Round your answer to two decimal places.) (b) Compute the standard error of the estimate using equation s = MSE = SSE n − 2  . (Round your answer to three decimal places.) (c) Compute the estimated standard deviation of b1 using equation sb1 = s Σ(xi −...
(a) Compute the mean square error using equation s2 = MSE =
Consider the data. xi 1 2 3 4 5 yi 4 6 5 12 13 (a) Compute the mean square error using equation s2 = MSE = SSE n − 2  . (Round your answer to two decimal places.) (b) Compute the standard error of the estimate using equation s =MSE= SSE n − 2 =  . (Round your answer to three decimal places.) (c) Compute the estimated standard deviation of b1 using equation sb1 = s Σ(xi − x)2...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT