Homework: Variables into Knowledge
Imagine that you are hired as a data analyst for a bank. The bank would like to learn more about its customers' spending and banking habits to identify areas of improvement. You have been asked to review the bank's income statements over the last 5 years and identify trends that will allow them to better understand their customers.
Download your chosen bank's annual income statements from the last 5 years (data attached).
Identify three variables or categories that the bank may be interested in further researching, such as sales or revenue. Using these three variables or categories, build a frequency table, a bar chart, and a pie chart using Excel. Using the same three variables in each table and chart, so the same data will be displayed in three different formats.
After creating the three tables, which of the tables and charts do you find most useful for communicating information about the bank's customers? Write a briefcase report summarizing your analysis and results.
In your paper,
I. Identify three variables in the income statements that the bank may be interested in further researching to learn more about its customers.
II. Develop a frequency table, a bar chart, and a pie chart using variables in the income statements for your bank.
III. Analyze the table and charts to find the most useful information for communicating information about the bank's customers.
Format your homework according to the give formatting requirements:
• The answer must be using Times New Roman font (size 12), double spaced, typed, with one-inch margins on all sides.
• The response also includes a cover page containing the student's name, the title of the homework, the course title, and the date. The cover page is not included in the required page length.
• Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.