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