Reference no: EM132501135

STA101 - Statistics for Business Assignment - Elite Education Institute, Australia

In the below case study, please make sure you answer all questions and show all necessary working steps. For any part of your answers that used excel, please write your input formula and/or copy your work from excel to your word document.

A student enrolled in the accounting major is attending the first class of the accounting course ACCT101. The student is worried the course is difficult. To alleviate his anxiety the student asks the professor about last year's marks. The professor provides a list of the final marks, which is composed of term work plus the final exam. There are a total 500 students enrolled in this course last semester, the professor provides him a sample of 60 students in one of his tutorial classes. (The 60 students marks will be provided in a separate excel sheet.)

a. Determine the mean, median and mode.

b. Work out the 1st and 3rd quartiles and determine the interquartile range.

c. Calculate the range and the standard deviation of the data set.

d. Professor would like to put these students into the following five categories:

Grades	Marks
Fail	< 50
Pass	50 - 64
Credit	65 - 74
Distinction	75 - 84
High Distinction	85 and above

Produce a relative frequency distribution, and draw a bar chart and a pie chart. Comment and summarize on your findings.

e. Produce a cumulative frequency distribution, and draw a line chart.

f. Given the confidence level is 90%, work out the significance level and give your interpretation in this question.

Note - Need to support your answers with appropriate Harvard style references where necessary.