Charts and Graphs - Bovis Lend Lease Salary Data

Description:

Based on the information provided, we have created Tables, Charts and Graphs to understand promotion and salary trends at Bovis Lend Lease.

The Data:

This spreadsheet shows the Level (or position), Graduation Date, Salary, and School of study for 20 Employees in the operations department of Bovis Lend Lease. The second table provides information regarding the Level - Position column in the first spreadsheet.

Emp. #

Level - Position

Grad. Yr

Salary

School

1

2-APM

1997

51000

Florida

2

1-PE

2000

38000

Auburn

3

5-OM

1972

91000

Purdue

4

4-SPM

1991

78000

Vanderbilt

5

3-PM

1986

81000

Clemson

6

6-PIC

1981

150000

Florida

7

3-PM

1993

72000

Cincinnati

8

1-PE

2001

43000

Purdue

9

4-SPM

1977

68000

Florida

10

3-PM

1983

85000

Auburn

11

3-PM

1978

79000

Auburn

12

4-SPM

1988

87000

Stanford

13

2-APM

1995

48000

Ga Tech

14

3-PM

1992

59000

Georgia

15

4-SPM

1989

67000

Ga Tech

16

2-APM

1998

53000

Florida

17

3-PM

1990

71000

Ga Southern

18

5-OM

1980

115000

Alabama

19

3-PM

1996

60000

Auburn

20

5-OM

1970

140000

Ga Tech

Level Init. Position Title

1

PE

Project Engineer

2

APM

Assistant Project Manager

3

PM

Project Manager

4

SPM

Senior Project Manager

5

OM

Operations Manager

6

PIC

Principal In Charge

Variables:

The variables in the above Spreadsheet are Position, Year of Graduation, Salary, and the School from which one received their degree.

Frequency Table:

The following data table indicates the number of employees making a salary that falls between the given "bins", or salary ranges. This table tells us that the majority of employees in this department make less than 100k.

Frequency

Range ($k)

0

<35

5

35-55

6

55-75

6

75-95

1

95-115

0

115-135

2

135-155

0

>155

Bar/Column Charts:

This Column Chart is a graphical illustration of the Frequency table just reviewed. This graph, as with most data given with illustration, shows more clearly, that the vast majority of employees make between $35,000 and $95,000.

Pie Chart:

By percentages, this pie chart shows what percentage of the observations fall within which salary ranges (thousands of dollars), or bins, in the Frequency Table. Again, we show the same data, but with percentages. 85% of operations employees make less than $95,000.

Line Chart:

This chart shows the growth of salary over time since graduation. There appears to be a significant relationship between the date of graduation and a person's annual salary.

Scatter Plot:

This scatter plot was created to determine if there is a correlation between an employee's level (position) within the company and the date of their graduation. This scatter plot indicates that a person's level within the department correlates with an employee's date of graduation.

Conclusion:

Based on the graphs, tables and charts created, it can be statistically argued that a person's salary and level/position has much to do with the date that they graduated from college.