Regression model 3
Nameof the class
Nameof the school
QMStudy Hours= _xlfn.STDEV.P(D4:D33)=12.766971
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
ForQM Study and QM Exam Grade
Foractual study hours and exam grade
Bestmodel: for actual study hours and exam grade
Thereis a significant difference
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.
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.