Executive Solution Overview
Prior to beginning work on this assignment, read the following: – Chapter 1: Introduction to Business Analytics – Chapter 2: Data Management and Wrangling – Chapter 3: Summary Measures Imagine that you are hired as a data analyst for a bank. The bank would like to learn more about its customers’ spe…
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
Prior to beginning work on this assignment, read the following:
– Chapter 1: Introduction to Business Analytics
– Chapter 2: Data Management and Wrangling
– Chapter 3: Summary Measures
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 five years and identify trends that will allow them to understand their customers better.
Download your chosen bank’s annual income statements from the last five years from the [_Mergent OnlineLinks to an external site._](https://go.openathens.net/redirector/ashford.edu?url=http%3A%2F%2Fwww.mergentonline.com%2F) database in the University of Arizona Global Campus University Library. Review the [_Mergent Online: Accessing Mergent Online_Links to an external site.](https://content.bridgepointeducation.com/curriculum/file/ee4206e2-18df-4dc6-9618-9ab03b9bab52/1/mergent%20tipsheet%20final%20v2%20ADA.pdf) resource for tips on accessing and searching the database. Use the “Company Financials” tab in Mergent to access the income statements.
In your assignment,
– Identify an area of the bank’s income statement related to customer spending.
– Describe the data points or variables that give a complete picture of the customers’ spending pattern for the last six months.
– In addition to the income statement, explain which other data sources you might use to understand the customers’ spending patterns.
– List the steps you will take to prepare all these data sources such that they afford clear and accurate information.
– Build a frequency table, a bar chart, and a pie chart using Excel for the identified variables that explain the customers’ spending patterns. Review the [_Microsoft Excel Help: HomeLinks to an external site._](https://go.openathens.net/redirector/ashford.edu?url=https%3A%2F%2Fuagconline-libguides-com.eu1.proxy.openathens.net%2Fc.php%3Fg%3D895525%26p%3D6440517) webpage, available for resources to help utilize Microsoft Excel. Use the same three variables in each table and chart to display the same data in three different formats.
– After presenting your data in three formats, evaluate which tables and charts you find most helpful for communicating the desired message about the bank’s customers. For assistance on when and how to use tables, refer to resource [_Tables, Images, & Appendices_Links to an external site.](https://writingcenter.uagc.edu/tables-images-appendices).
The Turning Variables into Knowledge assignment
– must be two to three double-spaced pages in length (not including title and references pages, charts or tables), and formatted according to [_APA Style_Links to an external site.](https://writingcenter.uagc.edu/apa-style) as outlined in the Writing Center’s [_APA Formatting for Microsoft Word_Links to an external site.](https://writingcenter.uagc.edu/apa-formatting-microsoft-word) resource.
– must include a separate title page with the following:
– title of paper in bold font
– Space should appear between the title and the rest of the information on the title page.
– student’s name
– name of institution
– course name and number
– instructor’s name
– due date
– must utilize academic voice. Review the [_Academic Voice_Links to an external site.](https://writingcenter.uagc.edu/academic-voice) resource for additional guidance.
– must include an introduction and conclusion paragraph.
– Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.
– For assistance on writing [_Introductions & Conclusions_Links to an external site.](https://writingcenter.uagc.edu/introductions-conclusions) as well as [_Writing a Thesis Statement_Links to an external site.](https://writingcenter.uagc.edu/writing-a-thesis), refer to the Writing Center resources.
– must cite the information found in the [_Mergent OnlineLinks to an external site._](https://go.openathens.net/redirector/ashford.edu?url=http%3A%2F%2Fwww.mergentonline.com%2F) database in the University of Arizona Global Campus University Library. For assistance in citing the database, refer to the [_Mergent Online: Accessing Mergent Online_Links to an external site.](https://content.bridgepointeducation.com/curriculum/file/ee4206e2-18df-4dc6-9618-9ab03b9bab52/1/mergent%20tipsheet%20final%20v2%20ADA.pdf) resource.
– must document any information used from sources in APA Style as outlined in the Writing Center’s [_APA: Citing Within Your Paper_Links to an external site.](https://writingcenter.uagc.edu/apa-citing-within-your-paper) guide.
– must include a separate references page that is formatted according to APA Style as outlined in the Writing Center.
– Review the [_APA: Formatting Your References List_Links to an external site.](https://writingcenter.uagc.edu/format-your-reference-list) resource in the Writing Center for specifications.
– a year ago