Plot the original series, and each of the forecasts

Assignment Help Finance Basics
Reference no: EM131318401

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: EM131318401

Questions Cloud

How long are the project and feeder buffers : What is the duration of the project? How much slack is currently available in the non-critical path? How long are the project and feeder buffers?
Design the logical structure of a database : Design the logical structure of a database using Entity-Relationship diagram - Apply normalization techniques to reduce redundancy in a database.
Which firm is firm a also comment on your reasons : Which firm is Firm A? Comment on your reasons.- Which firm is Firm B? Comment on your reasons.- Which firm is Firm C? Comment on your reasons.
Nww marginal tax rate : A call premium of 14% would be required to retire the old bonds, and flotation costs on the new issue would amount to $3 million. NWW's marginal tax rate is 40%. The new bonds would be issued when the old bonds are called.
Plot the original series, and each of the forecasts : Create a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and a linear trend forecast for your data.
Level of the firms current liabilities : Company A has inventory equal to $100,000 with a current ratio of 2.3 and quick ratio of 1.8, what is the level of the firms current liabilities?
Differing responsibilities of federal and state law agencies : Prepare a 3 page paper which details the differing responsibilities of both federal and state law enforcement agencies seeking to ensure border safety
Why is a business review so important : What is a hyptohesis?Why is a business review so important?
Value of the starz stock : STARZ INC pays a constant dividend of $16 for next 18 years then will stop paying dividends forever. If investors require a return of 8.3% on this stock, what is the value of the STARZ stock? Write in the value with two decimal points but no dolla..

Reviews

Write a Review

Finance Basics Questions & Answers

  What is meant by corporate governance

Discusses what is meant by Corporate Governance in relation to how businesses align their values and behaviours with the expectations and needs of their stakeholders.

  Bond interest payments before and after taxes

Bond interest payments before and after taxes Charter Corp. has issued 2 ,500 debentures with a total principal value of $2,500,000. The bonds have a coupon interest rate of 7%. a. What dollar amount of interest per bond can an investor expect to..

  what does discounted payback period measure

If payback period measures the expected number of years required to recover the original investment, what does discounted payback period measure? Please define below.

  Operations of insurance companies

Analyse the operations of insurance companies and describe how their profitability has been affected by the prevailing economic environment. How are insurance companies responding to these challenges? (Maximum of 750 words)

  Bills bakery consists of a fire and bill loses some of his

bills bakery has a fire and bill loses some of his cost data. the bits of paper that he recovers after the fire provide

  Youre prepared to make monthly payments of 225 beginning at

youre prepared to make monthly payments of 225 beginning at the end of this month into an account that pays 10 percent

  What are the direct and indirect costs of bankruptcy

What are the direct and indirect costs of bankruptcy

  Rutledge inc has invested 100000 in a project that will

rutledge inc. has invested 100000 in a project that will produce cash flows of 45000 37000 and 42950 over the next

  World dominant economic power

After World War II, the United States was the world's dominant economic power. We're still the largest economy, but the rest of the world has caught up significantly. In some areas we've lost the lead.

  Find pv of bonds and which bond has the most volatile price

Calculate PV of Bonds with $100,000 par value. Bond 1: Term 1 yr coupon rate 2% market rate 2%. Bond 2: Term 10 yr coupon rate 2% market rate 2%. Bond 3: Term 1 yr coupon rate 10% market rate 10%. Which bond has the most volatile price and why?

  Determine the range of values of the probability that sael

buyu manufacturing has been contracted to provide sael electronics with printed circuit and motherboards pc boards

  What is s

What is σ, the standard deviation of the net cash flows?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd