With a capacity of 6,300 people, Royal Caribbean’s Oasis of the Seas is the world’s largest cruise ship. The average beer consum
ption over 35 randomly selected seven-day cruises on the ship was 81,740 bottles. From historical data you know that the population standard deviation of beer consumption is 4,590 bottles. Royal Caribbean would like to estimate the average beer consumption to plan its beer inventory levels on future cruises. (The ship certainly doesn’t want to run out of beer in the middle of the ocean!) A. Construct a 95% confidence interval to estimate the average beer consumption per cruise.
B. Verify this interval using excel.
C. What assumptions need to be made about this population?