Purchase Solution

Weighted Moving Average Using Multiple Regression

Not what you're looking for?

Ask Custom Question

1. Use Data Analysis from the attached excel file to create a multiple regression equation where the forecast for the next year is a function of the attendance in each of the previous 2 years.
That is: F(t)=a + b1*D(t-1)+b2*D(t-2)

Where:

F is the forecast for period t
a is the intercept
bj is the regression coefficient for one period ago
D(t-j) is the attendance j periods ago for

I am requesting an explanation of why we need 2 variables for this equation and why I cannot run the regression with the current data set.

Thank you!

Attachments
Purchase this Solution
Solution Summary

The expert examines the weighted moving average using multiple regression analysis.

Solution Preview

Hi there,

Thanks for selecting me as your expert. I've included ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

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

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

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.

View More Free Quizzes
Related BrainMass Solutions

  • Solve forecasting questions using naive, moving average

    d) Use three week weighted moving average with weights of 0.2, 0.3 and 0.5, compute the accuracy measures and what is the forecast for week 9? From excel, forecasr for week 9 is 22.3 using weighted moving average.

  • Analysis on 4 forecasting models using Excel

    • 3-Month Moving Average Model • 3-Month Weighted Moving Average Model • Exponential Smoothing Model • Regression Model 2.

  • Linear regression, multiple regression, time series

    D A TMA B CMA C Exponential smoothing D Deseasonalization Answer: Deseasonalization "TMA:Triangular Moving Average : The Triangular Moving Average is a form of Weighted Moving Average wherein the weights are assigned in a triangular

  • Forecasting for Palmdale Human Service Agency

    For time series regression, use the data for all four fiscal years. Which forecast will you use? Why? I have completed the simple moving average, weighted moving average, exponential smoothing. I need help with is Time Series Regression.

  • Time Series Forecasting Models

    First, use these data to develop forecasts for the years 6 through 13 using a 5-year moving average. Then, use these data to develop forecasts for the years 6 through 13 using a 5-year weighted moving average.

  • Forecasting: weighted moving average

    Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast. b. Using a simple three-month moving average, find the July forecast. c.

  • Time Series

    a) Weighted moving average b) Exponential smoothing c) Adjusted exponential smoothing d) Moving average 28.

  • Chapter 13 -Problem 17 Operations Management for Competitive

    From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate? Why? b.

  • Mean Absolute Deviation

    These include: 1)Simple Moving Average 2)Weighted Moving Average 3)Exponential Smoothing 4)Linear Regression 5)Seasonal Forecasting via Regression (i.e., linear trends with multiplicative seasonality or nonlinear trends with multiplicative

View More Related Solutions