Consider the following excel regression analysis output. Explain the significanc

Question

Consider the following excel regression analysis output.

Explain the significance of the r, p, F value

SUMMARY OUTPLUT Regression Statistio MultpleR R Square Adjusted R Square Standard Error Observations 0.875179 0.765938 0.73668 3.802138 10 ANOVA MS significance F Regression Residual Total 1 378.45378.45 26.17898833 0.0009110 8 115.65 14.45625 9 494.1 Coefficieindard Error tStatP-volue nteroept X Variable1 Lowe r 95% Upper 95% Lowe r 95.0% Upper 95.0% 75.4 2.08251736.2062 3.71058E-10 70.59770833 80.20229167 70.59770833 80.20229167 4.35 0.850184 -5.11654 0.000911066 -6.310527365 -2.389472635 -6.310527365 -2.389472635

Explanation / Answer

From given data we have r^2 = 0.7659

Correlation coefficient = r = 0.8751

There exists a strongly positive relation between two variables.

P value is 0.000911066 < 0.05 the result is not significant we reject the null hypothesis.

F cal = 26.17898833 > p value we conclude Rsquared value is not significantly different from zero

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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