You work as an academicoffice assistant in the university’s Commerce Faculty. Due to the coronavirus outbreak, students have switched to the online course since last semester.Professor Anderson wanted...

You work as an academicoffice assistant in the university’s Commerce Faculty. Due to the coronavirus outbreak, students have switched to the online course since last semester.Professor Anderson wanted to know the progress of the two subjects he teaches in the school. You are required doing some analysis of the students enrolledin ECO101 and STA101 respectively. In your report, you need to address the following points.

1. Give a brief introduction, including basic background information and issues to address.


2. Work out theaverage marks for ECO101students based on the
   least squares line. In your report, you need to include your excel calculation for covariance, correlation coefficient between tutorial attendance andaverage marks as well as a plotted scatter diagram. Briefly comment on the relationship.


3. Find out ‘whether the
   
   students study more than 10 hours per week for subject STA101’by hypothesis testing using
   
   a
   
   
   =0.05,
   and show details of your work.


4. Provide changes you have made to the existing performanceof STA101 in your report, including table and chart.


5. Comment on your findings and make suggestions or recommendations to Professor.

Your assignment should follow below structure

1. Introduction

1. Case Background


2. Issues to address

1. Data analysis
   
   
   
   1. Work onECO101 marks based on least squares method
   
   
   2. Find out students study time by hypothesis testing using
      a
      =0.05
   
   
   3. Performance analysis for STA101.
   
   
   
   

1. Conclusion and recommendation

Marks will be allocated as follows:


Introduction, assignment presentation and excel workings (10%)

• Well planned structure.


• The student’s essay reads well (not confusing). English expression is appropriate for an in-class essay (i.e. not expected to be as polished as a take home essay).


• The introduction clearly outlines the objective of the essay (what the student is going to do) while the conclusion reiterates the objective and summarises their argument/position.


• All the working are done via Excel clearly with all the formula and diagram attached

Details of the data analysis with supporting excel work (60%)

• Calculations are done via Excel and all the calculations must be clear and sufficient


• Interpret the results in simple English


• There is a relevant discussion on different parameters.


• Hypothesis testing has been conducted and explained clearly with supporting calculation provided

Conclusion and recommendation (30%)

• The student’s arguments are logical and consistent. A clear, consistent argument is presented which addresses the student’s perspective/position in relation to the proposed advertisement option


• Conclusion is made based on correct calculations.


• Calculations are correct and clear