Question

In: Statistics and Probability

1. Create a prediction for period 7 using the naive model. 2. Create your forecast using...

1. Create a prediction for period 7 using the naive model.

2. Create your forecast using the naive model. Calculate all the errors for each period. What is the error for period 3?

3. What is the mean sqaured error?

4. Find the root mean squared error

Solutions

Expert Solution

solution:

  

Consider data

Month 1 2 3 4 5 6
Values 24 13 21 13 20 24

--> Calculating errors using Most Recent Value (Naive method) Method

Naive Forecasting: Naive forecasting is a forecasting Technique which uses quantitative data for its data estimation.It is easy to  forecast the next month data by simply putting the previous data of last month to next month.

Using naive method forecast for next month is;

Month Value (A) Forecast Naive Method (N) Error (A-N) Absolute Error | (A-N) |

Squared Absolute Error |(A-N) |^2

|%Error|
1 24
2 13 24 -11 11 121 84.62%
3 21 13 8 8 64 38.10%
4 13 21 -8 8 64 61.54%
5 20 13 7 7 49 35%
6 24 20 4 4 16 16.67%
7 24 = 38 =314 =235.93%

1) Forecast for month 7 = 24

2) Error for period 3 is - 8

i) Mean Absolute Deviation

MAD = Absolute error / No.of months forecasted

= 38 / 5

= 7.6

ii)Mean Squared Error (MSE) is Squared Absolute Error divided by No.of months forecasted

MSE = |(A-N) |^2 / 5

= 314 / 5

= 62.8

iii) Mean Absolute Percentage Error

MAPE = |%Error| / No.of months forecasted

= 235.93% / 5

= 47.186%

3) MSE = 62.8

4) Root Mean Squared Error = = 7.925


Related Solutions

Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy.
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. a. Mean absolute error (to 1 decimal). b.Mean squared error (to 1 decimal). c. Mean absolute percentage error (to 2 decimals). d. What is the forecast for week 7 (to 2 decimals)?
a. Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.
Month137244335450534630750829936103511411245a.  Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.b. Compare the MFE, MSE, and MAPE on the modelsc.  Make a conclusion on which model to use.d. Find the alpha (smoothing constant) that minimizes the MSE.
Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy.
Consider the following time series data. Week 1 2 3 4 5 6 Value 20 15 18 14 18 15 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. a. Mean absolute error (to 1 decimal). _______ b.Mean squared error (to 1 decimal). _____ c. Mean absolute percentage error (to 2 decimals). _____% d. What is the forecast for week 7 (to 2 decimals)? ______
Calculate the measures of forecast error using the naive (most recent value) method and the average of historical data (to 2 decimals).
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 17 11 17 15 Calculate the measures of forecast error using the naive (most recent value) method and the average of historical data (to 2 decimals). Naive method Historical data Mean absolute error Mean squared error Mean absolute percentage error Top of Form Consider the following time series data. Month 1     2 3 4 5 6 7 Value 23 14 19 10 18 23...
1) Using a 5 period simple moving average, the forecast for period 13 will be:
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two...
Prediction: A common goal in regression is to use the estimated model for prediction. a) (1...
Prediction: A common goal in regression is to use the estimated model for prediction. a) (1 points) Using your model from 2c, provide a highway driving CO2 emissions prediction for vehicles that have a city CO2 emissions of 550. Show work by hand! You may validate with code provided in R. b) (1 point) A 2017 Ferrari California T has a city driving CO2 Emission of 550 and an observed highway driving CO2 Emission of 389. How far off is...
1. What is the main difference in prediction between the Lewis model and the Harris-Todaro model...
1. What is the main difference in prediction between the Lewis model and the Harris-Todaro model on rural to urban migration? 2. Take two countries, A and B, each has 100 mil population and in both countries 50% population is poor. Assume the poverty line is $1 per day. Below are two distributions of income in these countries. For each country, calculate the PG and APG. In which country poverty is more severe? Income: Between 0 and 25 cents Between...
1.at is the root mean square error (RMSE) for a "next period forecast" using 3-month moving...
1.at is the root mean square error (RMSE) for a "next period forecast" using 3-month moving average model for these three years of demand? Give your answer as an integer. 2.at is the root mean square error (RMSE) for a "next period forecast" using naive model for these three years of demand? Give your answer as an integer 3.What is the root mean square error (RMSE) for a "next period forecast" using cumulative model for these three years of demand?...
Problem 2 What is the main difference in prediction between the Lewis model and the Harris-Todaro...
Problem 2 What is the main difference in prediction between the Lewis model and the Harris-Todaro model on rural to urban migration? Given the validity of the Harris-Todaro model, what would you tell a government by creating government-subsidized jobs in its cities?
Most discounted cash flow valuations involve using cash flows: a. historical period, an explicit forecast period,...
Most discounted cash flow valuations involve using cash flows: a. historical period, an explicit forecast period, and a terminal value b. historical period and a terminal value c. historical period and an explicit forecast period d. explicit forecast period and a terminal value
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT