Import Raw Data from Productivity Data

For each entry Determine the Productivity

Which Operation has more observations than all the other operations?

Which Operation and Location has fewer observations than all others?

What is the lowest observed productivity reported in Pittsburgh for the Brazing Operation?

What & where is the highest productivity reported for the Endplate Operation for any location?

Based on Average Productivity for every location and Operation, create a table where any average over $100\%$ is colored green and under $80\%$ is colored red.

Based on averages, Does any location appear to betperforming below the others?

Which Operations consistently run over $100\%$ productivity?

Create a chart showing the overall average Productivity for each location.

If our goal is to eliminate one of our plants, which plant would you recommend and why?