Description
ALL QUESTIONS MUST BE TYPED AND SUBMITTED IN ONE FILE/ DOCUMENT. Please follow this direction. ??
- 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 |
15 |
||||
|
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.
