Regression model By (name)

Regression model 3

Regressionmodel

By(name)

Nameof the class

Nameof the school

Part1

Summarizethe distribution

Mean

QMStudy Hours=D34/30=632/30

QMExam Grade=E34/30=1324/30

ActualStudy Hours=F34/30=888/30

ActualExam Grade=G34/30=1661.5/30

Median

QMStudy Hours=MEDIAN(D4:D33)=21.5

QMExam Grade=MEDIAN(E4:E33)=32

ActualStudy Hours=MEDIAN(F4:F33)=33.5

ActualExam Grade=MEDIAN(G4:G33)=57.75

Standarddeviation

QMStudy Hours= _xlfn.STDEV.P(D4:D33)=12.766971

QMExam Grade=_xlfn.STDEV.P(E4:E33)=29.708285

ActualStudy Hours=_xlfn.STDEV.P(F4:F33)=15.354912

ActualExam Grade=_xlfn.STDEV.P(G4:G33)=25.802998

Part2

95%Confidence Interval

Theconfidence interval was calculated for a normal distribution. Theformula =_Xlfn.CONFIDENCE.NORM(0.95,29.70829,30) was input in theexcel worksheet with 25.803 being the standard deviation for actualexam grades.

Theconfidence interval for actual exam grade was computed using theformula =_xlfn.CONFIDENCE.NORM(0.95,25.803,30)

Thetabulated value for 0.05 significance level is 1.96. Since bothvalues computed are below the 1.96, the conclusion is there is nosignificant difference between the two standard deviation

Part3

Regressionmodel

ForQM Study and QM Exam Grade

y=45.8156-0.08x

Foractual study hours and exam grade

y=32.69+0.25x

Bestmodel: for actual study hours and exam grade

Thereis a significant difference

Part4

Abetter model cannot be developed despite splitting the studentsbasing on more or less than 20 hours of study as there is no provenlinear relationship between number of hours studied and the examgrade achieved.

Part5

Thisresults will not be replicated for students who actually sat the examfor the reason that: the model is based on ideal situations whichcannot be replicated in the exam situation, this being indicated onthe use of one variable yet exam results achieved will rely on morethan hours studied. To replicate the same results, a multi variablemodel will be required.

Regression model By (name)

Regression model 3

Regressionmodel

By(name)

Nameof the class

Nameof the school

Part1

Summarizethe distribution

Mean

QMStudy Hours=D34/30=632/30

QMExam Grade=E34/30=1324/30

ActualStudy Hours=F34/30=888/30

ActualExam Grade=G34/30=1661.5/30

Median

QMStudy Hours=MEDIAN(D4:D33)=21.5

QMExam Grade=MEDIAN(E4:E33)=32

ActualStudy Hours=MEDIAN(F4:F33)=33.5

ActualExam Grade=MEDIAN(G4:G33)=57.75

Standarddeviation

QMStudy Hours= _xlfn.STDEV.P(D4:D33)=12.766971

QMExam Grade=_xlfn.STDEV.P(E4:E33)=29.708285

ActualStudy Hours=_xlfn.STDEV.P(F4:F33)=15.354912

ActualExam Grade=_xlfn.STDEV.P(G4:G33)=25.802998

Part2

95%Confidence Interval

Theconfidence interval was calculated for a normal distribution. Theformula =_Xlfn.CONFIDENCE.NORM(0.95,29.70829,30) was input in theexcel worksheet with 25.803 being the standard deviation for actualexam grades.

Theconfidence interval for actual exam grade was computed using theformula =_xlfn.CONFIDENCE.NORM(0.95,25.803,30)

Thetabulated value for 0.05 significance level is 1.96. Since bothvalues computed are below the 1.96, the conclusion is there is nosignificant difference between the two standard deviation

Part3

Regressionmodel

ForQM Study and QM Exam Grade

y=45.8156-0.08x

Foractual study hours and exam grade

y=51.93-0.1164x

Bestmodel: for actual study hours and exam grade

Thereis a significant difference

Part4

Abetter model cannot be developed despite splitting the studentsbasing on more or less than 20 hours of study as there is no provenlinear relationship between number of hours studied and the examgrade achieved.

Part5

Thisresults will not be replicated for students who actually sat the examfor the reason that: the model is based on ideal situations whichcannot be replicated in the exam situation, this being indicated onthe use of one variable yet exam results achieved will rely on morethan hours studied. To replicate the same results, a multi variablemodel will be required.