The production department of Celltronics International wants to explore the relationship between the number of employees who assemble a subassembly and the number produced. As an experiment, 3 employees were assigned to assemble the subassemblies. They produced 16 during a one-hour period. Then 5 employees assembled them. They produced 27 during a one-hour period. The complete set of paired observations follows. Number of Assemblers 5 2 6 4 One-Hour Production (units) 16 27 11 50 36 The dependent variable is production; that is, it is assumed that different levels of production result from a different number of employees. Click here for the Excel Data File a. Draw a scatter diagram. 1. On the graph below, use the point tool to plot the point corresponding to the first Number of Assemblers and her Production (No of Assemblers1). 2. Repeat the process for the remainder of the sample (No of Assemblers2, No of Assemblers3, ... ). 3. To enter exact coordinates, double-click on the point and enter the exact coordinates of x and y. 10 30 Production 20 0 LD Assemblers 5 reset b. Based on the scatter diagram, does there appear to be any relationship between the number of assemblers and production? as the number of assemblers so does the production. c. Compute the correlation coefficient. (Negative value should be indicated by a minus sign. Round sx, Sy and r to 3 decimal places.) (x - 2) 16 (y-7) -12 (x - 3 (y - (x X) (y - 144 1 1 - 1 -17 5 2 6 4 1.1.19 .:01: 289 27 11 50 36 2 44 8 0 0 * Sx Sy