Correlation Coefficient

See attached assignment.  

 

NOTES:  I need this done using Data Analysis in Excel, show all work and answer all questions listed in the attached assignment. 

 

Due Date:  Wed, 6/19 5 PM PST.  

 

Assignment

1

: Discussion

Using one of the two formulas cited in this module calculate the correlation coefficient using the following values presented below. Once you have completed your calculation, discuss the following: Is there a statistically significant correlation between customer service attitude scores and number of overtime hours? State the research question and testable hypothesis. Interpret, discuss, and support your findings with at least two other classmates.

5

5

1

4

2

6

6

5

1

2

Customer Service Attitude Scores	OT Hours
			5			1
10			6
		2
11	8
12
	4
3