Having paying guests in ship staterooms is extremely important to the financial health of a cruise company. Percentage of stateroom occupancy is an often-reported metric on cruise ships. Holland America sails multiple ships out of Port Everglades, Ft. Lauderdale, FL during the Christmas season for both Eastern and Western Caribbean 7-day cruises. Stateroom occupancy data for two ships on different 7-day cruises Relevant data are contained in the Excel dataset Test 1 Data.xlsx on the tab Cruise Ships. Ship Duration Itinerary Occupied Rooms What additional data will you need to calculate percentage of stateroom occupancy for each ship? Total staterooms? Conduct a proportion test. Set your alpha level to .10, use a two-tail test. Assumptions Checks: Select a level of significance Tails: MS Eurodam 7-Days Eastern Caribbean 850 tail test, a = , n(1-p) = ; Zaandam: np = n(1-p) = Assumptions: Eurodam: np = Met?: Assumptions of normality met Assumptions of normality violated - check one Select the appropriate statistic Test: State the Null and the Alternative Hypothesis Null: Ho: Alt: H: CV: Calculate the Statistics Stats: z = Descriptives: Eurodam: P = MS Zaandam 7-Days Western Caribbean ,p= 525 . 90% CI[ ; Zaandam: P = (sample proportions) " Make the decision! APA: Conclusions. Based on the findings, what can you conclude about whether the proportion of stateroom occupancy on Eurodam sailings is the same as on Zaandam sailings? Line Ship Carnival Jubilee Carnival Celebration Carnival Mardi Gras Carnival Panorama Carnival Horizon Carnival Vista Carnival Breeze Carnival Magic Carnival Dream Carnival Splendor Carnival Freedom Carnival Liberty Carnival Valor Carnival Miracle Carnival Glory Carnival Conquest Carnival Legend Carnival Pride Carnival Spirit Carnival Radiance Carnival Sunrise Carnival Paradise Carnival Elation Sunshine! Ecstasy Discovery Princess Enchanted Princess Sky Princess Princess Majestic Princess Princess Regal Princess Princess Princess Princess Carnival Carnival Princess Princess Princess Princess Princess Princess Princess Princess Royal Princess Ruby Princess Emerald Princess Crown Princess Princess Princess Holland Koningsdam Nieuw Statendam. Holland Holland Rotterdam Holland Nieuw Amsterdam Holland Eurodam Holland Noordam Holland Oosterdam Holland Westerdam Holland Zuiderdam Holland Holland Class Excel Excel Zaandam Volendam Excel Vista Vista Vista Conquest Conquest Dream 2012 Dream 2011 Dream 2009 Splendor 2008 Conquest 2007 Conquest 2005 Conquest 2004 Spirit 2004 2002 2002 2002 Spirit Spirit Spirit Caribbean Princess Grand Diamond Princess Grand Sapphire Princess Grand Island Princess Coral Coral Princess Coral Grand Princess Grand Built Length (feet) Passengers (2 per cabin) Tons Crew Cabins Refurbished Decks Cruising Speed Specialty Dining Pools Hot Tubs 2023 1130 5374 182,800 1,735 2022 1130 2021 1130 2019 1055 1055 1055 1004 Royal Royal Royal Grand Grand Grand 2018 2016 2002 2001 Destiny 2021 Destiny 2019 Fantasy 1998 Fantasy 1998 Destiny 1996 Fantasy 2013 Royal 2022 Royal 2021 Royal 2019 2017 2014 2013 2008 2007 2006 2004 2004 2004 2003 2003 1998 Pinnacle 2016 Pinnacle 2018 Pinnacle 2021 Signature 2010 Signature 2008 Vista 2006 Vista 2003 2004 Vista Vista Rotterdam 1999 2002 Rotterdam. 1999 1004 1004 952 952 952 952 963 952 952 963 963 963 893 1108 855 855 892 855 1083 1083 1083 1083 1083 1083 951 951 952 952 952 952 964 965 949 935 935 935 935 935 951 951 951 951 780 780 5374 180,800 1,735 5282 180,800 1735 4008 133,500 1450 3690 133,500 1450 3934 133,500 1450 3690 130,000 1386 3690 130,000 1367 3646 130,000 1367 3012 113,573 1150 2980 110,000 1150 2974 110,000 1160 2980 110,000 1180 2124 88,500 934 2980 110,000 1150 2980 110,000 1150 2124 88,500 930 2124 88,500 930 2124 88,500. 930 2984 101,509 1,108 2984 101,509 893 2124 71,925 920 2190 71,909 900 3002 102,853 1040 2056 70,367 920 3,660 141,000 1,346 1,830 3,660 145,000 1,346 1,830 3,560 142,229 3,080 113,561 3,080 113,561 3,080 113,561 3,660 141,000 1,346 1,830 3,560 143,700 1,346 1,780 3,560 142,229 1,346 1,780 1,346 1,780 1,200 1,200 1,539 1,200 1,541 3,140 112,894 1200 1,556 2,670 115,875 1,100 1,337 2,670 115,875 1,100 1,337 2,200 92,822 900 987 2,000 91,627 895 1,545 2,600 107,517 1.150 1.301 2662 99500 1025 1331 99500 1025 1339 99500 1025 1339 86700 929 1053 1052 2678 2678 2106 2104 86273 929 820 986 817 1012 1972 82318 2024 82305 1968 82305 817 984 1970 82305 817 985 1432 61396 647 716 1432 61214 647 716 2017 2021 2017 2019 2019 2016 2021 2020 2010 2017 2019 2019 2021 2021 2019 2018 2020 2019 2019 2018 2018 2019 2018 2019 2019 2014 2017 2019 2019 19 19 19 19 19 19 19 19 19 19 18 18 16 16 17 22 22 22 22 22 22 22 22 22 22 21 24 20 6 6 5 4 5 5 5 5 5 6 5 4 4 4 4 3 3 3 3 3 3 3 3 3 3 3 7 7 7 7 7 5 5 5 5 2 2