Please help me with this assignment for Applied Statistics. I have to have the equations and numbers for the excel spreadsheet and then answer the questions. Please attach a screenshot of the equations and answers in a excel spreadsheet. I have already asked other tutors and they keep submitting a regular chart or the answers written on paper but I need to see it in a screenshot of the excel spreadsheet. One with just equations and then one with answers. Please fill in the equations and answers to the HW worksheet attached.

Instructions for Homework Assignment 5 For this homework, you will calculate the Pearson r and r2 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 r2 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.) Once you have completed the calculations, answer the questions in column J. Use table A.2 to answer questions about statistical significance. (Table A.2 is available in the appendix.) For 1 point extra credit, create a scatter plot of the data. This may be useful to check your work or help as a visual aid. First, highlight the X and Y columns of data, click on the INSERT tab, and select the scatter plot option.

Mile walk-run (sec) VO2max (ml/kg/min) X Y X-Xbar) squared (Y-Ybar) squared 420 55.4 410 51.4 436 52.5 511 45.6 460 38.4 510 41.5 530 39.6 586 33.2 591 37.7 600 40.1 Sum Mean Population SD Pearson r squared\fIs the correlation significant at alpha = 0.05? Is the correlation significant at alpha = 0.01? Is this a positive or inverse relationship? How much variance (in %) in VO,max is shared with the mile walk-run test? What does the sign of the Pearson r tell you about the relationship between these two variables? Homework 5 Example - Excel O REVIEW VIEW ADD-INS M A Recommended PivotChart Power Line Column Win/ Slicer Timeline Hyperlink Tex Charts T T View Loss Cha Scatter Sparklines Filters Links M N Q R S T U V (Zx) (Zy) X Y 1 -1 4 -1 1 7 Bubble 1 1 -1 -1 7 O 0 More Scatter Charts...Chart Title Series 1 Fill Outline 6 Delete 5 Reset to Match Style ill Change Series Chart Type. Select Data... 3-D Rotation... Add Data Labels Add Trendline... 0 2 6 Format Data Series...O Linear Chart Title + O Logarithmic J O Polynomial Order R= = 0.4857 .0 6 O Power Moving Perio Average 4 Trendline Name 2 Automatic Linea Custom Forecast 0 1 2 4 5 6 7 8 Forward 0.0 Backward 0.0 Set Intercept Display Equation on chart Display R-squared value on