(c) Calculate the coefficient of determination (R2). What does the value of R2 t

Question

(c) Calculate the coefficient of determination (R2). What does the value of R2 tell you? 3. A random sample of 5 students who had enrolled in a business analysis class were asked to report his or her mark in the course and the total number of hours spent studying. These data are listed here: Student 1 Student 2 Student 3 Student 4 Student 5 Study time (X)40 Marks (Y) 42 37 79 47 63 86 51 (a) Assume a linear function is used to describe these data, which is derived using least squares. Find the values of bi and bo 6 (b) Calculate the coefficient of determination (R?) Page I of 1

Explanation / Answer

for calculate regression line of equation and coefficient of determination ,intercept (b0) and slope ( b1 ) use Excel. the excel path is

menu---->excel---->enter the data of variable (x) in one column----->enter the data of variable ( y) in another column in excel----> data--->data analysis-----> regression------> ok----->input Y range ( select variable y data)------>input X range ( select variable x data )----->output range( click one blank box in excel )----->ok. the excel give the output ,the output is

intercept ( b0 ) = 19.457902 and slope ( b1 ) = 1.354505 . hence the equation of regression line is

y= 19.457902 +  1.354505 ( x )

and coefficient of determination is R2 = 0.6298

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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