1. For the following problems, construct a scatter plotusing excel. After the plot is drawn, analyze it to determine whichtype of relationship, if any, exists.

Enter data in the excelworksheet (let’s say in column A you enter x data, in B you enter ydata)à Select Data --> CLICKInsert --> Click Scatter --> Click the first case thatcontains unconnected points -->release themouse                                   

If you choose layout 9, youget the regression equation that can give you more detailedinformation

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

PROBLEM 2

The data below shows the score on a promotion test given topolice 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 seewhether there a relationship exists between the outside temperatureand the number of emergency calls it receives. The data is shownbelow.

Temperature x    |     68       74       82       88       93       99        101

Number of calls   |     3         4         7         8         9         12        13