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...

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.
Image of page 1

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
Image of page 2
service in the current year? age decreased from the previous year to the current year.
Image of page 3

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.
Image of page 4
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
Image of page 5

Subscribe to view the full document.

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

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern