Calculate descriptive statistics for the marks

Assignment Help Applied Statistics
Reference no: EM131916994 , Length: word count:3000

Statistics for Decision Making Assessment Authentic tasks - Case study analysis report

Report on students' performance in Statistics for Business

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 "STATISTICS FOR BUSINESS GRADES". The data collected are recorded in the file as follows:

Mark - Mark of each student

Classes - 3 Classes: Class 1, Class 2, Class 3

Status - 1 for Domestic students, 2 for International students

Gender - Gender: 1 for female students; 2 for male students

Assignment Tasks:

1. Visually present data for the marks from different classes. Calculate descriptive statistics for the marks of different classes. Comments on the location, shape and variability of those distributions.

2. 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, shape and variability of those distributions.

3. 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, shape and variability of those distributions.

4. 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? Use appropriate inferential statistical techniques.

5. 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? What do you find from your analysis? Use appropriate inferential statistical techniques.

6. 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? Use appropriate inferential statistical techniques.

7. How do you test whether there is significant difference between average marks of domestic and international students from Class 1? Use appropriate inferential statistical techniques.

Provide a thorough discussion of the implications of your findings.

Learning Outcomes -

  • Explain the importance of statistics as an aid to decision-making in any organisation.
  • Identify managerial statistical problems.
  • Apply appropriate statistical techniques for solving a particular problem within any organisation.
  • Interpret appropriate output from statistical computer packages such as SPSS/Minitab/Excel.
  • Produce a managerial report.
  • Demonstrate proficiency in analysis, interpretation and application of managerial statistics.

Your report must include:

a. An Executive Summary (100 to 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.

b. A Table of Contents with page numbers

c. Business Problem as given in the question in business language.

d. Statistical problem using the language of statistics (i.e. methods you have used to do your analysis).

e. Analysis: This section should present statistical output and discuss the results from all the analyses conducted. Outline required steps and show necessary computer output. Clearly label tables and graphs.

f. 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.

g. Implications: 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 (based on what you have found in your study).

Attachment:- Assignment Files.rar

Reference no: EM131916994

Questions Cloud

Discuss equal employment opportunity commission of us : Michael Cooke, an African-American male, worked at Novellus Systems in Silicon Valley where he had to listen on a regular basis to a Vietnamese-American.
What is the payback period for project : The tax rate is 32 percent, and the cost of capital is 8 percent. What is the payback period for this project?
Finding the hydraulic diameter of the round duct : Use the round duct as the base case. Note that the hydraulic diameter is equal to 4 times cross sectional area divided by the wetted perimeter
Munis have an active secondary market : Munis have an active secondary market. In 2008, FNMA and GNMA were placed into conservatorship.
Calculate descriptive statistics for the marks : ECON940: Statistics for Decision Making Assessment Authentic tasks - Case study analysis report. Calculate descriptive statistics for marks of different classes
How mathews behaviours are shaped : How Mathew's behaviours are shaped by the TWO levels or systems of the Ecological theory.
Review case of wilson v southwest airlines co : A new Texas airline, flying out of Dallas's Love Field, was in a precarious financial posture. A campaign was mounted to sell itself as "the airline.
What is sensitivity of the npv to changes in the quantity : What is the sensitivity of the NPV to changes in the quantity of the new clubs sold?
Calculate the minimum force f : (a) Calculate the minimum force F he must exert to get the block moving.

Reviews

len1916994

3/27/2018 4:48:40 AM

The answer to your assignment should be in the form of a business report. Marks awarded will be based on presentation (5%) as well as the rest (90%). The report will provide you with an opportunity to demonstrate proficiency in integrating statistical software SPSS, Mintab, KaddStat, Excel/PhStat with a word processor, Word. Note that you can easily import Minitab, KaddStat, SPSS, Excel/PhStat output to Word.

len1916994

3/27/2018 4:48:35 AM

Your report must include: An Executive Summary (100 to 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. Statistical problem using the language of statistics (i.e. methods you have used to do your analysis). Analysis: This section should present statistical output 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.

len1916994

3/27/2018 4:48:29 AM

The conclusions should be written in business language and in terms of the variables under discussion. Implications: 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 (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. If you have any queries on assignments, please do not hesitate to contact me. GOOD LUCK.

len1916994

3/27/2018 4:48:23 AM

Marking Criteria Correct identification, use and interpretation of statistical techniques. Appropriate interpretation of computer output. Overall, you are required to demonstrate the following knowledge and skills in this assessment: Demonstrate the use of visualising data in presentation of real world data, Demonstrate the use of statistical concepts/techniques in business data, Demonstrate how to conduct various hypothesis tests and regression analysis using computer software such as SPSS/Excel/KaddStat, Demonstrate the use of computer software to get necessary statistical output, Demonstrate the skills of preparation of a managerial report.

len1916994

3/27/2018 4:48:17 AM

Style and Format Business Report. Students are provided with a data set and a set of related questions they will need to answer by relying on the knowledge of statistical techniques and software acquired in class. In order to answer these questions students will need to prepare a business report, which will be marked by focusing both on the presentation and the rest (statistical analysis, output and interpretation). Specifically, the report will need to include the following sections: executive summary, table of contents, business problem, statistical problem, analysis, conclusion, implications. More detailed information will be provided in class.

len1916994

3/27/2018 4:48:11 AM

Assessment Submission This assessment task has been set up to be checked by Turnitin, a tool for checking if it has unreferenced content. This may not apply to all assignments. You can submit your assessment task to Turnitin prior to the due date and Turnitin may give you an originality report. You may then make any changes that may be required and re-submit your final version by the due date.

len1916994

3/27/2018 4:48:06 AM

LATE SUBMISSION OF ASSESSMENT TASKS Assessed work submitted late will be penalised by the deduction of 10 percent of the maximum possible mark for that assessment per working day or part thereof. The operation of this rule will not result in a negative mark being carried forward. This penalty for late submission may be waived upon presentation of a medical certificate of illness for a relevant period, or upon evidence of untoward or approved circumstances that fall under the Student Academic Consideration Policy (see Sydney Business School Student Handbook).

Write a Review

Applied Statistics Questions & Answers

  Calculate test statistic and p-value for each given sample

Calculate the test statistic and p-value for each sample. State the conclusion for the specified a. What is probability of producing at least 232,000 barrel

  Is there a significant interaction effect

All homework "Results sections" must follow the example given in the SPSS tutorials and the Course Content document "Writing Results of Statistical Tests in APA Format" (note: you do not have to refer to a figure).

  Select five empirical articles from peer-reviewed journals

Select five empirical articles from peer-reviewed journals

  Do the data support the twin-blade manufacturers claim

Do the data support the twin-blade manufacturer's claim? ?=.05. This is a t-test: Two-sample independent groups assuming equal variances.

  Compute the given numerical summaries of the data

Compute the following numerical summaries of the data: mean and median; standard deviation; interquartile range.

  Store sells a particular brand of monochrome

A small retail store sells a particular brand of monochrome and color television sets. Each monochrome set that is sold earns a profit of $100, while each color set earns $200 profit. The manager of the store estimates that the weekly demands for eac..

  What is a typical score for this sample

Testing of 20 randomly selected subjects yielded two sets of scores: Verbal IQ and Reading Comprehension. The table below displays the results and descriptive statistics, as well as frequency distribution charts for each variable and a scatterplot..

  Descriptive statistics and regression equations

Use excel to generate scatterplots, descriptive statistics, and regression equations.An additional observation at the bottom of the data file, needs to be added to the dataset. You should clearly mark on the Excel or Minitab file, which dataset (enti..

  Four subcomponents are randomly selected

Find the probability that if four subcomponents are randomly selected, all four have lengths that exceed 120 cm. normally distributed with mean =117cm and standard deviation of 5.2 cm

  Give the definition of a nonparametric test

1. Give the definition of a nonparametric test in your own words. 2. What is the difference between an ANOVA and the Kruskal-Wallis Test? 3. What is the difference between the Wilcoxon signed-ranks test and the Wilcoxon rank-sum test? 4. What does rs..

  Strategic placement of lobster traps is one of the keys for

Strategic placement of lobster traps is one of the keys for a successful lobster fisherman. An observational study of teams fishing for the red spiny lobster in Baja California Sur, Mexico, was conducted and the results published in Bulletin of Marin..

  How much of variation is explained by the regression line

a)Show the scatterplot for this data with the least squares regression line. Find R^2. HOw much of the variation is explained by the regression line? b)Experiment with the non-linear regressions available on the calculator. Which seem to fit? S..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd