# SWhiteweek6excel

.xlsx
MAG DEPTH 0.66 7.5 0.74 2.5 0.64 14.0 1.20 15.5 0.70 3.1 2.20 2.4 1.98 14.4 0.64 5.7 1.22 6.1 1.55 7.1 1.58 17.1 1.26 8.7 3.55 10.5 0.90 12.3 1.76 9.8 0.22 7.4 2.80 12.1 0.01 8.8 0.55 5.0 1.46 18.2 1.62 12.7 1.82 4.7 0.99 6.8 0.65 6.1 0.40 14.6 1.28 4.9 r 0.132747 0.83 16.1 CV 0.279 1.34 9.9 0.54 16.1 1.25 6.4 0.93 6.1 1.20 16.3 0.79 14.0 Slope 0.930807 0.79 4.2 Y-intercept 8.328016 1.44 5.5 Regression Equation y-hat=8.175=1.124x 1.00 5.9 2.24 15.6 2.50 7.7 1.79 16.4 1.25 15.4 1.49 4.9 0.84 8.1 y-hat 10.18963 1.42 7.5 y-bar 9.486 1.00 14.1 1.25 11.1 1.34 14.8 1.35 4.6 1.45 7.1 Slide 3. Construct a Scatterplot Below. Slide 4. Find the value of the linear correlation coefficient r and the critica Include an explanation on how you found those values. Slide 6. Find the regression equation. Let the predictor ( x ) variable be the slope and the y-intercept within your regression equation. Slide 7. Is the equation a good model? Explain. What would be the best p earthquake with a magnitude of 2.0? Include the correct units. *Hint: You only need to find y-hat or y-bar (not both). *Note: Refer to the deliverable instructions for a breakdown of the Powe 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 0.0 2.0 4.0 6.0 8.0 10.0 12.0 14.0 16.0 18.0 20.0
0.40 3.2 1.39 5.3
al value of r using α = 0.05. magnitude. Identify the predicted depth of an erPoint requirements. 0 4.00