1. regression analysis,
2. t-tests, f-tests or Anova using excel
3. your choice of a problem and solution related to regression analysis
Branch Name,Branch Number,City,County,Established Date,Bank Name,State,Street Address,Zipcode,2010 Deposits,2011 Deposits,2012 Deposits,2013 Deposits,2014 Deposits,2015 Deposits,2016 Deposits Columbia University Branch,117,New York City,New York,1/1/1824,JPMorgan Chase Bank,NY,2824-26 Broadway,10025,"476,616","500,560","509,924","535,937","552,926","585,744","645,046" JPMorgan Chase Bank Main Office,0,Columbus,Delaware,1/1/1824,JPMorgan Chase Bank,OH,1111 Polaris Parkway,43240,"633,131,000","743,268,000","832,455,000","916,543,000","1,032,549,000","1,069,425,000","1,155,185,000" Downtown Flushing Branch,113,Flushing,Queens,1/29/1906,JPMorgan Chase Bank,NY,39-01 Main Street,11354,"488,717","553,758","665,005","819,541","984,053","1,101,585","1,246,785" Washington Heights Branch,21,New York City,New York,1/2/1909,JPMorgan Chase Bank,NY,1421 Saint Nicholas Avenue,10033,"136,997","142,882","151,420","158,669","157,862","163,336","179,566" Carroll Gardens Branch,34,Brooklyn,Kings,6/9/1913,JPMorgan Chase Bank,NY,79 Hamilton Avenue,11231,"46,199","51,254","54,859","70,898","69,824","77,536","79,441" Yorkville Branch,52,New York City,New York,6/15/1914,JPMorgan Chase Bank,NY,126 East 86th Street,10028,"383,871","410,662","437,302","490,441","538,860","526,558","535,283" Bloomingdales Branch,63,New York City,New York,8/2/1915,JPMorgan Chase Bank,NY,770 Lexington Avenue,10065,"273,852","284,524","295,659","301,179","365,023","356,922","353,925" Lexington Avenue & 72nd Street Branch,81,New York City,New York,1/15/1917,JPMorgan Chase Bank,NY,1003 Lexington Avenue,10021,"198,144","187,406","232,051","238,634","263,619","293,597","304,304" Audubon Branch,40,New York City,New York,4/2/1917,JPMorgan Chase Bank,NY,3940 Broadway,10032,"91,380","97,219","104,093","106,875","114,292","122,220","139,830" Steinway and Broadway Branch,122,Astoria,Queens,1/27/1919,JPMorgan Chase Bank,NY,38-18 Broadway,11103,"191,624","190,802","210,850","237,922","242,952","253,736","321,267" Chinatown Branch,46,New York City,New York,11/24/1919,JPMorgan Chase Bank,NY,180 Canal Street,10013,"480,964","523,824","589,914","638,030","715,607","791,413","892,267" Sheridan Square Branch,82,New York City,New York,1/3/1920,JPMorgan Chase Bank,NY,204 West Fourth Street,10014,"307,978","323,295","339,057","387,560","398,346","440,728","454,616" Chelsea Branch,79,New York City,New York,6/15/1921,JPMorgan Chase Bank,NY,"158 West 14th Street, 2nd Floor",10011,"201,447","208,175","207,242","226,551","236,501","242,861","260,559" Forest Hills 71st Ave Branch,114,Forest Hills,Queens,1/2/1922,JPMorgan Chase Bank,NY,107-36 71st Avenue,11375,"369,462","377,148","398,091","436,707","469,300","502,087","520,197" Burnside Avenue Branch,15,Bronx,Bronx,2/14/1922,JPMorgan Chase Bank,NY,5 West Burnside Avenue,10453,"39,888","42,546","43,800","45,867","51,363","56,693","62,993" Broadway Lispenard Branch,45,New York City,New York,8/1/1922,JPMorgan Chase Bank,NY,407 Broadway,10013,"150,592","160,595","204,645","244,811","275,726","306,902","333,954" Empire State Branch,85,New York City,New York,4/1/1924,JPMorgan Chase Bank,NY,349 Fifth Avenue and 34th Street,10016,"666,584","655,384","733,993","833,534","890,817","7,099,781","15,580,897" Kingsbridge Road Branch,18,Bronx,Bronx,8/18/1924,JPMorgan Chase Bank,NY,66 East Kingsbridge Road,10468,"69,778","72,816","74,729","75,470","78,759","83,978","88,674" Sutton Place Branch,83,New York City,New York,6/7/1926,JPMorgan Chase Bank,NY,994 First Avenue,10022,"381,890","416,914","446,512","469,062","437,428","474,278","513,961" Broadway Branch,22,Bronx,Bronx,7/12/1926,JPMorgan Chase Bank,NY,5581 Broadway,10463,"113,665","112,165","122,634","126,619","124,031","134,475","131,545" Grand Army Plaza Branch,33,Brooklyn,Kings,3/14/1927,JPMorgan Chase Bank,NY,401 Flatbush Avenue,11238,"135,506","136,764","146,051","163,797","178,001","227,647","255,084" Times Square Branch,44,New York City,New York,5/2/1927,JPMorgan Chase Bank,NY,3 Times Square,10036,"313,024","338,725","432,032","449,569","474,047","495,929","532,606" Stapleton Branch,124,Staten Island,Richmond,5/1/1928,JPMorgan Chase Bank,NY,621 Bay Street,10304,"50,571","49,589","47,365","53,341","52,521","54,804","56,262" Fit Seventh Avenue Branch,86,New York City,New York,9/17/1929,JPMorgan Chase Bank,NY,305 Seventh Avenue,10001,"270,220","289,307","336,648","359,183","389,188","400,925","491,408" West 86th Street Branch,95,New York City,New York,12/9/1929,JPMorgan Chase Bank,NY,59 West 86th Street,10024,"297,520","298,637","307,545","329,475","358,566","359,705","374,965" London Terrace Branch,64,New York City,New York,5/1/1931,JPMorgan Chase Bank,NY,475 West 23rd Street,10011,"143,289","163,960","168,332","194,739","224,536","245,573","249,426" Far Rockaway Branch,112,Far Rockaway,Queens,10/5/1931,JPMorgan Chase Bank,NY,1912 Mott Avenue,11691,"41,599","41,935","41,661","46,938","48,890","51,464","52,268" Pelham Branch,129,Pelham,Westchester,9/16/1935,JPMorgan Chase Bank,NY,35 Fifth Avenue,10803,"195,892","194,287","202,564","205,522","229,560","225,678","246,944" Gracie Square Branch,98,New York City,New York,2/1/1938,JPMorgan Chase Bank,NY,453 East 86th Street,10028,"199,955","201,831","226,978","249,119","270,207","276,765","291,172" Riverdale Branch,20,Bronx,Bronx,6/1/1950,JPMorgan Chase Bank,NY,3775 Riverdale Avenue,10463,"304,300","311,508","330,224","360,791","367,202","364,435","387,333" Gun Hill Branch,16,Bronx,Bronx,12/18/1950,JPMorgan Chase Bank,NY,1308 East Gun Hill Road,10469,"73,702","70,049","70,447","78,946","80,677","82,756","88,954" Tremont Branch,71,Bronx,Bronx,10/18/1954,JPMorgan Chase Bank,NY,601 East Tremont Avenue,10457,"48,180","43,965","45,267","48,717","53,949","56,093","56,539" Soho Branch,42,New York City,New York,10/18/1954,JPMorgan Chase Bank,NY,525 Broadway,10012,"286,082","320,252","344,141","385,854","488,886","508,122","615,029" Columbus Avenue & 72nd Street Branch,62,New York City,New York,10/18/1954,JPMorgan Chase Bank,NY,260 Columbus Avenue,10023,"311,593","350,759","338,917","356,374","384,371","383,014","429,310" Hunters Point Branch,121,Long Island City,Queens,10/18/1954,JPMorgan Chase Bank,NY,10-51 Jackson Avenue,11101,"130,285","136,220","146,084","175,561","188,246","226,631","248,397" Oceanside Branch,127,Oceanside,Nassau,6/23/1956,JPMorgan Chase Bank,NY,3285 Long Beach Road,11572,"186,475","192,357","211,930","225,057","220,445","223,883","292,667" Westchester Square Branch,24,Bronx,Bronx,6/29/1959,JPMorgan Chase Bank,NY,2725 East Tremont Avenue,10461,"155,289","157,396","161,177","169,839","167,495","183,544","194,609" Exxon Building Branch,105,New York City,New York,9/9/1959,JPMorgan Chase Bank,NY,1251 Avenue Of The Americas,10020,"1,633,290","1,755,963","1,915,696","1,999,711","2,004,986","2,008,347","2,072,137" Queens Blvd and 64th Ave Branch,123,Rego Park,Queens,12/28/1959,JPMorgan Chase Bank,NY,97-41 Queens Boulevard,11374,"188,844","193,020","202,799","215,948","225,394","217,878","224,070" Bay Terrace Branch,111,Bayside,Queens,6/6/1960,JPMorgan Chase Bank,NY,2398 Bell Boulevard,11360,"169,397","164,359","184,653","210,463","239,369","253,658","279,639" Vernon Hills Scarsdale Branch,2,Scarsdale,Westchester,3/20/1961,JPMorgan Chase Bank,NY,676 White Plains Road,10583,"293,229","310,791","325,742","327,930","327,792","341,475","381,558" Third Avenue & 51st Street Branch,37,New York City,New York,5/5/1961,JPMorgan Chase Bank,NY,850 Third Avenue,10022,"463,550","456,859","508,804","540,179","595,786","581,725","643,283" East End Branch,38,New York City,New York,5/22/1961,JPMorgan Chase Bank,NY,1495 York Avenue,10075,"299,301","306,225","317,068","359,173","410,737","425,169","447,613" Astoria 30th Avenue Branch,110,Long Island City,Queens,6/19/1961,JPMorgan Chase Bank,NY,31-05 30th Avenue,11102,"148,276","155,347","176,789","206,933","228,963","250,939","272,444" Third Avenue & 41st Street Branch,99,New York City,New York,10/2/1961,JPMorgan Chase Bank,NY,633 Third Avenue,10017,"536,930","534,039","584,368","652,110","674,841","708,847","741,339" Hempstead Fulton Branch,132,Hempstead,Nassau,5/6/1963,JPMorgan Chase Bank,NY,136 Fulton Street,11550,"83,334","80,416","82,907","91,316","91,996","92,963","99,338" Rockville Centre Branch,131,Rockville Centre,Nassau,6/4/1963,JPMorgan Chase Bank,NY,10 North Village Avenue,11570,"356,382","372,278","416,956","446,580","446,229","471,622","513,718" Great Neck Northern Boulevard Branch,3,Great Neck,Nassau,9/9/1963,JPMorgan Chase Bank,NY,410 Northern Boulevard,11021,"191,011","206,933","216,439","237,983","234,183","262,455","278,940" Rochdale Village Mall Branch,118,Jamaica,Queens,12/26/1963,JPMorgan Chase Bank,NY,165-40 Baisley Boulevard,11434,"79,155","79,979","79,218","86,187","92,112","103,283","111,129" Mount Vernon Branch,9,Mount Vernon,Westchester,2/25/1964,JPMorgan Chase Bank,NY,22 West First Street,10550,"146,820","136,672","140,678","154,313","148,707","145,499","151,949" Bay Parkway and 85th St Branch,26,Brooklyn,Kings,3/25/1964,JPMorgan Chase Bank,NY,8418 Bay Parkway,11214,"187,794","195,965","214,398","227,519","252,124","278,547","297,821" First Avenue & 72nd Street Branch,41,New York City,New York,6/15/1964,JPMorgan Chase Bank,NY,360 East 72nd Street,10021,"384,454","364,852","387,515","440,753","500,574","483,835","536,219" Lawrence Rockaway Branch,5,Lawrence,Nassau,1/16/1965,JPMorgan Chase Bank,NY,335 Rockaway Turnpike,11559,"172,608","172,749","189,413","198,445","205,198","223,200","235,594" Castle Hill Branch,12,Bronx,Bronx,12/11/1965,JPMorgan Chase Bank,NY,784 Castle Hill Avenue,10473,"75,131","80,172","82,333","94,538","97,046","107,166","110,592" North Hartsdale Branch,4,Hartsdale,Westchester,2/19/1966,JPMorgan Chase Bank,NY,353 North Central Avenue,10530,"87,110","88,367","93,163","109,659","111,985","116,772","140,233" Forest Avenue Livermore Branch,136,Staten Island,Richmond,11/12/1966,JPMorgan Chase Bank,NY,1480 Forest Avenue,10302,"102,440","103,511","108,168","167,418","174,257","195,843","217,998" Woodbury Branch,137,Woodbury,Nassau,1/7/1967,JPMorgan Chase Bank,NY,7977 Jericho Turnpike,11797,"336,232","364,094","407,292","434,065","473,883","443,733","509,827" Elmsford Branch,138,Elmsford,Westchester,5/13/1967,JPMorgan Chase Bank,NY,324 Saw Mill River Road,10523,"69,960","82,378","75,417","100,752","117,726","174,351","115,819" Plainview Branch,140,Plainview,Nassau,11/10/1967,JPMorgan Chase Bank,NY,1064 Old Country Road,11803,"227,651","245,466","247,680","261,922","289,271","285,591","292,952" Coney Island Avenue Branch,142,Brooklyn,Kings,1/6/1968,JPMorgan Chase Bank,NY,2730 Coney Island Avenue,11235,"151,017","153,682","156,303","183,572","199,027","199,141","223,629" Thornwood Branch,144,Thornwood,Westchester,2/1/1969,JPMorgan Chase Bank,NY,608 Columbus Avenue,10594,"140,401","145,620","151,223","162,526","167,717","166,077","184,267" Garment Center Branch,148,New York City,New York,11/24/1969,JPMorgan Chase Bank,NY,1411 Broadway,10018,"722,415","756,573","825,562","921,794","1,028,179","1,088,274","1,107,800" Bainbridge Branch,149,Bronx,Bronx,1/17/1970,JPMorgan Chase Bank,NY,3169 Bainbridge Avenue,10467,"95,881","97,372","101,001","106,185","112,012","108,989","113,878" Bayside South Branch,151,Oakland Gardens,Queens,9/26/1970,JPMorgan Chase Bank,NY,215-16 73rd Avenue,11364,"154,441","155,722","166,811","178,915","187,522","185,374","197,150" White Plains Branch,154,White Plains,Westchester,4/17/1971,JPMorgan Chase Bank,NY,191 Mamaroneck Avenue,10601,"435,292","415,391","428,516","456,042","436,171","452,475","452,700" Kew Gardens Hills Branch,156,Flushing,Queens,11/15/1971,JPMorgan Chase Bank,NY,71-41 Main Street,11367,"253,851","277,587","298,261","323,460","338,008","358,750","373,343" Restoration Plaza Branch,158,Brooklyn,Kings,12/20/1971,JPMorgan Chase Bank,NY,1380 Fulton Street,11216,"103,719","108,159","114,156","121,110","131,026","147,089","168,128" Water Street Branch,159,New York City,New York,4/3/1972,JPMorgan Chase Bank,NY,55 Water Street,10041,"1,002,240","965,981","959,075","976,472","996,233","992,896","1,069,059" Mineola Branch,163,Mineola,Nassau,11/10/1972,JPMorgan Chase Bank,NY,32 Jericho Turnpike,11501,"88,738","93,165","100,406","115,772","128,278","135,141","176,190" East Flushing Branch,165,Flushing,Queens,6/8/1973,JPMorgan Chase Bank,NY,196-03 Northern Boulevard,11358,"82,032","90,628","96,660","106,917","115,674","121,256","130,731" Knolls Crescent Branch,171,Bronx,Bronx,12/6/1974,JPMorgan Chase Bank,NY,13b Knolls Crescent,10463,"102,620","104,179","111,486","116,699","119,020","120,116","122,159" Sixth Avenue and 23rd St Branch,172,New York City,New York,1/6/1975,JPMorgan Chase