DataPalooza 2021

ADVANCED METRIC FUNCTIONS

Figure 14 – Median Solution Chart

DIFFERENCE Now we will create a new derived metric called E013 Median Diff. In the formula bar simply solve E013 – Median E013 . The reason we are doing this is to see if any bank stands out from their competitors on a State and Bank Chartered Level.

Figure 15 – Difference Formula

12 | P a g e