You work as an academic office 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 enrolled in 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 the average 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 and average 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  =0.05, and show details of your work. 

4) Provide changes you have made to the existing performance of 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.1 Case  Background

1.2 Issues to address

2. Data analysis

2.1 Work onECO101 marks based on least squares method

2.2 Find out students study time by hypothesis testing using  =0.05

2.3 Performance analysis for STA101. 

3. Conclusion and recommendation

Case Details

The total enrolment number for STA101and ECO101are 250 students and 150 students, respectively. 

The professor Anderson found last semester’s passing rate for ECO101 was quite low and he wanted to know whether a low attendance rate was one of the main reasons for the poor result. The below table is a summary of the past eight semester’s tutorial attendance rate vs. average marks. This semester’s attendance is just at 50%,work out the average marks for ECO101 students based on the least squares line method.

The professor was also interested to know whether the students study more than 10 hours per week for subject STA101.You designed a survey and sent to the entire Stream A students regarding the study hours per week, assuming that the study time is normally distributed with a standard deviation of 14. The survey data is provided in a separate excel sheet.

The students’ performance of STA101is summarized below. Among the 40 failure students, 30 students are eligible for the supplementary exam. The supplementary exam was just taken place two weeks ago with50% passing rate, therefore these students could eventually get a Pass grade. You job is to recalculate the overall performance of the students after taking into account of the supplementary exam results, with new table and chart analysis.

Based on your analysis of both subjects, comment on your findings and make some suggestions to the professor.

Assessment-2-raw-data