d09 1 correlation and regression

For this refer to the Excel file Discussion 9-1 Data Set that contains information on the following:

  1. Identify the worksheet (tab) that matches the first letter of your LAST name (i.e., if your last name were “Fudd” you would use the data from the “F” tab). This will be the source data you will use to answer your remaining questions for this initial post.
  2. From your source data: What is the linear correlation coefficient?
  3. Using the linear correlation coefficient obtained in step 2 and at a level of significance of 0.05, is there sufficient evidence to support the claim of linear correlation between the two variables? Explain. (Hint: In the Excel file you used to obtain the source data, there is a worksheet/tab named Critical Values. You will need to use it to support your claim on this part of the discussion).
  4. *********************************USE LETTER “R”*******************************

"Is this question part of your assignment? We can help"