Use This Information to Answer the Following Questions

question 16

Essay

Use this information to answer the following questions.
The following table contains information on the cost to run four jobs (1,2,3,and 4)on four available machines (A,B,C,and D).

-Refer to the table above.Use Excel to model and solve this problem to determine the least costly job-machine assignment.

---

Definitions:

Histograms

Graphical representations of the distribution of numerical data using bars of different heights to illustrate the frequencies of different values.

Leverage

The use of borrowed funds to increase the potential return of an investment or project.

Studentized Residuals

Residuals in a statistical model that have been standardized by dividing by an estimate of their standard deviation.

Least-Squares Regression

A statistical method used to determine a line of best fit by minimizing the sum of the squares of the vertical distances of the points from the line.