Business Analytics
3rd Edition
ISBN: 9780135231715
Author: Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter A3, Problem 2PE
Create a sunburst chart for the regions, items, and units sold in the Excel file Store and Regional Sales Database.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
find out he 78th percntile for given data
45,78,85,89,3,5,69,63,78
The results of a search to find the least expensive round-trip flights to Atlanta and Salt Lake C
major U.S. cities are shown in the following table. The departure date was June 20, 2012 and
was June 27, 2012. Click on the datafile logo to reference the data,
DATA file
Round-Trip Cost ($)
Departure City
Atlanta
Salt Lake Cit
Cincinnati
New York
340.10
321.60
291.60
570.10
354.60
465.60
Chicago
Dae
210/O
Find the 5-number summary for the following data: 6,8,4,4,6,2,4,6,2,4,2,8,4,6
Chapter A3 Solutions
Business Analytics
Ch. A3 - Create a treemap for the regions, items, and units...Ch. A3 - Create a sunburst chart for the regions, items,...Ch. A3 - Use PivotTables to find the number of loans by...Ch. A3 - Use PivotCharts to create a useful dashboard for...Ch. A3 - Prob. 6PECh. A3 - Use PivotCharts to create a useful dashboard for...Ch. A3 - Prob. 9PE
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
- Bicycling World, a magazine devoted to cycling, reviews hundreds of bicycles throughout the year. Its "Road-Race" category contains reviews of bicycles used by riders primarily interested in racing. One of the most important factors in selecting a bicycle for racing is the weight of the bicycle. The following data show the weight (pounds) and price ($) for ten racing bicycles reviewed by the magazine. Click on the datafile logo to reference the data. Model Weight (lb) Price ($) Fierro 7B 17.9 2,200 HX 5000 16.2 6,350 Durbin Ultralight 15.0 8,470 Schmidt 16.0 6,300 WSilton Advanced 17.3 4,100 Bicyclette vélo 13.2 8,700 Supremo Team 16.3 6,100 XTC Racer 17.2 2,680 D'Onofrio Pro 17.7 3,500 Americana #6 14.2 8,100 How much of the variation in the prices of the bicycles in the sample does the regression model you estimated in part (b) explain? If required, round your answer to the nearest whole number. Do not round intermediate…arrow_forwardThe average monthly residential gas bill for Black Hills Energy customers in Cheyenne, Wyoming is (Wyoming Public Service Commission website). How is the average monthly gas bill for a Cheyenne residence related to the square footage, number of rooms, and age of the residence? The following data show the average monthly gas bill for last year, square footage, number of rooms, and age for typical Cheyenne residences. Average Monthly Gas Number of Bill for Last Year Age Square Footage Rooms $70.20 16 2537 6 $81.33 2 3437 8 $45.86 27 976 6 $59.21 11 1713 7 $117.88 16 3979 11 $57.78 2 1328 7 $47.01 27 1251 6 $52.89 4 827 5 $32.90 12 645 4 $67.04 29 2849 5 $76.76 1 2392 7 $60.40 26 900 5 $44.07 14 1386 5 $26.68 20 1299 4 $62.70 17 1441 6 $45.37 13 562 4 $38.09 10 2140 4 $45.31 22 908 6 $52.45 24 1568 5 $96.11 27 1140 10…arrow_forwardFill out 2 blanksarrow_forward
- This chart displays the average rate of people living in poverty in the 23 continental states west of the Mississippi River for the years 2014 – 2016. Create a stemplot for these data. Note that a stemplot never shows the decimal symbol and only the rightmost digit is used for the leaf. (https://www.census.gov/data/tables/2017/demo/income-poverty/p60-259.html) Average rate of people living in poverty in the 23 continental states west of the Mississippi River for the years 2014 – 2016 State Rate of Poverty (%) Minnesota 8.3 Utah 9.4 Iowa 10.1 Wyoming 10.1 Colorado 10.2 North Dakota 10.5 Nebraska 10.6 Missouri 11.1 Washington 11.5 Idaho 11.9 Montana 11.9 Kansas 12.5 Oregon 12.7 Nevada 13.4 South Dakota 13.7 California 14.5 Texas 15.0 Oklahoma 15.4 Arkansas 16.8 Arizona 18.2 New Mexico 19.1 Louisiana 20.6 Mississippi 20.8arrow_forwardSuppose 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?arrow_forwardFind the 5 number summary of the following set of data: 11, 8, 12, 4, 7, 10, 3, 15, 8, 8, 7arrow_forward
- Find the range for the given data set, 22,52,89,63,41,71,14,83,96,12arrow_forwardThe average number of minutes Americans commute to work is 27.7 minutes (Sterling's Best Places, April 13, 2012). The average commute time in minutes for 48 cities are as follows: Click on the datafile logo to reference the data. DATA file Albuquerque Atlanta Austin Baltimore Boston Charlotte Chicago Cincinnati Cleveland Columbus Dallas Denver Detroit El Paso Fresno Indianapolis 23.3 28.3 24.6 32.1 31.7 25.8 38.1 24.9 26.8 23.4 28.5 28.1 29.3 24.4 23.0 24.8 Jacksonville Kansas City Las Vegas Little Rock Los Angeles Louisville Memphis Miami Milwaukee Minneapolis Nashville New Orleans New York Oklahoma City Orlando Philadelphia 26.2 Phoenix 23.4 Pittsburgh Portland 28.4 20.1 32.2 21.4 23.8 30.7 24.8 23.6 25.3 31.7 43.8 22.0 27.1 34.2 Providence Richmond c. What is the mode for these 48 cities? Select your answer - Sacramento Salt Lake City San Antonio San Diego San Francisco San Jose Seattle St. Louis Tucson Tulsa Washington, D.C. 28.3 25.0 26.4 23.6 23.4 25.8 20.2 26.1 24.8 32.6 28.5…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 72,471 1 19,206,132 19,206 B 65,139 2 36,453,357 36,453 C 48,007 3 18,200,006 nothing D 31,186 4 23,909,187 nothing E 18,072 5 12,430,135 nothing F 6,127 6 594,514 nothing (Round to the nearest whole number as needed.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Elementary Geometry For College Students, 7eGeometryISBN:9781337614085Author:Alexander, Daniel C.; Koeberlein, Geralyn M.Publisher:Cengage,
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Elementary Geometry For College Students, 7e
Geometry
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Cengage,
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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
Statistics 4.1 Point Estimators; Author: Dr. Jack L. Jackson II;https://www.youtube.com/watch?v=2MrI0J8XCEE;License: Standard YouTube License, CC-BY
Statistics 101: Point Estimators; Author: Brandon Foltz;https://www.youtube.com/watch?v=4v41z3HwLaM;License: Standard YouTube License, CC-BY
Central limit theorem; Author: 365 Data Science;https://www.youtube.com/watch?v=b5xQmk9veZ4;License: Standard YouTube License, CC-BY
Point Estimate Definition & Example; Author: Prof. Essa;https://www.youtube.com/watch?v=OTVwtvQmSn0;License: Standard Youtube License
Point Estimation; Author: Vamsidhar Ambatipudi;https://www.youtube.com/watch?v=flqhlM2bZWc;License: Standard Youtube License