User Account

All Pages

Determine the trend line and generate a forecast for cpi

Assignment Help Basic Statistics
Reference no: EM131338056

Linear Regression Exponential Smoothing / Linear regression

Slope =

Forecast for CPI in 2011= /

Intercept = MAPE= /

Year Period CPI Exp. Smoothing Forecast Linear Regression Forecast

2001 1 102.8

2002 2 104.5 103.48

2003 3 106.8 105.42

2004 4 109.7 107.96

2005 5 113.4 111.18

2006 6 117.1 114.88

2007 7 120.4 118.42

2008 8 125.0 122.24

2009 9 124.6 124.84

2010 10 126.6 125.4

2011 11 75.5

1) Use Exponential smotthing with alpha =0.4 to generate a forecast for CPI in the year 2011. Begin with a naive initialization.

2) Use the regression tool in Excel or the "bulit in" Excel functions to determine the trend line and generate a forecast for CPI in the year 2011.

3) For each of the two forecasting method you used, generate backcasts and compute MAPE.

Reference no: EM131338056

Questions Cloud

Ethical analysis of the issues raised in the case study : TECH7402 Professional IT Culture Individual Written Assignment. Prepare a business report of about 1500 words that gives an ethical analysis of the issues raised in the case study. In particular (at least), include in the report responses to the fo..
Discuss social or historical context in which event occurred : Discuss the social or historical context in which the event occurred. Discuss the impact that your chosen historical event has had upon our scientific understanding of an aspect of the natural world.
Organized a future search conference to address : If you organized a Future Search Conference to address the issue identified in Question 1 above, who would you include in the initial planning before the conference? Who you invite to the conference? How many people would you invite, and why? Any ..
Use as annual sales figure when evaluating this project : Winnebagel Corp. currently sells 18,000 motor homes per year at $27,000 each, and 7,200 luxury motor coaches per year at $51,000 each. An independent consultant has determined that if Winnebagel introduces the new campers, it should boost the sales o..
Determine the trend line and generate a forecast for cpi : Use the regression tool in Excel or the "bulit in" Excel functions to determine the trend line and generate a forecast for CPI in the year 2011.
What is proper cash flow amount to use as initial investment : Parker & Stone, Inc., is looking at setting up a new manufacturing plant in South Park to produce garden tools. The company bought some land 6 years ago for $5 million in anticipation of using it as a warehouse and distribution site, but the company ..
What is the velocity of the probe relative to the earth : A spacecraft that moves away from the earth with a speed of 0.800c and fires a space probe in the direction of its movement with a speed of 0.650c. What is the velocity of the probe relative to the earth?
Identify appropriate methods and measures or techniques : Identify appropriate methods, measures or techniques which you consider are necessary for the security of telepresence systems.
How many shares are outstanding and issued : The authorized share capital of the Alfred Cake Company is 100,000 shares. The equity is currently shown in the company’s books as follows: How many shares are issued? How many shares are outstanding? How many more shares can be issued without the ap..

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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