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, 22.06.2019 04:00, only1123

Match the type of agreements to their descriptions. will trust living will prenuptial agreement

Answers: 2

continue

Business, 22.06.2019 09:40, leomessifanboy678

As related to a company completing the purchase to pay process, is there an accounting journal entry "behind the scenes" when xyz company pays for the goods within 10 days of the invoice (gross method is used for discounts and terms are 2/10 net 30) that updates the general ledger?

Answers: 3

continue

Business, 22.06.2019 10:10, cuthbertson157

conquest, inc. produces a special kind of light-weight, recreational vehicle that has a unique design. it allows the company to follow a cost-plus pricing strategy. it has $9,000,000 of average assets, and the desired profit is a 10% return on assets. assume all products produced are sold. additional data are as follows: sales volume 1000 units per year; variable costs $1000 per unit; fixed costs $4,000,000 per year; using the cost-plus pricing approach, what should be the sales price per unit?

Answers: 2

continue

Business, 22.06.2019 12:00, lyn36

In mexico, many garment or sewing shops found they could entice many young people to work for them if they offered clean, air conditioned work areas with high-quality locker rooms to clean up in after the work day. typically, traditional garment shops had to offer to get workers to apply for the hard, repetitive, and somewhat dangerous work. a. benchmark competitive wages b. compensating differentials c. monopoly wages d. wages based on human capital development of each employee

Answers: 3

continue

You know the right answer?

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