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

Temperaturex |	68	74	82	88	93	99	101
Number of calls|	5	5	7	8	11	12	13