Calculate the mse and mad for each

Assignment Help Finance Basics

Reference no: EM131288671

a. Create a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and a linear trend forecast for your data.

b. Calculate the MSE and MAD for each.

c. Plot the original series, and each of the forecasts.

d. Create forecasts for 2014 using each of these three techniques. If you had to choose one of these, which would you choose and why?

e. Given your data, and this time period, would you prefer to try some other type of forecast, or modify the data in some way? (You must explain your answer for full credit.)

Attachment:- 1968625_1_State-QPI-2004-20132.xlsx

Reference no: EM131288671

Questions Cloud

What does the bible say about who humans are : What does Bible say about who humans are? From what you know about psychology, how does science describe a human being? Is humanistic existentialism a direct opposite of the biblical concept of the image of God in humans?

Additional tax on the transaction : Sally has taxable income of $160,000 as of November 30 of this year. She wants to sell a Rodin sculpture that has appreciated $90,000 since she purchased it six years ago, but she does not want to pay more than $15,000 of additional tax on the transa..

What type of internal controls is the report addressing : Section 404(a) of the Sarbanes-Oxley Act requires management of a public company to issue a report on internal control over financial reporting (ICOFR) as of the end of the comany's fiscal year. What type of internal controls is the report addressing..

How often have you had a positive encounter with leadership : How often have you had a positive encounter with leadership? Have you been called upon to lead? How could your experience(s) with leadership been improved? Provide specific details.

Calculate the mse and mad for each : Given your data, and this time period, would you prefer to try some other type of forecast, or modify the data in some way? (You must explain your answer for full credit.)

Depreciation-appreciation of the chinese currency : 1) If the interest rate in Renminbi is 15% and the investor has assets denominated in dollars and Renminbi in his portfolio. What is the expected depreciation/appreciation of the Chinese currency?

What is wrong with penelopey : What is wrong with Penelopey? How does it impact her school setting?How will it impact her when it comes to choosing a career? What can the school do for penelope to help her with this problem?

Construct conceptual ethic framework by objectively defining : Construct a conceptual ethics framework by objectively defining, in your own words, each of the following concepts and describe the relationship between them.

Estimate the value of twitter at the time of the ipo : Based on the information given in the case, how would you estimate the value of Twitter at the time of the IPO based on a simple average of comparable firm enterprise to EBITDA multiples based on projected 2014 EBITDA?

User Account

All Pages