A manager wishes to determine whether there is a relationship between the number of radio ads aired per week and the amount in sales (in thousands of dollars) of a product. The data for the sample are provided in the Excel Workbook. Construct a scatter plot and determine the correlation coefficient and its significance at = 0.05. Perform the calculation for r without the built-in function CORREL. Clearly show and document all steps

DATA

No. of ads (x)	2	5	8	8	10	12
Sales (y)	2	4	7	6	9	10