Please use the accompanying Excel data set or accompanying Text file data set when completing the following exercise. The monthly absolute estimate of global (land and ocean combined) temperature...

Extracted text: Please use the accompanying Excel data set or accompanying Text file data set when completing the following exercise. The monthly absolute estimate of global (land and ocean combined) temperature indexes (degrees C) in 2000 and 2001 are (source: (http://www.ncdc.noaa.gov/oa/climate/). 2000: 12.28 12.63 13.22 14.21 15.13 15.82 16.05 16.02 15.29 14.29 13.16 12.47 2001: 12.44 12.55 13.35 14.22 15.28 15.99 16.23 16.17 15.44 14.52 13.52 12.61 Round your answers to 3 decimal places. (a) Estimate the correlation coefficient. r = (b) Test the hypothesis that Ho:p = 0.85 against H1:p # 0.85 with a = 0.05. (c) Construct a 95% confidence interval for the correlation coefficient. i i Statistical Tables and Charts