Are the marks one receives in a course related to the amount of time spent study

Question

Are the marks one receives in a course related to the amount of time spent studying the subject? To analyze this mysterious possibility, a student took a random sample of 15 students who had enrolled in an accounting class last semester. He asked each to report his or her mark (score) in the course and the total number of hours spent studying accounting.

1.Draw a scatter diagram

2.Calculate the Covariance

3.Calculate the Coefficient of Correlation

4.Draw a least squares regression line and r-squared valued

5.Interpret your findings

Excel!!!

Study time Marks 40 77 42 63 37 79 47 86 25 51 44 78 41 83 48 90 35 65 28 47 50 90 55 88 20 55 45 80 76 94

Explanation / Answer

2 ) to calculate covariance use excel. the excel path is

enter the data of marks (y) and study time(x) in excel------> data ----->data analysis---->covariance----->ok------> input range ( select the whole data from excel)----> output range ( click on blank box from excel )----ok . the excel give the ouptput is

the covariance is 158.5867

3 ) to calculate correlation coefficient use excel . the excel pathe is , enter the data of marks (y) and study time(x) in excel------> data ----->data analysis---->correlation----->ok------ > input range ( select the whole data from excel)----> output range ( click on blank box from excel )----ok . the excel give the ouptput is r = 0.8362

4) to calculate the regression line use excel . the excel path is , enter the data of marks (y) and study time(x) in excel------> data ----->data analysis---->regression ----> ok---->input y range (select data of marks )------>input x range ( select the data of study time ) ----> output range ( click on one blank box from excel )----->ok. the excel give the regression line is y = b 0 + b1 (x) here  b 0 = intercept = 35.0788 and  b1 = slope = 0.9475 hence the regression line is y =  35.0788 +  0.9475 (x)

Column 1 Column 2 Column 1 167.36 Column 2 158.5867 214.8622

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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