EXCEL STATISTICS HELP help please! Please fill out the entire chart with answers

Question

EXCEL STATISTICS HELP

help please! Please fill out the entire chart with answers and excel formulas used! Positive points awards and thumbs up!

additional information:

x-xbar = x value - mean

(x-xbar)^2 = (the answer from the equation above)^2

SAME GOES FOR y-ybar and (y-ybar)^2

Mean = Average of x-values

SAME GOES for y-values

THANK YOU SO SO MUCH! I'm just struggling alot.

Homework 6 Instructions For this assignment, you will perform a bivariate regression on two variables, X and Y. For your assignment, X will be vertical jump height and Y will be 40 yard sprint time. The purpose of this analysis would be to determine if vertical jump height can predict 40 yard sprint time. As usual, to receive full credit, you must use Excel formulas to perform all calculations. I have input the correct answers for b and t next to the boxes where you will place your excel formulas to calculate b and t. I provided you with these answers to help ensure you are performing all of the calculations correctly. If you need help with your assigrlment, do not hesitate to email me.

Explanation / Answer

Please rate my solution

X Y X-Xbar (X-Xbar)^2 Y-Ybar (Y-Ybar)^2 (X-Xbar)(Y-Ybar) Ypred Y-Ypred (Y-Yp)^2 31.2 5.2 5.99 35.8801 -0.83 0.6889 -4.9717 5.008598 0.191402 0.036635 24.5 6.6 -0.71 0.5041 0.57 0.3249 -0.4047 6.151067 0.448933 0.201541 18.1 7.8 -7.11 50.5521 1.77 3.1329 -12.5847 7.24238 0.55762 0.31094 33.6 4.9 8.39 70.3921 -1.13 1.2769 -9.4807 4.599356 0.300644 0.090387 22.8 6.4 -2.41 5.8081 0.37 0.1369 -0.8917 6.440947 -0.04095 0.001677 25.1 5.5 -0.11 0.0121 -0.53 0.2809 0.0583 6.048756 -0.54876 0.301133 23.5 5.7 -1.71 2.9241 -0.33 0.1089 0.5643 6.321585 -0.62158 0.386367 28.2 5.3 2.99 8.9401 -0.73 0.5329 -2.1827 5.520151 -0.22015 0.048467 20.7 6.8 -4.51 20.3401 0.77 0.5929 -3.4727 6.799034 0.000966 9.33E-07 24.4 6.1 -0.81 0.6561 0.07 0.0049 -0.0567 6.168119 -0.06812 0.00464 mean 25.21 6.03 sd 4.666773808 0.887004948 r 0.897139803 b -0.17051768 a 10.32875072 SE_a 0.759812364 SE_b 0.02968504 df 9 crit t 2.262 lower 21.87182306 upper 28.54817694

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.