1. Open Excel and create a new workbook.
2. Import the data from the Mergent database into Excel.
3. Select the data that you want to include in the frequency table.
4. Go to the Insert tab and click on the PivotTable button.
5. In the PivotTable dialog box, select New sheet and click on the OK button.
6. In the PivotTable, drag the Category field to the Rows area and the Amount field to the Values area.
7. Right-click on the Amount field and select Value Field Settings.
8. In the Value Field Settings dialog box, select the Count option and click on the OK button.
9. The frequency table will now be displayed in the PivotTable.

To build a bar chart, follow these steps:

1. Select the data that you want to include in the bar chart.
2. Go to the Insert tab and click on the Bar chart button.
3. Select the type of bar chart that you want to create.
4. The bar chart will now be displayed in the Excel sheet.

To build a pie chart, follow these steps:

1. Select the data that you want to include in the pie chart.
2. Go to the Insert tab and click on the Pie chart button.
3. The pie chart will now be displayed in the Excel sheet.

Here are the three variables or categories that the bank may be interested in further researching:

• Net income: This is the amount of money that the bank has left after paying all of its expenses. The bank may be interested in this variable to see how its profits have changed over time.
• Interest income: This is the money that the bank earns from lending money to customers. The bank may be interested in this variable to see how its interest income has changed over time.
• Non-interest income: This is the money that the bank earns from other sources, such as fees and commissions. The bank may be interested in this variable to see how its non-interest income has changed over time.

Here is an example of a frequency table, bar chart, and pie chart that can be created using these three variables:

Frequency table

Bar chart

[Bar chart showing the frequency of net income for the past 5 years]

Pie chart

[Pie chart showing the percentage of net income from each category for the past 5 years]

These tables and charts can help the bank to visualize the trends in its income over the past 5 years. The bank can then use this information to identify areas where it can improve its performance.

For example, the bank may see that its net income has been declining in recent years. This could be due to a number of factors, such as increasing competition, rising interest rates, or a decrease in lending activity. The bank can use this information to develop strategies to improve its profitability.

The bank can also use the tables and charts to compare its performance to other banks. This can help the bank to identify areas where it is doing well and areas where it can improve.

Overall, the tables and charts can be a valuable tool for the bank to use to understand its financial performance and identify areas where it can improve.