Having paying guests in ship staterooms is extremely important to the financial health of a cruise...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Additional data needed to calculate percentage of stateroom occupancy for each ship Total number of staterooms on each ship Assumptions for proportion ... View the full answer
Related Book For
Statistics For Business & Economics
ISBN: 9781337901062
14th Edition
Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The new CFO e-mails you, asking for your help this week analyzing some competitor's financial statements. Knowing that there are over 20 different ratios that can be used to monitor and assess the...
-
Capital expenditures talk over funds that are employed by a corporation for the acquisition, improvement, or maintenance of long-term assets to enhance the efficiency or capacity of the corporate....
-
Write the nodal equations for the networks in Figure. Using determinants, solve for the nodal vo ltages. R4 2 5 A R 1 R3 50 4 3 A
-
The assembly department has the following production and cost data for the current month. Materials are entered at the beginning of the process. The ending work in process units are 70% complete as...
-
You are an astrophysicist working on a problem involving Saturn's rings and trying to figure out why the smaller ice chunks in the rings stick to larger chunks. You hypothesize that as the chunks...
-
Consider the air pollution and mortality data given in Problem 3.15 and Table B. 15 . Problem 3.15 McDonald and Ayers [1978] present data from an early study that examined the possible link between...
-
Twenty liters of liquid n-propyl benzoate (C6H5CO2C3H7, SG = 1021) and 15 liters of liquid benzene are mixed and heated from 25C to 75C. Calculate the required heat input (kJ), using Kopps rule when...
-
(Profitability analysis) Last year the P. M. Postem Corporation had sales of $440,000, with a cost of goods sold of $112,000. The firm's operating expenses were $130,000, and its increase in retained...
-
The Conch Oil Company needs to transport 30 million barrels of crude oil from a port in Doha, Qatar in the Persian Gulf to three refineries throughout Europe. The refineries are in Rotterdam,...
-
A proprietor of a restaurant knows that will need 40, 70, and 60 tablecloths on Thursday, Friday, and Saturday respectively for scheduled banquets. He can rent tablecloths for 3 days for $2 each. A...
-
What are any major impacts of the macroeconomic business cycle on supply for the soft drink industry (NAICS 312111)- i.e. how might different phases of the business cycle impact the industry's...
-
Stocks and savings accounts are both examples of investments that give the investor a share in a company. True False
-
How Shifts in Trade Impact Labor Markets Section 2 introduces the impacts of international trade on jobs, wages, and working conditions on the domestic market. In this discussion, your task is to:...
-
Topic: The relationship between international trade and national income The globalization of trade has become a central feature of the modern economy. How does international trade impact national...
-
A seller's estimated net proceeds calculation is a guarantee of the money they will cash out after the close of escrow. Group of answer choices True False
-
what is electric displocement vector D ?
-
Explain what is meant by vicarious liability and when it is available?
-
In 2018, Mike Krzyewski and John Calipari topped the list of highest-paid college basketball coaches (Sports Illustrated website,...
-
Consumer complaints are frequently reported to the Better Business Bureau (BBB). Some industries against whom the most complaints are reported to the BBB are banks; cable and satellite television...
-
Electric plug-in vehicle sales have been increasing worldwide. The table below displays data collected by the U.S. Department of Energy on electric plug-in vehicle sales in the words top markets in...
-
Suppose a job enrichment effort in one plant of a manufacturing firm is judged to be very successful. You are the corporate change agent responsible for the project, and you wish to diffuse it to...
-
Describe an example of resistance to change that you have observed. Why did it occur?
-
What qualities would the ideal gatekeeper possess to facilitate the communication of technical information in the firm?
Study smarter with the SolutionInn App