Reference no: EM132412635
Assignment -
Part 1 -
1. Often, cruise ships conduct all on-board transactions, with the exception of gambling, on 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 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
|
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
|
4. 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.
a. Sort the data by type of Bus Manufacturer and calculate the Average Cost of Maintenance for each Manufacturer.
b. Sort the data by Fuel Type and calculate the cost of Maintenance and the Average Mileage by each fuel type of fuel.
c. Present your results in a table and a chart. Cut and paste your chart and table into MS-Word and attach your results.
Part 2 -
1. List all the questions that should be answered and the processes that you would use to resolve the issues raised by the three persons in this case
2. Identify reasons why houses in one neighborhood may be different from another, though the sizes of houses and designs may be similar.
3. Describe the purpose of descriptive statistics. How can they be used to answer the questions in this problem?