Compute three-week weighted moving average for time series

Assignment Help Financial Management

Reference no: EM13804338

Refer again to the gasoline sales time series data in Table 6.1.

Month 1 2 3 4 5 6 7

Value 24 13 20 12 19 23 15

a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent, and 1/6 for third most recent, compute a three-week weighted moving average for the time series.

b. Compute the MSE for the weighted moving average in part (a). Do you prefer this weighted moving average to the unweighted moving average? Remember that the MSE for the unweighted moving average is 10.22.

c. Suppose you are allowed to choose any weights as long as they sum to 1. Could you always find a set of weights that would make the MSE smaller for a weighted moving average than for an unweighted moving average? Why or why not?

Reference no: EM13804338

Questions Cloud

Drawback of switching from a partnership to the corporate : One drawback of switching from a partnership to the corporate form of organization is the following:

Net present value is generally considered to be best method : Given that the net present value (NPV) is generally considered to be the best method of analysis, why could you still use the other methods? You need to use other methods because the net present value method is unreliable when a project has unconvent..

Selling corporation had earnings before interest and taxes : Last year the selling corporation had earnings before interest and taxes (operating income) equal to $1 million. it paid $200,000 in dividends to its stockholders and $100,000 in interest to its creditors. During the year, the company also repaid a b..

Forecast the percentage of administrative expenses : The Seneca Children’s Fund (SCF) is a local charity that runs a summer camp for disadvantaged children. The fund’s board of directors has been working very hard over recent years to decrease the amount of overhead expenses, a major factor in how char..

Compute three-week weighted moving average for time series : Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent, and 1/6 for third most recent, compute a three-week weighted moving average for the time series. Compute the MSE for the weighted moving average in part (a). Do yo..

Describe cyclical variations and seasonal variations : We’ve already discussed seasonal variations and how they result from the predictable shopping habits of consumers. Describe cyclical variations. How do they compare to seasonal variations?

How much did he invest in each account : Paul invests $15,250 in two different accounts. One pays an interest rate of 8.5% while the other account pays 10%. If he gains a total of $1411.75 annually, how much did he invest in each account?

What is economic profit and accounting profit : What is economic profit and accounting profit with the information given?

The average annual salary for a person living : In 2005, the average annual salary for a person living in the Washington,D.C. Area was about 1.16 times the average annual salary for a person living in Hartford, Connecticut. If the average annual salary in Hartford was $42,706, what was the average..

User Account

All Pages