Determine the Pearson correlation on the data
Klaus is an officer manager at a data entry company. He is interested in finding ways to improve employee productivity. Klaus wonders if the number of hours worked is related to productivity. To test this, he installs software on each of his employees' computers that measures how many cells of data they enter and how long they work. The data provided below. By hand, using Excel, or using SPSS, conduct the full hypothesis testing procedures for his data and draw any appropriate conclusions.
# of hours worked (in min)
|
# of cells entered
|
240
|
500
|
390
|
618
|
495
|
592
|
270
|
340
|
345
|
689
|
525
|
703
|
330
|
440
|
435
|
478
|