The Solution of a Linear Programming Problem Using Microsoft Excel

question 1

Multiple Choice

The solution of a linear programming problem using Microsoft Excel typically involves the following three stages:

• A) formulating the problem,invoking Solver,and sensitivity analysis
• B) formulating the problem,graphing the problem,and sensitivity analysis
• C) the changing cells,the target cells,and the constraints
• D) the inputs,the changing cells,and the outputs

---

Definitions:

Normally Distributed

A probability distribution that demonstrates symmetry around its mean, indicating that occurrences diminish as distance from the mean increases.

Probability

The quantification of the chance of an event happening, represented as a numerical value ranging from 0 to 1.

Test Statistic

A standardized value that is calculated from sample data during a hypothesis test. It is used to determine whether to reject the null hypothesis.

Null Hypotheses

A statement that assumes there is no significant difference or effect in a population, and any observed difference is due to sampling or experimental error.