SOLUTION: The production department of Celltronics International wants to explore the relationship between the number of employees who assemble a subassemblies. They produce 15 during a one-

Algebra ->  Probability-and-statistics -> SOLUTION: The production department of Celltronics International wants to explore the relationship between the number of employees who assemble a subassemblies. They produce 15 during a one-      Log On


   

Question 1019754: The production department of Celltronics International wants to explore the relationship between the number of employees who assemble a subassemblies. They produce 15 during a one-hour period. Then four employees assembled them. They produced 25 during a one-hour period. The complete set of paired observation follows.
# of assemblers - 1 hr production (units)
2 - 15
4 - 25
1 - 10
5 - 40
3 - 30
a. Draw a scatter diagram.
b. Based on the scatter diagram, does there appear to be any relationship between the number of assemblers and production? Explain.
c. Compute the correlation coefficient.
Answer by ewatrrr(24785) About Me  (Show Source):
You can put this solution on YOUR website!


Hi  

Excel will do your scatter plot as well as the Trend Line and R^2 automatically!

Calculating correlation coefficient: sqrt(R^2) using Excel...

	X	Y	XY	X^2	Y^2	

	1	10	10	1	100	

	2	15	30	4	225	

	3	25	75	9	625	

	4	30	120	16	900	

	5	40	200	25	1600	

sum	15	120	435	55	3450	

sum squared	225	14400				

	Correlation(r) = NΣXY - (ΣX)(ΣY) / Sqrt([NΣX^2 - (ΣX)^2][NΣY^2 - (ΣY)^2])					

						

	r = 	(5*435 - 15*120)/sqrt([5*55-225][5*3450-14400]) = highlight%28.9934%29