An emergency service wishes to see whether a relationship exists between the outside temperature and the number of emergency calls it receives for a 7-hour period. The data are provided in the Excel Workbook. Construct a scatter plot and determine the correlation coefficient along with the significance at = 0.01. Perform the calculation for r without the builtin function CORREL. Clearly show and document all steps.

Data

	Temperature oF (x)	68	74	82	88	93	99	101
	No. of calls (y)	7	4	8	10	11	9	13