After setting up the Analysis ToolPak, complete the following activity.
This is just to test that your plug-in is working.
Go to Data > Data Analysis
In the "Input Y Range" box, click and drag over the 5 numbers in the "Y Values" colum
Don Levine Corporation is considering adding an additional plant to its three existing facilities in Decatur,
Minneapolis, and Carbondale. Both St. Louis and East St. Louis are being considered. On this sheet, you will
evaluate St. Louis. Use Solver to de
You will submit two files for your assignment: this document, plus your regression results in Excel.
Your final answers must be given directly on this document. Do not put answers to the questions in
your Excel file.
You must per
The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The
assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air
conditioner takes 3 hours of wiring and 2 ho
1. Susan Solomon is thinking about starting her own independent gasoline station. Susan's problem is to decide
how large her station should be. After a careful analysis, Susan developed the table shown below. For example, if
Susan constructs a small stati