Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems Analysis And Synthesis Bridging Computer Science And Information Technology

Authors: Barry Dwyer

1st Edition

0128054492, 9780128054499

More Books

Students also viewed these Databases questions

Question

What is cultural awareness?

Answered: 1 week ago