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 Ashford University Library. Review the Getting Started with Mergent 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 Guide (Links to an external site.) 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,
Identify three variables in the income statements that the bank may be interested further researching to learn more about its customers.
Develop a frequency table, a bar chart, and a pie chart using variables in the income statements for your bank.
Analyze the table and charts to find the most useful information for communicating information about the bankâs customers.
Summarize your analysis and results, including how the charts were useful in your research.
Sample Solution
There are seven fundamental components in relational correspondence. These components exist at whatever point we cooperate here and there. The pith of these components is that they are firmly related and progress in an intermittent cycle. It is one. DeVito says that there are consistently wellsprings of data when two individuals convey. The originator is the wellspring of the message and is liable for encoding the message and offering significance to the message (DeVito, 2013). The beneficiary of the message being gotten by the narrows is the beneficiary. Relational correspondence is a significant part of life. Notwithstanding trading data among individuals engaged with the correspondence cycle, there are other significant parts of correspondence between individuals (West, 2011). Connection of relational relationship assists individuals with getting thoughts andEffective correspondence is critical to the accomplishment of any business association. Since the world is turning into a worldwide town, compelling correspondence is basic inside and outside the association. Notwithstanding, in light of the enormous size of the association and the high association structure, it is hard to get data. This makes limits inside for different offices inside the association and remotely for clients. So as to conquer this “difficulty”, in the video “message” Professor Chip Heath stressed the significance of passing on data, yet in addition zeroing in on disclosing how to unravel it . The significance of oral correspondence and the significance of oral correspondence The significance of verbal correspondence: When the vast majority talk about oral correspondence, they allude to discourse and discourse. Because of the online correspondence channel, record correspondence turns out to be progressively normal, and representatives in numerous regions every so often make oral reports. Numerous individuals are stressed over giving a discourse. In any case, verbal correspondence additionally incorporates correspondence with different workers and bosses. This kind of correspondence is significant in current workplaces. Office depends more on email and text correspondence than any time in recent memory, yet these correspondence channels are not as quick and verbal as verbal conversation. Zeroing in on oral correspondence assists representatives with increasing a bit of leeway. A few extra arrangements will assist you with capitalizing on the open doors individuals talk. Numerous significant focal point of the correspondence cycle is seeing viable correspondence. Nonetheless, there are numerous correspondence measures that are made out of numerous significant components and that give regular formal and casual ways at significant clinical establishments. The primary substance of correspondence is partitioned into three fundamental components. These are components that include measures or disconnected occasions, investment of at any rate two individuals, and trade of individual data. relational abilities through the correspondence cycle (DeVito, 2009). All the more critically, when utilizing relational correspondence, the gatherings associated with the correspondence cycle are bound to communicate their feelings and feelings. In this way, the use of innovation during the time spent relational correspondence is still significant and assumes a significant part in the public arena (Wood, 2010). As indicated by an overview of April 2012, in the previous 30 days, about 70% of cell phone clients and 86% of cell phone clients are leading in any event one of the accompanying exercises. Subject 9 Interpersonal relationship ï¬ What is relational correspondence? Relational correspondence ï· Interpersonal correspondence is the way toward imparting, conveying, and haggling between the two individuals. Relational correspondence ï¬ What is the hypothetical perspective about relational correspondence? Relational correspondence in the 1960’s ï¬ Learning, friction, balance, social judgment, response. â Speech and social impact relational relationship From the last part of the 1960s to the mid 1970s â Self articulation, self exposure, relational connections, nonverbal correspondence and relationship advancement. â Development of relational connections and relational connections Interpersonal correspondence during the 1970s>
There are seven fundamental components in relational correspondence. These components exist at whatever point we cooperate here and there. The pith of these components is that they are firmly related and progress in an intermittent cycle. It is one. DeVito says that there are consistently wellsprings of data when two individuals convey. The originator is the wellspring of the message and is liable for encoding the message and offering significance to the message (DeVito, 2013). The beneficiary of the message being gotten by the narrows is the beneficiary. Relational correspondence is a significant part of life. Notwithstanding trading data among individuals engaged with the correspondence cycle, there are other significant parts of correspondence between individuals (West, 2011). Connection of relational relationship assists individuals with getting thoughts andEffective correspondence is critical to the accomplishment of any business association. Since the world is turning into a worldwide town, compelling correspondence is basic inside and outside the association. Notwithstanding, in light of the enormous size of the association and the high association structure, it is hard to get data. This makes limits inside for different offices inside the association and remotely for clients. So as to conquer this “difficulty”, in the video “message” Professor Chip Heath stressed the significance of passing on data, yet in addition zeroing in on disclosing how to unravel it . The significance of oral correspondence and the significance of oral correspondence The significance of verbal correspondence: When the vast majority talk about oral correspondence, they allude to discourse and discourse. Because of the online correspondence channel, record correspondence turns out to be progressively normal, and representatives in numerous regions every so often make oral reports. Numerous individuals are stressed over giving a discourse. In any case, verbal correspondence additionally incorporates correspondence with different workers and bosses. This kind of correspondence is significant in current workplaces. Office depends more on email and text correspondence than any time in recent memory, yet these correspondence channels are not as quick and verbal as verbal conversation. Zeroing in on oral correspondence assists representatives with increasing a bit of leeway. A few extra arrangements will assist you with capitalizing on the open doors individuals talk. Numerous significant focal point of the correspondence cycle is seeing viable correspondence. Nonetheless, there are numerous correspondence measures that are made out of numerous significant components and that give regular formal and casual ways at significant clinical establishments. The primary substance of correspondence is partitioned into three fundamental components. These are components that include measures or disconnected occasions, investment of at any rate two individuals, and trade of individual data. relational abilities through the correspondence cycle (DeVito, 2009). All the more critically, when utilizing relational correspondence, the gatherings associated with the correspondence cycle are bound to communicate their feelings and feelings. In this way, the use of innovation during the time spent relational correspondence is still significant and assumes a significant part in the public arena (Wood, 2010). As indicated by an overview of April 2012, in the previous 30 days, about 70% of cell phone clients and 86% of cell phone clients are leading in any event one of the accompanying exercises. Subject 9 Interpersonal relationship ï¬ What is relational correspondence? Relational correspondence ï· Interpersonal correspondence is the way toward imparting, conveying, and haggling between the two individuals. Relational correspondence ï¬ What is the hypothetical perspective about relational correspondence? Relational correspondence in the 1960’s ï¬ Learning, friction, balance, social judgment, response. â Speech and social impact relational relationship From the last part of the 1960s to the mid 1970s â Self articulation, self exposure, relational connections, nonverbal correspondence and relationship advancement. â Development of relational connections and relational connections Interpersonal correspondence during the 1970s>
