Use the Excel file “25_US_Bank” and perform/answer following: A) Describe a typical bank in the US in terms of “Rev/Asset”, “Dep/Asset”, and “Asset/Empl”. Use descriptive statistics to respond by calculating mean, median, min, max, range, variance, standard deviation, skewness, and kurtosis. calculations must be done in Excel Characteristics of Selected U.S. Banks (n = 41) Branches Billions of Dollars Ratios Obs Name Year Ticker Charter Employees Domestic Foreign Assets Revenue Deposits Rev/Asset Dep/Asset Asset/Empl ($m) 1 JPMorgan Chase & Co 2019 JPM NAT 257,444 5034 33 2765.00 109.03 1458.76 0.0394 0.5276 10.74 2 Bank of America Corp 2018 BAC NAT 205,000 4339 27 2325.00 91.24 1345.65 0.0392 0.5788 11.34 3 Citigroup 2018 C NAT 204,000 702 172 1917.00 72.85 1005.18 0.0380 0.5244 9.40 4 Wells Fargo & Co 2018 WFC NAT 258,700 5585 12 1895.00 86.40 1266.59 0.0456 0.6684 7.33 5 Goldman Sachs Group Inc 2018 GS SMB 36,600 2 1 1000.00 36.62 151.52 0.0366 0.1515 27.32 6 Morgan Stanley 2018 MS NAT 60,348 0 0 853.53 40.11 175.19 0.0470 0.2053 14.14 7 U.S. Bancorp 2017 USB NAT 74,000 3048 1 488.00 22.06 331.18 0.0452 0.6786 6.59 8 PNC Financial Services Group Inc 2017 PNC NAT 52,906 2416 2 380.77 16.33 264.88 0.0429 0.6956 7.20 9 Capital One Financial Corp 2018 COF NAT 48,800 0 1 372.54 28.08 247.20 0.0754 0.6636 7.63 10 Bank of New York Mellon Corp 2018 BK SMB 51,300 2 15 362.87 16.39 231.59 0.0452 0.6382 7.07 11 Charles Schwab Group 2018 SCHW NAT 19,500 345 2 296.48 10.13 213.41 0.0342 0.7198 15.20 12 State Street Corp 2018 STT SMB 40,142 2 11 244.63 11.98 168.20 0.0490 0.6876 6.09 13 Truist Financial Corp (BB&T Corp) 2018 BBT SNM 37,000 1871 1 225.70 11.65 154.56 0.0516 0.6848 6.10 14 SunTrust Banks Inc 2018 STI SMB 22,899 1163 0 216.00 9.00 160.38 0.0417 0.7425 9.43 15 American Express Corp 2018 AXP NAT 59,000 0 0 188.60 36.99 69.30 0.1961 0.3674 3.20 16 Ally Financial Inc 2018 ALLY SMB 8,200 0 0 178.87 5.79 101.38 0.0324 0.5668 21.81 17 MUFG Americas Holding Company 2018 MUFG NAT 12,141 349 0 160.53 5.48 90.98 0.0341 0.5667 13.22 18 Citizens Financial Group 2018 CFG NAT 18,000 1104 1 160.52 6.13 117.08 0.0382 0.7294 8.92 19 Fifth Third Bancorp 2018 FITB SMB 18,125 1138 1 146.07 6.95 108.88 0.0476 0.7454 8.06 20 KeyCorp (KeyBank) 2017 KEY NAT 17,999 1179 0 137.70 6.87 105.78 0.0499 0.7682 7.65 21 Northern Trust Corp 2018 NTRS SMB 18,800 56 5 132.21 5.96 104.89 0.0451 0.7934 7.03 22 Regions Financial Corp 2018 RF SMB 19,969 1453 0 126.69 6.76 93.26 0.0534 0.7361 6.34 23 M&T Bank Corp 2017 MTB SMB 16,354 787 2 118.59 6.02 89.14 0.0508 0.7517 7.25 24 Huntington Bancshares Inc 2017 HBAN NAT 14,511 948 0 104.19 4.35 81.69 0.0418 0.7840 7.18 25 First Republic Bank 2018 FRC SNM 5,350 72 0 99.21 3.04 74.76 0.0306 0.7536 18.54 26 Discover Financial Services 2016 DFS SNM 15,549 0 0 92.31 2.39 63.67 0.0259 0.6897 5.94 27 BBVA Compass Bancshares Inc 2018 CBSS SMB 10,045 640 0 90.06 3.70 70.38 0.0411 0.7815 8.97 28 Comerica Inc 2017 CMA SMB 8190 436 1 71.57 3.60 56.01 0.0503 0.7826 8.74 29 Zions Bancorp 2017 ZION NAT 1,600 434 0 66.29 2.61 53.79 0.0394 0.8114 41.43 30 SVB Financial Group 2018 SIVB SMB 2,438 4 1 56.93 2.72 49.33 0.0478 0.8665 23.35 31 New York Community Bancorp Inc 2018 NYCB NAT 3,096 225 0 51.90 1.78 30.32 0.0343 0.5842 16.76 32 CIT Group Inc 2019 CIT NAT 3,678 63 0 50.78 2.29 30.83 0.0451 0.6071 13.81 33 Signature Bank 2018 SBNY SNM 1,415 7 0 49.41 1.73 36.09 0.0350 0.7304 34.92 34 People's United Financial Inc 2018 PBCT NAT 5,188 407 0 47.88 1.26 36.16 0.0263 0.7552 9.23 35 First Horizon National Corp 2018 FHN NAT 5,577 299 0 40.83 2.27 31.01 0.0556 0.7595 7.32 36 Synovus Financial Corp 2018 SNV SMB 4,651 299 0 32.67 1.62 26.72 0.0496 0.8179 7.02 37 Hancock Whitney Bank Corp 2017 HWC SNM 3,887 196 0 27.34 1.17 23.15 0.0428 0.8467 7.03 38 Texas Capital Bank 2018 TCBI NAT 1,564 11 0 28.30 0.99 20.61 0.0350 0.7283 18.09 39 Pacific Western Bank 2018 PACW SNM 1,669 74 0 25.73 1.16 18.87 0.0451 0.7334 15.42 40 Pinnacle Bank 2018 PNFP SNM 2,297 113 0 25.03 1.15 19.70 0.0459 0.7871 10.90 41 Commerce Bank 2018 CBSH SMB 4,869 168 0 23.50 1.33 20.32 0.0566 0.8647 4.83

Use the Excel file “25_US_Bank” and perform/answer following: A) Describe a typical bank in the US in terms of “Rev/Asset”, “Dep/Asset”, and “Asset/Empl”. Use descriptive statistics to respond by calculating mean, median, min, max, range, variance, standard deviation, skewness, and kurtosis. calculations must be done in Excel Characteristics of Selected U.S. Banks (n = 41) Branches Billions of Dollars Ratios Obs Name Year Ticker Charter Employees Domestic Foreign Assets Revenue Deposits Rev/Asset Dep/Asset Asset/Empl ($m) 1 JPMorgan Chase & Co 2019 JPM NAT 257,444 5034 33 2765.00 109.03 1458.76 0.0394 0.5276 10.74 2 Bank of America Corp 2018 BAC NAT 205,000 4339 27 2325.00 91.24 1345.65 0.0392 0.5788 11.34 3 Citigroup 2018 C NAT 204,000 702 172 1917.00 72.85 1005.18 0.0380 0.5244 9.40 4 Wells Fargo & Co 2018 WFC NAT 258,700 5585 12 1895.00 86.40 1266.59 0.0456 0.6684 7.33 5 Goldman Sachs Group Inc 2018 GS SMB 36,600 2 1 1000.00 36.62 151.52 0.0366 0.1515 27.32 6 Morgan Stanley 2018 MS NAT 60,348 0 0 853.53 40.11 175.19 0.0470 0.2053 14.14 7 U.S. Bancorp 2017 USB NAT 74,000 3048 1 488.00 22.06 331.18 0.0452 0.6786 6.59 8 PNC Financial Services Group Inc 2017 PNC NAT 52,906 2416 2 380.77 16.33 264.88 0.0429 0.6956 7.20 9 Capital One Financial Corp 2018 COF NAT 48,800 0 1 372.54 28.08 247.20 0.0754 0.6636 7.63 10 Bank of New York Mellon Corp 2018 BK SMB 51,300 2 15 362.87 16.39 231.59 0.0452 0.6382 7.07 11 Charles Schwab Group 2018 SCHW NAT 19,500 345 2 296.48 10.13 213.41 0.0342 0.7198 15.20 12 State Street Corp 2018 STT SMB 40,142 2 11 244.63 11.98 168.20 0.0490 0.6876 6.09 13 Truist Financial Corp (BB&T Corp) 2018 BBT SNM 37,000 1871 1 225.70 11.65 154.56 0.0516 0.6848 6.10 14 SunTrust Banks Inc 2018 STI SMB 22,899 1163 0 216.00 9.00 160.38 0.0417 0.7425 9.43 15 American Express Corp 2018 AXP NAT 59,000 0 0 188.60 36.99 69.30 0.1961 0.3674 3.20 16 Ally Financial Inc 2018 ALLY SMB 8,200 0 0 178.87 5.79 101.38 0.0324 0.5668 21.81 17 MUFG Americas Holding Company 2018 MUFG NAT 12,141 349 0 160.53 5.48 90.98 0.0341 0.5667 13.22 18 Citizens Financial Group 2018 CFG NAT 18,000 1104 1 160.52 6.13 117.08 0.0382 0.7294 8.92 19 Fifth Third Bancorp 2018 FITB SMB 18,125 1138 1 146.07 6.95 108.88 0.0476 0.7454 8.06 20 KeyCorp (KeyBank) 2017 KEY NAT 17,999 1179 0 137.70 6.87 105.78 0.0499 0.7682 7.65 21 Northern Trust Corp 2018 NTRS SMB 18,800 56 5 132.21 5.96 104.89 0.0451 0.7934 7.03 22 Regions Financial Corp 2018 RF SMB 19,969 1453 0 126.69 6.76 93.26 0.0534 0.7361 6.34 23 M&T Bank Corp 2017 MTB SMB 16,354 787 2 118.59 6.02 89.14 0.0508 0.7517 7.25 24 Huntington Bancshares Inc 2017 HBAN NAT 14,511 948 0 104.19 4.35 81.69 0.0418 0.7840 7.18 25 First Republic Bank 2018 FRC SNM 5,350 72 0 99.21 3.04 74.76 0.0306 0.7536 18.54 26 Discover Financial Services 2016 DFS SNM 15,549 0 0 92.31 2.39 63.67 0.0259 0.6897 5.94 27 BBVA Compass Bancshares Inc 2018 CBSS SMB 10,045 640 0 90.06 3.70 70.38 0.0411 0.7815 8.97 28 Comerica Inc 2017 CMA SMB 8190 436 1 71.57 3.60 56.01 0.0503 0.7826 8.74 29 Zions Bancorp 2017 ZION NAT 1,600 434 0 66.29 2.61 53.79 0.0394 0.8114 41.43 30 SVB Financial Group 2018 SIVB SMB 2,438 4 1 56.93 2.72 49.33 0.0478 0.8665 23.35 31 New York Community Bancorp Inc 2018 NYCB NAT 3,096 225 0 51.90 1.78 30.32 0.0343 0.5842 16.76 32 CIT Group Inc 2019 CIT NAT 3,678 63 0 50.78 2.29 30.83 0.0451 0.6071 13.81 33 Signature Bank 2018 SBNY SNM 1,415 7 0 49.41 1.73 36.09 0.0350 0.7304 34.92 34 People's United Financial Inc 2018 PBCT NAT 5,188 407 0 47.88 1.26 36.16 0.0263 0.7552 9.23 35 First Horizon National Corp 2018 FHN NAT 5,577 299 0 40.83 2.27 31.01 0.0556 0.7595 7.32 36 Synovus Financial Corp 2018 SNV SMB 4,651 299 0 32.67 1.62 26.72 0.0496 0.8179 7.02 37 Hancock Whitney Bank Corp 2017 HWC SNM 3,887 196 0 27.34 1.17 23.15 0.0428 0.8467 7.03 38 Texas Capital Bank 2018 TCBI NAT 1,564 11 0 28.30 0.99 20.61 0.0350 0.7283 18.09 39 Pacific Western Bank 2018 PACW SNM 1,669 74 0 25.73 1.16 18.87 0.0451 0.7334 15.42 40 Pinnacle Bank 2018 PNFP SNM 2,297 113 0 25.03 1.15 19.70 0.0459 0.7871 10.90 41 Commerce Bank 2018 CBSH SMB 4,869 168 0 23.50 1.33 20.32 0.0566 0.8647 4.83

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Topic Video

Question

Use the Excel file “25_US_Bank” and perform/answer following:

A) Describe a typical bank in the US in terms of “Rev/Asset”, “Dep/Asset”, and “Asset/Empl”. Use descriptive statistics to respond by calculating mean, median, min, max, range, variance, standard deviation, skewness, and kurtosis.

calculations must be done in Excel

Characteristics of Selected U.S. Banks (n = 41)
						Branches	Billions of Dollars	Ratios
Obs	Name	Year	Ticker	Charter	Employees	Domestic	Foreign	Assets	Revenue	Deposits	Rev/Asset	Dep/Asset	Asset/Empl ($m)
1	JPMorgan Chase & Co	2019	JPM	NAT	257,444	5034	33	2765.00	109.03	1458.76	0.0394	0.5276	10.74
2	Bank of America Corp	2018	BAC	NAT	205,000	4339	27	2325.00	91.24	1345.65	0.0392	0.5788	11.34
3	Citigroup	2018	C	NAT	204,000	702	172	1917.00	72.85	1005.18	0.0380	0.5244	9.40
4	Wells Fargo & Co	2018	WFC	NAT	258,700	5585	12	1895.00	86.40	1266.59	0.0456	0.6684	7.33
5	Goldman Sachs Group Inc	2018	GS	SMB	36,600	2	1	1000.00	36.62	151.52	0.0366	0.1515	27.32
6	Morgan Stanley	2018	MS	NAT	60,348	0	0	853.53	40.11	175.19	0.0470	0.2053	14.14
7	U.S. Bancorp	2017	USB	NAT	74,000	3048	1	488.00	22.06	331.18	0.0452	0.6786	6.59
8	PNC Financial Services Group Inc	2017	PNC	NAT	52,906	2416	2	380.77	16.33	264.88	0.0429	0.6956	7.20
9	Capital One Financial Corp	2018	COF	NAT	48,800	0	1	372.54	28.08	247.20	0.0754	0.6636	7.63
10	Bank of New York Mellon Corp	2018	BK	SMB	51,300	2	15	362.87	16.39	231.59	0.0452	0.6382	7.07
11	Charles Schwab Group	2018	SCHW	NAT	19,500	345	2	296.48	10.13	213.41	0.0342	0.7198	15.20
12	State Street Corp	2018	STT	SMB	40,142	2	11	244.63	11.98	168.20	0.0490	0.6876	6.09
13	Truist Financial Corp (BB&T Corp)	2018	BBT	SNM	37,000	1871	1	225.70	11.65	154.56	0.0516	0.6848	6.10
14	SunTrust Banks Inc	2018	STI	SMB	22,899	1163	0	216.00	9.00	160.38	0.0417	0.7425	9.43
15	American Express Corp	2018	AXP	NAT	59,000	0	0	188.60	36.99	69.30	0.1961	0.3674	3.20
16	Ally Financial Inc	2018	ALLY	SMB	8,200	0	0	178.87	5.79	101.38	0.0324	0.5668	21.81
17	MUFG Americas Holding Company	2018	MUFG	NAT	12,141	349	0	160.53	5.48	90.98	0.0341	0.5667	13.22
18	Citizens Financial Group	2018	CFG	NAT	18,000	1104	1	160.52	6.13	117.08	0.0382	0.7294	8.92
19	Fifth Third Bancorp	2018	FITB	SMB	18,125	1138	1	146.07	6.95	108.88	0.0476	0.7454	8.06
20	KeyCorp (KeyBank)	2017	KEY	NAT	17,999	1179	0	137.70	6.87	105.78	0.0499	0.7682	7.65
21	Northern Trust Corp	2018	NTRS	SMB	18,800	56	5	132.21	5.96	104.89	0.0451	0.7934	7.03
22	Regions Financial Corp	2018	RF	SMB	19,969	1453	0	126.69	6.76	93.26	0.0534	0.7361	6.34
23	M&T Bank Corp	2017	MTB	SMB	16,354	787	2	118.59	6.02	89.14	0.0508	0.7517	7.25
24	Huntington Bancshares Inc	2017	HBAN	NAT	14,511	948	0	104.19	4.35	81.69	0.0418	0.7840	7.18
25	First Republic Bank	2018	FRC	SNM	5,350	72	0	99.21	3.04	74.76	0.0306	0.7536	18.54
26	Discover Financial Services	2016	DFS	SNM	15,549	0	0	92.31	2.39	63.67	0.0259	0.6897	5.94
27	BBVA Compass Bancshares Inc	2018	CBSS	SMB	10,045	640	0	90.06	3.70	70.38	0.0411	0.7815	8.97
28	Comerica Inc	2017	CMA	SMB	8190	436	1	71.57	3.60	56.01	0.0503	0.7826	8.74
29	Zions Bancorp	2017	ZION	NAT	1,600	434	0	66.29	2.61	53.79	0.0394	0.8114	41.43
30	SVB Financial Group	2018	SIVB	SMB	2,438	4	1	56.93	2.72	49.33	0.0478	0.8665	23.35
31	New York Community Bancorp Inc	2018	NYCB	NAT	3,096	225	0	51.90	1.78	30.32	0.0343	0.5842	16.76
32	CIT Group Inc	2019	CIT	NAT	3,678	63	0	50.78	2.29	30.83	0.0451	0.6071	13.81
33	Signature Bank	2018	SBNY	SNM	1,415	7	0	49.41	1.73	36.09	0.0350	0.7304	34.92
34	People's United Financial Inc	2018	PBCT	NAT	5,188	407	0	47.88	1.26	36.16	0.0263	0.7552	9.23
35	First Horizon National Corp	2018	FHN	NAT	5,577	299	0	40.83	2.27	31.01	0.0556	0.7595	7.32
36	Synovus Financial Corp	2018	SNV	SMB	4,651	299	0	32.67	1.62	26.72	0.0496	0.8179	7.02
37	Hancock Whitney Bank Corp	2017	HWC	SNM	3,887	196	0	27.34	1.17	23.15	0.0428	0.8467	7.03
38	Texas Capital Bank	2018	TCBI	NAT	1,564	11	0	28.30	0.99	20.61	0.0350	0.7283	18.09
39	Pacific Western Bank	2018	PACW	SNM	1,669	74	0	25.73	1.16	18.87	0.0451	0.7334	15.42
40	Pinnacle Bank	2018	PNFP	SNM	2,297	113	0	25.03	1.15	19.70	0.0459	0.7871	10.90
41	Commerce Bank	2018	CBSH	SMB	4,869	168	0	23.50	1.33	20.32	0.0566	0.8647	4.83

Definition Definition Middle value of a data set. The median divides a data set into two halves, and it also called the 50th percentile. The median is much less affected by outliers and skewed data than the mean. If the number of elements in a dataset is odd, then the middlemost element of the data arranged in ascending or descending order is the median. If the number of elements in the dataset is even, the average of the two central elements of the arranged data is the median of the set. For example, if a dataset has five items—12, 13, 21, 27, 31—the median is the third item in ascending order, or 21. If a dataset has six items—12, 13, 21, 27, 31, 33—the median is the average of the third (21) and fourth (27) items. It is calculated as follows: (21 + 27) / 2 = 24.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Centre, Spread, and Shape of a Distribution$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.