Business, 22.02.2021 19:40, Huvch3183

The file FDICBankFailures contains data on failures of federally insured banks between 2000 and 2012. Create a PivotTable in Excel to answer the following questions. The PivotTable should group the closing dates of the banks into yearly bins and display the counts of bank closures each year in columns of Excel. Row labels should include the bank locations and allow for grouping the locations into states or viewing by city. You should also sort the PivotTable so that the states with the greatest number of total bank failures between 2000 and 2012 appear at the top of the PivotTable. (a)Which state had the greatest number of federally insured bank closings between 2000 and 2012?
(b)How many bank closings occurred in the state of Nevada (NV) in 2010?
In what cities did these bank closings occur?
Carson City, Henderson, Las VegasElko, HendersonElko, Las Vegas, RenoCarson City, Las Vegas, RenoCarson City, Reno
(c)Use the PivotTableâ€™s filter capability to view only bank closings in California (CA), Florida (FL), Texas (TX), and New York (NY) for the years 2009 through 2012. What is the total number of bank closings in these states between 2009 and 2012?
(d)Using the filtered PivotTable from part c, what city in Florida had the greatest number of bank closings between 2009 and 2012? How many bank closings occurred in this city?
The city in Florida with the greatest number of bank closures between 2009 and 2012 was - Select your answer -, with bank closures.
(e)Create a PivotChart to display a column chart that shows the total number of bank closings in each year 2000 through 2012 in the state of Florida. Adjust the formatting of this column chart so that it best conveys the data.

Answers: 3

Show answers

Other questions on the subject: Business

Business, 21.06.2019 16:00, romet31

Danny "dimes" donahue is a neighborhood's 9-year-old entrepreneur. his most recent venture is selling homemade brownies that he bakes himself. at a price of $2 each, he sells 100. at a price of $1.5 each, he sells 300. instructions: round your answer to 1 decimal place. a. what is the elasticity of demand? 3.50 â± 0.1 . b. is demand elastic or inelastic over this price range? . c. if demand had the same elasticity for a price decline from $1.5 to $1 as it does for the decline from $2 to $1.5, would cutting the price from $1.5 to $1 increase or decrease danny's total revenue? .

Answers: 1

continue

Business, 21.06.2019 21:30, divadebbgirl1

Ryan terlecki organized a new internet company, capuniverse, inc. the company specializes in baseball-type caps with logos printed on them. ryan, who is never without a cap, believes that his target market is college and high school students. you have been hired to record the transactions occurring in the first two weeks of operations. issued 2,900 shares of $0.01 par value common stock to investors for cash at $29 per share. borrowed $68,000 from the bank to provide additional funding to begin operations; the note is due in two years. paid $1,000 for the current month's rent of a warehouse and another $1,000 for next month's rent. paid $1,440 for a one-year fire insurance policy on the warehouse (recorded as a prepaid expense). purchased furniture and fixtures for the warehouse for $16,000, paying $3,200 cash and the rest on account. the amount is due within 30 days. purchased for $2,800 cash the university of pennsylvania, notre dame, the university of texas at austin, and michigan state university baseball caps as inventory to sell online. placed advertisements on google for a total of $340 cash. sold caps totaling $1,900, half of which was charged on account. the cost of the caps sold was $1,100. (hint: make two entries.) made full payment for the furniture and fixtures purchased on account in (e). received $280 from a customer on account.

Answers: 2

continue

Business, 22.06.2019 10:50, stodd9503

Explain whether each of the following events increases, decreases, or has no effect on the unemployment rate and the labor-force participation rate. a. after a long search, jon finds a job. b. tyrion, a full-time college student, graduates and is immediately employed. c. after an unsuccessful job search, arya gives up looking and retires. d. daenerys quits her job to become a stay-at-home mom. e. sansa has a birthday, becomes an adult, but has no interest in working. f. jaime has a birthday, becomes an adult, and starts looking for a job. g. cersei dies while enjoying retirement. h. jorah dies working long hours at the office.

Answers: 2

continue

Business, 22.06.2019 12:40, abilovessoftball

Which of the following tasks would be a line cook's main responsibility? oa. frying french fries ob. chopping onions oc. taking inventory of stocked dry goods od. paying invoices

Answers: 2

continue

Do you know the correct answer?

The file FDICBankFailures contains data on failures of federally insured banks between 2000 and 2012...