• 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. 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

  1. Data Handling Coursework

    The reason for the anomalies in my graph is that age is not the only factor which affects the percentage depreciation, but as most of my cars fit the pattern I conclude that there is a strong link between the age and the percentage depreciation and that as the age increases the percentage depreciation also increases for most cars.

  2. Used Cards - find which factors will influence the price of a second hand ...

    Eventually I ended up deleting about 50% of the original data for each car, leaving me with the following: Car make Number of cars Mercedes 19 Ford 19 Here is the data that I will continue to explore with and provide spearman's rank with: Ford Data Car Make Model Price

  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. T-Total Maths

    inside T shape 9 10 11 3 19 10 11 12 4 20 11 12 13 5 21 12 13 14 6 22 13 14 15 7 23 14 15 16 8 24 5 X 9 =45 - 52 = -7 FORMULA = 5N + 7 GRID 9 T NUMBER

  1. used car coursework

    This suggests that the cars are not made for the same market as there is a big difference in second hand price. The most expensive car for Ford is �7999 where as the most expensive Rover was �6795. The least expensive Ford was �850 but the least expensive for Rover was higher at �1295.

  2. &amp;quot;Used Cars&amp;quot; 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

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