• 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. The task for this investigation is to statistically analyse the data given to compare ...

    371.42 1,000/10 = 100 750/11 = 68.18 1,350/8 = 168.75 2,950/8 = 368.75 3,250/7 = 464.28 5,650/3 = 1883.33 4,600/2 = 2300 5,400/1 = 5400 4,800/1 = 4800 2,700/5 = 540 11,000/1 = 11000 2,800/5 = 560 8,000/4 = 2000 6,495/2 = 3247.50 4,050/4 = 1012.50 6,300/2 = 3150 4,100/4

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


    As my main objection is to find he deprecation per year I will now make r the subject of the formula. R here indicates the depreciation per year. R as a function is very complicated as it includes several other variables that affect it.

  1. Maths Coursework - Used Cars

    Method of stratified sample: The total of the four cars (Ford, Vauxhall, Rover and Fiat) adds up to 51 My sample size is 40 Ford: 16/51 * 40 = 12.54901961 = 13 cars Vauxhall: 13/51 * 40 = 10.19607843 = 10 cars Rover: 12/51 * 40 = 9.411764706 = 9

  2. Maths Coursework:Used Cars

    As the car got older the second hand price decreased again and as the engine size got bigger the second hand price got higher. Next I will do cumulative frequency and box plots for the four car makes to investigate further and to find the median.

  1. "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

  2. Maths Coursework: Car Sales

    Still one brand (Fiat) is an odd one out which means it still can't be said to be a major influence. From these two graphs shown previously, I can therefore conclude that I can never find a specific value of the price and the value will be changed depending on the variables that affect it.

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