PLEASE COMPLETE IN EXCEL AND SHOW FORMULAS FOR ALL

The Federal Deposit Insurance Corporation provides information on the top 50 banks and their total deposits. The information is contained in the Too Big to Fail file in the data folder on Blackboard.

Create a histogram using the method we followed in class. Be sure your submission shows your answers to the following questions.

i. What is the appropriate number of classes (show formula) ii. What is the appropriate class interval width, that is, the size of each class? (show formula)

iii. What is the frequency of each class? (show formula) iv. What is the relative frequency of each class? (show formula)

Bank State Headquartered No. Office Total Deposits in $1,000 of dollars) BANK OF AMERICA CORPORAT North Carolina 5,856 1,066,655,151 WELLS FARGO & COMPANY California 6,386 793,617,903 JPMORGAN CHASE & CO. New York 5,437 768,955,618 CITIGROUP INC. New York 1,064 320,158,438 U.S. BANCORP Minnesota 3,139 198,455,053 PNC FINANCIAL SERVICES GRO Pennsylvania 2,618 180,771,942 TORONTO-DOMINION BANK, T Foreign 1,300 151,465,629 CAPITAL ONE FINANCIAL CORI Virginia 979 129,251,458 SUNTRUST BANKS, INC. Georgia 1,076 126,776,134 BANK OF NEW YORK MELLON New York 26 114,253,354 BB&T CORPORATION North Carolina 1,779 111,384,364 UK FINANCIAL INVESTMENTS Foreign 1,527 99,535,194 HSBC HOLDINGS PLC Foreign 480 98,706,061 REGIONS FINANCIAL CORPORA Alabama 1,768 98,397,236 FIFTH THIRD BANCORP Ohio 1,370 77,515,079 MORGAN STANLEY New York 2 65,134,410 M&T BANK CORPORATION New York 793 60,077,592 KEYCORP Ohio 1,059 59,764,459 MITSUBISHI UFJ FINANCIAL GR Foreign 409 57,310,314 BANCO SANTANDER, S.A. Foreign 775 52,744,866 BNP PARIBAS Foreign 718 51,037,133 BANCO BILBAO VIZCAYA ARG. Foreign 755 48,364,525 HUNTINGTON BANCSHARES IN Ohio 696 41,393,309 COMERICA INCORPORATED Texas 443 41,008,600 ZIONS BANCORPORATION 516 39,900,029 ALLY FINANCIAL INC. Michigan 2 38,461,259 BANK OF MONTREAL Foreign 338 37,029,131 DISCOVER FINANCIAL SERVICE Illinios 3 35,340,539 MARSHALL & ILSLEY CORPORA Wisconsin 385 34,624,418 GOLDMAN SACHS GROUP, INC., New York 4 31,802,000 AMERICAN EXPRESS COMPANY New York 2 31,783,394 NORTHERN TRUST CORPORATI Illinios 83 30,421,322 STATE STREET CORPORATION Massachusetts 1 28,614,029 POPULAR, INC. Puerto Rico 290 27,824,937 UBS AG Foreign 1 27,551,088 SYNOVUS FINANCIAL CORP. Georgia 294 22,787,351 NEW YORK COMMUNITY BAN New York 282 22,024,445 ROYAL BANK OF CANADA Foreign 425 20,571,420 CITY NATIONAL CORPORATIOI California 82 19,329,918 FIRST NIAGARA FINANCIAL GR New York 360 19,302,695 DEUTSCHE BANK AKTIENGESE Foreign 5 19,288,350 FIRST CITIZENS BANCSHARES, I North Carolina 429 17,675,233 BOK FINANCIAL CORPORATION Oklahoma 186 16,783,197 EAST WEST BANCORP, INC. California 131 16,149,182 FIRST HORIZON NATIONAL CO. Tenessee 183 16,033,657 COMMERCE BANCSHARES, INC. Missouri 203 15,662,189 HANCOCK HOLDING COMPANY Mississippi 306 15,573,320 CULLEN/FROST BANKERS, INC. Texas 129 15,187,958 ASSOCIATED BANC-CORP Wisconsin 279 14,049,589 WEBSTER FINANCIAL CORPOR/ Connecticut 174 13,770,447 Utah