Posted: February 25th, 2023
Prior to beginning work on this assignment, read Chapters 1 and 2 of your textbook.
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 from the Mergent database in the University of Arizona Global Campus Library. Review the Mergent Online: Accessing Mergent OnlineLinks to an external site. resource for tips on accessing and searching the Mergent database. Use the “Company Financials” tab in Mergent to access the income statements.
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. Review the Microsoft Excel Help: BUS625 Excel GuideLinks to an external site. webpage for resources to help utilize Microsoft Excel. You will be 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 brief case report summarizing your analysis and results.
In your paper,
The Turning Variables Into Knowledge paper
Carefully review the Grading RubricLinks to an external site. for the criteria that will be used to evaluate your assignment.
SOLUTION
Introduction
The banking industry has seen significant changes in the last decade, and banks must continually learn more about their customers to keep up with these changes. By reviewing the income statements over the last five years of a bank, data analysts can identify trends that allow the bank to understand its customers’ spending and banking habits better. This paper analyzes income statements of a bank to identify three variables that the bank may be interested in further researching, build frequency tables, bar charts, and pie charts, and identify the most useful table and chart for communicating information about the bank’s customers.
Place an order in 3 easy steps. Takes less than 5 mins.