(Bivariate Regression) Andrew was interested in determining if the number of hit

Question

(Bivariate Regression) Andrew was interested in determining if the number of hits by a hammer impacted the depth of bury of sheet piling. He conducted an experiment with 10 sheet piles and drove them into the ground with a hammer for five minutes. The number of times each sheet pile was hit was recorded (hits). Next, Andrew measured the depth the sheet piles were driven into the ground (depth). Conduct a linear regression to predict the number of hits required to drive the sheet pile into the ground. What are your conclusions?

Role Input Input Missin Columns Ali Measure Label Values Width Decimals Right Scale Scale Name None None hits Numeric None None Right depth Numeric

Explanation / Answer

Hit^ = 0.57968 + 0.372441118*depth

this model is significant as p-value for F is less than 0.01

SUMMARY OUTPUT Regression Statistics Multiple R 0.929987168 R Square 0.864876132 Adjusted R Square 0.847985649 Standard Error 3.137748046 Observations 10 ANOVA df SS MS F Significance F Regression 1 504.1362976 504.1363 51.20494 9.65E-05 Residual 8 78.7637024 9.845463 Total 9 582.9 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 0.579683029 1.161492413 0.499085 0.631153 -2.09872 3.258089 -2.09872 3.258089 depth 0.372441118 0.05204772 7.155762 9.65E-05 0.252419 0.492463 0.252419 0.492463

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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