Purchase Solution

Forecasting using Regression Analysis

Not what you're looking for?

Ask Custom Question

Demand for stereo headphones and CD players for joggers has caused Nina Industries to experience growth of almost 50% over the past year. The number of joggers is continuing to expand, so Nina expects demand for headsets to also expand. Demands for the stereo headsets for last year was as follows:

January 4,200
February 4,300
March 4,000
April 4,400
May 5,000
June 4,700
July 5,300
August 4,900
September 5,400
October 5,700
November 6,300
December 6,000

A. Using least squares regression analysis, what would you estimate demand to be for each month next year?
B. To be reasonably confident of meeting demand, Nina decides to use three standard errors of estimate for safety. How many additional units should be held to meet this level of confidence?

This problem has to be completed in Excel.

Purchase this Solution

Solution Summary

Least squares regression analysis, is used to estimate demand for each month next year. The problem is solved in Excel.

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.

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.

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.