When Using Excel to Calculate a P-Value for an Upper-Tail

question 1

Multiple Choice

When using Excel to calculate a p-value for an upper-tail hypothesis test, the following must be used

• A)RAND
• B)1 - NORM.S.DIST
• C)NORM.S.DIST
• D)Not enough information is given to answer this question.

---

Definitions:

Variable Manufacturing Overhead

Costs that vary with the level of production output and include expenses such as indirect materials, supplies, and utilities used in manufacturing.

Variable Overhead Efficiency Variance

The difference between the actual variable overhead incurred and the expected variable overhead based on efficient operations.

Variable Overhead

Costs that vary with the level of production or sales, such as utilities or hourly wages, that are not directly tied to a specific product.

Direct Labor-hours

Sum total of hours expended by workers directly active in the manufacturing domain.