Question

1. 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.

Enter data in the excel worksheet (let’s say in column A you enter x data, in B you enter y data)à Select Data --> CLICK Insert --> Click Scatter --> Click the first case that contains unconnected points -->release the mouse                                    

If you choose layout 9, you get the regression equation that can give you more detailed information

b.   For each of the following problems compute the correlation coefficient r, r², (show the intermediary steps) and summarize/explain the results

PROBLEM 2

The data below shows the score on a promotion test given to police officers and the number of hours studied.

Hours Studied	Score on promotion test
2	0
3	1
5	1
4	2
7	5
7	7
10	9
12	10

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     |      68        74        82        88        93        99        101

Number of calls   |      3          4          7          8          9          12        13

Answer 1