BUSN1009 assignment -- Data Analysis Assignment

You are provided with an Excel file entitled BUSN1009 Quantitative Methods Assignment Data, The data are about marks and grades of a SAMPLE of students in a big course. The main variables include: Year, Gender, Semester, Mark, and Grade.

For this assignment assume that the number of ALL students in the course is much larger than the number of students in the sample data provided to you. You need to apply what have you learnt in BUSN1009 Quantitative Methods and write a report about your findings after analysing the sample data. Your assignment should comprise the following sections:

a)Descriptive Statistics use descriptive statistics and data visualization techniques such as measures of central tendency (mean, median, mode), variation (range, variance and standard deviation) and shape (box plots, histograms, frequency tables, etc.), summarise and compare data.

For example you can compare two different years or two different semesters or different genders [25% of your assignment mark]

b) Confidence interval estimates for the mean/proportion and/or confidence interval for the difference between two means. State the assumptions clearly [25% of your

assignment mark]

c) Hypothesis testing for the mean/proportion and/or the difference between two

Means. State the assumptions clearly [25% of your assignment mark]

Please note that the finished assignment should be presented as a report with the appropriate measures selected, rationale for the selection of those measures, clearly stated hypotheses and the associated tests. You will be graded based on both the statistical analysis and the quality of your writing.

The assignment must be clearly written; any diagrams, charts, tables etc. must be clearly labelled and explained in your text and any equations defined and explained. Apart from the statistical analysis, you will also be graded based on your writing and communication abilities to a broader audience [25% of your assignment mark].

Your arguments and the clarity with which you explain and illustrate the relevant findings are very important.

Suggestion for the structure of the report:

Cover page

Introduction

Body of report. Use 3 different sections (descriptive statistics, confidence interval,

hypothesis testing) as stated in the previous page

Conclusion

References

Word count: 1,000 - 1,500

(Excel Graph below images)

Year 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 Study Period Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Gender Male Male Male Female Female Male Male Female Female Female Female Female Female Female Female Female Male Female Male Male Female Male Mark 50 71 57 82 89 77 97 65 63 90 73 50 79 50 63 98 83 80 78 52 95 62 Grade Pass Credit Pass Distinction High Distinction Distinction High Distinction Credit Pass High Distinction Credit Pass Distinction Pass Pass High Distinction Distinction Distinction Distinction Pass High Distinction Pass 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 Semester 1 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Female Male Male Female Male Female Female Male Female Male Male Female Male Female Male Male Female Male Male Female Male Female Male Male 76 80 94 94 96 72 83 61 58 66 94 79 61 97 77 63 87 74 76 86 51 86 3 35 Distinction Distinction High Distinction High Distinction High Distinction Credit Distinction Pass Pass Credit High Distinction Distinction Pass High Distinction Distinction Pass High Distinction Credit Distinction High Distinction Pass High Distinction Fail Fail 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Female Male Male Female Female Male Female Male Female Female Female Male Male Male Male Female Male Male Female 50 64 86 68 80 86 78 66 71 73 65 82 62 84 50 79 64 95 77 Pass Pass High Distinction Credit Distinction High Distinction Distinction Credit Credit Credit Credit Distinction Pass Distinction Pass Distinction Pass High Distinction Distinction 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Male Female Female Male Female Female Female Female Male Male Male Male Female Male Male Female Female Female Female 67 50 66 96 82 72 77 57 62 84 91 72 72 28 42 46 28 45 44 43 Credit Pass Credit High Distinction Distinction Credit Distinction Pass Pass Distinction High Distinction Credit Credit Fail Fail Fail Fail Fail Fail Year 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 Study Period Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Gender Male Male Male Female Female Male Male Female Female Female Female Female Female Female Female Female Male Female Male Male Female Male Mark 50 71 57 82 89 77 97 65 63 90 73 50 79 50 63 98 83 80 78 52 95 62 Grade Pass Credit Pass Distinction High Distinction Distinction High Distinction Credit Pass High Distinction Credit Pass Distinction Pass Pass High Distinction Distinction Distinction Distinction Pass High Distinction Pass 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 Semester 1 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Female Male Male Female Male Female Female Male Female Male Male Female Male Female Male Male Female Male Male Female Male Female Male Male 76 80 94 94 96 72 83 61 58 66 94 79 61 97 77 63 87 74 76 86 51 86 3 35 Distinction Distinction High Distinction High Distinction High Distinction Credit Distinction Pass Pass Credit High Distinction Distinction Pass High Distinction Distinction Pass High Distinction Credit Distinction High Distinction Pass High Distinction Fail Fail 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Semester 1 Female Male Male Female Female Male Female Male Female Female Female Male Male Male Male Female Male Male Female 50 64 86 68 80 86 78 66 71 73 65 82 62 84 50 79 64 95 77 Pass Pass High Distinction Credit Distinction High Distinction Distinction Credit Credit Credit Credit Distinction Pass Distinction Pass Distinction Pass High Distinction Distinction 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Semester 2 Male Female Female Male Female Female Female Female Male Male Male Male Female Male Male Female Female Female Female 67 50 66 96 82 72 77 57 62 84 91 72 72 28 42 46 28 45 44 43 Credit Pass Credit High Distinction Distinction Credit Distinction Pass Pass Distinction High Distinction Credit Credit Fail Fail Fail Fail Fail Fail