Question: This activity involves the total number of messages written and the score on the final exam. You will need to record the total number of messages that you have written as of now and the score you expect on the final exam (since you haven't yet taken the exam, I hope). In your portfolios there is a summary box with a bunch of statistics. It includes the total number of messages that you have written; please use that number. You will need to edit the attached excel spreadsheet by replacing the last entry, (0, 0), with your ordered pair, (total messages written, expected score on final exam) before participating in the activities below. Note, when you replace the (0, 0) entry with your numbers and move the curser to an empty cell, all the information in the scatter diagram changes automatically. Please just use the new regression equation and the new R-squared value to complete the
following activity. Post your response to this activity using plain text or html. Do not attach the excel spreadsheet to your posting but do state the ordered pair you use.

Total Main Topics Written 1 Total Words Written 1591 Average Words per Message 122
Total Asides Written 3 Total Characters Written 0 Average Characters per Message 0
Total Responses Written 9
Total Messages Written 13

a) State the value of the correlation coefficient.

b) Is it significant at the 5% level, 1% level, both levels, or neither level? (You should consult Table I on page 738 of the textbook.)

c) Write a conclusion in the context of this problem.