Business Analytics
3rd Edition
ISBN: 9780135231715
Author: Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter A3, Problem 9PE
To determine
To create charts and dashboards for database of people choice bank.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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.
The 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.
Please help with (d)
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
- Block: _ Date. Five year-old Susie's parents are concerned that she seems short for her age. Their doctor has the followng rer of Susie' height: Age (months): 20 30 45 50 57 60 Height (cm): 80 86 87 90 91 94 (a) Make a scatterplot of these data:arrow_forwardExplain why there is a need to present results/data through graphs and tables.arrow_forwardPLEASE HELParrow_forward
- 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_forwardPlease help asap with this. thank you!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_forward
- Describe about the three positive relationships of Scatterplots?arrow_forwardThe data represent the cost, return on investment, and graduation rate for a random sample of fifty colleges or universities in the United States. The data is from payscale.com. The variable "Cost" represents the four-year cost including tuition, supplies, room and board of attending the school. The variable "Annual ROI" represents the return on investment for graduates of the school. It essentially represents how much you would earn on the investment of attending the school. The variable "Grad Rate" represents the graduation rate of the school. Complete parts (a) and (b) below. Click here to view the school data. Click here to view the table of critical values of the correlation coefficient. (a) Describe the association between Cost and Graduation Rate graphically by drawing a scatter diagram, treating Cost as the explanatory variable. Describe the association between Cost and Graduation Rate by finding the linear correlation between the two variables. Is there a linear association…arrow_forwardI need help with this problem please.arrow_forward
- You've heard of "Florida Man;" now meet "Florida Bear." This problem involves data from a subspecies of black bear found in Florida, Ursus americanus floridanus. The data were collected by T. D. Bartareau as part of a study published in the Journal of Fish and Wildlife Management (2017, vol 8, pp 234- 239). Before you begin consult the info sheet included at the end (a) Do you predict an allometric or isometric scaling relationship between body weight and body length? Explain. (b) Based on your answer to part a, what would a plot of log body weight (vertical axis) versus log body length (horizontal axis) look like? (c) Using the data provided, create a plot of log body weight versus log body length. Make sure to label the axes. Why might someone think your plot fails to provide clear support for your claim in part b? (d) Using the tools described on the info sheet to isolate portions of the dataset, refine your use of data in part c to strengthen support for your claim in b. Why does…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_forwardEach week the Wall Street Journal and Harris Interactive track the opinions and experiences of college recruiters for large corporations and summarize the results in the Business School Survey. Data have been gathered for the top 10 business schools from a list of 76 and is summarized below. Please complete the questions below and upload this document and your EXCEL document to the portal in CANVAS. School Ranking Enrollment (# of full-time students) Annual Tuition ($) Mean GMAT % with Job Offer Average Salary ($) Dartmouth 1 503 38,400 704 89 119,800 Michigan 2 1873 33,076 690 91 105,986 Carnegie Mellon 3 661 38,800 691 93 95,531 Northwestern 4 2650 38,844 700 94 117,060 Yale 5 468 36,800 696 86 104,018 Pennsylvania 6 1840 40,458 716 92 117,471 California Berkeley 7 1281 21,512 701 92 112,699 Columbia 8 1796 38,290 709 95 126,319 North…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 Harcourt
Glencoe 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
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