Statistics Data Study

Statistics Data Study

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.

Age

Price

1

7999

Total

1

10999

98832

1

6795

Average

1

7500

9883

1

7500

1

7995

1

14999

1

13995