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
Videos
Textbook Question
Chapter 2, Problem 3P
Ohio Logistics manages the logistical activities for firms by matching companies that need products shipped with carriers that can provide the best rates and best service for the companies. Ohio Logistics is very concerned that its carriers deliver their customers’ material on time, so it carefully monitors the percentage of on-time deliveries. The following table contains a list of the carriers used by Ohio Logistics and the corresponding on-time percentages for the current and previous years.
- a. Sort the carriers in descending order by their current year’s percentage of on-time deliveries. Which carrier is providing the best service in the current year? Which carrier is providing the worst service in the current year?
- b. Calculate the change in percentage of on-time deliveries from the previous to the current year for each carrier. Use Excel’s conditional formatting to highlight the carriers whose on-time percentage decreased from the previous year to the current year.
- c. Use Excel’s conditional formatting tool to create data bars for the change in percentage of on-time deliveries from the previous year to the current year for each carrier calculated in part b.
- d. Which carriers should Ohio Logistics try to use in the future? Why?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The table to the right shows the arrival
data for two airlines in five cities.
Complete parts (a) through (c) below.
Excelsior Airlines
Percentage Number of
on-time arrivals
Destination
Los Angeles
94.5%
Phoenix
95.7%
San Diego
94.4%
San Francisco 83.5%
85.9%
Seattle
Total
440
277
101
631
2183
3632
Paradise Airlines
Percentage Number of
on-time
arrivals
87.9%
94.6%
88.6%
75.6%
72.8%
821
5177
406
405
259
7068
a. Which airline has the higher percentage of on-time flights to the five cities?
Excelsior Airlines has the higher percentage of on-time flights.
b. Compute the percentage of on-time flights for the two airlines over all five cities.
Over all five cities, Excelsior Airlines had an on-time percentage of % and Paradise Airlines had an on-time
percentage of %.
(Round to the nearest tenth as needed.)
Most Expensive Colleges Listed below are the annual costs (dollars) of tuition and fees at the 10 most expensive colleges in the United States for a recent year (based on data from U.S. News & World Report). The colleges listed in order are Columbia, Vassar, Trinity, George Washington, Carnegie Mellon, Wesleyan, Tulane, Bucknell, Oberlin, and Union. What does this “top 10” list tell us about those costs for the population of all U.S. college tuitions?
Please answer ASAP. Thank you!
Chapter 2 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 2 - A Wall Street Journal subscriber survey asked 46...Ch. 2 - The following table contains a partial list of...Ch. 2 - Ohio Logistics manages the logistical activities...Ch. 2 - A partial relative frequency distribution is...Ch. 2 - In a recent report, the top five most-visited...Ch. 2 - In a study of how chief executive officers (CEOs)...Ch. 2 - Consumer complaints are frequently reported to the...Ch. 2 - Reports have found that many U.S. adults would...Ch. 2 - Consider the following data: a. Develop a...Ch. 2 - Consider the following frequency distribution....
Ch. 2 - The owner of an automobile repair shop studied the...Ch. 2 - Approximately 1.65 million high school students...Ch. 2 - Consider a sample with data values of 10, 20, 12,...Ch. 2 - Consider a sample with data values of 27, 25, 20,...Ch. 2 - Consider a sample with data values of 53, 55, 70,...Ch. 2 - If an asset declines in value from 5,000 to 3,500...Ch. 2 - Suppose that you initially invested 10,000 in the...Ch. 2 - The average time that Americans commute to work is...Ch. 2 - Suppose that the average waiting time for a...Ch. 2 - According to the National Education Association...Ch. 2 - Return to the waiting times given for the...Ch. 2 - The results of a national survey showed that on...Ch. 2 - Suppose that the national average for the math...Ch. 2 - Five observations taken for two variables follow....Ch. 2 - The scatter chart in the following figure was...Ch. 2 - The economic downturn in 20082009 resulted in the...Ch. 2 - Heavenly Chocolates manufactures and sells quality...
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
- Jensen Tire & Auto is in the process of deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). Weekly Usage(hours) AnnualMaintenance Expense 19 24 16 29 26 37 34 44 38 54 23 38 30 40 37 46 46 59 44 47 -select your answer choices- b. p-value less than 0.01 between 0.01 and 0.025 between 0.025 and 0.05 between 0.05 and 0.10 greater than 0.10 Conclusion Do not conclude that there is a significant relationship between expense and weekly usage Conclude that there is a significant relationship between expense and weekly usage d. No, the expected maintenance expense is less than $3000 Yes, the expected maintenance expense is greater than $3000arrow_forwardReliable Furniture is a family business that has been selling to retail customers in the Oakville area for many years. It advertises extensively on radio and TV, emphasizing their its prices and easy credit terms. The owner would like to review the relationship between sales and the amount spent on advertising. Below is information on sales and advertising expense for the last four months. Ad Exp. Sales Rev. Month ($ in 000) ($ in 000) July 2 7 August 1 3 September 3 8 October 4 10 G-9 B continued Questions from G-9 e) Reproduce the excel output manually. f) Interpret the strength of the correlation coefficient. g) Determine the coefficient of determination. Interpret. h) Test the significance of the Coefficient of Correlation i) Test the significance of the slope coefficients of the regression equation.arrow_forwardReliable Furniture is a family business that has been selling to retail customers in the Oakville area for many years. It advertises extensively on radio and TV, emphasizing their its prices and easy credit terms. The owner would like to review the relationship between sales and the amount spent on advertising. Below is information on sales and advertising expense for the last four months. Ad Exp. Sales Rev. Month ($ in 000) ($ in 000) July 2 7 August 1 3 September 3 8 October 4 10 a) Determine the regression equation. b) Interpret the values of a and b. c) Estimate sales when $3 thousand is spent on advertising. Include the 95% confidence interval for average X d) Determine the coefficient of correlation.arrow_forward
- The following table provides monthly revenue values for Tedstar, Inc., a company thatsells valves to large industrial firms. The monthly revenue data have been graphed usinga line chart in the following figure. a. What are the problems with the layout and display of this line chart?b. Create a new line chart for the monthly revenue data at Tedstar, Inc. Format the chartto make it easy to read and interpret.arrow_forwardBob and Pat are trying to decide where to spend their retirement. They have narrowed the field to four retirement centers. Their decision will be based largely upon the quality of care offered at the hospitals local to each of the retirement communities. They are researching the closest vicinity hospital to each of the retirement centers, and they want to know each hospital's death rate. Use the statistics listed in Table 6 to calculate the gross death rate (rounded to 1 decimal place) for each retirement center. Table 6 Hospital Death Statistics Hospital Death Statistics Hospital Discharged Patients Inpatient Deaths Death Rates Northern Sea Breeze 223 23 Great Plains City 418 28 Rocky Mount Center 215 32 South Beach Cove 319 29…arrow_forwardJensen Tire & Auto is in the process of deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). Weekly Usage(hours) AnnualMaintenanceExpense 13 17.0 10 22.0 20 30.0 28 37.0 32 47.0 17 30.5 24 32.5 31 39.0 40 51.5 38 40.0 test statistic is 6.90 Find the p-value. (Round your answer to three decimal places.) p-value = State your conclusion. Reject H0. We conclude that the relationship between weekly usage (hours) and annual maintenance expense (in hundreds of dollars) is significant. Do not reject H0. We conclude that the relationship between weekly usage (hours) and annual maintenance expense (in hundreds of dollars) is significant. Reject H0. We cannot conclude that the relationship between weekly usage…arrow_forward
- In 2010, the U.S. Congress passed the historic health care reform bill that will provide some type of coverage for the 32 million Americans currently without health care insurance. Just how widespread is the lack of medical coverage? The media claim that the segments of the population most at risk for disease and thus needing healthcare are women, children, the elderly and the poor. The following tables were generated from the U.S. Census Bureau, Current Population Survey, Annual Social and Economic Supplement (2011). Explain using supportive arguments from your analyses. Write a general summary paragraph identifying groups lacking in coverage by gender, age and income and commenting on the headline. Reference the observed numbers and percentages in your summary paragraph to see how the groups trend in identifying potentially more at-risk. Analysises for reference: Is being insured or not dependent on gender? Fill in the degrees of freedom and p-value in the output below and draw…arrow_forwardIn 2010, the U.S. Congress passed the historic health care reform bill that will provide some type of coverage for the 32 million Americans currently without health care insurance. Just how widespread is the lack of medical coverage? The media claim that the segments of the population most at risk for disease and thus needing healthcare are women, children, the elderly and the poor. The following tables were generated from the U.S. Census Bureau, Current Population Survey, Annual Social and Economic Supplement (2011). The tables report the number of uninsured (in thousands) by sex, by age, and by household income. Is being insured or not dependent on gender? Fill in the degrees of freedom and p-value in the output below and draw a clear conclusion indicating which gender is more at risk of not being insured if there is a significant difference.arrow_forwardIn 2010, the U.S. Congress passed the historic health care reform bill that will provide some type of coverage for the 32 million Americans currently without health care insurance. Just how widespread is the lack of medical coverage? The media claim that the segments of the population most at risk for disease and thus needing healthcare are women, children, the elderly and the poor. The following tables were generated from the U.S. Census Bureau, Current Population Survey, Annual Social and Economic Supplement (2011). The tables report the number of uninsured (in thousands) by sex, by age, and by household income Is being insured or not dependent on the income groups identified in the analysis? Fill in the degrees of freedom and p-value in the output below and draw a clear conclusion indicating which income-groups are more at risk of not being insured if there is a significant relationship.arrow_forward
- An experienced census official feels that she can accurately estimate the number of inhabitants of a city block by simply noting the size of the block and the types of buildings (single family homes, apartments, businesses, etc.) that are found on the block. This procedure, if accurate, would be much quicker and cheaper than visiting each residence and taking a survey of its inhabitants. The data below are estimates of block populations provided by the official for 10 blocks in a large city, and the actual numbers of inhabitants for the same 10 blocks. Estimate 211 160 Actual Inhabitants of City Blocks 145 97 165 145 90 180 210 220 125 200 110 95 180 200 225 130 210 60 Copy Data Step 1 of 2: Find the value of the test statistic for testing whether there is a linear relationship between the actual number of inhabitants and the estimated number. Round your answer to two decimal places, if necessary.arrow_forwardThe activities for Christina's Visa Card account for one billing period is shown below. The previous balance on (June 7) was $2793.14 Christina's Visa Card Activities (June 7 - July 7) Description Billing date Shopping Date Amount June 7 $2793.14 June 11 $162.55 June 16 Restaurant $123 June 19 $1500 Payment Sam's Club and gas June 22 July 4 $179.37 Entertainment $60.56 Determine the average daily balance for the next billing (July 7). Express the amount in two decimal places. For example, 23.45, or 57.20, or 89.00. The average daily balance for the next billing (July 7) is $arrow_forwardA manager of a large corporation recommends a $10,000 raise be given to keep a valuedsubordinate from moving to another company. What internal and external sources of datamight be used to decide whether such a salary increase is appropriate?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
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
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
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY