Business Analytics
3rd Edition
ISBN: 9780135231715
Author: Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter A3, Problem 7PE
Use PivotCharts to create a useful dashboard for the data in the Excel file Store and Regional Sales. Explain why you chose the elements of the dashboard and how a manager might use them.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The data in the picture contains purchase data for golf purchases. Create a doughnut chart in Excel to compare the purchases by gender each year with the US population. Below the chart, explain what it illustrates.
Describe the three primary charts and graphs used to organize and display data.
Find the five-number summary of the data. Be sure to include the screenshot of excel of your answers and formulas/command that you use.
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
- The Toyota Camry is one of the best-selling cars in North America. The cost of a previously owned Camry depends on many factors, including the model year, mileage, and condition. To investigate the relationship between the car's mileage and the sales price for Camrys, the following data show the mileage and sale price for 19 sales (PriceHub web site, February 24, 2012). DATA file Miles (1,000s) Price ($1,000s) 22 16.2 29 16.0 36 13.8 47 11.5 63 12.5 77 12.9 73 11.2 87 13.0 92 11.8 101 10.8 110 8.3 28 12.5 59 11.1 68 15.0 68 12.2 91 13.0 42 15.6 65 12.7 110 8.3arrow_forwardthe data file is just a blank excel sheet, you do not need to see it to access information.arrow_forwardThe Toyota Camry is one of the best-selling cars in North America. The cost of a previously owned Camry depends upon many factors, including the model year, mileage, and condition. To investigate the relationship between the car's mileage and the sales price for a 2007 model year Camry, the following data show the mileage and sale price for 19 sales (PriceHub website). Click on the datafile logo to reference the data. DATA file Price ($1000s) Miles (1000s) 22 16.2 29 16.0 36 13.8 47 11.5 63 12.5 77 12.9 73 11.2 87 13.0 92 11.8 101 10.8 110 8.3 28 12.5 59 11.1 68 15.0 68 12.2 91 13.0 42 15.6 65 12.7 110 8.3 If your answer is zero, enter "0". a. Select a scatter diagram with the car mileage on the horizontal axis and the price on the vertical axis.arrow_forward
- An insurance company crashed four cars in succession at 5 miles per hour. The cost of repair for each of the crashes was $421,$465,$412,$218. Compute the range of dataarrow_forwardA high school guidance counselor analyzed data from a sample of 200 community colleges throughout the United States. One of his goals was to estimate the annual tuition costs of community colleges in the United States. Describe the population and variable of interest to the guidance counselor. Why?arrow_forwardPlease explain all work, including use of excel.arrow_forward
- What would be a suitable chart type to show the proportions of the sales by products?arrow_forward16 20 40 60 80 100 Miles (1000s) 120 Scatter diagram 1 b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? Negative relationship c. Develop the estimated regression equation that could be used to predict the price ($1000s) (to 4 decimals). 16.469 .0588 I d. Test for a significant relationship at the 0.05 level of significance (to 3 decimals). p-value= less than α = 0.05. e. Did the estimated regression equation provide a good fit? Yes f. Provide terpretation for the slope of the estimated regression equation (to 4 decimals but dollar value to the nearest cent). Enter negative values as negative numbers. The slope of the estimated regression is -.0588. Therefore, every additional 1,000 miles on the car's odometr will result in a $ predicted price. decrease in the g. Suppose that you are considering purchasing a previously owned 2007 Camry that has been driven 60,000 miles. Using the estimated regression equation developed in…arrow_forwardIf you could use a chart like this example to help me visualize everything thank you.arrow_forward
- Recently, management at Oak Tree Golf Course received a few complaints about the condition of the greens. Several players complained that the greens are too fast. Rather than react to the comments of just a few, the Golf Association conducted a survey of 100 male and 100 female golfers. The survey results are summarized here. Excel File: data02-31.xlsx Male Golfers Green Condition Gender Too Fast Male Handicap Under 15 15 or more 25 25 a. Complete the crosstabulation shown below. Green Condition Female Too Fast 10 Fine Fine 40 Female Golfers Total Green Condition Handicap Under 15 15 or more Too Fast 1 Fine 9 39 51 Total Which group shows the highest percentage saying that the greens are too fast? - Select your answer - b. Refer to the initial crosstabulations. For those players with low handicaps (better players), which group (male or female) shows the highest percentage saying the greens are too fast? For the low handicappers, the - Select your answer - have a higher percentage who…arrow_forwardBicycling, the world's leading cycling magazine, reviews hundreds of bicycles throughout the year. Their "Road-Race" category contains reviews of bikes used by riders primarily interested in racing. One of the most important factors in selecting a bike for racing is the weight of the bike. The following data show the weight (pounds) and price ($) for 10 racing bikes reviewed by the magazine (Bicycling website). DATA file Brand FELT F5 PINARELLO Paris ORBEA Orca GDR EDDY MERCKX EMX-7 BH RC1 Ultegra BH Ultralight 386 CERVELO S5 Team GIANT TCR Advanced 2 WILIER TRIESTINA Gran Turismo (to 3 decimals) Weight Price ($) 17.8 16.1 14.9 15.9 Did the estimated regression equation provide a good fit? The estimated regression equation provided a - Select your answer - fit. c. Predict the price for a bike that weighs 15 pounds. (to whole number) 2100 6250 8370 6200 17.2 13.1 16.2 17.1 17.6 SPECIALIZED S-Works Amira SL4 14.1 8000 a. Use the data to develop an estimated regression equation that could…arrow_forwardList one possible confounding variable for this analysis and explain what impact it might have on the variables of interest.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Which is the best chart: Selecting among 14 types of charts Part II; Author: 365 Data Science;https://www.youtube.com/watch?v=qGaIB-bRn-A;License: Standard YouTube License, CC-BY