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 between 4 and 6 September 2017(inclusive).
Part A covers parts of Topic 1, Part B parts of Topics 5 and 6 and Part Cparts of Topics 7 to 9.
You will need to work on this project throughout Session 3.
The data set provided contains 10 randomly chosen samples of size 121.
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 1 your sample is Sample 1 and you will be analysing used car data for Mazda 3 cars for sale in Queensland in columns I1:O125.
Your statistical analysis ofused car data is to enable you to answer questions from a relative who is seeking to buy a used car of the make and model specified by your sample. Your relative is restricting their search to the state they are living in also specified by the sample. For example, if your student ID number ends in 0 your sample is Sample 0 and your relative is seeking to buy a Toyota RAV4 (4 cylinder) in New South Wales.
In each part of the project you are required to analyse your sample data in response to given questions and provide a written answer. You can assume that each written answer is a part of a letter or email to your relative.