NF Bank's Summary of Loan Statistics Column Labels Kendall Row Labels North Miami Opa Locka Grand Total Sum of Loan Amount Average of Interest Rate $116,000.00 83% $45,000.00 4.85% $66,000.00 8.45% $227,000.00 6.73% Sum of Loan Amount Average of Interest Rate $625,000.00 $825,000.00$975,000.00 6.27% $2,425,000.00 6.31% 6.44% 6.05% Sum of Loan Amount Average of Interest Rate $75,500.00 5.63% $32,000.00 8.00% $107,500.00 6.42% $2,759,500.00 6.47% Total Sum of Loan Amount Total Average of Interest Rate $816,500.00 $902,000.00 $1,041,000.00 7.14% 6.27% 6.30% Figure 2: Pivot table NF Bank's Summary of Loan Statistics Column Labels Kendall Row Labels North Miami Opa Locka Grand Total Sum of Loan Amount Average of Interest Rate $116,000.00 83% $45,000.00 4.85% $66,000.00 8.45% $227,000.00 6.73% Sum of Loan Amount Average of Interest Rate $625,000.00 $825,000.00$975,000.00 6.27% $2,425,000.00 6.31% 6.44% 6.05% Sum of Loan Amount Average of Interest Rate $75,500.00 5.63% $32,000.00 8.00% $107,500.00 6.42% $2,759,500.00 6.47% Total Sum of Loan Amount Total Average of Interest Rate $816,500.00 $902,000.00 $1,041,000.00 7.14% 6.27% 6.30% Figure 2: Pivot table