CASE STUDY ANALYSIS REPORT | MANAGEMENT

Assessment 2 Authentic tasks - Case study analysis report

Type of Collaboration Individual assessment

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 Excel/KaddStat

 Demonstrate the use of computer software to get necessary statistical output

 Demonstrate the skills of preparation of a managerial report

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.

Assessment Submission Handover the hard copy of the assignment to your lecturer during thelecture time. You should submit your assignment to Turnitin site in the Moodle and get a copy of Turnitin report. This report should attached to your hard copy of your assignment.

Detailed Information Report Luxury Car Buyers

Case Study: Luxury Car Buyers @Nelson Perera 2012

In order to find who is buying different types of luxury cars Automobile Association conducted a survey of luxury car buyers. In this case study, data is collected for three types of luxury cars; BMW, Lexus and Mercedes. The ages, household incomes and years of education for each type of luxury car were collected in the survey. The data set is organised as follows:

Column 1: Type of car, 1 for BMW, 2 for Lexus and 3 for Mercedes.

Column 2: Age of the customer

Column 3: Household Income in Dollars

Column 4: Years of Education

Data set is loaded on eLearning site under assignment data.

Tasks

1. Visually present data for the ages of buyers of the three different luxury cars. Calculate the descriptive statistics for the ages of buyers of the three different luxury cars. Comment on the location, shape and variability of the age distributions of buyers.
2. Visually present data for the household income of the buyers of three different luxury cars. Calculate the descriptive statistics for the household incomes of buyers of the three different luxury cars. Comment on the location, shape and variability of the household income distributions of buyers.
3. Visually present data for the years of education of buyers of the three different luxury cars. Calculate the descriptive statistics for the years of education of buyers of the three different luxury cars. Comment on the location, shape and variability of those distributions.
4. Some car dealers believe that the type of luxury car the people purchase do not depend on their ages, household incomes or years of education. Using the data collected test the belief that there is no significant difference of the average ages of the buyers of three different luxury cars.
5. Test the belief that that there is no significant difference in mean household incomes of the three different luxury cars.
6. Test the belief that that there is no significant difference in average years of education of the three different luxury cars.
7. Some other car dealers claim that older people with higher household income and more years of education prefer Mercedes to BMW or Lexus. Use the given data set to determine whether this claim justified?

Provide a thorough discussion of the implications of your findings.

More information on this assessment will be provided during the session

time including the presentation of the assignment and submission to

Turnitin. Please note that you should submit the assignment according to

the format given in the Moodle site.

Note

1. Use 5% level of significance in your analyses for all questions of

hypothesis testing.

2. EXCEL outputs should be incorporated into your report.