Prepare a forecast using linear regression

Assignment Help Operation Management

Reference no: EM131858483

Consider the demand for trading cards listed below.

Month Demand

Jan. 55,000

Feb. 49,000

March 59,000

April 68,000

May 76,000

June 69,000

July 82,000

Aug. 94,000

Sep. 101,000

Use Excel to prepare a forecast for October, November, and December using linear regression. Print out the sheet of results, as well as a sheet containing the formulas that you used (<CTRL> ` can be used to toggle between displaying values and displaying formulas; or you can click on Formulas-->Formula Auditing-->Show Formulas.)

Reference no: EM131858483

Questions Cloud

What is the ratio of men with prostate cancer in auckland : Assignment: Introduction of Epidemiology. What is the ratio of men with prostate cancer in Auckland relative to Wellington?

What is the maximum data rate per connection : In a network whose max segment is 128 bytes, max segment lifetime is 30 sec, and has 8-bit sequence numbers, what is the maximum data rate per connection

What issue or problem would you like to write about : Think of a specific problem or issue that you are interested in researching and writing an essay about.

Compute an optimal solution to your standard form : Apply simplex algorithm to compute an optimal solution to your standard form starting with all slacks basic.

Prepare a forecast using linear regression : Use Excel to prepare a forecast for October, November, and December using linear regression. Print out the sheet of results, as well as a sheet containing.

Research and discuss the basic theories of motivation : Research and discuss the basic theories of motivation as well as a description of what they are.

Compute a multicast spanning tree for router : Compute a multicast spanning tree for router C in the following network for a group with members at routers A, B, C, D, E, F, I, and K

Beccaria on law and the criminal justice systema : What was the significance of the study by Beccaria on law and the criminal justice system?

Emergency management response : What is the involvement of politics in emergency management response? Does the EOC need to take politics into consideration?

User Account

All Pages