3. The data for Single Family Home sales in 3 areas (Hamilton and Galloway Townships and Northfield City) for the period of January 1, 2012 and April 19, 2012 is available on Blackboard. The data consists of the sales price and the square footage of each home sold.

a. Find the correlation coefficient between the sold price and square footage for each area and test the significance of the correlation. Use a level of significance of 0.05.

b. For each area that has a significant correlation, find the equation for the regression line. Make a scatter plot of the data and draw the regression line on the plot. (ONLY for data with significant correlation! Additional plots will be marked incorrect.

Hamilton IN` Galloway Tip Monthfield City Gold Price SQ FT Gold Price 54 FT Gold Price 54 FT 1, 250 DIRT, WHO 1, 570 $135, 19^ DID'E $70, #^ 1 , 3:0^ 1 , 1 0 0 $175, #` 1, 3:0^ $120, #` 1450,`^ 1 , 1 10 $145, 0^ 1 , 4 8 0 1 , 717 $140, 0^ 1 , 512 $152, #`` 1 , 650 $210, AND 1 , $50 $213, #` 2, 20 0 $213, 695 1 , 614 $170, 0`` 1 , 416 $ITO, #` 1 , 70^ 1, 8^ $IRD,`^ 1 , 7^` $103, #` 1 , 750 $195, 0^ 2010 1 , 717 1, 137 $210, #^ 2, 250 2, 4^