A bank requires eight pieces of information from loan applicants: income, education level, age, length of time at current residence, length of time with current employer, savings, debt, and number of credit cards. A bank administrator wants to analyze this data to determine the best way to group and report it. The administrator collects the information for 30 loan applicants.
The administrator uses conditional formatting to identify the applicants in the lowest 10% for income.
The three cells that represent the lowest 10% income are shaded red.