Reference no: EM133112883 , Length: word count:3000
ECON 940 Statistics for Decision Making
Case Study Analysis Report - An Individual Assignment
Report on students' performance in Business Statistics
An Australian Business School is keen to improve students' performance in the subject Statistics for Business and understand important differences in students' performance across gender and international student status.
Assume you work as an Analyst for this Business School and you have been asked to study the current students' performance. You have collected data for 60 students taking the subject in the Business School. The data is on an excel file named "Business Statistics". The data collected are recorded in the file as follows:
Assignment Tasks:
Visually present data for the marks from different classes. Calculate descriptive statistics for the marks of different classes. Comments on the location, variability and shape of the distributions.
Visually present data for the marks for domestic and international students. Calculate descriptive statistics for the marks of domestic and international students among the classes. Comments on the location, variability and shape of the distributions.
Visually present data for the marks of students in Class 1 for domestic and international students. Calculate descriptive statistics for the grades of students in Class 1 by domestic or international status. Comments on the location, variability, and shape of the distributions.
You have been asked to analyse difference in marks between female and male students. How do you test whether there is a significant difference of average marks across these two groups?
Using the data collected, how do you test the claim that there is no significant difference of the average marks of students from the different classes?
The Business School is interested in understanding the performance of domestic and international students. How do you test whether there is a significant difference of average marks across the two groups?
How do you test whether there is significant difference between average marks of domestic and international students from Class 1?
PRESENTATION OF ASSIGNMENT
The answer to your assignment should be in the form of a Business Report.
The report will provide you with an opportunity to demonstrate proficiency in Excel. Note that you need to provide your statistical outputs and can easily do this by importing Excel outputs to the Word document.
The following order is required for components of your Business Report:
An Executive Summary (Max 150 words). In this section you summarize the main conclusions of the report in business language. It should also describe the primary purpose of the study, the general methodology used, the significant findings of each section, as well as key general conclusions and recommendations.
A Table of Contents with page numbers
Business Problem as given in the question in business language. Do not copy the question directly to the report.
Statistical Problem (i.e. methods you have used to do your analysis).
Analysis: This section should present the formula and discuss the results from all the analyses conducted. Outline required steps and show necessary computer output. Clearly label tables and graphs.
General Conclusion: This section should briefly review the study, summarize the inference(s) stemming from it, and highlight the evidence supporting each inference. Where appropriate, indicate the limitations of the results. The conclusions should be written in business language and in terms of the variables under discussion.
Recommendations: bearing in mind why the study was undertaken, briefly describe the implications and consequences of the conclusions drawn. You should include your recommendations for action (i.e. based on what you have found in your study).
Write clearly and precisely. A precise report is a clear report, one that is composed of unambiguous statements. The word limit is 3000 words.
Attachment:- Statistics for Decision Making.rar