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...

done as soon as possible


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 rubric 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 IIWeekly hours worked for Statistics IIGrade Statistics I 661165 651350 611064 531047 661450 48944 691358 721083 661257 631161 561335 45559 931785 811571 721460 931692 691173 511228 73990 831767 711271 501226 661070 731087 59965 701547 611156 751279 741839 761373 611341 671074 831765 741368 781470 691267 691267 64976 731370 701177 671448 621252 771186 52760 901869 691362 50949 731370 761372 791471 531232 751844 721083 941691 711271 701455 63878 611060 671640 651070 57959 701363 551235 64973 881774 721271 771374 771942 831761 821666 631254 721365 661355 551145 02274 721461 58964 941695 50946 641257 841484 721556 641158 801573 83110 821196 701455 701082 621250 731558 631067 791192 691455 791569 58963 691269 36728 721273 52853 41550