Business Finance Homework Help

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