Robert Hope Received a Welcome Surprise in This Management Science

question 73

Essay

Robert Hope received a welcome surprise in this management science class; the instructor has decided to let each person define the percentage contribution to their grade for each of the graded instruments used in the class. These instruments were: homework, an individual project, a mid-term exam, and a final exam. Robert's grades on these instruments were 75, 94, 85, and 92, respectively. However, the instructor complicated Robert's task somewhat by adding the following stipulations: The following LP model allows Robert to maximize his numerical grade. ​ What values would you enter in the Analytic Solver Platform (ASP) task pane for the cells in this Excel spreadsheet implementation of this problem?
Objective Cell:
Variables Cells:
Constraints Cells:

---

Definitions:

Regression Toward The Mean

The tendency for extreme or unusual scores or events to fall back (regress) toward the average.

Unusual Scores

Scores that significantly deviate from the norm or average in any type of assessment, indicating atypical performance or results.

Average

A statistical measure representing the central tendency or typical value of a set of numbers, calculated as the sum of the values divided by the number of values.

Correlation Coefficients

Statistical measures that describe the direction and degree of relationship between two or more variables.