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 AssemblersOne-Hour Production (units)316527211650436 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 b.A scatter diagram is provided below. Based on it, 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 amounts should be indicated by a minus sign. Round sx, sy and r to 3 decimal places.) XY( )2( )2( )( )3 16 is the dependent variable. c.Determine the correlation coefficient. (Round your answer to 2 decimal places.) Coefficient of correlation correlation between the variables.4.The owner of Maumee Ford-Mercury-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year. CarAge (years)Selling Price ($000)CarAge (years)Selling Price ($000)198.1787.6276.08118.03113.69108.04124.010126.0585.01168.66710.01268.0 Click here for the Excel Data File a.If we want to estimate selling price on the basis of the age of the car, which variable is the dependent variable and which is the independent variable? is the independent variable and is the dependent variable. b-1.Determine the correlation coefficient. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) XY( )2( )2( )( )9.0 8.1 correlation between age of car and selling price. So, H0: ? ? 0