# My maths coursework is based on a spreadsheet with information about cars.

GCSE Maths Coursework – Statistics

My maths coursework is based on a spreadsheet with information about cars.  I am going to study the data and answer the following questions: -

• In general does the age of second hand cars affect the price?
• Does the mileage of second hand cars affect the price?
• Does the size of the engine on second hand cars affect the price?
• The average cost of Vauxhall cars compared to Ford cars.

In general does the age of second hand cars affect the price?

Plan

I am going to find out whether the age of second hand cars affects the price.

I am going to use all the data in the spreadsheet as there are only a hundred pieces.  This will make my results as accurate as possible.

Firstly I am going to separate the age and price columns from the rest of the spreadsheet.  Then I will sort the data into age groups and take the average of each group.  The averages of each age group will be then put into a table and on a line of best fit.  I am going to use the averages because this is the best way to display the data.  All of the data from each category (Make of car) will be used to work out the averages, as there isn’t enough data in each category to take a sample.

Collecting, Processing and Representing

I have collected the required data and sorted it into tables.  All the cars which are 1 year old are shown below.  I have worked out the mean; this will be used in the final chart which will compare all of the ages.

The two year old cars are shown below.

The three year old cars are shown below.

The four year old cars are shown below.

The five year old cars are shown below.

The six year old cars are shown below.

The seven year old cars are shown below.

The eight year old cars are shown below.

The nine year old cars are shown below.

The ten year old cars are shown below.

The average price of cars at each age is shown below.

The information is shown below in the form of a line graph.  I chose to use a line graph as this is the best way to display the data as it shows patterns and trends.

I have removed the anomalous result and redrawn the graph.

I have also plotted all of the results on a ...