Business statistics

profileshahniti
MAT137ExcelProject1.xlsx
Home>Mathematics homework help>Statistics homework help>Business statistics

SANIT Original Data

Cruise Ship Cruise Line Date Score Flag
Adonia P&O Cruises 10/28/17 98 Europe
Adventure of the Seas Royal Caribbean International 2/24/19 90 Bahamas
AIDAaura Aida Cruises 3/19/13 86 Europe
AIDABella Aida Cruises 10/28/14 98 Europe
AIDAdiva Aida Cruises 11/10/19 99 Europe
AIDAluna Aida Cruises 10/14/18 93 Europe
AIDAmar Aida Cruises 10/31/17 94 Europe
AIDAVITA Aida Cruises 8/16/19 94 Europe
Albatros Bernhard Schulte Cruise 10/16/15 91 Bahamas
Allure of the Seas Royal Caribbean International 5/12/19 99 Bahamas
Amadea Bernhard Schulte Cruise 4/26/19 93 Bahamas
Amsterdam Holland America Line 7/8/19 90 Europe
Anthem of the Seas Royal Caribbean International 6/11/19 100 Bahamas
Arcadia P&O Cruises 1/29/19 96 Europe
Artania Bernhard Schulte Cruise 1/9/19 95 Bahamas
Asuka II NYK Cruises Co., LTD 5/26/18 91 Bahamas
Aurora P&O Cruises 9/24/18 100 Europe
Azamara Journey Azamara Cruises 4/5/16 94 Europe
Azamara Pursuit Azamara Cruises 11/20/18 96 Europe
Azamara Quest Azamara Cruises 12/22/17 97 Europe
Azura P&O Cruises 12/27/16 95 Europe
Balmoral Fred Olsen Cruise Line 2/23/19 92 Bahamas
Braemar Fred Olsen Cruise Line 3/5/09 95 Bahamas
Bremen Hapag Lloyd Kreuzfahrten 9/8/15 89 Bahamas
Brilliance of the Seas Royal Caribbean International 4/6/19 100 Bahamas
Britannia P&O Cruises 12/13/16 95 Europe
Caledonian Sky Salen Ship Management AB 7/12/13 95 Bahamas
Caribbean Princess Princess Cruises 7/7/18 90 Bermuda
Carnival Breeze Carnival Cruise Lines, Inc. 5/4/19 90 Panama
Carnival Conquest Carnival Cruise Lines, Inc. 10/5/19 97 Panama
Carnival Dream Carnival Cruise Lines, Inc. 7/13/19 91 Panama
Carnival Ecstasy Carnival Cruise Lines, Inc. 7/20/19 94 Panama
Carnival Elation Carnival Cruise Lines, Inc. 10/19/19 96 Panama
Carnival Fantasy Carnival Cruise Lines, Inc. 10/5/19 99 Panama
Carnival Fascination Carnival Cruise Lines, Inc. 3/4/19 98 Bahamas
Carnival Freedom Carnival Cruise Lines, Inc. 2/2/19 93 Panama
Carnival Glory Carnival Cruise Lines, Inc. 3/11/19 97 Panama
Carnival Horizon Carnival Cruise Lines, Inc. 6/29/19 95 Panama
Carnival Imagination Carnival Cruise Lines, Inc. 7/11/19 94 Bahamas
Carnival Inspiration Carnival Cruise Lines, Inc. 7/12/19 97 Bahamas
Carnival Legend Carnival Cruise Lines, Inc. 9/10/19 99 Panama
Carnival Liberty Carnival Cruise Lines, Inc. 10/18/19 95 Panama
Carnival Magic Carnival Cruise Lines, Inc. 2/13/19 93 Panama
Carnival Miracle Carnival Cruise Lines, Inc. 5/5/19 98 Panama
Carnival Paradise Carnival Cruise Lines, Inc. 7/30/18 97 Panama
Carnival Pride Carnival Cruise Lines, Inc. 8/18/19 93 Panama
Carnival Sensation Carnival Cruise Lines, Inc. 7/25/19 94 Bahamas
Carnival Spirit Carnival Cruise Lines, Inc. 2/17/12 97 Panama
Carnival Splendor Carnival Cruise Lines, Inc. 10/6/18 93 Panama
Carnival Sunrise Carnival Cruise Lines, Inc. 2/21/19 92 Bahamas
Carnival Sunshine Carnival Cruise Lines, Inc. 8/10/19 97 Bahamas
Carnival Valor Carnival Cruise Lines, Inc. 9/9/19 97 Panama
Carnival Victory Carnival Cruise Lines, Inc. 9/6/19 97 Panama
Carnival Vista Carnival Cruise Lines, Inc. 12/16/18 88 Panama
Celebrity Constellation Celebrity Cruises 4/2/16 99 Europe
Celebrity Eclipse Celebrity Cruises 8/6/19 99 Europe
Celebrity Edge Celebrity Cruises 3/17/19 98 Europe
Celebrity Equinox Celebrity Cruises 6/10/19 100 Europe
Celebrity Infinity Celebrity Cruises 3/16/19 92 Europe
Celebrity Millennium Celebrity Cruises 8/23/17 98 Europe
Celebrity Reflection Celebrity Cruises 4/22/19 97 Europe
Celebrity Silhouette Celebrity Cruises 3/6/19 96 Europe
Celebrity Solstice Celebrity Cruises 10/2/18 98 Europe
Celebrity Summit Celebrity Cruises 2/11/19 100 Europe
Club Med 2 Club Med Marine 11/29/16 89 Europe
Coral Princess Princess Cruises 10/18/19 99 Bermuda
Costa Atlantica Costa Crociere S.P.A. 4/15/15 97 Europe
Costa Deliziosa Costa Crociere S.P.A. 12/19/18 94 Europe
Costa Fortuna Costa Crociere S.P.A. 3/24/10 93 Europe
Costa Luminosa Costa Crociere S.P.A. 10/14/15 100 Europe
Costa Mediterranea Costa Crociere S.P.A. 3/20/15 94 Europe
Crown Princess Princess Cruises 4/3/19 99 Bermuda
Crystal Serenity Crystal Cruises , Inc. 12/7/18 95 Bahamas
Crystal Symphony Crystal Cruises , Inc. 9/12/19 91 Bahamas
Diamond Princess Princess Cruises 9/17/13 98 Bermuda
Disney Dream Disney Cruise Lines 8/17/18 100 Bahamas
Disney Fantasy Disney Cruise Lines 3/30/19 94 Bahamas
Disney Magic Disney Cruise Lines 2/8/19 96 Bahamas
Disney Wonder Disney Cruise Lines 12/7/18 100 Bahamas
Emerald Princess Princess Cruises 8/29/18 99 Bermuda
Empress of the Seas Royal Caribbean International 9/15/19 97 Bahamas
Enchantment of the Seas Royal Caribbean International 7/12/19 100 Bahamas
Eurodam Holland America Line 10/21/18 96 Europe
Europa Hapag Lloyd Kreuzfahrten 4/24/17 90 Bahamas
Europa 2 Hapag Lloyd Kreuzfahrten 9/26/16 90 Bahamas
Explorer of the Seas Royal Caribbean International 10/2/18 95 Bahamas
Freedom of the Seas Royal Caribbean International 6/9/19 97 Bahamas
Golden Princess Princess Cruises 6/18/19 98 Other
Grand Celebration Bahamas Paradise Cruise Line 5/6/19 97 Bermuda
Grand Princess Princess Cruises 6/19/19 93 Bahamas
Grande Caribe Blount Small Ship Adventures 9/29/17 93 Bermuda
Grande Mariner Blount Small Ship Adventures 8/16/19 92 USA
Grandeur of the Seas Royal Caribbean International 4/1/19 93 USA
Hanseatic Hapag Lloyd Kreuzfahrten 9/10/16 87 Bahamas
Harmony of the Seas Royal Caribbean International 5/19/19 96 Bahamas
Independence of the Seas Royal Caribbean International 4/11/19 92 Bahamas
Island Princess Princess Cruises 1/19/19 96 Bermuda
Jewel of the Seas Royal Caribbean International 3/29/19 98 Bahamas
Koningsdam Holland America Line 1/23/19 99 Europe
L'Austral Compagnie Du Ponant SA 8/6/15 92 Other
Le Boreal Compagnie Du Ponant SA 10/6/17 84 Other
Le Soleal Compagnie Du Ponant SA 7/6/19 91 Other
Liberty of the Seas Royal Caribbean International 10/28/18 98 Bahamas
Maasdam Holland America Line 8/25/18 93 Europe
Majesty of the Seas Royal Caribbean International 9/9/19 100 Bahamas
Mariner of the Seas Royal Caribbean International 5/24/19 86 Bahamas
Mein Schiff 1 TUI Cruises GmbH 9/20/19 98 Europe
Mein Schiff 6 TUI Cruises GmbH 10/4/18 96 Europe
MS Fram Hurtigruten ASA 10/8/09 92 Europe
MS Grand Classica Bahamas Paradise Cruise Line 10/26/19 88 Europe
MS Hamburg Hamburg Cruise SA 9/29/18 91 Bahamas
MSC Armonia MSC Cruise Management (UK) 7/22/19 98 Panama
MSC Divina MSC Cruise Management (UK) 3/14/19 93 Panama
MSC Lirica MSC Cruise Management (UK) 1/6/09 100 Panama
MSC Magnifica MSC Cruise Management (UK) 2/9/19 97 Panama
MSC Orchestra MSC Cruise Management (UK) 5/5/09 96 Panama
MSC Poesia MSC Cruise Management (UK) 3/2/13 87 Panama
MSC Seaside MSC Cruise Management (UK) 2/23/19 92 Panama
National Geo Explorer Lindblad Expeditions 10/15/08 92 Other
National Geo Orion Lindblad Expeditions 9/10/04 88 Other
National Geo Quest Lindblad Expeditions 8/25/19 91 Other
National Geo Sea Bird Lindblad Expeditions 8/23/19 91 Other
National Geo Sea Lion Lindblad Expeditions 7/6/19 86 Other
Navigator of the Seas Royal Caribbean International 12/3/17 100 Bahamas
Nieuw Amsterdam Holland America Line 6/17/19 100 Europe
Nieuw Statendam Holland America Line 4/7/19 96 Europe
Noordam Holland America Line 7/4/19 96 Europe
Norwegian Bliss Norwegian Cruise Lines 2/12/19 94 Bahamas
Norwegian Breakaway Norwegian Cruise Lines 6/30/19 98 Bahamas
Norwegian Dawn Norwegian Cruise Lines 7/8/19 98 Bahamas
Norwegian Epic Norwegian Cruise Lines 1/12/19 96 Bahamas
Norwegian Escape Norwegian Cruise Lines 7/28/19 97 Bahamas
Norwegian Gem Norwegian Cruise Lines 4/2/19 99 Bahamas
Norwegian Getaway Norwegian Cruise Lines 1/6/19 97 Bahamas
Norwegian Jade Norwegian Cruise Lines 3/4/19 92 Bahamas
Norwegian Jewel Norwegian Cruise Lines 6/20/19 97 Bahamas
Norwegian Pearl Norwegian Cruise Lines 8/8/18 97 Bahamas
Norwegian Sky Norwegian Cruise Lines 4/12/19 98 Bahamas
Norwegian Spirit Norwegian Cruise Lines 3/29/16 100 Bahamas
Norwegian Star Norwegian Cruise Lines 11/19/18 94 Bahamas
Norwegian Sun Norwegian Cruise Lines 12/7/18 97 Bahamas
Oasis of the Seas Royal Caribbean International 12/2/18 98 Bahamas
Ocean Dream Maritime Holdings Group 6/7/19 92 Other
Oceana P&O Cruises 1/27/17 92 Europe
Oceania Insignia Oceania Cruises 7/11/19 94 Other
Oceania Marina Oceania Cruises 4/22/18 97 Other
Oceania Regatta Oceania Cruises 7/9/19 94 Other
Oceania Riviera Oceania Cruises 12/22/18 97 Other
Oceania Sirena Oceania Cruises 1/20/19 88 Other
Oosterdam Holland America Line 7/7/19 95 Europe
Oriana P&O Cruises 2/10/16 90 Europe
Pacific Princess Princess Cruises 6/3/18 97 Bermuda
Pearl Mist V. Ships Leisure U.S.A. 8/15/19 94 USA
Prinsendam Holland America Line 3/25/19 91 Europe
Quantum of the Seas Royal Caribbean International 3/31/15 94 Bahamas
Queen Elizabeth Cunard Line 1/16/18 86 Bermuda
Queen Mary 2 Cunard Line 1/3/19 95 Bermuda
Queen Victoria Cunard Line 1/21/19 87 Bermuda
Radiance of the Seas Royal Caribbean International 8/4/19 95 Bahamas
Regal Princess Princess Cruises 3/25/18 100 Bermuda
Rhapsody of the Seas Royal Caribbean International 2/9/19 100 Bahamas
Rotterdam Holland America Line 2/14/19 94 Europe
Royal Princess Princess Cruises 9/11/19 94 Bermuda
Ruby Princess Princess Cruises 8/31/19 100 Bermuda
Safari Endeavour Un-Cruise Adventures 9/9/18 79 USA
Safari Quest Un-Cruise Adventures 5/19/18 92 USA
Sapphire Princess Princess Cruises 11/23/13 96 Other
Sea Princess Princess Cruises 8/19/18 100 Bermuda
Seabourn Odyssey Seabourn Cruise Line 12/5/17 100 Bahamas
Seabourn Quest Seabourn Cruise Line 11/4/18 100 Bahamas
Seabourn Sojourn Seabourn Cruise Line 12/21/17 95 Bahamas
Seadream I Sea Dream Yacht Club 3/27/19 87 Bahamas
Seadream II Sea Dream Yacht Club 12/27/18 90 Bahamas
Serenade of the Seas Royal Caribbean International 9/30/18 96 Bahamas
Seven Seas Explorer Regent Seven Seas 3/25/19 98 Bahamas
Seven Seas Mariner Regent Seven Seas 7/5/19 99 Bahamas
Seven Seas Navigator Regent Seven Seas 9/21/19 95 Bahamas
Seven Seas Voyager Regent Seven Seas 2/6/19 91 Bahamas
Silver Cloud Silversea Cruises Ltd 3/20/15 99 Bahamas
Silver Explorer Silversea Cruises Ltd 9/13/18 95 Bahamas
Silver Muse Silversea Cruises Ltd 9/10/19 97 Bahamas
Silver Shadow Silversea Cruises Ltd 5/26/18 93 Bahamas
Silver Spirit Silversea Cruises Ltd 4/2/19 90 Bahamas
Silver Whisper Silversea Cruises Ltd 10/29/19 96 Bahamas
Silver Wind Silversea Cruises Ltd 3/18/18 79 Bahamas
Stad Amsterdam Rederij Clipper 4/16/19 91 Europe
Star Legend Wind Star Sail Cruises 5/28/19 97 Bahamas
Star Pride Wind Star Sail Cruises 3/9/19 90 Bahamas
Star Princess Princess Cruises 5/29/19 96 Bermuda
Sun Princess Princess Cruises 8/2/16 96 Bermuda
Symphony of the Seas Royal Caribbean International 3/5/19 93 Bahamas
The World ResidenSea 12/30/17 98 Bahamas
Veendam Holland America Line 3/26/19 96 Europe
Ventura P&O Cruises 2/20/19 95 Europe
Victory I Victory I Partners, Ltd. 7/31/19 88 USA
Victory II Victory I Partners, Ltd. 8/7/19 99 USA
Viking Orion Viking Ocean Cruises 5/30/19 97 Europe
Viking Sea Viking Ocean Cruises 10/23/19 100 Europe
Viking Sky Viking Ocean Cruises 11/13/17 95 Europe
Viking Star Viking Ocean Cruises 10/15/18 100 Europe
Viking Sun Viking Ocean Cruises 12/8/17 97 Europe
Vision of the Seas Royal Caribbean International 4/1/19 99 Bahamas
Volendam Holland America Line 5/31/19 98 Europe
Voyager of the Seas Royal Caribbean International 3/24/12 96 Bahamas
Vspbeta VSP Office Cruise Line 4/18/11 97 Other
Westerdam Holland America Line 7/3/19 98 Europe
Wind Spirit Wind Star Sail Cruises 3/15/09 97 Bahamas
Wind Surf Wind Star Sail Cruises 2/28/06 95 Bahamas
World Odyssey CMI Ship Mgmt 1/3/19 89 Bahamas
Zaandam Holland America Line 8/17/19 99 Europe
Zuiderdam Holland America Line 11/25/18 97 Europe

Task 1

To minimize the potential for gastrointestinal disease outbreaks, all passenger cruise ships arriving at US pots are subject to unannounced sanitation inspections.
Ships are rated on a 100-point scale by the Centers for Disease Control and Prevention. A score of 86 or higher indicates that the ship is providing an accepted standard of sanitation.
The latest (as of March 2019) sanitation scores for 211 cruise ships are given in this file in the "SANIT Original Data" sheet
There are five variables in this data set.
1. Cruise Ship: The name of the ship
2. Cruise Line: The company that operates the cruise ship
3. Date: The date of inspection
4. Score: Sanitation inspection score on a 100-point scale
5. Flag: The ship’s registration country under whose laws it is registered/licensed
We will focus on four variables, Date, Flag, and Score. Flag are qualitative variables, while Date and Score are a quantitative variables.
Task 1: This is mostly a demonstration task, but you need to answer two questions at the end. Use Excel [Excel:=Sort(data, column, order), :=Sort(Unique(data)]), :=countif(data, criteria)]
to construct a table summarizing the class frequence, class relative frequency, and class percentage of Flag data,
then to construct a bar graph and a pie chart of Flag using relatve frequency and percentage, respectively.
You may need to click the graph on the chart, select format data or label to modify the appearance of the graph.
(Questions that need to completed are in cell with color orange).
Extracted data, Sorted
Date Scores Flag Flag Frequence Relative Frequency Percentage
2/24/19 90 Bahamas Bahamas 84 0.40 40%
10/16/15 91 Bahamas Bermuda 18 0.09 9%
5/12/19 99 Bahamas Europe 58 0.27 27%
4/26/19 93 Bahamas Other 17 0.08 8%
6/11/19 100 Bahamas Panama 27 0.13 13%
1/9/19 95 Bahamas USA 7 0.03 3%
5/26/18 91 Bahamas
2/23/19 92 Bahamas Total 211 1 1
3/5/09 95 Bahamas
9/8/15 89 Bahamas
4/6/19 100 Bahamas
7/12/13 95 Bahamas
3/4/19 98 Bahamas
7/11/19 94 Bahamas
7/12/19 97 Bahamas
7/25/19 94 Bahamas
2/21/19 92 Bahamas
8/10/19 97 Bahamas
12/7/18 95 Bahamas
9/12/19 91 Bahamas
8/17/18 100 Bahamas
3/30/19 94 Bahamas
2/8/19 96 Bahamas
12/7/18 100 Bahamas
9/15/19 97 Bahamas
7/12/19 100 Bahamas
4/24/17 90 Bahamas
9/26/16 90 Bahamas
10/2/18 95 Bahamas Question: Which flag has the highest frequency? Which flag has the lowest frequency?
6/9/19 97 Bahamas
6/19/19 93 Bahamas Answer:
9/10/16 87 Bahamas
5/19/19 96 Bahamas
4/11/19 92 Bahamas
3/29/19 98 Bahamas
10/28/18 98 Bahamas
9/9/19 100 Bahamas
5/24/19 86 Bahamas
9/29/18 91 Bahamas
12/3/17 100 Bahamas
2/12/19 94 Bahamas
6/30/19 98 Bahamas
7/8/19 98 Bahamas
1/12/19 96 Bahamas
7/28/19 97 Bahamas
4/2/19 99 Bahamas
1/6/19 97 Bahamas
3/4/19 92 Bahamas
6/20/19 97 Bahamas
8/8/18 97 Bahamas
4/12/19 98 Bahamas
3/29/16 100 Bahamas
11/19/18 94 Bahamas
12/7/18 97 Bahamas
12/2/18 98 Bahamas
3/31/15 94 Bahamas
8/4/19 95 Bahamas
2/9/19 100 Bahamas
12/5/17 100 Bahamas
11/4/18 100 Bahamas
12/21/17 95 Bahamas
3/27/19 87 Bahamas
12/27/18 90 Bahamas
9/30/18 96 Bahamas
3/25/19 98 Bahamas
7/5/19 99 Bahamas
9/21/19 95 Bahamas
2/6/19 91 Bahamas
3/20/15 99 Bahamas
9/13/18 95 Bahamas
9/10/19 97 Bahamas
5/26/18 93 Bahamas
4/2/19 90 Bahamas
10/29/19 96 Bahamas
3/18/18 79 Bahamas
5/28/19 97 Bahamas
3/9/19 90 Bahamas
3/5/19 93 Bahamas
12/30/17 98 Bahamas
4/1/19 99 Bahamas
3/24/12 96 Bahamas
3/15/09 97 Bahamas
2/28/06 95 Bahamas
1/3/19 89 Bahamas
7/7/18 90 Bermuda
10/18/19 99 Bermuda
4/3/19 99 Bermuda
9/17/13 98 Bermuda
8/29/18 99 Bermuda
5/6/19 97 Bermuda
9/29/17 93 Bermuda
1/19/19 96 Bermuda
6/3/18 97 Bermuda
1/16/18 86 Bermuda
1/3/19 95 Bermuda
1/21/19 87 Bermuda
3/25/18 100 Bermuda
9/11/19 94 Bermuda
8/31/19 100 Bermuda
8/19/18 100 Bermuda
5/29/19 96 Bermuda
8/2/16 96 Bermuda
10/28/17 98 Europe
3/19/13 86 Europe
10/28/14 98 Europe
11/10/19 99 Europe
10/14/18 93 Europe
10/31/17 94 Europe
8/16/19 94 Europe
7/8/19 90 Europe
1/29/19 96 Europe
9/24/18 100 Europe
4/5/16 94 Europe
11/20/18 96 Europe
12/22/17 97 Europe
12/27/16 95 Europe
12/13/16 95 Europe
4/2/16 99 Europe
8/6/19 99 Europe
3/17/19 98 Europe
6/10/19 100 Europe
3/16/19 92 Europe
8/23/17 98 Europe
4/22/19 97 Europe
3/6/19 96 Europe
10/2/18 98 Europe
2/11/19 100 Europe
11/29/16 89 Europe
4/15/15 97 Europe
12/19/18 94 Europe
3/24/10 93 Europe
10/14/15 100 Europe
3/20/15 94 Europe
10/21/18 96 Europe
1/23/19 99 Europe
8/25/18 93 Europe
9/20/19 98 Europe
10/4/18 96 Europe
10/8/09 92 Europe
10/26/19 88 Europe
6/17/19 100 Europe
4/7/19 96 Europe
7/4/19 96 Europe
1/27/17 92 Europe
7/7/19 95 Europe
2/10/16 90 Europe
3/25/19 91 Europe
2/14/19 94 Europe
4/16/19 91 Europe
3/26/19 96 Europe
2/20/19 95 Europe
5/30/19 97 Europe
10/23/19 100 Europe
11/13/17 95 Europe
10/15/18 100 Europe
12/8/17 97 Europe
5/31/19 98 Europe
7/3/19 98 Europe
8/17/19 99 Europe
11/25/18 97 Europe
6/18/19 98 Other
8/6/15 92 Other
10/6/17 84 Other
7/6/19 91 Other
10/15/08 92 Other
9/10/04 88 Other
8/25/19 91 Other
8/23/19 91 Other
7/6/19 86 Other
6/7/19 92 Other
7/11/19 94 Other
4/22/18 97 Other
7/9/19 94 Other
12/22/18 97 Other
1/20/19 88 Other
11/23/13 96 Other
4/18/11 97 Other
5/4/19 90 Panama
10/5/19 97 Panama
7/13/19 91 Panama
7/20/19 94 Panama
10/19/19 96 Panama
10/5/19 99 Panama
2/2/19 93 Panama
3/11/19 97 Panama
6/29/19 95 Panama
9/10/19 99 Panama
10/18/19 95 Panama
2/13/19 93 Panama
5/5/19 98 Panama
7/30/18 97 Panama
8/18/19 93 Panama
2/17/12 97 Panama
10/6/18 93 Panama
9/9/19 97 Panama
9/6/19 97 Panama
12/16/18 88 Panama
7/22/19 98 Panama
3/14/19 93 Panama
1/6/09 100 Panama
2/9/19 97 Panama
5/5/09 96 Panama
3/2/13 87 Panama
2/23/19 92 Panama
8/16/19 92 USA
4/1/19 93 USA
8/15/19 94 USA
9/9/18 79 USA
5/19/18 92 USA
7/31/19 88 USA
8/7/19 99 USA

Bar Graph of Flag data

Bahamas Bermuda Europe Other Panama USA 0.3981042654028436 8.5308056872037921E-2 0.27488151658767773 8.0568720379146919E-2 0.12796208530805686 3.3175355450236969E-2

Pie Chart of Flag Data

Bahamas Bermuda Europe Other Panama USA 0.3981042654028436 8.5308056872037921E-2 0.27488151658767773 8.0568720379146919E-2 0.12796208530805686 3.3175355450236969E-2

Task 2

Task 2: This is mostly a demonstration task, but you need to answer two questions at the end.
Use Excel [Excel:=max(data), :=min(data), :=min(data), :=average(data), :=median(data), :=counta(data), :=countif(data, criteria)]
to construct a table summarizing the min, max, mean, and median of Score data, (and number of ships having score of 86 or higher)
then to construct the histogram of Score data, use SIX bins by clicking the bottom or x-axis of the graph to select "format axis…", then adjust "number of bins".
(Questions that need to be completed are in cells with color orange).
Extracted data, Sorted by Score
Date Scores Flag Min Max Average Median Number of ships meets accepted standard of sanitation Percentage
3/18/18 79 Bahamas 79 100 94.88 96 208 98.58%
9/9/18 79 USA
10/6/17 84 Other Total number of ships
5/24/19 86 Bahamas 211
1/16/18 86 Bermuda
3/19/13 86 Europe
7/6/19 86 Other
9/10/16 87 Bahamas
3/27/19 87 Bahamas
1/21/19 87 Bermuda
3/2/13 87 Panama
10/26/19 88 Europe
9/10/04 88 Other
1/20/19 88 Other
12/16/18 88 Panama
7/31/19 88 USA
9/8/15 89 Bahamas
1/3/19 89 Bahamas
11/29/16 89 Europe
2/24/19 90 Bahamas
4/24/17 90 Bahamas
9/26/16 90 Bahamas
12/27/18 90 Bahamas Question: Is the score data left-skewed or right-skewed? What is the percentage of ship that meets accepted standard of sanitation?
4/2/19 90 Bahamas
3/9/19 90 Bahamas Answer:
7/7/18 90 Bermuda
7/8/19 90 Europe
2/10/16 90 Europe
5/4/19 90 Panama
10/16/15 91 Bahamas
5/26/18 91 Bahamas
9/12/19 91 Bahamas
9/29/18 91 Bahamas
2/6/19 91 Bahamas
3/25/19 91 Europe
4/16/19 91 Europe
7/6/19 91 Other
8/25/19 91 Other
8/23/19 91 Other
7/13/19 91 Panama
2/23/19 92 Bahamas
2/21/19 92 Bahamas
4/11/19 92 Bahamas
3/4/19 92 Bahamas
3/16/19 92 Europe
10/8/09 92 Europe
1/27/17 92 Europe
8/6/15 92 Other
10/15/08 92 Other
6/7/19 92 Other
2/23/19 92 Panama
8/16/19 92 USA
5/19/18 92 USA
4/26/19 93 Bahamas
6/19/19 93 Bahamas
5/26/18 93 Bahamas
3/5/19 93 Bahamas
9/29/17 93 Bermuda
10/14/18 93 Europe
3/24/10 93 Europe
8/25/18 93 Europe
2/2/19 93 Panama
2/13/19 93 Panama
8/18/19 93 Panama
10/6/18 93 Panama
3/14/19 93 Panama
4/1/19 93 USA
7/11/19 94 Bahamas
7/25/19 94 Bahamas
3/30/19 94 Bahamas
2/12/19 94 Bahamas
11/19/18 94 Bahamas
3/31/15 94 Bahamas
9/11/19 94 Bermuda
10/31/17 94 Europe
8/16/19 94 Europe
4/5/16 94 Europe
12/19/18 94 Europe
3/20/15 94 Europe
2/14/19 94 Europe
7/11/19 94 Other
7/9/19 94 Other
7/20/19 94 Panama
8/15/19 94 USA
1/9/19 95 Bahamas
3/5/09 95 Bahamas
7/12/13 95 Bahamas
12/7/18 95 Bahamas
10/2/18 95 Bahamas
8/4/19 95 Bahamas
12/21/17 95 Bahamas
9/21/19 95 Bahamas
9/13/18 95 Bahamas
2/28/06 95 Bahamas
1/3/19 95 Bermuda
12/27/16 95 Europe
12/13/16 95 Europe
7/7/19 95 Europe
2/20/19 95 Europe
11/13/17 95 Europe
6/29/19 95 Panama
10/18/19 95 Panama
2/8/19 96 Bahamas
5/19/19 96 Bahamas
1/12/19 96 Bahamas
9/30/18 96 Bahamas
10/29/19 96 Bahamas
3/24/12 96 Bahamas
1/19/19 96 Bermuda
5/29/19 96 Bermuda
8/2/16 96 Bermuda
1/29/19 96 Europe
11/20/18 96 Europe
3/6/19 96 Europe
10/21/18 96 Europe
10/4/18 96 Europe
4/7/19 96 Europe
7/4/19 96 Europe
3/26/19 96 Europe
11/23/13 96 Other
10/19/19 96 Panama
5/5/09 96 Panama
7/12/19 97 Bahamas
8/10/19 97 Bahamas
9/15/19 97 Bahamas
6/9/19 97 Bahamas
7/28/19 97 Bahamas
1/6/19 97 Bahamas
6/20/19 97 Bahamas
8/8/18 97 Bahamas
12/7/18 97 Bahamas
9/10/19 97 Bahamas
5/28/19 97 Bahamas
3/15/09 97 Bahamas
5/6/19 97 Bermuda
6/3/18 97 Bermuda
12/22/17 97 Europe
4/22/19 97 Europe
4/15/15 97 Europe
5/30/19 97 Europe
12/8/17 97 Europe
11/25/18 97 Europe
4/22/18 97 Other
12/22/18 97 Other
4/18/11 97 Other
10/5/19 97 Panama
3/11/19 97 Panama
7/30/18 97 Panama
2/17/12 97 Panama
9/9/19 97 Panama
9/6/19 97 Panama
2/9/19 97 Panama
3/4/19 98 Bahamas
3/29/19 98 Bahamas
10/28/18 98 Bahamas
6/30/19 98 Bahamas
7/8/19 98 Bahamas
4/12/19 98 Bahamas
12/2/18 98 Bahamas
3/25/19 98 Bahamas
12/30/17 98 Bahamas
9/17/13 98 Bermuda
10/28/17 98 Europe
10/28/14 98 Europe
3/17/19 98 Europe
8/23/17 98 Europe
10/2/18 98 Europe
9/20/19 98 Europe
5/31/19 98 Europe
7/3/19 98 Europe
6/18/19 98 Other
5/5/19 98 Panama
7/22/19 98 Panama
5/12/19 99 Bahamas
4/2/19 99 Bahamas
7/5/19 99 Bahamas
3/20/15 99 Bahamas
4/1/19 99 Bahamas
10/18/19 99 Bermuda
4/3/19 99 Bermuda
8/29/18 99 Bermuda
11/10/19 99 Europe
4/2/16 99 Europe
8/6/19 99 Europe
1/23/19 99 Europe
8/17/19 99 Europe
10/5/19 99 Panama
9/10/19 99 Panama
8/7/19 99 USA
6/11/19 100 Bahamas
4/6/19 100 Bahamas
8/17/18 100 Bahamas
12/7/18 100 Bahamas
7/12/19 100 Bahamas
9/9/19 100 Bahamas
12/3/17 100 Bahamas
3/29/16 100 Bahamas
2/9/19 100 Bahamas
12/5/17 100 Bahamas
11/4/18 100 Bahamas
3/25/18 100 Bermuda
8/31/19 100 Bermuda
8/19/18 100 Bermuda
9/24/18 100 Europe
6/10/19 100 Europe
2/11/19 100 Europe
10/14/15 100 Europe
6/17/19 100 Europe
10/23/19 100 Europe
10/15/18 100 Europe
1/6/09 100 Panama

Task 3

Task 3: This is mostly a demonstration task, but you need to answer two questions at the end.
Use Excel [Excel:, :=average(data), :=stdev.s(data), :=countifs(data1, criteria1, data2, criteria2)]
to construct a table summarizing the, mean, and stand deviation of Score data,
then find the percentage of data that fall within two or three standard derivations of the mean, respectively.
Lastly, calculate a few z-scores from the Score data; and also find the Score values that are corresponding to the given z-scores
(Questions that need to be completed are in cells with color orange).
Extracted data, Sorted by Score
Date Scores Flag Mean, m Stdev, s Left End of the interal Right End of the interval Frequency Inside Percentage
3/18/18 79 Bahamas 94.88 3.97 m-2s 86.94 m+2s 102.83 204 96.68%
9/9/18 79 USA m-3s 82.96 m+3s 106.80 209 99.05%
10/6/17 84 Other
5/24/19 86 Bahamas
1/16/18 86 Bermuda
3/19/13 86 Europe Score z-score z-score Score
7/6/19 86 Other 80 -3.75 -1.5 89
9/10/16 87 Bahamas 86 -2.24 -1 91
3/27/19 87 Bahamas 90 -1.23 -0.5 93
1/21/19 87 Bermuda 95 0.03 0 95
3/2/13 87 Panama 100 1.29 0.5 97
10/26/19 88 Europe 1 99
9/10/04 88 Other 1.25 100
1/20/19 88 Other
12/16/18 88 Panama
7/31/19 88 USA
9/8/15 89 Bahamas Question: What are the empirical rule conclusions about these two percentages?
1/3/19 89 Bahamas Compare the percentages to the percentages given by the empirical rule, are they larger, smaller or equal to the empirical rule conclusions?
11/29/16 89 Europe
2/24/19 90 Bahamas
4/24/17 90 Bahamas Answer:
9/26/16 90 Bahamas
12/27/18 90 Bahamas
4/2/19 90 Bahamas
3/9/19 90 Bahamas
7/7/18 90 Bermuda
7/8/19 90 Europe
2/10/16 90 Europe
5/4/19 90 Panama
10/16/15 91 Bahamas
5/26/18 91 Bahamas
9/12/19 91 Bahamas
9/29/18 91 Bahamas
2/6/19 91 Bahamas
3/25/19 91 Europe
4/16/19 91 Europe
7/6/19 91 Other
8/25/19 91 Other
8/23/19 91 Other
7/13/19 91 Panama
2/23/19 92 Bahamas
2/21/19 92 Bahamas
4/11/19 92 Bahamas
3/4/19 92 Bahamas
3/16/19 92 Europe
10/8/09 92 Europe
1/27/17 92 Europe
8/6/15 92 Other
10/15/08 92 Other
6/7/19 92 Other
2/23/19 92 Panama
8/16/19 92 USA
5/19/18 92 USA
4/26/19 93 Bahamas
6/19/19 93 Bahamas
5/26/18 93 Bahamas
3/5/19 93 Bahamas
9/29/17 93 Bermuda
10/14/18 93 Europe
3/24/10 93 Europe
8/25/18 93 Europe
2/2/19 93 Panama
2/13/19 93 Panama
8/18/19 93 Panama
10/6/18 93 Panama
3/14/19 93 Panama
4/1/19 93 USA
7/11/19 94 Bahamas
7/25/19 94 Bahamas
3/30/19 94 Bahamas
2/12/19 94 Bahamas
11/19/18 94 Bahamas
3/31/15 94 Bahamas
9/11/19 94 Bermuda
10/31/17 94 Europe
8/16/19 94 Europe
4/5/16 94 Europe
12/19/18 94 Europe
3/20/15 94 Europe
2/14/19 94 Europe
7/11/19 94 Other
7/9/19 94 Other
7/20/19 94 Panama
8/15/19 94 USA
1/9/19 95 Bahamas
3/5/09 95 Bahamas
7/12/13 95 Bahamas
12/7/18 95 Bahamas
10/2/18 95 Bahamas
8/4/19 95 Bahamas
12/21/17 95 Bahamas
9/21/19 95 Bahamas
9/13/18 95 Bahamas
2/28/06 95 Bahamas
1/3/19 95 Bermuda
12/27/16 95 Europe
12/13/16 95 Europe
7/7/19 95 Europe
2/20/19 95 Europe
11/13/17 95 Europe
6/29/19 95 Panama
10/18/19 95 Panama
2/8/19 96 Bahamas
5/19/19 96 Bahamas
1/12/19 96 Bahamas
9/30/18 96 Bahamas
10/29/19 96 Bahamas
3/24/12 96 Bahamas
1/19/19 96 Bermuda
5/29/19 96 Bermuda
8/2/16 96 Bermuda
1/29/19 96 Europe
11/20/18 96 Europe
3/6/19 96 Europe
10/21/18 96 Europe
10/4/18 96 Europe
4/7/19 96 Europe
7/4/19 96 Europe
3/26/19 96 Europe
11/23/13 96 Other
10/19/19 96 Panama
5/5/09 96 Panama
7/12/19 97 Bahamas
8/10/19 97 Bahamas
9/15/19 97 Bahamas
6/9/19 97 Bahamas
7/28/19 97 Bahamas
1/6/19 97 Bahamas
6/20/19 97 Bahamas
8/8/18 97 Bahamas
12/7/18 97 Bahamas
9/10/19 97 Bahamas
5/28/19 97 Bahamas
3/15/09 97 Bahamas
5/6/19 97 Bermuda
6/3/18 97 Bermuda
12/22/17 97 Europe
4/22/19 97 Europe
4/15/15 97 Europe
5/30/19 97 Europe
12/8/17 97 Europe
11/25/18 97 Europe
4/22/18 97 Other
12/22/18 97 Other
4/18/11 97 Other
10/5/19 97 Panama
3/11/19 97 Panama
7/30/18 97 Panama
2/17/12 97 Panama
9/9/19 97 Panama
9/6/19 97 Panama
2/9/19 97 Panama
3/4/19 98 Bahamas
3/29/19 98 Bahamas
10/28/18 98 Bahamas
6/30/19 98 Bahamas
7/8/19 98 Bahamas
4/12/19 98 Bahamas
12/2/18 98 Bahamas
3/25/19 98 Bahamas
12/30/17 98 Bahamas
9/17/13 98 Bermuda
10/28/17 98 Europe
10/28/14 98 Europe
3/17/19 98 Europe
8/23/17 98 Europe
10/2/18 98 Europe
9/20/19 98 Europe
5/31/19 98 Europe
7/3/19 98 Europe
6/18/19 98 Other
5/5/19 98 Panama
7/22/19 98 Panama
5/12/19 99 Bahamas
4/2/19 99 Bahamas
7/5/19 99 Bahamas
3/20/15 99 Bahamas
4/1/19 99 Bahamas
10/18/19 99 Bermuda
4/3/19 99 Bermuda
8/29/18 99 Bermuda
11/10/19 99 Europe
4/2/16 99 Europe
8/6/19 99 Europe
1/23/19 99 Europe
8/17/19 99 Europe
10/5/19 99 Panama
9/10/19 99 Panama
8/7/19 99 USA
6/11/19 100 Bahamas
4/6/19 100 Bahamas
8/17/18 100 Bahamas
12/7/18 100 Bahamas
7/12/19 100 Bahamas
9/9/19 100 Bahamas
12/3/17 100 Bahamas
3/29/16 100 Bahamas
2/9/19 100 Bahamas
12/5/17 100 Bahamas
11/4/18 100 Bahamas
3/25/18 100 Bermuda
8/31/19 100 Bermuda
8/19/18 100 Bermuda
9/24/18 100 Europe
6/10/19 100 Europe
2/11/19 100 Europe
10/14/15 100 Europe
6/17/19 100 Europe
10/23/19 100 Europe
10/15/18 100 Europe
1/6/09 100 Panama

Task 4

Task 4: In this task you need to construct a histogram and to answer one question, using the idea and tools given in task 2.
Use the sorted data, ordered by date, to construct a histogram of Date of inspections use FIVE bins.
You may need to click the bottom or x-axis of the graph to select "format axis…", then adjust "number of bins".
From the histogram, is the data left-skewed or right-skewed?
(Questions that need to be completed are in cells with color orange).
Extracted data, Sorted by Date Histogram of Date
9/10/04 88 Other
2/28/06 95 Bahamas
10/15/08 92 Other
1/6/09 100 Panama
3/5/09 95 Bahamas
3/15/09 97 Bahamas
5/5/09 96 Panama
10/8/09 92 Europe
3/24/10 93 Europe
4/18/11 97 Other
2/17/12 97 Panama
3/24/12 96 Bahamas
3/2/13 87 Panama
3/19/13 86 Europe
7/12/13 95 Bahamas
9/17/13 98 Bermuda
11/23/13 96 Other
10/28/14 98 Europe
3/20/15 99 Bahamas
3/20/15 94 Europe
3/31/15 94 Bahamas
4/15/15 97 Europe
8/6/15 92 Other
9/8/15 89 Bahamas Answer to the question:
10/14/15 100 Europe
10/16/15 91 Bahamas
2/10/16 90 Europe
3/29/16 100 Bahamas
4/2/16 99 Europe
4/5/16 94 Europe
8/2/16 96 Bermuda
9/10/16 87 Bahamas
9/26/16 90 Bahamas
11/29/16 89 Europe
12/13/16 95 Europe
12/27/16 95 Europe
1/27/17 92 Europe
4/24/17 90 Bahamas
8/23/17 98 Europe
9/29/17 93 Bermuda
10/6/17 84 Other
10/28/17 98 Europe
10/31/17 94 Europe
11/13/17 95 Europe
12/3/17 100 Bahamas
12/5/17 100 Bahamas
12/8/17 97 Europe
12/21/17 95 Bahamas
12/22/17 97 Europe
12/30/17 98 Bahamas
1/16/18 86 Bermuda
3/18/18 79 Bahamas
3/25/18 100 Bermuda
4/22/18 97 Other
5/19/18 92 USA
5/26/18 91 Bahamas
5/26/18 93 Bahamas
6/3/18 97 Bermuda
7/7/18 90 Bermuda
7/30/18 97 Panama
8/8/18 97 Bahamas
8/17/18 100 Bahamas
8/19/18 100 Bermuda
8/25/18 93 Europe
8/29/18 99 Bermuda
9/9/18 79 USA
9/13/18 95 Bahamas
9/24/18 100 Europe
9/29/18 91 Bahamas
9/30/18 96 Bahamas
10/2/18 95 Bahamas
10/2/18 98 Europe
10/4/18 96 Europe
10/6/18 93 Panama
10/14/18 93 Europe
10/15/18 100 Europe
10/21/18 96 Europe
10/28/18 98 Bahamas
11/4/18 100 Bahamas
11/19/18 94 Bahamas
11/20/18 96 Europe
11/25/18 97 Europe
12/2/18 98 Bahamas
12/7/18 95 Bahamas
12/7/18 100 Bahamas
12/7/18 97 Bahamas
12/16/18 88 Panama
12/19/18 94 Europe
12/22/18 97 Other
12/27/18 90 Bahamas
1/3/19 89 Bahamas
1/3/19 95 Bermuda
1/6/19 97 Bahamas
1/9/19 95 Bahamas
1/12/19 96 Bahamas
1/19/19 96 Bermuda
1/20/19 88 Other
1/21/19 87 Bermuda
1/23/19 99 Europe
1/29/19 96 Europe
2/2/19 93 Panama
2/6/19 91 Bahamas
2/8/19 96 Bahamas
2/9/19 100 Bahamas
2/9/19 97 Panama
2/11/19 100 Europe
2/12/19 94 Bahamas
2/13/19 93 Panama
2/14/19 94 Europe
2/20/19 95 Europe
2/21/19 92 Bahamas
2/23/19 92 Bahamas
2/23/19 92 Panama
2/24/19 90 Bahamas
3/4/19 98 Bahamas
3/4/19 92 Bahamas
3/5/19 93 Bahamas
3/6/19 96 Europe
3/9/19 90 Bahamas
3/11/19 97 Panama
3/14/19 93 Panama
3/16/19 92 Europe
3/17/19 98 Europe
3/25/19 98 Bahamas
3/25/19 91 Europe
3/26/19 96 Europe
3/27/19 87 Bahamas
3/29/19 98 Bahamas
3/30/19 94 Bahamas
4/1/19 99 Bahamas
4/1/19 93 USA
4/2/19 99 Bahamas
4/2/19 90 Bahamas
4/3/19 99 Bermuda
4/6/19 100 Bahamas
4/7/19 96 Europe
4/11/19 92 Bahamas
4/12/19 98 Bahamas
4/16/19 91 Europe
4/22/19 97 Europe
4/26/19 93 Bahamas
5/4/19 90 Panama
5/5/19 98 Panama
5/6/19 97 Bermuda
5/12/19 99 Bahamas
5/19/19 96 Bahamas
5/24/19 86 Bahamas
5/28/19 97 Bahamas
5/29/19 96 Bermuda
5/30/19 97 Europe
5/31/19 98 Europe
6/7/19 92 Other
6/9/19 97 Bahamas
6/10/19 100 Europe
6/11/19 100 Bahamas
6/17/19 100 Europe
6/18/19 98 Other
6/19/19 93 Bahamas
6/20/19 97 Bahamas
6/29/19 95 Panama
6/30/19 98 Bahamas
7/3/19 98 Europe
7/4/19 96 Europe
7/5/19 99 Bahamas
7/6/19 91 Other
7/6/19 86 Other
7/7/19 95 Europe
7/8/19 98 Bahamas
7/8/19 90 Europe
7/9/19 94 Other
7/11/19 94 Bahamas
7/11/19 94 Other
7/12/19 97 Bahamas
7/12/19 100 Bahamas
7/13/19 91 Panama
7/20/19 94 Panama
7/22/19 98 Panama
7/25/19 94 Bahamas
7/28/19 97 Bahamas
7/31/19 88 USA
8/4/19 95 Bahamas
8/6/19 99 Europe
8/7/19 99 USA
8/10/19 97 Bahamas
8/15/19 94 USA
8/16/19 94 Europe
8/16/19 92 USA
8/17/19 99 Europe
8/18/19 93 Panama
8/23/19 91 Other
8/25/19 91 Other
8/31/19 100 Bermuda
9/6/19 97 Panama
9/9/19 100 Bahamas
9/9/19 97 Panama
9/10/19 97 Bahamas
9/10/19 99 Panama
9/11/19 94 Bermuda
9/12/19 91 Bahamas
9/15/19 97 Bahamas
9/20/19 98 Europe
9/21/19 95 Bahamas
10/5/19 97 Panama
10/5/19 99 Panama
10/18/19 99 Bermuda
10/18/19 95 Panama
10/19/19 96 Panama
10/23/19 100 Europe
10/26/19 88 Europe
10/29/19 96 Bahamas
11/10/19 99 Europe

Task 5

Task 5: In this task you need to repeat most what we have done in task 1, using the idea and tools given there.
First, construct a table summarizing the class frequence, class relative frequency, and class percentage of extracted partial Flag data, ships that were inspected since 2016,
then construct a bar graph and a pie chart of Flag use relatve frequency and percentage, respectively.
Lastly, using the method done in task 2 to find the number of ships that meet the accepted standard of sanitation since 2016 and answer the question:
What is the percentage of ship that meets accepted standard of sanitation score (86) since 2016?
(Questions that need to be completed are in cells with color orange).
Extracted partial data, since 2016, sorted by Flag Cut-off time Flag Frequence Relative Frequency Percentage
2/24/19 90 Bahamas 1/1/16 Bahamas 75 0.41 41%
5/12/19 99 Bahamas Bermuda
4/26/19 93 Bahamas Europe
6/11/19 100 Bahamas Other
1/9/19 95 Bahamas Panama
5/26/18 91 Bahamas USA
2/23/19 92 Bahamas
4/6/19 100 Bahamas Total 185 1.00 100%
3/4/19 98 Bahamas
7/11/19 94 Bahamas
7/12/19 97 Bahamas
7/25/19 94 Bahamas Bar Graph Pie Chart
2/21/19 92 Bahamas
8/10/19 97 Bahamas
12/7/18 95 Bahamas
9/12/19 91 Bahamas
8/17/18 100 Bahamas
3/30/19 94 Bahamas
2/8/19 96 Bahamas
12/7/18 100 Bahamas
9/15/19 97 Bahamas
7/12/19 100 Bahamas
4/24/17 90 Bahamas
9/26/16 90 Bahamas
10/2/18 95 Bahamas
6/9/19 97 Bahamas
6/19/19 93 Bahamas
9/10/16 87 Bahamas
5/19/19 96 Bahamas Accepted Sanitation Standard Number of ships meets accepted standard of sanitation since 2016 Percentage
4/11/19 92 Bahamas 86
3/29/19 98 Bahamas
10/28/18 98 Bahamas
9/9/19 100 Bahamas Answer:
5/24/19 86 Bahamas
9/29/18 91 Bahamas
12/3/17 100 Bahamas
2/12/19 94 Bahamas
6/30/19 98 Bahamas
7/8/19 98 Bahamas
1/12/19 96 Bahamas
7/28/19 97 Bahamas
4/2/19 99 Bahamas
1/6/19 97 Bahamas
3/4/19 92 Bahamas
6/20/19 97 Bahamas
8/8/18 97 Bahamas
4/12/19 98 Bahamas
3/29/16 100 Bahamas
11/19/18 94 Bahamas
12/7/18 97 Bahamas
12/2/18 98 Bahamas
8/4/19 95 Bahamas
2/9/19 100 Bahamas
12/5/17 100 Bahamas
11/4/18 100 Bahamas
12/21/17 95 Bahamas
3/27/19 87 Bahamas
12/27/18 90 Bahamas
9/30/18 96 Bahamas
3/25/19 98 Bahamas
7/5/19 99 Bahamas
9/21/19 95 Bahamas
2/6/19 91 Bahamas
9/13/18 95 Bahamas
9/10/19 97 Bahamas
5/26/18 93 Bahamas
4/2/19 90 Bahamas
10/29/19 96 Bahamas
3/18/18 79 Bahamas
5/28/19 97 Bahamas
3/9/19 90 Bahamas
3/5/19 93 Bahamas
12/30/17 98 Bahamas
4/1/19 99 Bahamas
1/3/19 89 Bahamas
7/7/18 90 Bermuda
10/18/19 99 Bermuda
4/3/19 99 Bermuda
8/29/18 99 Bermuda
5/6/19 97 Bermuda
9/29/17 93 Bermuda
1/19/19 96 Bermuda
6/3/18 97 Bermuda
1/16/18 86 Bermuda
1/3/19 95 Bermuda
1/21/19 87 Bermuda
3/25/18 100 Bermuda
9/11/19 94 Bermuda
8/31/19 100 Bermuda
8/19/18 100 Bermuda
5/29/19 96 Bermuda
8/2/16 96 Bermuda
10/28/17 98 Europe
11/10/19 99 Europe
10/14/18 93 Europe
10/31/17 94 Europe
8/16/19 94 Europe
7/8/19 90 Europe
1/29/19 96 Europe
9/24/18 100 Europe
4/5/16 94 Europe
11/20/18 96 Europe
12/22/17 97 Europe
12/27/16 95 Europe
12/13/16 95 Europe
4/2/16 99 Europe
8/6/19 99 Europe
3/17/19 98 Europe
6/10/19 100 Europe
3/16/19 92 Europe
8/23/17 98 Europe
4/22/19 97 Europe
3/6/19 96 Europe
10/2/18 98 Europe
2/11/19 100 Europe
11/29/16 89 Europe
12/19/18 94 Europe
10/21/18 96 Europe
1/23/19 99 Europe
8/25/18 93 Europe
9/20/19 98 Europe
10/4/18 96 Europe
10/26/19 88 Europe
6/17/19 100 Europe
4/7/19 96 Europe
7/4/19 96 Europe
1/27/17 92 Europe
7/7/19 95 Europe
2/10/16 90 Europe
3/25/19 91 Europe
2/14/19 94 Europe
4/16/19 91 Europe
3/26/19 96 Europe
2/20/19 95 Europe
5/30/19 97 Europe
10/23/19 100 Europe
11/13/17 95 Europe
10/15/18 100 Europe
12/8/17 97 Europe
5/31/19 98 Europe
7/3/19 98 Europe
8/17/19 99 Europe
11/25/18 97 Europe
6/18/19 98 Other
10/6/17 84 Other
7/6/19 91 Other
8/25/19 91 Other
8/23/19 91 Other
7/6/19 86 Other
6/7/19 92 Other
7/11/19 94 Other
4/22/18 97 Other
7/9/19 94 Other
12/22/18 97 Other
1/20/19 88 Other
5/4/19 90 Panama
10/5/19 97 Panama
7/13/19 91 Panama
7/20/19 94 Panama
10/19/19 96 Panama
10/5/19 99 Panama
2/2/19 93 Panama
3/11/19 97 Panama
6/29/19 95 Panama
9/10/19 99 Panama
10/18/19 95 Panama
2/13/19 93 Panama
5/5/19 98 Panama
7/30/18 97 Panama
8/18/19 93 Panama
10/6/18 93 Panama
9/9/19 97 Panama
9/6/19 97 Panama
12/16/18 88 Panama
7/22/19 98 Panama
3/14/19 93 Panama
2/9/19 97 Panama
2/23/19 92 Panama
8/16/19 92 USA
4/1/19 93 USA
8/15/19 94 USA
9/9/18 79 USA
5/19/18 92 USA
7/31/19 88 USA
8/7/19 99 USA

Task 6

Task 6: This is a task to complete the work done similarly in task 3 by using the ideas and tools given there.
First,use the extracted partial Flag data, ships that were inspected since 2016, to construct a table summarizing the, mean, and stand deviation of Score data,
then find the percentage of data that fall within two or three standard derivations of the mean, respectively.
Lastly, calculate a few z-scores from the Score data and then calculate Score values corresponding to the given z-scores
(Questions that need to be completed are in cells with color orange).
Extracted partial data, since 2016, sorted by Flag
Date Scores Flag Cut-off time Mean, m Stdev, s Left End of the interal Right End of the interval Frequency Inside Percentage
2/24/19 90 Bahamas 1/1/16 94.95 m-2s m+2s
5/12/19 99 Bahamas m-3s m+3s
4/26/19 93 Bahamas
6/11/19 100 Bahamas
1/9/19 95 Bahamas
5/26/18 91 Bahamas Score z-score z-score Score
2/23/19 92 Bahamas 80 -1.5
4/6/19 100 Bahamas 86 -1
3/4/19 98 Bahamas 90 -0.5
7/11/19 94 Bahamas 95 0
7/12/19 97 Bahamas 100 0.5
7/25/19 94 Bahamas 1
2/21/19 92 Bahamas 1.25
8/10/19 97 Bahamas
12/7/18 95 Bahamas
9/12/19 91 Bahamas
8/17/18 100 Bahamas Question: What are the empirical rule conclusions about these two percentages?
3/30/19 94 Bahamas Compare the percentages to the percentages given by the empirical rule, are they larger, smaller or equal to the empirical rule conclusions?
2/8/19 96 Bahamas
12/7/18 100 Bahamas
9/15/19 97 Bahamas Answer:
7/12/19 100 Bahamas
4/24/17 90 Bahamas
9/26/16 90 Bahamas
10/2/18 95 Bahamas
6/9/19 97 Bahamas
6/19/19 93 Bahamas
9/10/16 87 Bahamas
5/19/19 96 Bahamas
4/11/19 92 Bahamas
3/29/19 98 Bahamas
10/28/18 98 Bahamas
9/9/19 100 Bahamas
5/24/19 86 Bahamas
9/29/18 91 Bahamas
12/3/17 100 Bahamas
2/12/19 94 Bahamas
6/30/19 98 Bahamas
7/8/19 98 Bahamas
1/12/19 96 Bahamas
7/28/19 97 Bahamas
4/2/19 99 Bahamas
1/6/19 97 Bahamas
3/4/19 92 Bahamas
6/20/19 97 Bahamas
8/8/18 97 Bahamas
4/12/19 98 Bahamas
3/29/16 100 Bahamas
11/19/18 94 Bahamas
12/7/18 97 Bahamas
12/2/18 98 Bahamas
8/4/19 95 Bahamas
2/9/19 100 Bahamas
12/5/17 100 Bahamas
11/4/18 100 Bahamas
12/21/17 95 Bahamas
3/27/19 87 Bahamas
12/27/18 90 Bahamas
9/30/18 96 Bahamas
3/25/19 98 Bahamas
7/5/19 99 Bahamas
9/21/19 95 Bahamas
2/6/19 91 Bahamas
9/13/18 95 Bahamas
9/10/19 97 Bahamas
5/26/18 93 Bahamas
4/2/19 90 Bahamas
10/29/19 96 Bahamas
3/18/18 79 Bahamas
5/28/19 97 Bahamas
3/9/19 90 Bahamas
3/5/19 93 Bahamas
12/30/17 98 Bahamas
4/1/19 99 Bahamas
1/3/19 89 Bahamas
7/7/18 90 Bermuda
10/18/19 99 Bermuda
4/3/19 99 Bermuda
8/29/18 99 Bermuda
5/6/19 97 Bermuda
9/29/17 93 Bermuda
1/19/19 96 Bermuda
6/3/18 97 Bermuda
1/16/18 86 Bermuda
1/3/19 95 Bermuda
1/21/19 87 Bermuda
3/25/18 100 Bermuda
9/11/19 94 Bermuda
8/31/19 100 Bermuda
8/19/18 100 Bermuda
5/29/19 96 Bermuda
8/2/16 96 Bermuda
10/28/17 98 Europe
11/10/19 99 Europe
10/14/18 93 Europe
10/31/17 94 Europe
8/16/19 94 Europe
7/8/19 90 Europe
1/29/19 96 Europe
9/24/18 100 Europe
4/5/16 94 Europe
11/20/18 96 Europe
12/22/17 97 Europe
12/27/16 95 Europe
12/13/16 95 Europe
4/2/16 99 Europe
8/6/19 99 Europe
3/17/19 98 Europe
6/10/19 100 Europe
3/16/19 92 Europe
8/23/17 98 Europe
4/22/19 97 Europe
3/6/19 96 Europe
10/2/18 98 Europe
2/11/19 100 Europe
11/29/16 89 Europe
12/19/18 94 Europe
10/21/18 96 Europe
1/23/19 99 Europe
8/25/18 93 Europe
9/20/19 98 Europe
10/4/18 96 Europe
10/26/19 88 Europe
6/17/19 100 Europe
4/7/19 96 Europe
7/4/19 96 Europe
1/27/17 92 Europe
7/7/19 95 Europe
2/10/16 90 Europe
3/25/19 91 Europe
2/14/19 94 Europe
4/16/19 91 Europe
3/26/19 96 Europe
2/20/19 95 Europe
5/30/19 97 Europe
10/23/19 100 Europe
11/13/17 95 Europe
10/15/18 100 Europe
12/8/17 97 Europe
5/31/19 98 Europe
7/3/19 98 Europe
8/17/19 99 Europe
11/25/18 97 Europe
6/18/19 98 Other
10/6/17 84 Other
7/6/19 91 Other
8/25/19 91 Other
8/23/19 91 Other
7/6/19 86 Other
6/7/19 92 Other
7/11/19 94 Other
4/22/18 97 Other
7/9/19 94 Other
12/22/18 97 Other
1/20/19 88 Other
5/4/19 90 Panama
10/5/19 97 Panama
7/13/19 91 Panama
7/20/19 94 Panama
10/19/19 96 Panama
10/5/19 99 Panama
2/2/19 93 Panama
3/11/19 97 Panama
6/29/19 95 Panama
9/10/19 99 Panama
10/18/19 95 Panama
2/13/19 93 Panama
5/5/19 98 Panama
7/30/18 97 Panama
8/18/19 93 Panama
10/6/18 93 Panama
9/9/19 97 Panama
9/6/19 97 Panama
12/16/18 88 Panama
7/22/19 98 Panama
3/14/19 93 Panama
2/9/19 97 Panama
2/23/19 92 Panama
8/16/19 92 USA
4/1/19 93 USA
8/15/19 94 USA
9/9/18 79 USA
5/19/18 92 USA
7/31/19 88 USA
8/7/19 99 USA

Task 7

Task 7: This is mostly a demonstration task, but you need to answer two questions at the end.
We first construct a binomial distribution histogram, then from the given simulated random samples to construct a relative frequency histogram,
then to compare the two graphs.
You may need to click the graph on the chart, select format data or label to modify the appearance of the graph.
(Questions that need to completed are in cell with color orange).
Bahamas Flag chance, p, from Task 1
p x n Binomial probability, p(x)
40% 0 10 0.01
1 10 0.04
2 10 0.12
3 10 0.22
4 10 0.25
5 10 0.20
6 10 0.11
7 10 0.04
8 10 0.01
9 10 0.00
10 10 0.00
100 random samples of size n=10 from the entire 212 data set
Sample.1 Sample.2 Sample.3 Sample.4 Sample.5 Sample.6 Sample.7 Sample.8 Sample.9 Sample.10 Sample.11 Sample.12 Sample.13 Sample.14 Sample.15 Sample.16 Sample.17 Sample.18 Sample.19 Sample.20 Sample.21 Sample.22 Sample.23 Sample.24 Sample.25 Sample.26 Sample.27 Sample.28 Sample.29 Sample.30 Sample.31 Sample.32 Sample.33 Sample.34 Sample.35 Sample.36 Sample.37 Sample.38 Sample.39 Sample.40 Sample.41 Sample.42 Sample.43 Sample.44 Sample.45 Sample.46 Sample.47 Sample.48 Sample.49 Sample.50 Sample.51 Sample.52 Sample.53 Sample.54 Sample.55 Sample.56 Sample.57 Sample.58 Sample.59 Sample.60 Sample.61 Sample.62 Sample.63 Sample.64 Sample.65 Sample.66 Sample.67 Sample.68 Sample.69 Sample.70 Sample.71 Sample.72 Sample.73 Sample.74 Sample.75 Sample.76 Sample.77 Sample.78 Sample.79 Sample.80 Sample.81 Sample.82 Sample.83 Sample.84 Sample.85 Sample.86 Sample.87 Sample.88 Sample.89 Sample.90 Sample.91 Sample.92 Sample.93 Sample.94 Sample.95 Sample.96 Sample.97 Sample.98 Sample.99 Sample.100
Other Panama Europe Europe Panama Panama Bahamas Europe Bermuda Other Panama Bahamas Bahamas Bahamas Panama Bahamas Bahamas Panama Bahamas Other Bahamas Europe Europe Bahamas Bermuda Bahamas Europe Bahamas Bahamas Other Europe Other Bermuda Bahamas Europe Bahamas Bahamas Europe Europe Europe Europe Panama Europe USA Bahamas Panama Panama Europe Other Bahamas Bahamas Other Other Europe Other Bermuda Bahamas Bahamas Europe Europe Bahamas Bahamas Europe Other Other Panama Bahamas Other Panama Europe Bermuda Europe Other Bermuda Panama Bermuda Other Europe Europe Europe Bermuda Europe Bahamas Other Europe Europe Bahamas Bahamas Europe Europe Bahamas Bahamas Panama Europe Other Panama Europe Bahamas Bahamas Bahamas
Bermuda Bahamas Panama Other Other Other Europe Panama Bahamas Other Panama Bahamas Bahamas Panama Bahamas Bahamas Bermuda Bahamas Bahamas Bahamas Panama Bahamas Europe Bahamas Other Bahamas Europe Bahamas Bahamas Bahamas Europe Bahamas Europe Bahamas Europe Europe Bahamas Europe USA Bahamas Bahamas Bahamas Other Bahamas USA Panama Panama Europe Europe Europe Europe Bahamas Europe Bahamas Bermuda Europe Bahamas Other Panama Bahamas Europe Bahamas Bahamas Bahamas Europe Europe Europe Bahamas Panama Panama Europe Europe Other Bermuda Bahamas Bermuda Bermuda Bahamas Bahamas Panama Bahamas Europe Panama Panama Bahamas Panama Europe Bahamas Bahamas Bahamas Europe Bahamas Panama Panama Europe Europe Europe Bahamas Bermuda Panama
Bahamas Panama Bahamas Bahamas Bahamas Bermuda Bahamas Bahamas Bermuda Other Bermuda Panama Europe Europe Europe Bahamas Bahamas Panama Europe Bermuda Bahamas Europe Bahamas Bahamas Bahamas Other Europe Bahamas Europe Bahamas Bahamas Bahamas Bahamas Panama Europe Europe Bahamas Other Bahamas Other Panama Other Europe Panama Bahamas Bermuda Other Other Europe Panama Bahamas Bahamas Bahamas Europe Bahamas Panama Europe Panama Europe Europe Europe Bahamas Other Europe Panama Bahamas Bahamas USA Bahamas Europe Europe Panama Other Panama Other Bahamas Bahamas Other Bermuda Bahamas Bahamas Bahamas Europe Panama Europe Bermuda Bermuda Bahamas Bahamas Bahamas Bahamas Europe Bahamas Other Europe Panama Panama Panama Europe Panama
Europe Panama Panama Bahamas Europe Europe Other Europe Bahamas Europe Bahamas Bermuda Bahamas Europe Europe Panama Bahamas Bahamas Europe Bahamas Bahamas Panama Bahamas Bahamas Europe Europe Bahamas Europe Bahamas Bahamas Panama Bahamas Bermuda Bahamas Bahamas Other Bahamas Bahamas Panama Bahamas Bahamas Panama Panama Bermuda Panama Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Other Bahamas Bahamas Other Bahamas Europe Other Panama Europe Europe Panama Europe Bermuda Panama Panama Panama Bermuda Bermuda Bahamas Bahamas Europe Bahamas Bahamas Panama Bahamas Europe Other Panama Europe Bahamas Bahamas Bahamas Panama Bahamas Bahamas Bermuda USA Other Bahamas Europe Bahamas Europe Europe Europe Bahamas Bahamas Bahamas Bahamas Europe
Bahamas Bahamas Bahamas Bermuda Panama Other Bahamas Bahamas Panama Europe Bahamas Bahamas Bahamas Europe Other Bahamas Bahamas Bahamas Panama Bahamas Panama Europe Europe Panama Bahamas Panama Bahamas Bahamas Europe Other Bahamas Bahamas Other Bahamas Bahamas Europe Panama Bermuda Bermuda Bermuda Bahamas Europe Europe Panama Bahamas USA Panama Bahamas Other Europe Europe Bahamas Europe Bahamas Bahamas Bahamas Europe Bahamas USA USA Europe Europe Europe Bahamas Bermuda Panama Bahamas Bahamas Bahamas Panama Europe Panama Bahamas Panama Europe Other Europe Bahamas Europe Europe Panama Bahamas Bahamas Europe Europe Other Bahamas Bahamas Europe Europe Panama Bahamas Europe Panama Bahamas Other Bahamas Europe Europe Panama
Bahamas Bermuda Europe Panama Bahamas Bermuda Other Panama Bermuda Bahamas Panama Europe Europe Bahamas Europe Bahamas Bermuda Bahamas Europe Bahamas Panama Bahamas Bahamas Europe Bahamas Europe Bahamas Other Panama Bahamas Europe Bermuda Bahamas Bahamas Panama Bahamas Bahamas Europe Other Bermuda Europe Bahamas Bahamas Europe Bahamas Bermuda Bermuda Bahamas Panama Other Bahamas Bahamas Other Panama Bahamas Bahamas Other Europe Bahamas Bahamas USA Europe Europe Bermuda Bahamas Europe Bahamas Europe Panama Bahamas Panama Bahamas Bermuda Bahamas Europe Bermuda Europe Europe Bahamas Bahamas Europe Europe Panama Bermuda Panama Europe Europe Bahamas Bahamas Other Bahamas Panama Other Europe Bermuda Bahamas Panama Bahamas Bermuda Europe
Bermuda Europe Europe Europe Other Panama Europe Bahamas Bahamas Panama Panama Bahamas Bahamas Panama Panama Bahamas Other Bahamas Europe Europe Bahamas Bahamas Europe Europe Bahamas Bahamas Bahamas Europe Europe Bahamas Bahamas Other Bahamas Bahamas Bahamas Bahamas Bahamas Panama Europe Panama Other Bahamas Bahamas Europe Bahamas Europe Bahamas Bahamas Other Bahamas Bahamas Bahamas Bahamas Panama Europe Bahamas Other Europe Bahamas Europe Bermuda USA USA Bahamas Bahamas Bahamas Europe Europe Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Other Panama Bermuda USA Other Europe Bahamas Europe Other Europe Panama Europe Bermuda Bahamas Europe Bahamas Europe Panama Panama Bahamas Bahamas
Bahamas Bahamas Bahamas Europe Bermuda Bahamas Bahamas Europe Bahamas Europe Europe Bahamas Bahamas Europe Bahamas Panama Bahamas Bahamas Bahamas Europe Bahamas Bahamas Bahamas Europe Other Europe USA Bahamas Bahamas Other Panama Bahamas Bahamas Bahamas Bahamas Other Bahamas Europe Panama Europe Panama Europe Europe USA Other Other Panama Bahamas Bahamas Europe Bermuda Bahamas Europe Europe Panama Panama Europe Bahamas Bahamas Other Panama Bahamas Bahamas Europe USA Bermuda Bahamas Other Other Bahamas Bahamas Bahamas Bahamas Panama Europe Bermuda Bahamas Other Bermuda Europe Europe Bahamas Panama Bahamas Bahamas Panama Europe Bahamas Bahamas Bahamas Europe Other Other Bahamas Bahamas Bahamas Bahamas Other Europe Bermuda
Europe Bahamas Bahamas Europe Bahamas Europe Bahamas Bahamas Panama Europe Europe Bermuda Panama Europe Bahamas Other Bahamas Bahamas Europe Bahamas Bahamas Bermuda Europe Bermuda USA Europe Panama Panama Panama Europe Bermuda Bahamas Bahamas Bahamas Bahamas Europe Panama Bahamas Bahamas Bahamas Other Bahamas Panama Bahamas Panama Bahamas Panama Europe Bahamas Panama Panama Europe Bermuda Other Europe Europe Bahamas Other Europe Europe Bermuda Europe Europe Other Bahamas Europe Panama Europe Bahamas Bahamas Europe Bahamas Europe Bahamas Europe Bahamas Bahamas Bahamas Europe Bahamas Bahamas Other Other Bahamas Panama USA Panama Bahamas Bahamas Bahamas Bahamas Bahamas Europe Europe Bahamas Bahamas Bahamas Europe Bahamas Bahamas
Bahamas Panama Panama Panama Panama Bahamas Europe Bahamas Panama Europe Europe Europe Bermuda Panama Bahamas Europe Bahamas Bahamas Panama USA Europe Europe Bahamas Europe Panama Bermuda Panama USA Bahamas Bahamas Europe Bahamas Other Bermuda Europe USA Europe Europe Europe Europe Europe Panama Bahamas Bahamas Bahamas Bermuda Bahamas Bahamas Bahamas Bahamas Bermuda Bahamas Europe Panama Europe Europe Other Bahamas Bahamas Europe Europe USA Europe Other Bahamas Bahamas Other Bahamas Bahamas Bahamas Europe Other Bahamas Bahamas Europe Europe Bahamas Bahamas Europe Bahamas Bahamas Europe Bahamas Europe Bahamas Bahamas Bahamas Bahamas USA Other Bahamas Bahamas Bermuda Europe Europe Bahamas Europe Europe Bahamas Bahamas
Number of times, x, that the Bahamas Flag was being included in the sample
Bahamas 5 4 4 2 3 2 5 5 4 1 2 5 6 2 4 6 7 8 3 5 6 4 5 4 4 3 4 5 5 6 3 7 5 8 5 3 7 2 2 3 3 4 3 3 6 2 3 6 4 4 5 7 3 3 3 4 3 4 4 2 1 4 2 3 4 3 5 3 5 6 3 4 5 5 2 4 5 5 3 4 5 4 4 2 4 3 3 8 5 5 5 6 2 1 4 5 4 4 5 4
Total size n 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
Frequency Relative Fequency
0 0 0
1 3 0.03
2 12 0.12
3 21 0.21
4 26 0.26
5 23 0.23
6 8 0.08
7 4 0.04
8 3 0.03
9 0 0
10 0 0
Total 100
Question: Construct a bar graph by combining two graphs togther. Are the two similar? How do you interpret this result?
Answer: The two graphs are very similar. This is because the random samples are approximately binomail distribution of n=10 and p= ?
p=

Binomial PDF of n=10, p=0.4

0 1 2 3 4 5 6 7 8 9 10 6.2404032819297342E-3 4.1275108321424996E-2 0.12285032240550132 0.21668088361285262 0.25080385741015232 0.19906321910979025 0.10971988454870327 4.1468932742816968E-2 1.0285601428336491E-2 1.5117944356610054E-3 9.9992702831121848E-5

Frequency histogram of 100 samples of size 10

0 1 2 3 4 5 6 7 8 9 10 0 0.03 0.12 0.21 0.26 0.23 0.08 0.04 0.03 0 0

Combined Graphes

Binomial probability, p(x) 0 1 2 3 4 5 6 7 8 9 10 6.2404032819297342E-3 4.1275108321424996E-2 0.12285032240550132 0.21668088361285262 0.25080385741015232 0.19906321910979025 0.10971988454870327 4.1468932742816968E-2 1.0285601428336491E-2 1.5117944356610054E-3 9.9992702831121848E-5 Relative Fequency 0 1 2 3 4 5 6 7 8 9 10 0 0.03 0.12 0.21 0.26 0.23 0.08 0.04 0.03 0 0

Task 8

Task 8: This is a task to complete the work done similarly in task 7 by using the ideas and tools given there. (Some of the questions are done for you as examples)
We first construct a binomial distribution histogram, then from the given simulated random samples to construct a relative frequency histogram,
then to compare the two graphs.
You may need to click the graph on the chart, select format data or label to modify the appearance of the graph.
(Questions that need to be completed are in cells with color orange).
Panama Flag chance, p, from Task 1
p x n Binomial probability, p(x) Binomial PDF distribution graph with n=10 and p=0.13
13% 0 10 0.25
1 10
2 10
3 10
4 10
5 10
6 10
7 10
8 10
9 10
10 10
100 random samples of size n=10 from the entire 212 data set
Sample.1 Sample.2 Sample.3 Sample.4 Sample.5 Sample.6 Sample.7 Sample.8 Sample.9 Sample.10 Sample.11 Sample.12 Sample.13 Sample.14 Sample.15 Sample.16 Sample.17 Sample.18 Sample.19 Sample.20 Sample.21 Sample.22 Sample.23 Sample.24 Sample.25 Sample.26 Sample.27 Sample.28 Sample.29 Sample.30 Sample.31 Sample.32 Sample.33 Sample.34 Sample.35 Sample.36 Sample.37 Sample.38 Sample.39 Sample.40 Sample.41 Sample.42 Sample.43 Sample.44 Sample.45 Sample.46 Sample.47 Sample.48 Sample.49 Sample.50 Sample.51 Sample.52 Sample.53 Sample.54 Sample.55 Sample.56 Sample.57 Sample.58 Sample.59 Sample.60 Sample.61 Sample.62 Sample.63 Sample.64 Sample.65 Sample.66 Sample.67 Sample.68 Sample.69 Sample.70 Sample.71 Sample.72 Sample.73 Sample.74 Sample.75 Sample.76 Sample.77 Sample.78 Sample.79 Sample.80 Sample.81 Sample.82 Sample.83 Sample.84 Sample.85 Sample.86 Sample.87 Sample.88 Sample.89 Sample.90 Sample.91 Sample.92 Sample.93 Sample.94 Sample.95 Sample.96 Sample.97 Sample.98 Sample.99 Sample.100
Other Panama Europe Europe Panama Panama Bahamas Europe Bermuda Other Panama Bahamas Bahamas Bahamas Panama Bahamas Bahamas Panama Bahamas Other Bahamas Europe Europe Bahamas Bermuda Bahamas Europe Bahamas Bahamas Other Europe Other Bermuda Bahamas Europe Bahamas Bahamas Europe Europe Europe Europe Panama Europe USA Bahamas Panama Panama Europe Other Bahamas Bahamas Other Other Europe Other Bermuda Bahamas Bahamas Europe Europe Bahamas Bahamas Europe Other Other Panama Bahamas Other Panama Europe Bermuda Europe Other Bermuda Panama Bermuda Other Europe Europe Europe Bermuda Europe Bahamas Other Europe Europe Bahamas Bahamas Europe Europe Bahamas Bahamas Panama Europe Other Panama Europe Bahamas Bahamas Bahamas
Bermuda Bahamas Panama Other Other Other Europe Panama Bahamas Other Panama Bahamas Bahamas Panama Bahamas Bahamas Bermuda Bahamas Bahamas Bahamas Panama Bahamas Europe Bahamas Other Bahamas Europe Bahamas Bahamas Bahamas Europe Bahamas Europe Bahamas Europe Europe Bahamas Europe USA Bahamas Bahamas Bahamas Other Bahamas USA Panama Panama Europe Europe Europe Europe Bahamas Europe Bahamas Bermuda Europe Bahamas Other Panama Bahamas Europe Bahamas Bahamas Bahamas Europe Europe Europe Bahamas Panama Panama Europe Europe Other Bermuda Bahamas Bermuda Bermuda Bahamas Bahamas Panama Bahamas Europe Panama Panama Bahamas Panama Europe Bahamas Bahamas Bahamas Europe Bahamas Panama Panama Europe Europe Europe Bahamas Bermuda Panama
Bahamas Panama Bahamas Bahamas Bahamas Bermuda Bahamas Bahamas Bermuda Other Bermuda Panama Europe Europe Europe Bahamas Bahamas Panama Europe Bermuda Bahamas Europe Bahamas Bahamas Bahamas Other Europe Bahamas Europe Bahamas Bahamas Bahamas Bahamas Panama Europe Europe Bahamas Other Bahamas Other Panama Other Europe Panama Bahamas Bermuda Other Other Europe Panama Bahamas Bahamas Bahamas Europe Bahamas Panama Europe Panama Europe Europe Europe Bahamas Other Europe Panama Bahamas Bahamas USA Bahamas Europe Europe Panama Other Panama Other Bahamas Bahamas Other Bermuda Bahamas Bahamas Bahamas Europe Panama Europe Bermuda Bermuda Bahamas Bahamas Bahamas Bahamas Europe Bahamas Other Europe Panama Panama Panama Europe Panama
Europe Panama Panama Bahamas Europe Europe Other Europe Bahamas Europe Bahamas Bermuda Bahamas Europe Europe Panama Bahamas Bahamas Europe Bahamas Bahamas Panama Bahamas Bahamas Europe Europe Bahamas Europe Bahamas Bahamas Panama Bahamas Bermuda Bahamas Bahamas Other Bahamas Bahamas Panama Bahamas Bahamas Panama Panama Bermuda Panama Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Other Bahamas Bahamas Other Bahamas Europe Other Panama Europe Europe Panama Europe Bermuda Panama Panama Panama Bermuda Bermuda Bahamas Bahamas Europe Bahamas Bahamas Panama Bahamas Europe Other Panama Europe Bahamas Bahamas Bahamas Panama Bahamas Bahamas Bermuda USA Other Bahamas Europe Bahamas Europe Europe Europe Bahamas Bahamas Bahamas Bahamas Europe
Bahamas Bahamas Bahamas Bermuda Panama Other Bahamas Bahamas Panama Europe Bahamas Bahamas Bahamas Europe Other Bahamas Bahamas Bahamas Panama Bahamas Panama Europe Europe Panama Bahamas Panama Bahamas Bahamas Europe Other Bahamas Bahamas Other Bahamas Bahamas Europe Panama Bermuda Bermuda Bermuda Bahamas Europe Europe Panama Bahamas USA Panama Bahamas Other Europe Europe Bahamas Europe Bahamas Bahamas Bahamas Europe Bahamas USA USA Europe Europe Europe Bahamas Bermuda Panama Bahamas Bahamas Bahamas Panama Europe Panama Bahamas Panama Europe Other Europe Bahamas Europe Europe Panama Bahamas Bahamas Europe Europe Other Bahamas Bahamas Europe Europe Panama Bahamas Europe Panama Bahamas Other Bahamas Europe Europe Panama
Bahamas Bermuda Europe Panama Bahamas Bermuda Other Panama Bermuda Bahamas Panama Europe Europe Bahamas Europe Bahamas Bermuda Bahamas Europe Bahamas Panama Bahamas Bahamas Europe Bahamas Europe Bahamas Other Panama Bahamas Europe Bermuda Bahamas Bahamas Panama Bahamas Bahamas Europe Other Bermuda Europe Bahamas Bahamas Europe Bahamas Bermuda Bermuda Bahamas Panama Other Bahamas Bahamas Other Panama Bahamas Bahamas Other Europe Bahamas Bahamas USA Europe Europe Bermuda Bahamas Europe Bahamas Europe Panama Bahamas Panama Bahamas Bermuda Bahamas Europe Bermuda Europe Europe Bahamas Bahamas Europe Europe Panama Bermuda Panama Europe Europe Bahamas Bahamas Other Bahamas Panama Other Europe Bermuda Bahamas Panama Bahamas Bermuda Europe
Bermuda Europe Europe Europe Other Panama Europe Bahamas Bahamas Panama Panama Bahamas Bahamas Panama Panama Bahamas Other Bahamas Europe Europe Bahamas Bahamas Europe Europe Bahamas Bahamas Bahamas Europe Europe Bahamas Bahamas Other Bahamas Bahamas Bahamas Bahamas Bahamas Panama Europe Panama Other Bahamas Bahamas Europe Bahamas Europe Bahamas Bahamas Other Bahamas Bahamas Bahamas Bahamas Panama Europe Bahamas Other Europe Bahamas Europe Bermuda USA USA Bahamas Bahamas Bahamas Europe Europe Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Bahamas Other Panama Bermuda USA Other Europe Bahamas Europe Other Europe Panama Europe Bermuda Bahamas Europe Bahamas Europe Panama Panama Bahamas Bahamas
Bahamas Bahamas Bahamas Europe Bermuda Bahamas Bahamas Europe Bahamas Europe Europe Bahamas Bahamas Europe Bahamas Panama Bahamas Bahamas Bahamas Europe Bahamas Bahamas Bahamas Europe Other Europe USA Bahamas Bahamas Other Panama Bahamas Bahamas Bahamas Bahamas Other Bahamas Europe Panama Europe Panama Europe Europe USA Other Other Panama Bahamas Bahamas Europe Bermuda Bahamas Europe Europe Panama Panama Europe Bahamas Bahamas Other Panama Bahamas Bahamas Europe USA Bermuda Bahamas Other Other Bahamas Bahamas Bahamas Bahamas Panama Europe Bermuda Bahamas Other Bermuda Europe Europe Bahamas Panama Bahamas Bahamas Panama Europe Bahamas Bahamas Bahamas Europe Other Other Bahamas Bahamas Bahamas Bahamas Other Europe Bermuda
Europe Bahamas Bahamas Europe Bahamas Europe Bahamas Bahamas Panama Europe Europe Bermuda Panama Europe Bahamas Other Bahamas Bahamas Europe Bahamas Bahamas Bermuda Europe Bermuda USA Europe Panama Panama Panama Europe Bermuda Bahamas Bahamas Bahamas Bahamas Europe Panama Bahamas Bahamas Bahamas Other Bahamas Panama Bahamas Panama Bahamas Panama Europe Bahamas Panama Panama Europe Bermuda Other Europe Europe Bahamas Other Europe Europe Bermuda Europe Europe Other Bahamas Europe Panama Europe Bahamas Bahamas Europe Bahamas Europe Bahamas Europe Bahamas Bahamas Bahamas Europe Bahamas Bahamas Other Other Bahamas Panama USA Panama Bahamas Bahamas Bahamas Bahamas Bahamas Europe Europe Bahamas Bahamas Bahamas Europe Bahamas Bahamas
Bahamas Panama Panama Panama Panama Bahamas Europe Bahamas Panama Europe Europe Europe Bermuda Panama Bahamas Europe Bahamas Bahamas Panama USA Europe Europe Bahamas Europe Panama Bermuda Panama USA Bahamas Bahamas Europe Bahamas Other Bermuda Europe USA Europe Europe Europe Europe Europe Panama Bahamas Bahamas Bahamas Bermuda Bahamas Bahamas Bahamas Bahamas Bermuda Bahamas Europe Panama Europe Europe Other Bahamas Bahamas Europe Europe USA Europe Other Bahamas Bahamas Other Bahamas Bahamas Bahamas Europe Other Bahamas Bahamas Europe Europe Bahamas Bahamas Europe Bahamas Bahamas Europe Bahamas Europe Bahamas Bahamas Bahamas Bahamas USA Other Bahamas Bahamas Bermuda Europe Europe Bahamas Europe Europe Bahamas Bahamas
Number of times, x, that the Panama Flag was being included in the sample
Panama 0 4 3 2 3 2 0 2 3 1 4 1 1 3 2 2 0 2 2 0 3 1 0 1 1 1 2 1 2 0 2 0 0 1 1 0 2 1 2 1 2 3 2 2 2 2 5 0 1 2 1 0 0 3 1 2 0 1 2 0 1 1 0 0 2 3 2 0 3 2 1 2 0 3 2 0 0 0 1 1 2 0 3 3 2 2 1 0 0 1 1 1 2 2 0 2 3 2 0 3
Total size n 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
Frequency Relative Fequency Frequency Histogram
0 26
1
2
3
4
5
6
7
8
9
10
Total 100
Question: Construct a bar graph by combining two graphs togther. Are the two similar? How do you interpret this result?
Combined Graphes
Answer: