Question

Often, cruise ships conduct all onboard transactions, with the exception of gambling, on a cashless basis. At the end of the cruise, guests pay one bill that covers all onboard transactions. Suppose that 60 single travelers and 70 couples were surveyed as to their onboard bills for a seven-day cruise from Los Angeles to the Mexican Riviera. Following is a summary of the bills for each group.

Singles Couples Amount($) Frequency Relative Frequency Amount($) Frequency Relative Frequency 51-100 5 100-150 5 101-150 10 201-250 5 151-200 15 251-300 5 201-250 15 301-350 5 251-300 10 351-400 10 301-350 5 401-450 10 451-500 10 501-550 10 551-600 5

a. Fill in the relative frequency for each group.

b. Construct a histogram for the singles group. Scale the x-axis by $50 widths. Use relative frequency on the y-axis.

c. Construct a histogram for the couples group. Scale the x-axis by $50 widths. Use relative frequency on the y-axis.

2. The next two tables are summaries from a neighborhood survey. Use the information in the tables to summarize the results of the survey. Which of the neighborhoods would you consider the lowest income neighborhood? Explain your answer?

TABLE 2 CROWN HEIGHTS, EAST NEW YORK PROSPECT HEIGHTS / FLATBUSH BED-STUY / BUSHWICK INCOME Count % Count % Count % LESS THAN $15,000 45 19.7% 5 7.8% 11 8.3% $15,000 - $24,999 69 30.1% 25 39.1% 38 28.6% $25,000 - $34,999 64 27.9% 18 28.1% 40 30.1% $35,000 - $44,999 27 11.8% 6 9.4% 21 15.8% $45,000 OR MORE 24 10.5% 10 15.6% 23 17.3% 3. The table below contains the 2010 obesity rates in U.S. states. Using MS-Excel, calculate the average rate of states by Group and present your summary in a chart. Copy and paste the chart into MS-Word. Which group of states has the highest obesity rate? Group A Group B Group C State Percent (%) State Percent (%) State Percent (%) Alabama 32.2 Kentucky 31.3 North Dakota 27.2 Alaska 24.5 Louisiana 31.0 Ohio 29.2 Arizona 24.3 Maine 26.8 Oklahoma 30.4 Arkansas 30.1 Maryland 27.1 Oregon 26.8 California 24.0 Massachusetts 23.0 Pennsylvania 28.6 Colorado 21.0 Michigan 30.9 Rhode Island 25.5 Connecticut 22.5 Minnesota 24.8 South Carolina 31.5 Delaware 28.0 Mississippi 34.0 South Dakota 27.3 Washington, DC

Answer 1