The excel files contains (completely hypothetical, made up) information about grades in a large introductory statistics course. The data contains for every student in the course the unique ID number,...

The excel files contains (completely hypothetical, made up) information about grades in a large introductory statistics course. The data contains for every student in the course the unique ID number, the tutorial the student is enrolled in, whether a student was working while they took the course, and the final grade. The marking system is like that at the University of Adelaide, ranging from 0 to 100, with 50 as the pass grade. Answer each of the following questions making use of the data given in the attached excel file. The file also contains a number of excel commands that you might find useful. Additional resources for Excel are included in the textbook or available on www.linkedIn.com/learning 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 (as it contains a number of calculations in addition to text answers), but answers that excessively long and contain irrelevant details will be penalized Calculations can be done in Excel. 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. Please submit your answer as a Microsoft Word file. Please make sure that your answer contains your name and ID number. Also, please indicate in the file separate sections for each question, so the markers can easily identify which particular question you are answering.