The Bekaert Company of Belgium is a major supplier of bead wire for tire re-enforcement and other specialized wire processes in the USA and throughout the world. The company has always prided itself on its dedication to employee training and education.
Recently they have increased production from 70,000 to 90,000 pounds per week during a time when it implemented a basic skills training program over an 18 month period.
The following data date measures the number of total cumulative basic skills hours of training and the per week productivity figures taken once a month over this time period.
Question - In Excel use the regression tool to analyze the data in a brief report (Power Point or Word Doc) to the CEO of Bekaert.
Discuss the predictability of productivity from cumulative hours of training.
The Data
Cumulative Hours of Training Productivity (lbs. /week)
0 70,000
100 70,350
250 70,500
375 72,600
525 74,000
750 76,500
875 77,000
1,100 77,400
1,300 77,900
1,450 77,200
1,660 78,900
1,900 81,000
2,300 82,500
2,600 84,000
2,850 86,500
3,150 87,000
3,500 88,600
4,000 90,000