Question

A researcher believes that there is a positive relationship between the time spent in studying and the score a student gets at the end of the semester. She selected a sample of students and recorded the following data:

Time Spent in minutes	Score out of 100
120	86
75	83
60	78
45	75
180	91
30	72
90	84

After analyzing the data using Microsoft Excel, the researcher got the outputs below:

Answer the following (Please, use at least 2 decimals when you type numbers ):

a.    The correlation coefficient (r) = Answer

b.    The relationship between the time spent in studying and the score a student gets is: Answerweak and positivestrong and negativeweak and negativestrong and positive

c.    The y-intercept equals: Answer

d.    The regression (time spent) coefficient equals = Answer

e.    The regression model will be: AnswerScore = 70.704 + 0.123 MinuteMinute = 0.123 + 70.704 ScoreScore = 0.123 + 70.704 MinuteMinute = 70.704 + 0.123 Score

f.     From the regression model, the researcher can predict that if a student spends 2.5 hours, the score he gets will be: Answer

g.    From the regression model, if a student did not study at all, his score would be expected to be: Answer

h.    The coefficient of determination for this model is:  Answer95708890%

Answer 1

## Q ) A researcher believes that there is a positive relationship between the time spent in studying and the score a student gets at the end of the semester.

## a) The correlation coefficient (r) = 0.9507

## b) The relationship between the time spent in studying and the score a student gets is : = postive strong

## c) The y-intercept equals = 70.7037

## d) The regression (time spent) coefficient equals : 0.123

## e) The regression model will be:  Answer

Score = 70.704 + 0.123 Minute

## f) From the regression model, the researcher can predict that if a student spends 2.5 hours, the score

he gets will be :

2.5 hours into the Minute is 150 min :

predict y when x = 150  

that is score =   70.704 + 0.123 *150 =

score = 89.2222

## g) From the regression model, if a student did not study at all, his score would be expected to be

Answer : x = 0 then y hat = 70.704 that is score will be 70.704

## h) The coefficient of determination for this model is : = 0.9038 %

variatiion explained by model is : 90.38 %

## MIcrosoft Excel Output :