For this homework, you will calculate the Pearson r and r 2 between two variables. The X variable is time to walk or run a mile. The Y variable is VO2max (maximal oxygen consumption, the gold standard laboratory test of cardiovascular fitness) as determined by a laboratory exercise test. Using Excel equations, calculate Pearson r (treating the data set like a population data set) and the r 2 using the definition formula; that is the calculations should appear similar to table 8.1 (as seen in the module 18 lecture) and include N, X mean, Y mean, SD of X, SD of Y, the sum of ZX*ZY, and r. For your SD calculations, you may use the formula =STDEV.P instead of going through the manual calculation of each SD. However if you are more comfortable using the full calculations, columns D and E are available for you. (You do not need to fill out columns D and E if you use STDEV.P.)

Numbers File Edit Insert Table Organize Format Arrange View Share Window Help NE 49% Fri 5:02 PM Q OE . . . Ch. 8 Data Set Worksheet 100% EE T View Zoom Add Category Insert Table Chart Text Shape Media Comment Collaborate Format Organize Sheet Name Mile walk-run (sec) VO2max (ml/kg/min) Sheet1 Y (X-Xbar) squared (Y-Ybar) squared Zx Zy (2 x ) (ZY ) Last Name 42 55.4 First Name 410 51.4 436 52.5 511 45.6 Background 460 38.4 510 41.5 Is the correlation significant at alpha = 0.05? 530 39 .6 586 33.2 Duplicate Sheet 591 37.7 Is the correlation significant at alpha = 0.01? 600 40.1 Delete Sheet Sum Is this a positive or inverse relationship? N Mean Population SD How much variance (in %) in VO2max is shared with the Pearson mile walk-run test? squared What does the sign of the Pearson r tell you about the elationship between these two variables