M Quiz on chapter 13 http zoncomOnline Sh The production dep

M Quiz on chapter 13 http:/ zon.com-Online Sh.. The production department of Celltronics Intemational 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 8 during a one-hour period Then 5 employees assombled them. They produced 13 during a one-hour period. The complete set of paired observations follows 13 23 16 The dependent variable is production, that is, it is assumed that different levels of production result from a different number of employees Cick here for the Excel Data File b. A scatter diagram is provided below Based on i, does there appear to be any relationship between the number of assemblers and production? 40 30 20 10- 10 v as the number of assemblers increasesso does the production Yes c. Compute the correlation coefficient (Negative amounts should be indicated by a minus sign. Round S, Sy and r to 3 decimal places.) Y- X 25

Solution

c) Compute the correlation coefficent.

Using Excel to find the correlation coefficent.

Excel procedure

1.1. On the Data tab, click Data Analysis.

2. Select CORREL FUCTION

3.click OK.

The output is obtained as

r=0.9214065