Description
1. The excel file GDPlist contains list of 125 countries by continents on which they are located, and their respective gross domestic products (GDPs) in US dollars. Open the file in excel and do the following
a. Sort the countries in GDOlist from largest to smallest GDP. What are the top 10 countries according to GDP?
b. Filter the countries to display only the countries located in Africa. What are the top 5 countries according to GDP?
c. What are the top 5 countries that are located in Europe?
———————————————
2.On-Time Performance of Logistics Companies. 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 (excel file carriers) contains a list of the carriers used by Ohio Logistics and the corresponding on-time percentages for the current and previous years.
Carrier
Previous Year On-time Percentage
Current Year On-time Percentage
aBlue Box Shipping
88.4%
94.8%
Cheetah LLC
89.3%
91.8%
Granite State Carriers
81.8%
87.6%
Honsin Limited
74.2%
80.1%
Jones Brothers
68.9%
82.8%
Minuteman Company
91.0%
84.2%
Rapid Response
78.8%
70.9%
Smith Logistics
84.3%
88.7%
Super Freight
92.1%
86.8%
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?
———————————————–
Most Visited Web Sites. In a recent report, the top five most-visited English-language web sites were google.com (GOOG), facebook.com (FB), youtube.com (YT), yahoo.com (YAH), and wikipedia.com (WIKI). The most-visited web sites for a sample of 50 Internet users are shown in the (excel file websites) following table
Are these data categorical or quantitative?
Provide frequency and percent frequency distributions.
On the basis of the sample, which web site is most frequently the most-often-visited web site for Internet users? Which is second?
Preferred Show
YAH
WIKI
YT
WIKI
GOOG
YT
YAH
GOOG
GOOG
GOOG
WIKI
GOOG
YAH
YAH
YAH
YAH
YT
GOOG
YT
YAH
GOOG
FB
FB
WIKI
GOOG
GOOG
GOOG
FB
FB
WIKI
FB
YAH
YT
YAH
YAH
YT
GOOG
YAH
FB
FB
WIKI
GOOG
YAH
WIKI
- WIKI
YAH
YT
GOOG
GOOG
WIKI
