Assignment 3
Due date is Friday, June 4th, 12:00 Noon
You are the statistics lecturer for courses Statistics I (a first year course) and Statistics II (a second year course). Your Dean is concerned about the grades of your courses and how much effort students put into their studies. There are 100 students that have completed Statistics II this year, so the Dean asked you to collect their grades for that course, the grades these students got for Statistics I, which they completed last year, as well as information about the average number of hours these students spent studying for Statistics II each week. Then she asks you to run a simple linear regression on this data to understand how they are related.
Your task in this assignment is to run one simple linear regression on the data, mainly following the ru
ic and steps discussed in chapter 8 at the end of week 11 lecture. This includes selecting one relevant underlying model out of many possible ones, then picking the appropriate data for the x and y variables (please note: not all data variables have to be used), going through various checks, and interpretating the output. If you do not have enough information to make a full decision within a step, discuss this and choose any appropriate value.
The excel files contains (completely hypothetical, made up) information for 100 students. The data contains for every student in the course in Column (1) the final grade in Statistics II, in column (2) the number of hours the student spent per week on studying for Statistics II, and in column (3) the final grade the student got last year in Statistics I. The marking system is like that at the University of Adelaide, ranging from 0 to 100, with 50 as the pass grade. The time spent studying is given as the average number of hours per week.
Calculations can be done in Excel (or any other software). If you do, please do not submit your excel file, but do keep it until grades are released as this allows you to prove you did work yourself rather than copying from somebody.
Additional resources for Excel are included in the textbook, on www.linkedIn.com/learning (such as this course) , or on Youtube and other internet sources ( for example https:
youtu.be/NGFmRt2V8vo)
You can access Excel and Word through ADAPT https:
www.adelaide.edu.au/technology/your-tools/academic/adapt , or through a direct licence for your own computer: https:
www.adelaide.edu.au/technology/your-services/software/software-for-students#microsoft-office-365 )
Your answer should explain what you do (i.e. if you simply note an answer without explaining how you get there, points are deducted). There is no formal word limit and you are expected to use a number of charts and tables in your answer. Excessively long answers that provide no additional information can be penalized (if you have more than 1000 words, you should check if you need all of them)
Please submit your answer as a Microsoft Word file. Please make sure that your answer contains your name and ID number.
Data Assignment 3
(1) (2) (3)
Grade Statistics II Weekly hours worked for Statistics II Grade Statistics I
66 11 65
65 13 50
61 10 64
53 10 47
66 14 50
48 9 44
69 13 58
72 10 83
66 12 57
63 11 61
56 13 35
45 5 59
93 17 85
81 15 71
72 14 60
93 16 92
69 11 73
51 12 28
73 9 90
83 17 67
71 12 71
50 12 26
66 10 70
73 10 87
59 9 65
70 15 47
61 11 56
75 12 79
74 18 39
76 13 73
61 13 41
67 10 74
83 17 65
74 13 68
78 14 70
69 12 67
69 12 67
64 9 76
73 13 70
70 11 77
67 14 48
62 12 52
77 11 86
52 7 60
90 18 69
69 13 62
50 9 49
73 13 70
76 13 72
79 14 71
53 12 32
75 18 44
72 10 83
94 16 91
71 12 71
70 14 55
63 8 78
61 10 60
67 16 40
65 10 70
57 9 59
70 13 63
55 12 35
64 9 73
88 17 74
72 12 71
77 13 74
77 19 42
83 17 61
82 16 66
63 12 54
72 13 65
66 13 55
55 11 45
0 22 74
72 14 61
58 9 64
94 16 95
50 9 46
64 12 57
84 14 84
72 15 56
64 11 58
80 15 73
83 11 0
82 11 96
70 14 55
70 10 82
62 12 50
73 15 58
63 10 67
79 11 92
69 14 55
79 15 69
58 9 63
69 12 69
36 7 28
72 12 73
52 8 53
41 5 50