Business Analytics (2nd Edition)
2nd Edition
ISBN: 9780321997821
Author: James R. Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 5PE
Create a bubble chart for the first five colleges in the Excel file Colleges and Universities for which the x-axis is the Top 10% HS. y-axis is Acceptance Rate, and bubbles repesent the Expenditures per Student.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The 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…
uppose 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…
Please answer number 3 from a-c. Neglect the number 2 questions. Thanks.
Chapter 3 Solutions
Business Analytics (2nd Edition)
Ch. 3 - Create a line chart for the closing prices for all...Ch. 3 - Create a pie chart showing the breakdown of...Ch. 3 - The Excel tile Facebook Survey provides data...Ch. 3 - A national homebuilder builds single-family homes...Ch. 3 - Create a bubble chart for the first five colleges...Ch. 3 - Construct a column chart for the data in the Excel...Ch. 3 - The Excel file Internet Usage provides data about...Ch. 3 - Construct an appropriate chart to show the...Ch. 3 - In the Excel file Banking Data, apply the...Ch. 3 - Apply three different colors of data bars to...
Ch. 3 - For the Store and Regional Sales database, apply a...Ch. 3 - For the Excel file Closing Stock Prices, Apply...Ch. 3 - Convert the Store and Regional Sales database to...Ch. 3 - Prob. 14PECh. 3 - Prob. 15PECh. 3 - Prob. 16PECh. 3 - Prob. 17PECh. 3 - In the Purchase Orders database, conduct a Pareto...Ch. 3 - Use Excels filtering capability to (1) extract all...Ch. 3 - Prob. 20PECh. 3 - The Excel file Credit Risk Date Provides...Ch. 3 - Prob. 22PECh. 3 - Prob. 23PECh. 3 - A community health-status survey obtained the...Ch. 3 - Prob. 25PECh. 3 - Prob. 26PECh. 3 - Prob. 27PECh. 3 - Prob. 28PECh. 3 - Prob. 29PECh. 3 - Prob. 30PECh. 3 - Find the 10th and 90th percentiles and 1st, 2nd,...Ch. 3 - Construct cross-tabulations of Gender versus...Ch. 3 - Use PivotTables to construct a cross-tabulation...Ch. 3 - Use PivotTables to construct a cross-tabulation...Ch. 3 - Create a PivotTable to find the average amount of...Ch. 3 - Use PivotTables to find the number of loans by...Ch. 3 - Use PivotTables to find the number of sales...Ch. 3 - Create a PivotTable for the data in the Excel file...Ch. 3 - The Excel File Rins Gym provides sample data on...Ch. 3 - Create useful dashboards for each of the following...Ch. 3 - A marketing researcher surveyed 92 individuals,...
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
- If you graph a revenue and cost function, explain how to determine in what regions there is profit.arrow_forwardIf you are performing a break-even analysis for a business and their cost and revenue equations are dependent, explain what this means for the company's profit margins.arrow_forwardThe local Ice Cream shop keeps a track of how much ice cream they sell vs. the temperature on that day. Here are their figures for the last 12 monthly: Month: Jan., Feb., Mar., Apr., May, Jun., Jul., Aug., Sep., Oct., Nov., Dec. Temperature in Ferenheit: 57.5, 61.5, 53.4, 59.3, 65.3, 71.7, 66.9, 77.1, 74.1, 64.5, 72.6, 62.9 Ice Cream Sales: 215, 325, 185, 332, 406, 522, 412, 614, 544, 421, 445, 408 How does the average monthly temperature affect the number of ice cream they sell vs the temperature on that day?arrow_forward
- Suppose classmates who graduated in 2004 compared their median incomes ten years later. The bar graph displays the median income, in thousands of dollars, for each classmate during the time intervals from 2005‑2009 and 2010‑2014. For the individual with the largest dollar value increase in median income over the two time intervals, determine the amount of increase.arrow_forwardJamie's grade point average isarrow_forwardWould the number of items in your grocery cart be discrete or continuous data?arrow_forward
- A pediatrician records the age x (in yr) and average height y (in inches) for girls between the ages of 2 and 10. Height of Girls vs. Age 50- 40- (4,38) 30- 10- 0 Age(yr) Part: 0 / 4 Part 1 of 4 (a) Use the points (4, 38) and (8, 50) to write a linear model for these data. X y = Skip Part Check Height (in.) (8,50) Ⓒ2022 McGraw Hill LLC. All Rights Reserve Aarrow_forwardAs the leader of the sales team, you would like to increase the revenue brought by your team. You discovered a program for sales personnel that supposedly improve interpersonal skills and thus help settle deals with customers more often. You decide to send8 of your sales people for the training, and compare the amount they brought in sales in the month before they went and in the month after they received the training. The data are: Xbefore: 400, 300, 1200, 2100, 700, 450, 650, 3400 Xafter: 1000, 400, 1000, 2500, 1200, 600, 800, 3000 A. Identify the appropriate statistical measure to use. B. Conduct the test. Make a decision about the null hypothesis, interpret your results and calculate effect size if applicable. At ?=.05, can you report to upper management that the training worked? Or was it a waste of money? C. Calculate 95% confidence intervals for the estimate of the difference.arrow_forwardThe spreadsheet at MarathonWinningTimes.xlsx shows the history of the winning time in the Boston Marathon for men and women from 1966 (when women first ran) through 2013. What is the average rate at which the men’s finishing time changed from year to year?arrow_forward
- Draw a scatter diagram with square feet of living space as the independent variable and selling price as the dependent variable and describe variable and describe the relationship between the size of a house and the selling price.arrow_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_forwardThe 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.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
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
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY