Least squares regression analysis

Reference no: EM1396562

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.

Reference no: EM1396562

Questions Cloud

Random selection book from used-book sale : At a used-book sale, 100 books are adult books and 160 are children's books. Of the adult books, 70 are nonfiction while 60 of the children's books are nonfiction. If a book is selected at random, find the probability that is is:

Creating a dichotomous key from the bacteria : Create a Dichotomous Key using the following Bacteria. You are only allowed to use the characteristics listed in organizing your Dichotomous Key.

What are some advantages of being part of a food web : Provide an example of a food chain in the area where you live in Seattle Washington Humans are parts of food chains and food webs, too.

Explain which structure failed to cure unlevel ills : Illustrate what was unlevel trying to do when it introduced a new structure based on business groups in the mid 1990s? Explain why you think which this structure failed to cure unlevel ills?

Least squares regression analysis : Using least squares regression analysis, what would you estimate demand to be for each month next year?

Create climate plan for communication with staff and family : Collaborative-Communication Climate plan. Create the climate plan which have processes for communication with staff and families that help in building trust in school community.

Express contract for the construction of a warehouse : Diaz also Cuzco enter an express contract for the construction of a warehouse. Express contract terms are given, in relation to the parties' course of performance?

Determine whether a response is specific : Why is important to use varying concentrations of an enzyme to demonstrate specific action of the enzyme? What three observations are needed to determine whether a response is specific.

Determine the number of atp molecules : The transfer of electrons from one molecule of NADH to H2O via the electron transfer chain results in the net movements of 8 protons from the mitochondrial matrix into the intermembrane mitochondrial space.

User Account

All Pages