Question

Use appropriate graphs to interpret the relationship between (i) Final_exam and assignment_grade; (ii) Final_exam and Tutorial_attend; and (iii) assignment_grade and Tutorial_ attend. Carefully interpret and explain.

How would I do it and how do I interpret it on excel?

Final_exam	assignment_grade	Tutorial_attend
100	90	5
100	75	5
90	75	5
85	85	5
85	100	5
80	95	5
70	80	5
60	95	5
60	80	5
55	95	5
55	25	4
50	80	5
45	90	5
40	65	5
40	65	4
35	0	3
30	70	4
30	55	4
25	85	5
25	90	4
15	5	3
15	80	5
15	50	5
15	45	3
5	75	3
5	70	4
100	100	5
95	75	5
90	100	5
85	85	5
80	95	5
70	45	5
70	100	5
65	90	5
60	100	5
55	65	4
55	90	5
55	80	4
50	50	5
45	50	4
45	75	3
40	75	5
40	70	5
35	90	4
30	95	5
30	55	5
25	75	4
25	20	3
25	65	2
15	60	4
15	60	4
15	80	5
10	55	4
10	80	2
0	0	2

Answer 1

1. Here we are studying the relationship between two continuous variables - Final score and Assignment Grade. The appropriate graphical representation for the data would be a scatter plot:

We find that no strong pattern appears among the data points, but notice a general upward trend for the data.We may infer that both scores show a moderate positive relationship.It implies that students who score well in Final are also found to score well in Assignments (And vice versa). To numerically measure the strength and direction of the relationship we may make use of Pearson's correlation coefficient:

We get r = 0.472

Next in the following two pairs, we are comparing a continuous variable across more than 2 categories, a primary visual analysis can be done by comparing the mean of the continuous variable across all the categories ( 2,3,4,5,of tutorial attended).

First computing the means of the Final scores and Assignment grades for each of the four categories - 2,3,4,5, using the "AVERAGE" function:

In order to adjust the categories in x- axis : 2,3,4, and 5:

We find that students who attended tutorial 5 scored the highest in both Finals and Assignment.Final scores were lowest for those who attended Tutorial 2 and Assignment grade were lowest for those who attended Tutorial 3.