Homework 2
docx
keyboard_arrow_up
School
Hillsborough Community College *
*We aren’t endorsed by this school
Course
581
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
docx
Pages
5
Uploaded by coreano
Read the instructions for this homework,
Solve the following problems from the textbook Camm et.al.
When using Excel, get a screenshot of the output and paste it on the document.
1-
Problem 3 page 72
ch2
2-
Problem 6 page 74 ch2
3-
Problem 13 page 77 ch2
4-
Problem 14 page 77 ch2
Problem 3
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?
The best carrier who provided the best service in the current year is Blue Box Shipping with
94.8%, the opposite of this is the Rapid Response with only 70.9% being it the worst service in
carrier 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.
Based on the table above shows that Super Freight, Minuteman Company and Rapid Response
are the carriers with a decreased value from the current year to the previous 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?
Based on the table and data given Ohio Logistics should try to use Jones Brothers in the future
since considering the current year on time percentage of the said Carrier the change in On-time is
greater than the carriers given by the data.
Problem 6
A.
What is the least amount of time a CEO spent per week in meetings in this sample? The
highest?
Least =12, Highest 23
B.
Use a class width of 2 hours to prepare a frequency distribution and a percent frequency
distribution for the data.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
C.
Prepare a histogram and comment on the shape of the distribution.
Problem 13
Computing Mean and Median. Consider a sample with data values of 10, 20, 12, 17, and 16.
A.
Compute the mean and median.
B. Consider a sample with data values 10, 20, 12, 17, 16, and 12. How would you expect the
mean and median for these sample data to compare to the mean and median for part a (higher,
lower, or the same)? Compute the mean and median for the sample data 10, 20, 12, 17, 16, and
12.
Problem 14
Consider a sample with data values of 27, 25, 20, 15, 30, 34, 28, and 25. Compute the 20th, 25th,
65th, and 75th percentiles.