Descriptive Statistics
SOLUTION MANUAL
SOLUTION MANUAL 2 -
Any Issue? Contact me here
, Descriptive Statistics
Chapter 2
Descriptive Statistics
Solutions:
1. a. Quantitative
b. Categorical
c. Categorical
d. Quantitative
e. Categorical
2. a. The top 10 countries according to GDP are listed below.
Country Continent GDP (millions of US$)
United States North America 15,094,025
China Asia 7,298,147
Japan Asia 5,869,471
Germany Europe 3,577,031
France Europe 2,776,324
Brazil South America 2,492,908
United Kingdom Europe 2,417,570
Italy Europe 2,198,730
Russia Asia 1,850,401
Canada North America 1,736,869
b. The top 5 countries by GDP located in Africa are listed below.
Country Continent GDP (millions of US$)
South Africa Africa 408,074
Nigeria Africa 238,920
Egypt Africa 235,719
Algeria Africa 190,709
Angola Africa 100,948
c. The top-five European countries by GDP are: Germany, France, the United Kingdom, Italy, and
Spain.
3. a. The sorted list of carriers appears below.
2 -
Any Issue? Contact me here
, Descriptive Statistics
Previous Year Current Year
On-time On-time
Carrier Percentage Percentage
Blue Box Shipping 88.4% 94.8%
Cheetah LLC 89.3% 91.8%
Smith Logistics 84.3% 88.7%
Granite State Carriers 81.8% 87.6%
Super Freight 92.1% 86.8%
Minuteman Company 91.0% 84.2%
Jones Brothers 68.9% 82.8%
Honsin Limited 74.2% 80.1%
Rapid Response 78.8% 70.9%
Blue Box Shipping is providing the best on-time service in the current year. Rapid Response is
providing the worst on-time service in the current year.
b. The output from Excel with conditional formatting appears below.
c. The output from Excel containing data bars appears below.
d. The top 4 shippers based on current year on-time percentage (Blue Box Shipping, Cheetah LLC,
Smith Logistics, and Granite State Carriers) all have positive increases from the previous year and
high on-time percentages. These are good candidates for carriers to use in the future.
4. a. The relative frequency of D is 1.0 – 0.22 – 0.18 – 0.40 = 0.20.
2 -
Any Issue? Contact me here
, Descriptive Statistics
b. If the total sample size is 200 the frequency of D is 0.20*200 = 40.
c. and d.
Class Relative Frequency Frequency % Frequency
A 0.22 44 22
B 0.18 36 18
C 0.40 80 40
D 0.20 40 20
Total 1.0 200 100
5. a. These data are categorical.
b.
Web %
site Frequency Frequency
FB 7 14
GOOG 14 28
WIKI 9 18
YAH 13 26
YT 7 14
Total 50 100
c. The most frequent most-visited-web site is google.com (GOOG); second is yahoo.com (YAH).
6. a. Least = 12, Highest = 23
b.
Percent
Hours in Meetings per
Week Frequency Frequency
11–12 1 4
13–14 2 8
15–16 6 24
17–18 3 12
19–20 5 20
21–22 4 16
23–24 4 16
Total 25 100
2 -
Any Issue? Contact me here
SOLUTION MANUAL
SOLUTION MANUAL 2 -
Any Issue? Contact me here
, Descriptive Statistics
Chapter 2
Descriptive Statistics
Solutions:
1. a. Quantitative
b. Categorical
c. Categorical
d. Quantitative
e. Categorical
2. a. The top 10 countries according to GDP are listed below.
Country Continent GDP (millions of US$)
United States North America 15,094,025
China Asia 7,298,147
Japan Asia 5,869,471
Germany Europe 3,577,031
France Europe 2,776,324
Brazil South America 2,492,908
United Kingdom Europe 2,417,570
Italy Europe 2,198,730
Russia Asia 1,850,401
Canada North America 1,736,869
b. The top 5 countries by GDP located in Africa are listed below.
Country Continent GDP (millions of US$)
South Africa Africa 408,074
Nigeria Africa 238,920
Egypt Africa 235,719
Algeria Africa 190,709
Angola Africa 100,948
c. The top-five European countries by GDP are: Germany, France, the United Kingdom, Italy, and
Spain.
3. a. The sorted list of carriers appears below.
2 -
Any Issue? Contact me here
, Descriptive Statistics
Previous Year Current Year
On-time On-time
Carrier Percentage Percentage
Blue Box Shipping 88.4% 94.8%
Cheetah LLC 89.3% 91.8%
Smith Logistics 84.3% 88.7%
Granite State Carriers 81.8% 87.6%
Super Freight 92.1% 86.8%
Minuteman Company 91.0% 84.2%
Jones Brothers 68.9% 82.8%
Honsin Limited 74.2% 80.1%
Rapid Response 78.8% 70.9%
Blue Box Shipping is providing the best on-time service in the current year. Rapid Response is
providing the worst on-time service in the current year.
b. The output from Excel with conditional formatting appears below.
c. The output from Excel containing data bars appears below.
d. The top 4 shippers based on current year on-time percentage (Blue Box Shipping, Cheetah LLC,
Smith Logistics, and Granite State Carriers) all have positive increases from the previous year and
high on-time percentages. These are good candidates for carriers to use in the future.
4. a. The relative frequency of D is 1.0 – 0.22 – 0.18 – 0.40 = 0.20.
2 -
Any Issue? Contact me here
, Descriptive Statistics
b. If the total sample size is 200 the frequency of D is 0.20*200 = 40.
c. and d.
Class Relative Frequency Frequency % Frequency
A 0.22 44 22
B 0.18 36 18
C 0.40 80 40
D 0.20 40 20
Total 1.0 200 100
5. a. These data are categorical.
b.
Web %
site Frequency Frequency
FB 7 14
GOOG 14 28
WIKI 9 18
YAH 13 26
YT 7 14
Total 50 100
c. The most frequent most-visited-web site is google.com (GOOG); second is yahoo.com (YAH).
6. a. Least = 12, Highest = 23
b.
Percent
Hours in Meetings per
Week Frequency Frequency
11–12 1 4
13–14 2 8
15–16 6 24
17–18 3 12
19–20 5 20
21–22 4 16
23–24 4 16
Total 25 100
2 -
Any Issue? Contact me here
