2 - 1 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 3. a. The sorted list of carriers appears below. Carrier Previous Year On-time Percentage Current Year On-time 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% (Essentials of Business Analytics 2e Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson)
(For Complete File, Download link at the end of this File) Descriptive Statistics 2 - 2 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.2 0. b. If the total sample size is 200 the frequency of D is 0.2 0*200 = 40. c. and d. Class Relative Frequency Frequency % Frequency A 0.22 44 22 Descriptive Statistics 2 - 3 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. Show Frequency % Frequency Jep 9 18 JJ 8 16 BBT 14 28 THM 6 12 WoF 13 26 Total 50 100 c. The largest viewing audience is for The Big Bang Theory and the second largest is for Wheel of Fortune . 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% 25 100% Descriptive Statistics 2 - 4 c. The distribution is slightly skewed to the left. 7. a. Industry Frequency % Frequency Bank 26 13% Cable 44 22% Car 42 21% Cell 60 30% Collection 28 14% Total 200 100% b. The cellular phone providers had the highest number of complaints. c. The percentage frequency distribution shows that the two financial industries (banks and collection agencies) had about the same number of complaints. Also, new car dealers and cable and satellite television companies also had about the same number of complaints. 8. a. 01234567
11-12 13-14 15-16 17-18 19-20 21-22 23-24Fequency
Hours per Week in Meetings
Living Area Live Now Ideal Community City 32/100=32% 24/100=24% Suburb 26/100=26% 25/100=25% Small Town 26/100=26% 30/100=30% Rural Area 16/100=16% 21/100=21% Total 100% 100%
(For Complete File, Download link at the end of this File) Descriptive Statistics 2 - 2 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.2 0. b. If the total sample size is 200 the frequency of D is 0.2 0*200 = 40. c. and d. Class Relative Frequency Frequency % Frequency A 0.22 44 22 Descriptive Statistics 2 - 3 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. Show Frequency % Frequency Jep 9 18 JJ 8 16 BBT 14 28 THM 6 12 WoF 13 26 Total 50 100 c. The largest viewing audience is for The Big Bang Theory and the second largest is for Wheel of Fortune . 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% 25 100% Descriptive Statistics 2 - 4 c. The distribution is slightly skewed to the left. 7. a. Industry Frequency % Frequency Bank 26 13% Cable 44 22% Car 42 21% Cell 60 30% Collection 28 14% Total 200 100% b. The cellular phone providers had the highest number of complaints. c. The percentage frequency distribution shows that the two financial industries (banks and collection agencies) had about the same number of complaints. Also, new car dealers and cable and satellite television companies also had about the same number of complaints. 8. a. 01234567
11-12 13-14 15-16 17-18 19-20 21-22 23-24Fequency
Hours per Week in Meetings
Living Area Live Now Ideal Community City 32/100=32% 24/100=24% Suburb 26/100=26% 25/100=25% Small Town 26/100=26% 30/100=30% Rural Area 16/100=16% 21/100=21% Total 100% 100%
