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 on-board 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 table below is summary from a neighborhood survey. Use the information in the table to summarize the results of the survey. Which of the neighborhood would you consider the lowest income neighborhood? Explain your answer?
TABLE 1
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
22.2
Missouri
30.5
Tennessee
30.8
Florida
26.6
Montana
23.0
Texas
31.0
Georgia
29.6
Nebraska
26.9
Utah
22.5
Hawaii
22.7
Nevada
22.4
Vermont
23.2
Idaho
26.5
New Hampshire
25.0
Virginia
26.0
Illinois
28.2
New Jersey
23.8
Washington
25.5
Indiana
29.6
New Mexico
25.1
West Virginia
32.5
Iowa
28.4
New York
23.9
Wisconsin
26.3
The attached MS-Excel file contains data on the contains data the bus fleet of the Buena School district. Download the file and analyze the characteristics of the Buena Bus fleet.
Sort the data by type of Bus Manufacturer and calculate the Average Cost of Maintenance for each Manufacturer
Sort the data by Fuel Type and calculate the cost of Maintenance and the Average Mileage by each fuel type of fuel
Present your results in a table and a chart. Cut and paste your chart and table into MS-Word and attach your results.
