Essentials Of Business Analytics
Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
Publisher: Cengage Learning,
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 3, Problem 8P

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.

  1. a. Which state had the greatest number of federally insured bank closings between 2000 and 2012?
  2. b. How many bank closings occurred in the state of Nevada (NV) in 2010? In what cities did these bank closings occur?
  3. 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?
  4. 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?
  5. 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. What does this column chart suggest about bank closings between 2000 and 2012 in Florida? Discuss.

(Hint: You may have to switch the row and column labels in the PivotChart to get the best presentation for your PivotChart.)

Blurred answer
Students have asked these similar questions
Reconsider the patient satisfaction data in Table 1. Fit a multiple regression model using both patient age and severity as the regressors. (a) Test for significance of regression. (b) Test for the individual contribution of the two regressors. Are both regressor variables needed in the model? (c) Has adding severity to the model improved the quality of the model fit? Explain your answer.
The output voltage of a power supply is assumed to be normally distributed. Sixteen observations taken at random on voltage are as follows: 10.35, 9.30, 10.00, 9.96, 11.65, 12.00, 11.25, 9.58, 11.54, 9.95, 10.28, 8.37, 10.44, 9.25, 9.38, and 10.85. (a) Test the hypothesis that the mean voltage equals 12 V against a two-sided alternative using a = 0.05. (b) Construct a 95% two-sided confidence interval on μ. (c) Test the hypothesis that σ² = 11 using α = 0.05. (d) Construct a 95% two-sided confidence interval on σ. (e) Construct a 95% upper confidence interval on σ. (f) Does the assumption of normality seem reasonable for the output voltage?
Analyze the residuals from the regression model on the patient satisfaction data from Exercise 3. Comment on the adequacy of the regression model.
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License