Chapter 9 Activity Mission: You're really impressing them now. The newest idea is that the virus is related to age. To investigate this, each subject was given a virus score and their ages were recorded. These values are in the file \"Chapter 9 Activity.\" 1. Create a scatterplot of the data. What is the relationship between age and virus score, if any? 2. Calculate the covariance. (Round your value to two decimal places.) *Hint: See if Excel has a built-in function to calculate covariance. Covariance : 3. Use Excel to calculate the Pearson correlation coefficient. (Round to two decimal places.) r= 4. Interpret this value using the figure in your book. What type of relationship is present? 5. Calculate the coefficient of determination. (Round to four decimal places.) Coefficient of Determination: 6. What does this value mean? 7. Identify and interpret the effect size. 8. Calculate the p-value for the correlation coefficient. (Round to three significant digits.) P-value: 9. Can we say there is a cause-and-effect relationship between age and virus score? 10. Report your results in APA format. Age 33 55 64 66 29 52 62 21 55 31 82 62 42 61 32 33 42 52 52 49 53 57 57 53 59 21 44 38 52 74 38 28 42 56 74 59 53 55 52 62 45 73 34 62 Virus Score 72 70 59 63 76 75 58 57 63 72 68 69 64 64 72 67 63 67 63 62 68 63 68 65 65 66 70 68 68 66 66 60 64 66 57 63 66 62 69 61 71 59 61 62 43 61 43 58 63 50 88 48 47 50 48 62 50 36 34 51 38 64 52 54 70 57 40 72 42 39 39 69 39 30 32 51 71 53 40 38 60 53 61 43 58 54 47 39 41 66 70 62 65 63 63 70 59 67 75 63 66 63 69 58 66 70 55 62 64 66 67 67 68 64 72 67 64 69 63 68 60 69 76 69 71 55 75 59 64 71 64 64 65 62 60 37 40 62 76 68 65 50 58 64 66 58 63 72 67 68 70 68 67 70 64 56