• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

GCSE Math's Statistics Coursework Introduction: I have been given a database which contains information about one hundred different used cars

Extracts from this document...


Bilal Sheikh        -  -        10M

GCSE Math’s Statistics Coursework


 I have been given a database which contains information about one hundred different used cars. We are investigating what is the most influential factor when buying a second hand car. The factors which I will be using are the age and mileage of the cars to see how they affect the price.


Cars which are older and have got more mileage are generally cheaper, but if I have a vintage (antique) car it will change my graph so it would skew my data as an outlier. Also some cars will depreciate quicker than others in their first year.


Using the data which has been given to me I will compare age to mileage on a scatter graph with price. If I did the investigation by hand I would have chosen a sample of 100 cars of about 20 being picked at random using every 5th car as a sample and picking where to start counting at random by putting the numbers lets say the numbers 1-5 in a hat and pulling one out at random, But however I have been given the data on excel. By doing the charts on excel I will be able to plot all the data on the scatter graph and then draw a line of best fit (trendline)

...read more.


This graph shows that I have compared comparing price and mileage.  I am not too happy with this graph due to the trendline appears to have been drawn wrong by the outliers Bentley Rolls Royce. I will now remove the outliers because they are skewing my data to make the trendline inaccurate, I will also add the formula of the graph on to the trendline.


I have now changed my graph by removing the 5 outliers that were skewing my data, Now that I have removed the outliers from the original graph and I have also added the equation, which shows me that for every mile a car has done it has lost almost 5.01pence. This is the percentage of depreciation of the cars.

Now that I have done the price against age and mileage for all the cars, I will now compare those using specific makes of cars such as Ford and Vauxhall. Firstly I will do Fords, as they are the most numerous of all the cars in the table. Then I will compare my results.


I have now made a Ford graph for price against mileage, and the equation on the trendline shows me that for every mile a Ford car has done it will lose on average more or less 9 pence which I have rounded. I will now use the Ford data to compare price to age.


...read more.



This graph which I have made shows me that there is again a very strong positive correlation as the points are very close together, also the cars will depreciate 0.0006% on average for every mile it has done. I have found this out by looking at my graph that I have made.


From all the information that I have made from my coursework I have come to the conclusion that there are many things that affect the price of a second hand car these include:

  • Style
  • Central locking
  • Seats
  • Gearbox
  • Air conditioning
  • Airbags
  • MPG
  • Mileage
  • Service
  • Owners
  • Length of MOT
  • Tax
  • Insurance group
  • Doors
  • Age
  • Colour
  • Engine
  • Fuel

And many more.  I have got all these suggestions from my excel table which my coursework has been based upon. There are also some exceptions which influences the price of the car; the cars that are the exception (outliers) gains money due to that these are vintage cars e.g. Bentley, Mercedes and many others. This will nearly always be the case because there will always be cars that gain with mileage and those that will lose money with mileage. The data which I have collected has proven quite true in my hypothesis and my plan.

...read more.

This student written piece of work is one of many that can be found in our GCSE Gary's (and other) Car Sales section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Gary's (and other) Car Sales essays

  1. Statistics: Factors Affecting the Price of Used Cars

    For the price, the range is quite high compared to the interquartile and decile range. There could be an outlier here. Also, the interquartile range and decile range for mileage are closer together than the range so there may be an outlier here.

  2. "Used Cars" Statistics Coursework

    108 Ford Fiesta 13520 2330 8 12500 112 Vauxhall Tigra 11675 2025 11 90000 113 Ford Cougar 19990 4470 8 10000 120 Nissan Almera 13075 9075 2 90000 128 Subaru Impreza 13950 6130 6 15000 134 Ford Galaxy 18745 3885 11 10000 142 Vauxhall Zafira 14992 5565 6 10000 144

  1. GCSE statistics coursework

    This is for ford only Mileage Tally Frequency 0-10000 2 10001-20000 0 20001-30000 2 30001-40000 4 40001-50000 1 50001-60000 2 60001-70000 3 70001-80000 1 80001-90000 0 90001-100000 1 100001-110000 0 This shows that I was correct about the mileage in my hypothesis there are hardly any cars with a very

  2. used car coursework

    The lower quartile of the Rover was �1400 which was lower then the Renault which was at �1745. The Renault also had a higher upper quartile by �799. The price difference has been similar for these two cars which suggest that these two cars are aimed for similar markets.

  1. I will research the cars by putting the data I have been given into ...

    a curve showing the average values of the depreciation per year of all cars. Investigating depreciation for a specific age In this part I am looking at all makes depreciation for a specific age. I have chosen to only look at 6 year old cars to make the investigation fair.

  2. This piece of coursework is designed to test the use and interpretation of statistics ...

    8601 3995 no no no yes The extra features that I have chosen to use for this hypothesis consist of Central Locking, Air Conditioning, Airbags and Service History. I have decided to create a scatter diagram for this hypothesis. To do so, I will need to devise a table of

  1. Maths Coursework:Used Cars

    Cumulative Frequency Fiat Vauxhall Price Less than � CF <1000 0 <2000 4 <3000 3 <4000 2 <5000 0 <6000 1 Price Less than � CF <1000 1 <2000 1 <3000 1 <4000 2 <5000 3 <6000 0 <7000 3 <8000 2 Ford Rover Price Less than � CF <1000

  2. I have been given instructions to collect data for my GCSE statistics coursework and ...

    BELOW IS A GRAPH COMPARING THE LAST 30 CARS AND THEIR SECOND HAND PRICES You can see from the chart above that, the expensive make MERCEDES has the highest price ranging from 15000-20000 and this gives an idea that the the better the make, the more expensive the car.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work