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

Another question on Business

Business, 21.06.2019 16:10

Afirm produces a product in a competitive industry and has a total cost function (tc) of tc(q) = 60 + 10q + 2q2 and a marginal cost function (mc) of mc(q) = 10 + 4q. at the given market price (p) of $20, the firm is producing 5.00 units of output. is the firm maximizing profit? no what quantity of output should the firm produce in the long run? the firm should produce unit s) of output. (enter your response as an integer.)

Answers: 3

Answer

Business, 23.06.2019 01:10

1. alwaysrain irrigation, inc. would like to determine capacity requirements for the next four years. currently, two production lines are in place for making bronze and plastic sprinklers. three types of sprinklers are available in both bronze and plastic: 90-degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. management has forecast demand for the next four years as follows: both production lines can produce all the different types of nozzles. the bronze machines needed for the bronze sprinklers require two operators and can produce up to 12,000 sprinklers. the plastic injection molding machine needed for the plastic sprinklers requires four operators and can produce up to 200,000 sprinklers. three bronze machines and only one injection molding machine are available. what are the capacity requirements for the next four years? (assume that there is no learning.)

Answers: 1

Answer

Business, 23.06.2019 01:30

James jones is the owner of a small retail business operated as a sole proprietorship. during 2017, his business recorded the following items of income and expense: revenue from inventory sales $ 147,000 cost of goods sold 33,500 business license tax 2,400 rent on retail space 42,000 supplies 15,000 wages paid to employees 22,000 payroll taxes 1,700 utilities 3,600 compute taxable income attributable to the sole proprietorship by completing schedule c to be included in james’s 2017 form 1040. compute self-employment tax payable on the earnings of james’s sole proprietorship by completing a 2017 schedule se, form 1040. assume your answers to parts a and b are the same for 2018. further assume that james's business is not a service business, and that it has $155,000 unadjusted basis in tangible depreciable property. calculate james's 2018 section 199a deduction.

Answers: 1

Answer

Business, 23.06.2019 03:30

What does the term "smalling up" mean, according to white? what ways have you or people you know had to "small up"? if you haven't, what ways could you?

Answers: 2

Answer

You know the right answer?

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

Questions