HW#2 - 1,3,4,7,8 are to be graded.xlsx

# HW#2 - 1,3,4,7,8 are to be graded.xlsx - Carrier Blue Box...

• Notes
• 24
• 100% (4) 4 out of 4 people found this document helpful

This preview shows page 1 - 6 out of 24 pages.

Carrier Blue Box Shipping 88.4% 94.8% 6.4% Cheetah LLC 89.3% 91.8% 2.5% Smith Logistics 84.3% 88.7% 4.4% Granite State Carriers 81.8% 87.6% 5.8% Super Freight 92.1% 86.8% -5.3% Minuteman Company 91.0% 84.2% -6.8% Jones Brothers 68.9% 82.8% 13.9% Honsin Limited 74.2% 80.1% 5.9% Rapid Response 78.8% 70.9% -7.9% Question A Sort the carriers in descending order by their current year’s percentage of on-time d Question B Calculate the change in percentage of on-time deliveries from the previous to the cu Question C Use Excel’s conditional formatting tool to create data bars for the change in percenta A) Rapid Response is the worst service of the year and Blue Box Shipping is the best ser C) Ohio Logistics should try to use Jones Brother in the future because data shows that Previous Year On-time Percentage Current Year On-time Percentage Percenta ge Change (20 points) The given data is for problem 3.2. Please complete parts a, b and c.

Subscribe to view the full document.

deliveries. Which carrier is providing the best service in the current year? Which carrier is providing the worst s urrent year for each carrier. Use Excel’s conditional formatting to highlight the carriers whose on-time percenta age of on-time deliveries from the previous year to the current year for each carrier calculated in part b. rvice of the year for delivering 94.8% on time this carrier is improving the most
service in the current year? age decreased from the previous year to the current year.

Subscribe to view the full document.

Class Relative frequency Frequency distribution % Frequency distribution A 0.22 44 22% B 0.18 36 18% C 0.4 80 40% D 0.2 40 20% 1 200 100% a. What is the relative frequency of class D? b. The total sample size is 200. What is the frequency of class D? c. Show the frequency distribution. d. Show the percent frequency distribution. A) 0.2 =SUM(1-C8-C9-C10) B) 40 =200*C11 C) D) (For practice) Please answer question 4.2. parts a, b, c and d. The solution is provided in Appendix C.
Preferred Show YAH WIKI FB WIKI GOOG Bins Frequency YT YAH GOOG GOOG GOOG GOOG 14 WIKI GOOG YAH YAH YAH YAH 13 YAH YT GOOG YT YAH WIKI 9 GOOG FB FB WIKI GOOG FB 8 GOOG

Subscribe to view the full document.

• Fall '17
• Standard Deviation, Frequency distribution, Honsin Limited, Smith Logistics, Granite State Carriers, Minuteman Company

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern