Purchase Solution

Solve: Time Series and Forecasting

Not what you're looking for?

Ask Custom Question

Question: Victor Anderson, the owner of Anderson Belts, Inc., is studying absenteeism among his employees. His workforce is small, consisting of only five employees. For the last three years he recorded the following number of employee absences, in days, for each quarter.

Quarter
________________________________________________________________________
Year I II III IV
2001 4 10 7 3
2002 5 12 9 4
2003 6 16 12 4

Determine a typical seasonal index for each of the four quarters.

Purchase this Solution
Solution Summary

This solution provides a 3-step response demonstrating how to solve for a typical seasonal index. There is also an Excel spreadsheet which accompanies the solution, presenting the response in proper format. By clicking directly onto the cells of the spreadsheet, it shows which functions are needed in order to compute the corresponding values.

Solution Preview

Data (Rearranged)
Year
Quarter 2001 2002 2003
I 4 5 6
II 10 12 16
III 7 9 12
IV 3 4 4

Step 1: Compute overall ...

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.

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.

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

  • approaches to revenue forecasting.

    452093 Public Budgeting: Compare and contrast qualitative, time series, and causal analysis approaches to revenue forecasting. Compare and contrast qualitative, time series, and causal analysis approaches to revenue forecasting.

  • Demand Management and Forecasting in Business

    Techniques of Forecasting There are different forecasting techniques such as Delphi Technique, Scenario Writing, Subjective Approach and Time-Series Forecasting.

  • Relationships between time series and forecasting

    228341 Relationships between time series and forecasting A. What exactly is the relationship between time series and forecasting? How are they connected? B. What are the limitations of forecasting? C. What is Occam's Razor?

  • Appropriate Forecasting Technique for Aldi Foods

    Combining the time-series and qualitative forecasting method with the casual forecasting method in which the use of variables with similar characteristics would serve for the best forecasting result.

  • Compare and contrast forecasting methods

    There are two basic approaches to forecasting time series: the self-projecting time series and the cause-and-effect approach.

  • 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?

  • Quantitative Forecasting Explained

    If this is a reasonable assumption, than quantitative time series forecasting is appropriate. In addition, time series data (a set of data points recorded over successive periods of time in the past) must be available.

  • Production Planning and Quality Management: Forecasting Techniques for Manychip

    Time-series forecasting assumes that a time series is a combination of a pattern and some random error.

  • Forecasting Models

    483252 Forecasting Models Explain the differences between qualitative and judgmental, statistical time-series, and explanatory / causal forecasting models.

View More Related Solutions