memo
QANL 2216 Homework #1
Due date: 9/8/14
Requirement:
Use MS-Word to complete the homework. Copy and paste any Excel output to your WORD file, print it and staple all pages. Un-stapled homework is NOT acceptable.
Problem #1
The following data represent energy consumption and renewable energy consumption in the United States in 2005:
Energy Source %*
Renewable Energy Source %*
Coal 23.0
Ethanol 10.1
Hydroelectric power 2.7
Geothermal 10.8
Natural gas 22.2
Solar 1.9
Nuclear electric power 8.1
Waste 17.1
Petroleum 40.5
Wind 4.5
Renewable fuels 3.3
Wood 55.5
a. For energy consumption and renewable energy consumption, separately construct a bar chart, a pie chart.
b. Based on the results of (a), what conclusions can you reach about energy consumption and renewable energy consumption in the United States in 2005?
Problem #2
One of the major measures of the quality of service provided by any organization is the speed with which the organization responds to customer complaints. A large family-held department store selling furniture and flooring, including carpet, had undergone a major expansion in the past several years. In particular, the flooring department had expanded from 2 installation crews to an installation supervisor, a measurer, and 15 installation crews. During a recent year, the company got 50 complaints concerning carpet installation. The following data contained in the file furniture.xls represent the number of days between
Due date: 9/8/14
Requirement:
Use MS-Word to complete the homework. Copy and paste any Excel output to your WORD file, print it and staple all pages. Un-stapled homework is NOT acceptable.
Problem #1
The following data represent energy consumption and renewable energy consumption in the United States in 2005:
Energy Source %*
Renewable Energy Source %*
Coal 23.0
Ethanol 10.1
Hydroelectric power 2.7
Geothermal 10.8
Natural gas 22.2
Solar 1.9
Nuclear electric power 8.1
Waste 17.1
Petroleum 40.5
Wind 4.5
Renewable fuels 3.3
Wood 55.5
a. For energy consumption and renewable energy consumption, separately construct a bar chart, a pie chart.
b. Based on the results of (a), what conclusions can you reach about energy consumption and renewable energy consumption in the United States in 2005?
Problem #2
One of the major measures of the quality of service provided by any organization is the speed with which the organization responds to customer complaints. A large family-held department store selling furniture and flooring, including carpet, had undergone a major expansion in the past several years. In particular, the flooring department had expanded from 2 installation crews to an installation supervisor, a measurer, and 15 installation crews. During a recent year, the company got 50 complaints concerning carpet installation. The following data contained in the file furniture.xls represent the number of days between