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
Sketch to scale the orbit of Earth about the sun. Graph Icarus’ orbit on the same set of axesWhile the sun is the center of Earth’s orbit, it is a focus of Icarus’ orbit. There aretwo points of intersection on the graph. Based on the graph, what is the approximate distance between the two points of intersection (in AU)?
The diameters of ball bearings are distributed normally. The mean diameter is 67 millimeters and the standard deviation is 3 millimeters. Find the probability that the diameter of a selected bearing is greater than 63 millimeters. Round to four decimal places.
Suppose you like to keep a jar of change on your desk. Currently, the jar contains the following:
22 Pennies 27 Dimes
9 Nickels 30 Quarters
What is the probability that you reach into the jar and randomly grab a penny and then, without replacement, a dime? Express as a fraction or a decimal number rounded to four decimal places.
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
- A box contains 14 large marbles and 10 small marbles. Each marble is either green or white. 9 of the large marbles are green, and 4 of the small marbles are white. If a marble is randomly selected from the box, what is the probability that it is small or white? Express as a fraction or a decimal number rounded to four decimal places.arrow_forwardCan I get help with this step please? At a shooting range, instructors can determine if a shooter is consistently missing the target because of the gun sight or because of the shooter's ability. If a gun's sight is off, the variance of the distances between the shots and the center of the shot pattern will be small (even if the shots are not in the center of the target). A student claims that it is the sight that is off, not his aim, and wants the instructor to confirm his claim. If a skilled shooter fires a gun at a target multiple times, the distances between the shots and the center of the shot pattern, measured in centimeters (cm), will have a variance of less than 0.33. After the student shoots 28 shots at the target, the instructor calculates that the distances between his shots and the center of the shot pattern, measured in cm, have a variance of 0.25. Does this evidence support the student's claim that the gun's sight is off? Use a 0.025 level of significance. Assume that the…arrow_forwardThe National Academy of Science reported that 38% of research in mathematics is published by US authors. The mathematics chairperson of a prestigious university wishes to test the claim that this percentage is no longer 38%. He has no indication of whether the percentage has increased or decreased since that time. He surveys a simple random sample of 279 recent articles published by reputable mathematics research journals and finds that 123 of these articles have US authors. Does this evidence support the mathematics chairperson's claim that the percentage is no longer 38 % ? Use a 0.02 level of significance. Compute the value of the test statistic. Round to two decimal places.arrow_forward
- A marketing research company desires to know the mean consumption of milk per week among males over age 32. They believe that the milk consumption has a mean of 4 liters, and want to construct a 98% confidence interval with a maximum error of 0.07 liters. Assuming a variance of 0.64 liters, what is the minimum number of males over age 32 they must include in their sample? Round up to the next integer.arrow_forwardSuppose GRE Verbal scores are normally distributed with a mean of 461 and a standard deviation of 118. A university plans to recruit students whose scores are in the top 4 % . What is the minimum score required for recruitment? Round to the nearest whole number, if necessaryarrow_forwardNeed help with my homework thank you random sample of 6 fields of durum wheat has a mean yield of 45.5 bushels per acre and standard deviation of 7.43 bushels per acre. Determine the 80 % confidence interval for the true mean yield. Assume the population is approximately normal. Step 1: Find the critical value that should be used in constructing the confidence interval. Round to three decimal places. Step 2 of 2: Construct the 80% confidence interval. Round to one decimal place. I got 1.476 as my critical value and 41.0 and 49.9 as my confidence intervalarrow_forward
- Can someone check my work? If you draw a card with a value of four or less from a standard deck of cards, I will pay you $14. If not, you pay me $8. (Aces are considered the highest card in the deck.) Step 1 of 2: Find the expected value of the proposition. Round to two decimal places. Losses must be expressed as negative values. PT 2: If you played this game 718 times how much would you expect to win or lose? Round your answer to two decimal places. Losses must be expressed as negative values. for part 1 I got -2.92 pt 2 -2097.56arrow_forwardThe following table describes the distribution of a random sample S of 200 individuals, arranged by education level and income. Income(Dollars per Year) < High School High School Diploma Some College Bachelor’s Degree Graduate Degree Post-Graduate Degree 0-25,000 12 8 3 2 1 0 25,000-50,000 7 12 9 12 11 2 50,000-75,000 1 3 4 6 14 5 75,000-100,000 0 2 1 8 11 8 100,000-125,000 0 1 1 4 8 9 125,000-150,000 0 0 2 3 7 12 150,000+ 0 0 1 1 3 6 Let events be defined as follows: A = the event the subject makes 0-25,000 dollars per yearB = the event the subject makes 25,000-50,000 dollars per year C = the event the subject makes 50,000-75,000 dollars per yearD = the event the subject makes 75,000-100,000 dollars per yearE = the event the subject makes 100,000-125,000 dollars per yearF = the event the subject makes 125,000-150,000 dollars per yearG = the event…arrow_forwardwhat does the central limit theorem, for all samples of the same size n with n>30, the sampling distribution of x can be approximated by a normal distribution mean? What is a real life example using this theoremarrow_forward
- An investigator analyzed the leading digits from 797 checks issued by seven suspect companies. The frequencies were found to be 0, 19, 2, 50, 361, 309, 10, 22, and 24, and those digits correspond to the leading digits of 1, 2, 3, 4, 5, 6, 7, 8, and 9, respectively. If the observed frequencies are substantially different from the frequencies expected with Benford's law shown below, the check amounts appear to result from fraud. Use a 0.10 significance level to test for goodness-of-fit with Benford's law. Does it appear that the checks are the result of fraud? Leading Digit Actual Frequency Benford's Law: Distribution of Leading Digits 1 2 3 4 5 6 7 8 9 0 19 2 50 361 309 10 22 24 30.1% 17.6% 12.5% 9.7% 7.9% 6.7% 5.8% 5.1% 4.6% Determine the null and alternative hypotheses. Ho The leading digits are from a population that conforms to Benford's law. H₁: At least one leading digit has a frequency that does not conform to Benford's law. Calculate the test statistic, x². x² = (Round to three…arrow_forwardFor the distribution drawn here, identify the mean, median, and mode. Question content area bottom Part 1 A. Aequalsmode, Bequalsmedian, Cequalsmean B. Aequalsmode, Bequalsmean, Cequalsmedian C. Aequalsmedian, Bequalsmode, Cequalsmean D. Aequalsmean, Bequalsmode, Cequalsmedianarrow_forwardA study was done using a treatment group and a placebo group. The results are shown in the table. Assume that the two samples are independent simple random samples selected from normally distributed populations, and do not assume that the population standard deviations are equal. Complete parts (a) and (b) below. Use a 0.05 significance level for both parts. a. Test the claim that the two samples are from populations with the same mean. What are the null and alternative hypotheses? OA. Ho PP2 H₁: P1 P2 OC. Ho H₁₂ H₁: P₁arrow_forwardarrow_back_iosSEE MORE QUESTIONSarrow_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