Time series model

Assignment Help Basic Statistics
Reference no: EM131476997

Time Series Model

A time series model is a forecasting technique that attempts to predict the future values of a variable by using only historical data on that one variable. Here are some examples of variables you can use to forecast. You may use a different source other than the ones listed (be sure to reference the website). There are many other variables you can use, as long as you have values that are recorded at successive intervals of time.

  • Currency price: XE
  • XE Currency Converter. (n.d.). Retrieved July 08, 2016
  • GNP: Trading Economics
  • TRADING ECONOMICS | 300.00 INDICATORS | 196 COUNTRIES. (n.d.). Retrieved July 08, 2016,
  • Average home sales: National Association of Realtors
  • Existing-Home Sales. (n.d.). Retrieved July 08, 2016.
  • College tuition: National Center for Education Statistics
  • Existing-Home Sales. (n.d.). Retrieved July 08, 2016.
  • Weather temperature or precipitation
  • Existing-Home Sales. (n.d.). Retrieved July 08, 2016.
  • Stock price: Yahoo Finance.
  • Yahoo Finance - Business Finance, Stock Market, Quotes, News. (n.d.). Retrieved July 08, 2016,

Once you have historical data, address the following:

  1. State the variable you are forecasting.
  2. Collect data for any time horizon (daily, monthly, yearly). Select at least eight data values.
  3. Use Excel QM to forecast using moving average, weighted moving average and exponential smoothing (see video in Live Binder).
  4. Copy/paste the results of each method. Be sure to state the number of periods used in the moving average method, the weights used in the weighted moving average, and the value of alpha used in exponential smoothing. Be sure to include the MAD (mean absolute deviation) for each method.
  5. Clearly state the ânext periodâ prediction for each method.

Reference no: EM131476997

Questions Cloud

Adjusting your individual development plan : Discuss the importance of monitoring and adjusting your Individual Development Plan.
Calculate the chi square value : Answer the following question using a chi square test of significance. In your answer you must do the following:
What is the npv of the purchase of the new machine : A factory is considering the purchase of a new machine for one of its units. The machine costs $100,000. The machine will be depreciated on a straight line.
Define the macrs depreciation schedule : You are considering the following investment.The discount rate is 11% and the corporate tax rate is 34%.
Time series model : A time series model is a forecasting technique that attempts to predict the future values of a variable by using only historical data on that one variable.
Search engine optimization and pay-per-click advertising : Search Engine Marketing consists of Search Engine Optimization (SEO) and Pay-Per-Click (PPC) advertising.
What was two-year holding period return on infosys share : You bought Infosys share for Rs 4,250 two years ago. You held the stock for two years, and received dividendper share of Rs 90 and Rs 125 respectively.
Make the program especially well structured and readable : Make the program especially well structured and readable. Enhance to functionality of the program in various ways, even small ways.
Prepare a document flowchart using a system tool : Assessment item - System Documentation and BI. Based on the interview below with the department supervisor, prepare a document flowchart using a system tool

Reviews

Write a Review

Basic Statistics Questions & Answers

  Is the scale of measurement nominal, ordinal, interval

Summary of the problem: Give a brief description of the variable and whether the scale of measurement is nominal, ordinal, interval, or ratio, and why. Explain what it means to say that this variable is "normally distributed." Then, define probabi..

  Find the lowest income among the richest persons

Normally distributed with mean equal to 15,000 and standard deviation equal to 1000. What is the lowest income among the richest 250 persons?

  Question regarding algebra-polynomials

If a manufacturer charges 'p' dollars each for shirts, then he expects to sell 2000-100p shirts per week. What polynomial represents the total revenue expected for a week?

  Mean and standard deviation of distribution

Census data below show that 8% of students in a certain country went to college or a trade school within a year of graduating from high school. A random sample of 715 high school graduates is selected. Use the normal approximation to the binomial ..

  Suggest true mean spending on internet advertising increased

Suppose the mean spending on Internet advertising for these companies the previous year was $55.5 million. Is there any evidence to suggest the true mean spending on Internet advertising has increased? Use a = 0.05.

  Calculates the unbiased estimate of the population

1. The counselor calculates the unbiased estimate of the population's variance to be 15. What is the variance of the distribution of means?

  Confidence interval for difference of population means

For a study conducted by the research department of a pharmaceutical company, 295 randomly selected individuals were asked to report the amount of money they spend annually on prescription allergy relief medication. The sample mean was found to be..

  The mating preferences were measured in nine different

the mating habits of three- spined stickleback a fish have been studied intensively. one experiment examined whether

  A crossover trial is planned to evaluate the impact of an

A crossover trial is planned to evaluate the impact of an educational intervention program to reduce alcohol consumption in patients determined to be at risk for alcohol problems

  Here are the golf scores of 12 members of a college womens

here are the golf scores of 12 members of a college womens golf team in two rounds of tournament play. a golf score is

  Assume that aces are assigned a value to maximize the value

in the game of blackjack a player receives two cards. the value of each card is equal to its numerical value or 10 if

  Determined for a hypothesis test

Explain how the rejection region is determined for a hypothesis test. How does it differ between one- and two-tailed tests?

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