Gary's Car Sales Mathematics Coursework

Authors Avatar

Gary’s Car Sales Mathematics Coursework  

For this experiment I was given a table of second hand cars for sale showing how the factors eg. age and mileage, effect the cost of a second hand car, compared with the same cars price when new. The table consists of 36 cars separated into 5 different manufacturers. For my investigation I will only use 3 of these manufacturers, Ford, Vauxhall, and Rover. I chose these 3 because they were the makes with the largest amount of information. Using the table I have been given I will try to find out which car is the best value for money. To do this I will have to draw two different types of graph, age against second hand price, and mileage against second hand price, draw a line of best fit, and work out formulas for these graphs.

  Car no. Price   Age Make Cost when Mileage Engine Size     (£) (Years)     new   (£)       (Litres)               1 6,970 3 Ford 11,600 24,000 1.6 2 3,350 7 Peugeot 7,100 85,000 1.1 3 3,995 6 Ford 13,800 52,000 2.0 4 5,300 6 Vauxhall 16,300 70,000 2.0 5 6,500 3 Fiat 8,700 24,000 1.2 6 1,500 9 Vauxhall 8,700 82,000 1.6 7 995 9 Ford 8,500 102,000 1.8 8 3,000 7 Vauxhall 10,400 63,000 1.7 9 7,495 1 Vauxhall 9,770 8,000 1.4 10 850 10 Ford 7,540 124,000 1.6 11 5,595 4 Ford 11,000 41,000 1.6 12 4,995 3 Ford 9,880 34,000 1.4 13 5,595 4 Ford 14,000 55,000 1.6 14 4,995 4 Rover 11,500 40,000 1.4 15 2,600 7 Rover 12,000 82,000 1.6 16 1,000 10 Peugeot 6,200 119,000 1.1 17 750 11 Peugeot 5,100 96,000 1.0 18 1,350 8 Ford 9,140 108,000 1.6 19 2,950 8 Ford 17,750 96,000 2.9 20 3,250 7 Vauxhall 9,990 86,000 1.6 21 5,650 3 Vauxhall 11,150 34,000 1.6 22 4,600 2 Rover 7,300 17,000 1.1 23 5,400 1 Rover 7,300 11,000 1.1 24 4,800 1 Rover 7,300 26,000 1.1 25 2,700 5 Fiat 13,000 51,000 2.0 26 11,000 1 Peugeot 13,800 9,000 1.8 27 2,800 5 Fiat 6,500 43,000 1.0 28 8,000 4 Rover 21,000 142,000 2.3 29 6,495 2 Ford 8,800 23,000 1.3 30 4,050 4 Ford 8,400 48,000 1.3 31 6,300 2 Ford 10,300 26,000 1.3 32 4,100 4 Vauxhall 8,900 37,000 1.3 33 6,600 1 Vauxhall 8,500 9,000 1.3 34 7,800 1 Peugeot 10,500 13,000 1.4 35 8,700 3 Vauxhall 16,000 42,000 2.0 36 2,000 7 Peugeot 8,300 65,000 1.4

 

 

                                                                                                                                           Page 2

Join now!

 

 

Using the table I have drawn 4 graphs for age against second hand price. I have done 1 graph for each of my chosen manufacturers, Ford, Vauxhall, and Rover, and 1 with all three makes on it. I have used scatter graphs with lines of best fit, and have used the lines of best fit to work out the gradient using the formula x / y.

 

My first graph is for Ford. The line of best fit is a strong, negative correlation.

The price of a new Ford would be £7,900 and ...

This is a preview of the whole essay