1. For the following problems, construct a scatter plot using excel. After the plotis 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 first case that contains unconnected points -->release the mouse

For the regression line, double click the created chart --> on top you should seeChart Layouts, the 3rd one contains a line --> click on it

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

1. For each of the following problems compute the correlation coefficient r, r2, (show the intermediary steps) and summarize/explain theresults.

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
0	0
1	1
2	1
3	2
4	5
6	6
12	8
16	10