Question: This row ( 1 0 5 ) is used to calculate a decision rule for determining underutilization for the 8 0 % rule. If any

This row (105) is used to calculate a decision rule for determining underutilization for the 80% rule. If any ratio in Row 104 is less than 80%, there may be a problem with discrimination. To calculate this value, you must use the IF function in Excel. The IF function is used because it will help to retrieve one value for a TRUE result, and one for a FALSE result.
The IF function is input as follows:
Where: logical test = the value or expression that is to evaluated as TRUE or FALSE (e.g. that the 4/5th rule is met);
value_if_true = the value that returns when the logical_test evaluates as TRUE; and
value_if_false = the value that returns when the logical_test evaluates as FALSE.
For the purpose of this assignment, you will refer to the values derived in row 104 and assess whether they yield a TRUE or FALSE result (will appear as 1 or 0, respectively). Perform the function to find the rest of the values in the row.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!