Question

The commercial banking industry is undergoing rapid changes due to advances in technology and competitive pressures...

The commercial banking industry is undergoing rapid changes due to advances in technology and competitive pressures in the financial services sector. The data file BANKS contains selected information tabulated by Fortune concerning the revenues, profitability, and number of employees for the 51 largest US Commercial Banks in terms of revenues. Use the information in this file to complete the following:

a. Compute the mean, median and standard deviation for the three variables: revenues, profits and number of employees. Assume the data is defined as a population. (So since it's a population, would we use STDEV or STDEV.P ???)

b. Convert the data for each variable to z value. (Step-by-step explanation of finding z values). Consider Mellon Bank Corporation headquarters in Pittsburgh. How does it compare to the average bank in the study on the three variables? Discuss.

c. As you can see by examining the data and by looking at statistics computed in part (a), not all banks had the same revenue, same profit or the same number of employees. Which variable had the greatest relative variation among the banks in the study?

d. Calculate a new variable: profits per employee. Develop a frequency distribution and histogram for this new variable. Also compute the mean, median and standard deviation for the new variable. Write a short report that describes the profits per employee for the banks.

e. Referring to part (d), how many banks had a profit-per-employee ratio that exceeded 2 standard deviations from the mean?

Name Revenues Profits Employees
CITICORP 34697 3591 93700
CHASE MANHATTAN CORP. 30381 3708 69033
BANKAMERICA CORP. 23585 3210 77000
NATIONSBANK CORP. 21734 3077 80360
J.P.MORGAN & CO. 17701 1465 16943
FIRST UNION CORP. 14329 1896 43933
BANC ONE CORP. 13219 1306 56600
BANKERS TRUST N.Y. CORP. 12176 866 18286
FIRST CHICAGO NBD CORP. 10098 1525 33962
aMSOUTH BANCORP. 9660 1351 55729
WELLS FARGO & CO. 9608 1155 33100
FLEET FINANCIAL GROUP 8095 1303 32317
U.S. BANCORP 6909 839 25858
PNC BANK 6859 1052 24814
BANKBOSTON CORP. 6727 879 21500
KEYCORP 6568 919 24595
BANK OF NEW YORK CO. 5697 1104 16494
WACHOVIA CORP. 5270 593 21652
NATIONAL CITY CORP. 5152 807 29841
MELLON BANK CORP. 5134 771 27500
SUNTRUST BANKS 4585 667 21227
MBNA 4524 623 17398
CORESTATES FINAN. CORP. 4379 813 18847
BARNETT BANKS 4102 255 21487
REPUBLIC NEW YORK CORP. 3738 449 5900
STATE ST. CORP. 3428 380 14199
COMERICA 3175 530 11000
BB&T CORP. 2598 360 9803
SOUTHTRUST CORP. 2503 307 10311
SUMMIT BANCORP 2367 371 8566
HUNTINGTON BANCSHARES 2324 293 9485
NORTHERN TRUST CORP. 2267 309 7553
MERCANTILE BANCORP. 2257 205 9510
FIRST OF AMER. BANK CORP. 2078 315 10622
CRESTAR FINANCIAL CORP. 1997 310 8215
FIFTH THIRD BANCORP 1924 401 6787
REGIONS FINANCIAL 1912 300 9227
FIRSTAR CORP. 1893 295 7755
UNION PLANTERS CORP. 1778 209 7711
MARSHALL & ILSLEY CORP. 1743 245 10227
POPULAR 1739 210 8854
AMSOUTH BANCORP. 1644 226 6400
FIRST TENN. NATL. CORP. 1609 197 8207
FIRST SECURITY CORP. 1503 206 7673
OLD KENT FINANCIAL CORP. 1306 180 6328
FIRST EMPIRE STATE CORP. 1258 176 4781
PACIFIC CENTURY FINANCIAL 1250 139 5114
PROVIDIAN FINANCIAL 1217 191 3884
SYNOVUS FINANCIAL CORP. 1215 165 7496
COMPASS BANCSHARES 1131 156 5060
FIRST NATL. OF NEBRASKA 1047 75 5200
0 0
Add a comment Improve this question Transcribed image text
Answer #1

NO- solutions given data to Solve tho dato iAA Qu ii e A de erlel fouapevidd . Hoon odivicle arol OYANTY to Sum f all valu OfNo-(Q Popubation Hean tate We Revenues Poofits MELLON BANK CORP Sakqdug St34 Stardad essox Jn Craployees Q1269 Stdev n 51 7-1Page tea oeage NO-3) Employ af diteerte melon ard sin a af est * 9h1- 7 G- ighet given aenve and Corap hod HAN HATIAN CHASE(4 Poge NO IS C O 06 D04 O08 O.09 0.OS OO4 0.02 O.03 Hean Hodian Stol eu O.Ou O.04 Mean + Sldes O.037t O.DIu = Ob4 Raio aove

Add a comment
Know the answer?
Add Answer to:
The commercial banking industry is undergoing rapid changes due to advances in technology and competitive pressures...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • arclays is a London based multinational banking company that employs 140,000 employees. The company’s revenue drastically...

    arclays is a London based multinational banking company that employs 140,000 employees. The company’s revenue drastically decreased in 2012 ($53 billion) with a yearend deficit of $1.7 million. Later in 2012, Anthony Jenkins was appointed the new CEO in order to turn things around for Barclays so as to regain the trust of their investors and therein increase the profitability of the firm. In 2013, Barclays did achieve a positive net income of $890 million with sales growth of over...

  • What are the differentiating features of banks that target ethnic communities? (Bullet point answers please). United...

    What are the differentiating features of banks that target ethnic communities? (Bullet point answers please). United Commercial Bank and El Banco17CASE 2.1 This telling of the story of two special banks originally was prepared by students in 2007 who were engaged by the notion of two banks that had developed separate strategies for serving two niche markets. As you first read the students’ story, ask yourself, what could have gone wrong with each bank? Also, as you read, keep a...

  • The opening case, ‘Hackers Attack the SWIFT Global Banking Network’, discusses breaches in the system of...

    The opening case, ‘Hackers Attack the SWIFT Global Banking Network’, discusses breaches in the system of several banks that are a part of the SWIFT network. The case is an example of the importance of information system controls. Explain some of the security risks associated with information systems as well as some security and control measures that can be implemented to protect against these security risks. Hackers Attack the SWIFT Global Banking Network SWIFT, which stands for Society for Worldwide...

  • Read the attached article. Do you feel one style of banking control is more stable than...

    Read the attached article. Do you feel one style of banking control is more stable than the other? Why? Does one banking method minimize market volatility and risk better or is it just packaged differently? Do you feel the US (Western) Banking system can better control the patterns of behavior going forward that have caused economic damage in the past? Should the Fed continue its stimulus policy, reduce it or abandon it entirely (Google some recent articles to research this)?  (Please...

  • Trans-Pacific Industry & Technology Company Trans-Pacific Industry & Technology (TPIT), Inc. is a diversified industrial company....

    Trans-Pacific Industry & Technology Company Trans-Pacific Industry & Technology (TPIT), Inc. is a diversified industrial company. The Company owns businesses providing products & services to the energy, transportation, chemical, and construction sectors. The energy segment operates as an oil and natural gas contract drilling company the United States. The energy segment acquires, explores, develops, and produces oil and natural gas properties primarily located in Oklahoma and Texas, as well as in Arkansas, Colorado, Kansas, Louisiana, Mississippi, Montana, New Mexico, North...

  • Please list 5 inherent risk related items the assignment requires to list 5 inherent risks from...

    Please list 5 inherent risk related items the assignment requires to list 5 inherent risks from the description of the company that an auditor may take when deciding to accept this new client. Emphasis Heading 1 Heading 2 Heading 3 Heading 4 Description of Southwest Appliance, Inc. History and Corporate Structure Southwest Appliances, Inc. specializes in supplying a relatively small line of high-quality household appliances to residential construction contractors in a large and growing metropolitan area. Southwest has a large...

  • 1. Calculate the mean and standard deviation for each variable using formulas or functions. 2. Calculate...

    1. Calculate the mean and standard deviation for each variable using formulas or functions. 2. Calculate descriptive statistics for each variable using the Analysis Toolpak. 3. Calculate the coefficient of variation for each variable. What general interpretation can you make from these values? 4. Calculate the correlation between Revenue and Employees using a formula. Calculate the coefficient of determination. 5. Create a correlation matrix for the eight numerical variables. Note any relationship of interest Rank COMPANY NAME City State Revenue...

  • LO 10-6, 10 10-36 Based on an assessment of audit risk, the auditors are concerned with...

    LO 10-6, 10 10-36 Based on an assessment of audit risk, the auditors are concerned with the following two risks: 1. The risk that that the client might be making duplicate payments to vendors. 2. The risk that the client's accounting clerk might be making unauthorized payments to himself. a. Assuming that the client has a manual accounting system, describe how the auditors can design a test to identify the duplicate payments and unauthorized payments. b. Assuming that the client...

  • And there was a buy-sell arrangement which laid out the conditions under which either shareholder could...

    And there was a buy-sell arrangement which laid out the conditions under which either shareholder could buy out the other. Paul knew that this offer would strengthen his financial picture…but did he really want a partner?It was going to be a long night. read the case study above and answer this question what would you do if you were Paul with regards to financing, and why? ntroductloh Paul McTaggart sat at his desk. Behind him, the computer screen flickered with...

  • CASE 20 Enron: Not Accounting for the Future* INTRODUCTION Once upon a time, there was a...

    CASE 20 Enron: Not Accounting for the Future* INTRODUCTION Once upon a time, there was a gleaming office tower in Houston, Texas. In front of that gleaming tower was a giant "E" slowly revolving, flashing in the hot Texas sun. But in 2001, the Enron Corporation, which once ranked among the top Fortune 500 companies, would collapse under a mountain of debt that had been concealed through a complex scheme of off-balance-sheet partnerships. Forced to declare bankruptcy, the energy firm...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT