Question

AssignmentDescription: The commercial banking industry is undergoing rapid changes due to advances in technology and competitive pressures in the financial services sector. The data file Bankscontains selected information tabulated by Fortune concerning the revenues, profitability, and number of employees for the 51 largest U.S. commercial banks in terms of revenues.Instructions: Use the information in this file to complete the following:PartInstructionsPoints Possible1Start Excel. Open the downloaded Excel file named Banks.xlsx, and then save the file as Assignment5_LastFirst.02Compute the mean, median, and standard deviation for the three variables revenues, profits, and number of employees. Assume this data is defined as a population.153Convert the data for each variable to a z value. Consider Mellon Bank Corporation headquartered in Pittsburgh. How does it compare to the average bank in the study on the three variables? Discuss.154As you can see by examining the data and by looking at the 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?155Calculate a new variable: profits per employee. Develop a frequency distribution and a 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.406Referring to Question 5, how many banks had a profit-per-employee ratio that exceeded 2 standard deviations from the mean?157Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directe

Revenues	Profits	Employees
34697	3591	93700
30381	3708	69033
23585	3210	77000
21734	3077	80360
17701	1465	16943
14329	1896	43933
13219	1306	56600
12176	866	18286
10098	1525	33962
9660	1351	55729
9608	1155	33100
8095	1303	32317
6909	839	25858
6859	1052	24814
6727	879	21500
6568	919	24595
5697	1104	16494
5270	593	21652
5152	807	29841
5134	771	27500
4585	667	21227
4524	623	17398
4379	813	18847
4102	255	21487
3738	449	5900
3428	380	14199
3175	530	11000
2598	360	9803
2503	307	10311
2367	371	8566
2324	293	9485
2267	309	7553
2257	205	9510
2078	315	10622
1997	310	8215
1924	401	6787
1912	300	9227
1893	295	7755
1778	209	7711
1743	245	10227
1739	210	8854
1644	226	6400
1609	197	8207
1503	206	7673
1306	180	6328
1258	176	4781
1250	139	5114
1217	191	3884
1215	165	7496
1131	156	5060
1047	75	5200

Answer 1