Assignment Problem:
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.
With Statistics for Business Assignment Help, you will always be able to acquire the academic success that you have always dreamt of!
Tags: Statistics for Business Assignment Help, Statistics for Business Homework Help, Statistics for Business Coursework, Statistics for Business Solved Assignments