WGI is a large international construction company with operations in 43 countries. The company has been a

Question:

WGI is a large international construction company with operations in 43 countries. The company has been a major player in the reconstruction efforts in Iraq, with a number of subcontracts under the major contractor, Haliburton, Inc. However, the company is also involved in many small projects both in the United States and around the world. One of these is a sewer line installation project in Madison, Wisconsin. The contract is what is called a €œcost plus€ contract, meaning that the city of Madison will pay for all direct costs, including materials and labor, of the project plus an additional fee to WGI. Roberta Bernhart is the human resources (HR) manager for the Madison project and is responsible for overseeing all aspects of employee compensation and HR issues.

Required Tasks:
1. Develop and interpret histograms showing the distributions of current hourly rates and proposed new hourly rates for the crew members.
2. Compute and interpret key measures of central tendency and variation for the current and new hourly rates. Determine the coefficient of variation for each.
3. Compute a new variable called Pay Increase that reflects the difference between the proposed new pay rate and the current rate. Develop a histogram for this variable, and then compute key measures of the center and variation for the new variable.
4. Compute a new variable that is the percentage increase in hourly pay rate. Prepare a graphical and numerical description of this new variable.
5. Prepare a report to the city council that contains the results from tasks 1€“4.