MAT10251 STATISTICAL ANALYSIS PROJECT
This project leads you through a statistical analysis of used car data. The data for this project was obtained from the car sales website www.carsales.com.au 2 to 10 January 2019 (inclusive).
Part B parts of Topics 5 to 9.
You will need to work on this project throughout Session 1.
Project Data
The data for this project can be accessed from the MySCU site for MAT10251 in Task 2 - Project under ASSESSMENT.
The data set provided contains 10 randomly chosen samples of size 115.
To obtain your data
(1) Click on the Project Data file. This will download an Excel file.
(2) Select the 7 columns (Year to Price) of data for the sample specified by the last digit of your student ID number.
(3) Copy this into a new Excel file.
There are 10 sample data sets each of 7 columns (Year to Price)
Your sample number matches the last digit of your SCU student ID number. For example, if your student ID number ends in 2 your sample is Sample 2 and you will be analysing used car data for Toyota Corolla cars for sale in Western Australia in columns Q2:W120.
Project Situation
An online consumer group Oz-Price-Watch regularly analyses used car prices in various Australian states.
As a research assistant for Oz-Price-Watch, you are analysing the data for the Car and state specified by your sample. For example, if your student ID number ends in 0 your sample is Sample 0 and you will be analysing prices of used Toyota RAV4 (4 cylinder) in New South Wales.
You are required to analyse your sample data in response to the given questions and provide a written answer. You can assume that your written answers are components of a longer report on used car prices.
Project Preparation
You are expected to use Excel when completing the project.
Your written answers presenting your findings and conclusions should be considered as a part of a larger report on used car prices. Each written answer should be a word document into which your Excel output has been copied
In addition, your statistical workings for Part B should appear as appendices to your written answer. This should include all necessary steps and appropriate Excel output.
Each part of the project should be submitted as a SINGLE Word document, with appropriate Excel output added.
Notes
· You should not need to read beyond the study guide and textbook to complete the project.
Referencing
You are not required to reference.
However, as the format of your written answers are components of a longer report it may be appropriate to reference. In this case, use any consistent referencing style.
Furthermore, you are not required to use real references. That is, any reference can be fictitious/fake.
You are not required to reference any output or text from Part A that you reuse in Part B.
Project Submission
· Each part of the project should be a SINGLE Word file with Excel output included.
· The given cover sheets should be the first pages of your submitted project and are not part of the page limit.
· DO NOT submit your appendices, which are not part of the page or word limit, for Part B as a separate file.
· Ensure that the page setup of your submitted document is A4 Portrait, with an appropriate format so that it is easily readable if printed.
· Use line spacing of at least 1.5.
· Please name your file
“Family Name_First Name_Part_A/B/_Campus”
· For example; Jayne_Nicola_Part_A_Lismore