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?

Reviews

Write a Review

Finance Basics Questions & Answers

  Cost plus imports is a west coast chain specializing

Advise Cost Plus Imports on how it can protect itself against currency risk.

  Compute expected value of unit sales

Myers Business Systems is estimating the introduction of a new product. The possible levels of unit sales and probabilities of their occurrence are listed below:

  What premium rate would you gain on this store

Assume somebody offers you the accompanying money related contract. On the off chance that you store Rs.100,000 with him he guarantees to pay Rs.50,000 every year for a long time. What premium rate would you gain on this store?

  Required rate of return using the capm

Given a risk-free rate of return of 4 percent, a beta of 1.10, and a return on the market portfolio of 13 percent, what is the required rate of return using the CAPM?

  A calculator with a linear regression function

b. Determine the arithmetic average rates of return for Stock X and the NYSE over the period given. Calculate the standard deviations of returns for both Stock X and the NYSE.

  Calculate the effective cost of both proposals

Calculate the effective cost of both proposals, and indicate which proposal should be accepted.

  Compute the current price of common stock

The last dividend paid by xyz company was 1. XYZ growth rate is expected to be a constant 5 percent. XYZ's required rate of return on equity is 10%.

  Describe the basic additional funds needed (afn) equation

Describe the basic additional funds needed (AFN) equation.

  Compute the cost of common equity using the capm model

Compute the cost of common equity using the CAPM model. For beta, use the average beta of three selected competitors. You may obtain the betas from Yahoo Finance. Assume the risk free rate to be 3% and the market risk premium to be 4%.

  Should your company purchase the dump truck

The operator costs $22.00 per hour. Using 1,000 billable hours per year determine the net present value for the purchase of the dump truck using a MARR of 18%. Should your company purchase the dump truck?

  Recommend working capital strategies capital structures

prepare a two-page paper in which you present a comprehensive financial analysis of the selected organization .in your

  Dell computers has an outstanding matter of bond

Dell Computers has an outstanding matter of bond with a par value of $1,000, paying 8 percent coupon rate. The bond has 10 yrs to maturity.

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