Purchase Solution

Question about Moving average calculation

Not what you're looking for?

Ask Custom Question

A computer software company wants to use 5-period moving averages to forecast the number of users who download its anti-virus software. The numbers of users (in thousands) for the 14 most recent periods are shown in the middle column of the table below. Also shown is a time series plot of the data.
In the far-right column of the table are the 5 -period moving averages for the data. Fill in both blanks in this column. Round your responses to at least two decimal places.

Period/User in thousands/5 period moving average.
1 191.4 NA
2 191.9 NA
3 192.4 192.74
4 189.8 194.20
5 198.2 195.93
6 198.7
7 200.5 199.36
8 202.4
9 197 200
10 199.8 200.94
11 200.3 201.88
12 205.2 202.64
13 207.1 NA
14 200.8 NA

Purchase this Solution
Solution Summary

The solution provides step by step method for the calculation of 5 point moving average . Formula for the calculation and Interpretations of the results are also included.

Solution Preview

Solution is attached.
Question #11 / 11
A computer software company wants to use 5-period moving averages to forecast the number of users who download its anti-virus software. The numbers of users (in thousands) for the 14 most recent periods are ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Time Series Forecasting Models

    Question 1 MAD MSE Question 2 a) Moving average forecast for year 13 b) Weighted moving average forecast for year 13 c) MAD for part a d) MAD for part b e) Recommended forecast method (justify): Question 3 R-squared for Linear

  • Moving average

    of moving average .

  • Forecasting Methods:Moving Average and Exponential Smoothing

    Hello Student, For question 1, you have been asked to calculate the sales for 2006 using the moving average method.

  • Time series analysis : Seasonal index

    229208 Ratio to Moving Average Method Ratio to moving average method An analyst wants to use the ratio-to-moving average method to forecast a company's sales for the next few quarters.

  • Ratio to Moving Average Method

    keywords: averages, moving-average Please see the attached file for the complete solution. Thanks for using BrainMass. The solution provides step by step method for the calculation of seasonal index using ratio to moving average method.

  • Moving average in Mega Stat

    [Use Megastat or MS Excel, TOOLS, DATA ANALYSIS, MOVING AVERAGE function to determine the moving average and to chart the series. Center the moving average series to the original series.

  • Forecast for demand based on moving average

    Answer 33.2 The solution provides step by step method for the calculation of Forecast for demand based on moving average. . Formula for the calculation and Interpretations of the results are also included.

  • Least Square, Moving Average, or Weighted Moving Average

    189572 Least Square, Moving Average, or Weighted Moving Average Choose either the Least Squares Method, the Moving Average Method, or the Weighted Moving Average and provide step-by-step instructions you would use to plot the associated trend line.

  • Time Series Forecasting

    See Excel sheet for calculation. This solution looks at the moving average and mean square error of a time series.

View More Related Solutions