Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
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.
- 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?
- 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?
- 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.)
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Suppose you need to summarize ordinal data in a bar graph. How would you arrange the categories of data on the horizontal axis? Is it possible to make the order of the data apparent in a pie chart?
A real estate major collected information on some recent local home sales. The first 6 lines of the database appear in the accompanying table. The columns correspond to the house identification number, the community name, the zip code, the
number of acres of the property, the year the house was built, the market value, and the size of the living area (in square feet). Do the data appear to have come from a designed survey or experiment? What concerns might you have about
drawing conclusions from this data set?
E Click the icon to view the data table.
Do the data appear to have come from a designed survey or experiment?
O A. It is not clear if the data were obtained from an experiment. They are certainly not from a survey.
O B. It is not clear if the data were obtained from a survey. They are certainly not from an experiment.
O C. It is not clear if the data were obtained from a survey or an experiment.
O D. The data were certainly not obtained from survey or an experiment.
What…
MarkLines is an online portal (www.marklines.com) that reports automotive industry data. The table below shows the number of cars sold in the United States from January to November in 2017 and 2018. The top 22 manufacturers, plus others, are listed here. Sales data often is reported in this way to compare current sales to last year’s sales.
Car Sales
Manufacturer
Jan.-Nov.2017
Jan.-Nov.2018
GM (Est.)
2,691,493
2,654,568
Ford
2,334,290
2,265,590
Toyota
2,211,533
2,205,762
Fiat Chrysler
1,887,430
2,038,684
Honda
1,492,112
1,449,713
Nissan
1,455,238
1,345,157
Hyundai
621,961
612,225
Subaru
584,614
615,594
Kia
546,629
542,245
Mercedes (includes Sprinter)
332,990
318,012
BMW
271,432
276,657
VW
309,395
322,017
Mazda
262,577
274,455
Audi
199,534
200,558
Tesla (Est.)
40,320
106,050
Land Rover
66,759
81,526
Volvo
71828
89437
Mitsubishi
95,185
109,088
Porsche
51,507
53,116
MINI
42,494
40,887
Jaguar
36,180
27,021
Others
18,901
17,251
smart…
Chapter 3 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 3 - A sales manager is trying to determine appropriate...Ch. 3 - The following table shows an example of gross...Ch. 3 - The following table provides monthly revenue...Ch. 3 - In the file MajorSalary, data have been collected...Ch. 3 - Entrepreneur magazine ranks franchises. Among the...Ch. 3 - The file MutualFunds contains a data set with...Ch. 3 - The file TaxData contains information from federal...Ch. 3 - The file FDICBankFailures contains data on...Ch. 3 - The following 20 observations are for two...Ch. 3 - The file Fortune500 contains data for profits and...
Ch. 3 - The International Organization of Motor Vehicle...Ch. 3 - Prob. 12PCh. 3 - Prob. 13PCh. 3 - The total number of term life insurance contracts...Ch. 3 - An automotive company is considering the...Ch. 3 - Consider the following survey results regarding...Ch. 3 - The Northwest regional manager of Logan Outdoor...Ch. 3 - The Ajax Company uses a portfolio approach to...Ch. 3 - Heat maps can be very useful for identifying...Ch. 3 - The following table shows monthly revenue for six...Ch. 3 - Prob. 21PCh. 3 - Aurora Radiological Services is a health care...Ch. 3 - The motion picture industry is an extremely...
Knowledge Booster
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
- Create scatterplot using Excel with the following variables: gender: 0 = male, 1 = female. height: in inches. weight: in pounds. First we will create a scatterplot to examine how weight is related to height, ignoring gender. To do that in Excel: Sort the data by gender: Hold down the Control key (Command key on MacOS) and click the A key to select all of the data in the worksheet. Select the Home tab, then the Editing group Sort & Filter -> Custom Sort. In the pop-up window, make sure that My list has headers box is checked and then choose gender from the pull-down menu next to Sort by. Click OK. Now select all of the data in columns B and C, select the Insert tab and in the Charts group choose Scatter. Choose the first scatterplot option (Scatter with only Markers). Now we have a scatterplot, but the data is all on the right of the plot. To fix this: Right-click on the x-axis, and choose Format Axis from the pop-up menu. Make sure that Axis Options is selected on the left, and…arrow_forwardThe accompanying table gives the number of people diagnosed with AIDS in 2010 in 6 regions and the population of that region. Note that the "Rank Cases" column ranks the regions in order of the highest number of AIDS patients to the lowest number of AIDS patients; using 1 for the largest value and 6 for the smallest. Use the table to answer the following questions. LOADING... Click the icon to view the data table. Find the population of the remaining regions in thousands and add them to the table. Region AIDS Rank Cases Population Population (thousands) A 73,138 1 19,245,825 19,246 B 69,773 2 36,559,898 36,560 C 54,755 3 18,207,130 nothing D 38,544 4 23,900,845 nothing E 20,810 5 12,431,007 nothing F 6,068 6 591,888 nothing (Round to the nearest whole number as needed.)arrow_forwardIn a study, researchers wanted to measure the effect of alcohol on the hippocampal region, the portion of the brain responsible for long-term memory storage, in adolescents. The researchers randomly selected 23 adolescents with alcohol use disorders to determine whether the hippocampal volumes in the alcoholic adolescents were less than the normal volume of 9.02 cm. An analysis of the sample data revealed that the hippocampal volume is approximately normal with no outliers and x 8.18 cm and s=0.8 cm. Conduct the appropriate test at the a= 0.01 level of significance. State the null and alternative hypotheses. Ho: H H1: (Type integers or decimals. Do not round.) Identify the t-statistic. to = (Round to two decimal places as needed.) !! Identify the P-value. P-value = (Round to three decimal places as needed.) Make a conclusion regarding the hypothesis. the null hypothesis. There sufficient evidence to claim that the mean hippocampal volume is cm³ Statcrunch Next 8:01 SAMSUNG esc @ %23 $…arrow_forward
- An insurance company hires an actuary to determine whether the number of hours of safety drivingclasses can be used to predict the number of driving accidents for each driver. Identify theexplanatory variable, if any.arrow_forwardThe U.S. Census Bureau collects data on household size and publishes the information in Current Population Reports. What kind of data is the number of people in your household?arrow_forwardExplain the concept of Notation for Panel Data?arrow_forward
- please. help me answer this question. thank youarrow_forwarduppose Laura, a facilities manager at a health and wellness company, wants to estimate the difference in the average amount of time that men and women spend at the company's fitness centers each week. Laura randomly selects 13 adult male fitness center members from the membership database and then selects 13 adult female members from the database. Laura gathers data from the past month containing logged time at the fitness center for these members. She plans to use the data to estimate the difference in the time men and women spend per week at the fitness center. The sample statistics are summarized in the table. Population Populationdescription Population mean(unknown) Samplesize Sample mean(min) Sample standarddeviation (min) 1 male ?1 ?1=13 ?⎯⎯⎯1=132.5 ?1=45.3 2 female ?2 ?2=13 ?⎯⎯⎯2=108.7 ?2=31.1 df=21.256 The population standard deviations are unknown and unlikely to be equal, based on the sample data. Laura plans to use the two-sample ?-procedures to estimate the…arrow_forwardPlease help.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
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