Purchase Solution

Multiple Regression & Time Series Forecasting

Not what you're looking for?

Ask Custom Question

The CEO noticed that he has five years of quarterly sales data in hand, and they form a time series. He decided to also ask you to perform time-series analysis on it, and use it to forecast what future sales are expected to be at the end of 1Q 2009.

1. Plot the quarterly sales as a function of time in your Excel data spreadsheet. From the shape of these graphs, and any analysis that you think is needed, determine what type of trend model is best suitable for this data. Write down the equation for the trend model, and define and explain each of the variables as it applies to this problem.

2. Do a regression analysis on the data for the trend model you decided on in Question 1, and determine the parameters for the model.

3. Answer the CEOââ?¬â?¢s question. Tell him how much sales are expected to be at the end of 1Q 2009. Be careful, and also include the 95% confidence interval for this number.

Attachments
Purchase this Solution
Solution Summary

Step by step method for regression analysis and time series are discussed here. Regression coefficients, coefficient of determination, scatter diagram and significance of regression model are explained in the solution.

Purchase this Solution
Free BrainMass Quizzes
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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Multiple Choice Questions : Time Series Analysis

    115615 Multiple choice question from time series analysis 1. Time series methods a. discover a pattern in historical data and project it into the future. b. include cause-effect relationships.

  • Time Series Analysis: MCQs & Short Problems

    Question 10 Which of the following time-series forecasting methods would not be used to forecast a time series that exhibits a linear trend with no seasonal or cyclical patterns?

  • Correlation and Regression Analysis and Descriptive Models

    Predictive models are used more for forecasting future purposes 3. How can multiple regression and time-series data be employed in financial forecasting by a company?

  • Regression Equations of Real World Value

    Overall, our multiple regression appears to be a better tool for accurate forecasting than the simple regression. Time Series Analysis All business data are either cross section data or time series data.

  • How to Perform Multiple Regression with Excel and Megastat

    This solution provides a step-by-step "how to" on doing multiple regression, forecasting, and time series seasonal smoothing by moving average using Excel and the Megastat add-in.

  • Multiple choice questions

    Time series methods are the most common type of forecasting method for the long-term strategic planning process. F 3.

  • Forecasting methods (e.g., seasonal, Delphi, technological)

    50905 Forecasting methods Explain how Charter Communications, a broadband company, uses one or more forecasting methods (e.g., seasonal, Delphi, technological, time series), to forecast demand under conditions of uncertainty.

  • Appropriate quantitative forecasting methods

    TIME SERIES FORECASTING METHODS Time series forecasting methods are based on analysis of historical data (time series: a set of observations measured at successive times or over successive periods).

  • Time Series

    334996 Time Series Forecasting methods Which of the following time series forecasting methods would not be used to forecast seasonal data?

View More Related Solutions