Explore BrainMass

Use of regression analysis to estimate demand

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

A multiple regression analysis based on a data set that consists of 30 observations yielded the following estimated demand equation:

Q = 120 - 1.1P + 0.04 I + 0.90 A

Where P is price, I is income, and A is advertising. If price is equal to $1,000, income is equal to $20,000, and advertising expenditures are equal to $500, the what is the predicted quantity demanded? hide problem

© BrainMass Inc. brainmass.com October 25, 2018, 2:41 am ad1c9bdddf

Solution Summary

Use of multiple regression analysis to estimate demand

See Also This Related BrainMass Solution

Forecasting using Regression Analysis

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.

View Full Posting Details