Develop a three-week moving average for the time series

Assignment Help Operation Management

Reference no: EM13918479

Consider the following time series data:

Week	1	2	3	4	5	6
Value	18	13	16	11	17	14

a. Construct a time series plot. What type of pattern exists in the data?

b. Develop a three-week moving average for this time series. Compute MSE and a fore- cast for week 7.

c. Use a = 0.2 to compute the exponential smoothing values for the time series. Com- pute MSE and a forecast for week 7.

d. Compare the three-week moving average forecast with the exponential smoothing forecast using a = 0.2. Which appears to provide the better forecast based on MSE? Explain.

e. Use Excel Solver or LINGO to find the value of a that minimizes MSE. (Hint: Mini- mize the sum of squared error.)

Reference no: EM13918479

Questions Cloud

Application of an anthropological perspective : The education system in America has taken a turn for the worst in most cases. The emphasis on the value of education itself has somehow taken a back seat to fame and fortune of an educated or uneducated person.

What is its required return : You have a portfolio with a beta of 1.35. What will be the new portfolio beta if you keep 85 percent of your money in the old portfolio and 15 percent in a stock with a beta of 0.78? Paccar’s current stock price is $48.20 and it is likely to pay a $0..

Cultural universals effect on humanism : When we identify the cultural universals of the people that have a greater impact on our existence it gives us an understanding and a greater appreciation for the value of our being.

Explain how the literature review will be organized : Discuss the current status of the topic. Organize this section according to the previously mentioned themes or something similar. Discuss relationships that may exist in the literature.

Develop a three-week moving average for the time series : Develop a three-week moving average for this time series. Compute MSE and a fore- cast for week 7. Use a = 0.2 to compute the exponential smoothing values for the time series. Com- pute MSE and a forecast for week 7.

How long will it take for the account to be paid off : One of your customers is delinquent on his accounts payable balance. You’ve mutually agreed to a repayment schedule of $500 per month. You will charge 1.45 percent per month interest on the overdue balance. If the current balance is $13,500, how long..

Partner in the partnership a disregarded entity : At any time during the tax year, was any partner in the partnership a disregarded entity, a partnership (including an entity treated as a partnership), a trust, an S corporation, an estate (other than an estate of a deceased partner), or a nominee or..

Proposal to research as a cultural anthropologist : I would propose that research is done on success, and how to enhance the educational experience that would help develop a well rounded individual to succeed in any culture of choice.

Theory of historical particularism : 1. One of the shortcomings of the theory of historical particularism is: 2. Because most known societies prohibit incest, it can be considered:

User Account

All Pages