Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
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…
If a data set contains three groups that each have ten people in them, how many rows will the “data view” have?
30
3
100
10
Chapter 3 Solutions
Essentials Of Business Analytics
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
- 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…arrow_forwardPresent the data in tabular form with textual analysis.arrow_forwardCreate 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_forward
- AS2. NO9. DATA ANALYSISarrow_forwardPlease analyze these tables one by one . Explain as table 1 and table 2.arrow_forwardKevin Horn is the national sales manager for National Textbooks Inc. He has a sales staff of 40 who visit college professors all over the United States. Each Saturday morning he requires his sales staff to send him a report. This report includes, among other things, the number of professors visited during the previous week. Listed below, ordered from smallest to largest, are the number of visits last week. 38 59 40 41 45 48 48 50 59 59 62 62 62 63 Click here for the Excel Data File a. Determine the median number of calls. Median Q1 Q3 50 64 51 51 52 52 53 54 55 55 55 56 56 57 65 66 66 67 67 69 69 71 77 78 79 79 b. Determine the first and third quartiles. (Round Q1 to 2 decimal places and Q3 to nearest whole number.)arrow_forward
- Can you create a five number summary of the data set?arrow_forwardAn 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_forwardCan you fill the table according to data? Thank you!arrow_forward
- In 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_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_forwardExplain the concept of Notation for Panel Data?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
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