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
Please provide the solution for the attached image in detailed.
20 km, because
GISS
Worksheet 10
Jesse runs a small business selling and delivering mealie meal to the spaza shops.
He charges a fixed rate of R80, 00 for delivery and then R15, 50 for each packet of
mealle meal he delivers. The table below helps him to calculate what to charge
his customers.
10
20
30
40
50
Packets of mealie
meal (m)
Total costs in Rands
80
235
390
545
700
855
(c)
10.1.
Define the following terms:
10.1.1. Independent Variables
10.1.2. Dependent Variables
10.2.
10.3.
10.4.
10.5.
Determine the independent and dependent variables.
Are the variables in this scenario discrete or continuous values? Explain
What shape do you expect the graph to be? Why?
Draw a graph on the graph provided to represent the information in the
table above.
TOTAL COST OF PACKETS OF MEALIE MEAL
900
800
700
600
COST (R)
500
400
300
200
100
0
10
20
30
40
60
NUMBER OF PACKETS OF MEALIE MEAL
Let X be a random variable with support SX = {−3, 0.5, 3, −2.5, 3.5}. Part ofits probability mass function (PMF) is given bypX(−3) = 0.15, pX(−2.5) = 0.3, pX(3) = 0.2, pX(3.5) = 0.15.(a) Find pX(0.5).(b) Find the cumulative distribution function (CDF), FX(x), of X.1(c) Sketch the graph of FX(x).
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
- A well-known company predominantly makes flat pack furniture for students. Variability with the automated machinery means the wood components are cut with a standard deviation in length of 0.45 mm. After they are cut the components are measured. If their length is more than 1.2 mm from the required length, the components are rejected. a) Calculate the percentage of components that get rejected. b) In a manufacturing run of 1000 units, how many are expected to be rejected? c) The company wishes to install more accurate equipment in order to reduce the rejection rate by one-half, using the same ±1.2mm rejection criterion. Calculate the maximum acceptable standard deviation of the new process.arrow_forward5. Let X and Y be independent random variables and let the superscripts denote symmetrization (recall Sect. 3.6). Show that (X + Y) X+ys.arrow_forward8. Suppose that the moments of the random variable X are constant, that is, suppose that EX" =c for all n ≥ 1, for some constant c. Find the distribution of X.arrow_forward
- 9. The concentration function of a random variable X is defined as Qx(h) = sup P(x ≤ X ≤x+h), h>0. Show that, if X and Y are independent random variables, then Qx+y (h) min{Qx(h). Qr (h)).arrow_forward10. Prove that, if (t)=1+0(12) as asf->> O is a characteristic function, then p = 1.arrow_forward9. The concentration function of a random variable X is defined as Qx(h) sup P(x ≤x≤x+h), h>0. (b) Is it true that Qx(ah) =aQx (h)?arrow_forward
- 3. Let X1, X2,..., X, be independent, Exp(1)-distributed random variables, and set V₁₁ = max Xk and W₁ = X₁+x+x+ Isk≤narrow_forward7. Consider the function (t)=(1+|t|)e, ER. (a) Prove that is a characteristic function. (b) Prove that the corresponding distribution is absolutely continuous. (c) Prove, departing from itself, that the distribution has finite mean and variance. (d) Prove, without computation, that the mean equals 0. (e) Compute the density.arrow_forward1. Show, by using characteristic, or moment generating functions, that if fx(x) = ½ex, -∞0 < x < ∞, then XY₁ - Y2, where Y₁ and Y2 are independent, exponentially distributed random variables.arrow_forward
- 1. Show, by using characteristic, or moment generating functions, that if 1 fx(x): x) = ½exarrow_forward1990) 02-02 50% mesob berceus +7 What's the probability of getting more than 1 head on 10 flips of a fair coin?arrow_forward9. The concentration function of a random variable X is defined as Qx(h) sup P(x≤x≤x+h), h>0. = x (a) Show that Qx+b(h) = Qx(h).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