Purchase Solution

Time series analysis

Not what you're looking for?

Ask Custom Question

Barbara lynch is the product manager for a line of skiwear produced by Health Co Industries and privately branded for sale under several different names .A part of Ms Lynch's is to provide a Quarterly forecast of sale for the northern United State ,a region composed of 27 states stretching from Maine to Washington. A 10 years history is shown.

Attachments
Purchase this Solution
Solution Summary

This solution gives the step by step method for analyzing time series data.

Solution Preview

Please see the attachments.

a) Time Series Plot

The time series plot of sales suggests that there is linear trend in the sales during 1994Q1 to 2003Q4. There is also some seasonal fluctuations. We can fit a trend equation and predict the value of sales.

b) Trend Equation.

The trend can be estimated by the least squares method. The general form of trend equation is Y =a+bx. Where a is known as the intercept, b is the slope. The value of slope gives the change in sales for a unit increase in the time.
The details are given below.
Trend Analysis for Sales

Fitted Trend ...

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

  • Compare and contrast forecasting methods

    Unlike most time-series forecasting techniques, the Trend Analysis does not assume the condition of equally spaced time series. Seasonal Index: Seasonality is a pattern that repeats for each period.

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

  • Time Series Forecast

    This solution is comprised of a detailed analysis of the given problem and step-by-step calculations in EXCEL and provides students with a clear perspective of the underlying concepts of Time Series Forecast Analysis.

  • Multiple Choice Questions : Time Series Analysis

    This solution provides answers to multiple choice question from time series analysis

  • Time Series and Forecasting

    Time series is one of the quantitative methods we use to determine patterns in data collected over time. Time series analysis is used to detect pattern of change in statistical information over regular intervals of time.

  • Multiple Regression & Time Series Forecasting

    446898 Multiple Regression & Time Series Forecasting The CEO noticed that he has five years of quarterly sales data in hand, and they form a time series.

  • Multiple regression and Time series analysis

    231394 Multiple Regression and Time Series Analysis Multiple Regression (a) What is a binary predictor? (b) How do we test a binary predictor for significance?

  • 3 examples of Time Series used by your organization

    Based on the previous years data, a time series analysis can be performed to predict the demand for this year so that adequate stocks can be maintained. 3.

  • Regression Analysis of Time Series Data

    228066 Regression Analysis of Time Series Data The following time series data represent the yearly amounts spent on advertising (in millions of dollars) by a large toy company: 33.3, 42.5, 44.9, 47.2, 48.7, 53.1, 46.1, 46.8, 55.2 This series of data

  • Patterns of Time Series Data

    Trend Analysis: There are no proven "automatic" techniques to identify trend components in the time series data; however, as long as the trend is monotonous (consistently increasing or decreasing) that part of data analysis is typically not very difficult

View More Related Solutions