A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each

question 52

Multiple Choice

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the auditing information shown below to determine which of the following statements is TRUE.

• A) There is no error in the model.
• B) The model is incorrect because it is using the wrong information for the employee hours.
• C) The model is incorrect because it is using the wrong wage information.
• D) The model is incorrect, but it is impossible to determine why.
• E) The model is incorrect because it is using the wrong information for the employee hours and the model is incorrect because it is using the wrong wage information are both true.

---

Definitions:

Sales Dollars

The total revenue generated from sales, expressed in dollars.

One-tailed T-test

A statistical test used to determine if a sample mean significantly exceeds or is significantly less than a hypothesized value.

Mean Rating

The average score derived from the sum of all ratings divided by the number of ratings.

Attractive Defendants

The phenomenon where defendants who are deemed physically attractive may receive more lenient judgments or penalties.