For the following problems, construct a scatter plot using excel. After the plot is drawn, analyze it to determine which type of relationship, if any, exists. For each of the following problems compute the correlation coefficient r, r2, (show the intermediary steps) and summarize/explain the results.   PROBLEM 1:  The data below shows the reading (x) and math scores (y) of students.    Reading Scores Math Scores 1 3 3 6 3 7 3 8 4 7 5 7 5 6 7 10 8 9 10 9 9 7 10 8

For the following problems, construct a scatter plot using excel. After the plot is drawn, analyze it to determine which type of relationship, if any, exists. For each of the following problems compute the correlation coefficient r, r2, (show the intermediary steps) and summarize/explain the results.   PROBLEM 4: A company that manufactures small lathes is interested in establishing standards for employees.  A random sample of 18 employees is selected in order to develop the standards.  The data collected is below. A manager at the firm feels that assembly time is related to intelligence.  She feels that employees who did well in high school (as measured by high school averages) should be able to do the job faster.   Does the data support her hunch?    high school average   Time to assemble lathe (minutes) 50 52 62 53 65 62 68 70 71 73 73 78 75 80 79 82 80 85 82 86 83 90 90 111 94 120 94 139…

The table below shows the number of state-registered automatic weapons and the murder rate for several Northwestern states. 11.6 8.5 7.1 3.4 2.6 2.8 2.6 0.7 y 13.8 11.3 9.9 6.8 6.4 6.7 6.1 4.4 x = thousands of automatic weapons y = murders per 100,000 residents This data can be modeled by the equation y = 0.85x +4.02. Use this equation to answer the following; Special Note: I suggest you verify this equation by performing linear regression on your calculator. Use the equation with the values rounded to two decimal places to make your predictions. A) How many murders per 100,000 residents can be expected in a state with 6.7 thousand automatic weapons? Round to 3 decimal places. B) How many murders per 100,000 residents can be expected in a state with 8 thousand automatic weapons? Answer= Answer = Round to 3 decimal places.

For the following problems, construct a scatter plot using excel. After the plot is drawn, analyze it to determine which type of relationship, if any, exists. For each of the following problems compute the correlation coefficient r, r2, (show the intermediary steps) and summarize/explain the results.   PROBLEM 3:  An emergency service wishes to see whether there a relationship exists between the outside temperature and the number of emergency calls it receives.  The data is shown below.   Temperature x     |      110      90        85        75        70        105      67 Number of calls   |       20        15        10        2          1          19        1