The following data represent a list of the top 7 selling books. The number of co

Question

The following data represent a list of the top 7 selling books. The number of copies sold many pages are in the book are listed below: Which one is the independent variable and which one is the dependent variable? Find ft. Find b_0. Find SST. Find SSR. Find SSE. Find the coefficient of determination. Find the correlation coefficient. Find s_2. Find the test statistic for testing if ft is significant or not. What conclusion would you make based on the test statistic found above? Find the 95% confidence interval for ft.

Explanation / Answer

from Excel

a) sold is dependent variable and pages independent varibale

b) b1=0.036

c) b0=105.99

d) e) and f)

g) Coefficient of deteremination =0.20

h) correlation coeff=0.45

SUMMARY OUTPUT Regression Statistics Multiple R 0.45109 R Square 0.203482 Adjusted R Square 0.044179 Standard Error 22.19577 Observations 7 ANOVA df SS MS F Significance F Regression 1 629.2768 629.2768 1.277325 0.309679 Residual 5 2463.26 492.6521 Total 6 3092.537 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 105.99 14.71787 7.201445 0.000804 68.15646 143.8235 68.15646 143.8235 Pages 0.035926 0.031787 1.130188 0.309679 -0.04579 0.117638 -0.04579 0.117638

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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