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
Write a Regression summary explaining significance of mode, explaining regression coefficients, significance of the independent variables, R and R square.
Premiums earned
Net income
Dividends
Underwriting Gain/ Loss
30.2
1.6
0.6
0.1
47.2
0.6
0.7
-3.6
92.8
8.4
1.8
-1.5
95.4
7.6
2
-4
100.4
6.3
2.2
-8.1
104.9
6.3
2.4
-10.8
113.2
2.2
2.3
-18.2
130.3
3.0
2.4
-21.4
161.9
13.5
2.3
-12.8
182.5
14.9
2.9
-5.9
193.3
11.7
2.9
-7.6
1- Let A = {A1, A2, ...), in which A, A, = 0, when i j.
a) Is A a π-system? If not, which element(s) should be added to A to become a π-system?
b) Prove that σ(A) consists of the finite or countable unions of elements of A; i.c., A E σ(A) if and
only if there exists finite or countable sequence {n} such that A = U₁An (Hint: Let F be such
class; prove that F is a σ-filed containing A.)
c) Let p ≥ 0 be a sequence of non-negative real numbers with Σip₁ = 1. Using p₁'s, how do you
construct a probability measure on σ(A)? (Hint: use extension theorem.)
2- Construct an example for which P(lim sup A,) = 1 and P(lim inf An) = 0.
In a town with 5000 adults, a sample of 50 is selected using SRSWOR and asked their opinion of a proposed municipal project; 30 are found to favor it and 20 oppose it. If, in fact, the adults of the town were equally divided on the proposal, what would be the probability of observing what has been observed? Approximate using the Binomial distribution. Compare this with the exact probability which is 0.0418.
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
- Good explanation it sure experts solve itarrow_forwardBest explains it not need guidelines okkarrow_forwardActiv Determine compass error using amplitude (Sun). Minimum number of times that activity should be performed: 3 (1 each phase) Sample calculation (Amplitude- Sun): On 07th May 2006 at Sunset, a vessel in position 10°00'N 010°00'W observed the Sun bearing 288° by compass. Find the compass error. LMT Sunset: LIT: (+) 00d 07d 18h 00h 13m 40m UTC Sunset: 07d 18h 53m (added- since longitude is westerly) Declination (07d 18h): N 016° 55.5' d (0.7): (+) 00.6' Declination Sun: N 016° 56.1' Sin Amplitude = Sin Declination/Cos Latitude = Sin 016°56.1'/ Cos 10°00' = 0.295780189 Amplitude=W17.2N (The prefix of amplitude is named easterly if body is rising, and westerly if body is setting. The suffix is named same as declination) True Bearing=287.2° Compass Bearing= 288.0° Compass Error = 0.8° Westarrow_forward
- Only sure experts solve it correct complete solutions okkarrow_forward13. In 2000, two organizations conducted surveys to ascertain the public's opinion on banning gay men from serving in leadership roles in the Boy Scouts.• A Pew poll asked respondents whether they agreed with "the recent decision by the Supreme Court" that "the Boy Scouts of America have a constitutional right to block gay men from becoming troop leaders."A Los Angeles Times poll asked respondents whether they agreed with the following statement: "A Boy Scout leader should be removed from his duties as a troop leader if he is found out to be gay, even if he is considered by the Scout organization to be a model Boy Scout leader."One of these polls found 36% agreement; the other found 56% agreement. Which of the following statements is true?A) The Pew poll found 36% agreement, and the Los Angeles Times poll found 56% agreement.B) The Pew poll includes a leading question, while the Los Angeles Times poll uses neutral wording.C) The Los Angeles Times Poll includes a leading question, while…arrow_forwardAnswer questions 2arrow_forward
- (c) Give an example where PLANBAC)= PCAPCBIPCC), but the sets are not pairwise independentarrow_forwardScrie trei multiplii comuni pentru numerele 12 și 1..arrow_forwardIntroduce yourself and describe a time when you used data in a personal or professional decision. This could be anything from analyzing sales data on the job to making an informed purchasing decision about a home or car. Describe to Susan how to take a sample of the student population that would not represent the population well. Describe to Susan how to take a sample of the student population that would represent the population well. Finally, describe the relationship of a sample to a population and classify your two samples as random, systematic, cluster, stratified, or convenience.arrow_forward
- 1.2.17. (!) Let G,, be the graph whose vertices are the permutations of (1,..., n}, with two permutations a₁, ..., a,, and b₁, ..., b, adjacent if they differ by interchanging a pair of adjacent entries (G3 shown below). Prove that G,, is connected. 132 123 213 312 321 231arrow_forwardYou are planning an experiment to determine the effect of the brand of gasoline and the weight of a car on gas mileage measured in miles per gallon. You will use a single test car, adding weights so that its total weight is 3000, 3500, or 4000 pounds. The car will drive on a test track at each weight using each of Amoco, Marathon, and Speedway gasoline. Which is the best way to organize the study? Start with 3000 pounds and Amoco and run the car on the test track. Then do 3500 and 4000 pounds. Change to Marathon and go through the three weights in order. Then change to Speedway and do the three weights in order once more. Start with 3000 pounds and Amoco and run the car on the test track. Then change to Marathon and then to Speedway without changing the weight. Then add weights to get 3500 pounds and go through the three gasolines in the same order.Then change to 4000 pounds and do the three gasolines in order again. Choose a gasoline at random, and run the car with this gasoline at…arrow_forwardAP1.2 A child is 40 inches tall, which places her at the 90th percentile of all children of similar age. The heights for children of this age form an approximately Normal distribution with a mean of 38 inches. Based on this information, what is the standard deviation of the heights of all children of this age? 0.20 inches (c) 0.65 inches (e) 1.56 inches 0.31 inches (d) 1.21 inchesarrow_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