Answer Happy

Marks of the quiz 5 (quiz5) and the average
marks (average) of the first four quizzes are
given in results.xlsx. Perform regression
analysis to predict quiz 5 marks from the average marks.
a) Write down the explanatory and response variables.
Explanatory variable = [
Select ] ["quiz5", "average"]
Response variable = [
Select ] ["average", "quiz5"]
b) Estimate the parameters of the model and calculate the
coefficient of determination and correlation coefficient.
1. estimated [ Select
] ["average",
"quiz5"] = [
Select ] ["0.9728",
"1.4600"] + [
Select ] ["0.9728",
"1.4600"] ×
[ Select ] ["average",
"quiz5"]
2. When the average result increases by
[ Select ] ["1",
"10"] mark, quiz5 marks
[ Select ] ["decrease",
"increase"] by 0.9728 marks.
3. Correlation coefficient after rounding to 2 decimal
places = [ Select
] ["0.41", "0.64"] .
4. [ Select ]
["Coefficient of determination", "Correlation
coefficient"] gives the proportion of variation in
estimated quiz5 that is explained by the linear relationship
between average and quiz5.
5. [ Select ]
["41.43", "64.37"] % variation in
quiz5 can be explained by the linear relationship between average
and quiz5.