One of the earliest operations research groups during World War II was conducting a study on the optimum utilization of Spitfire and Hurricane aircraft during the Battle of Britain. Whenever one of these planes returned from battle, the locations of the bullet holes on it were carefully plotted. By repeatedly recording these data over time, and studying the clusters of data, the group was able to estimate the regions of the aircraft most likely to be hit by enemy gunfire, with the objective of reinforcing these regions with special armor. What difficulties are involved with this study. there are 4 different answers choose 1 Choose the correct answer below.

A.

The locations of bullet holes may change if the enemy changes tactics.

B.

Reinforcing these regions of the aircraft would make it more difficult to record locations of bullet holes in the future.

C.

The locations of bullet holes may not be precise, due to the need for repairing aircraft so they could be sent up again.

D.

The study was only observing planes that returned safely. Planes that were shot down could not be analyzed.

1. Select the difference between relative addressing and absolute addressing wher using cell formulas in Excel? A rlative address uses a dollar sign before either the row or column label; an absolute address uses the ampersand symbol before either the row or column label. A relative address uses a dollar sign before either the row or column label; an absolute address uses just the row and column label in the cell reference. A relative address uses just the row and colymn label in the cell reference; an absolute address uses a dollar sign before either the row or column label. A relative address only the column label in the cell reference; an absolute address uses the row. 2. A positive NPV means that the investment will provided added value because the projected return exceeds the Discount rate Modified internal rate of return Accounting rate of return Adjusted present value