• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  • Level: GCSE
  • Subject: Maths
  • Word count: 1521

Car sales

Extracts from this document...

Introduction

Ben Mister         11N        Car Sales

Car Sales Data Handling Project

Introduction

This is a project on sampling fifty cars from a database of over two hundred cars.         The sampling was done by random selection.

I am investigating the comparative relationships that the age and mileage of a car have on the used price.  I will compare the used price of 50 cars, which have been randomly selected, to their age/mileage.

In order to do this investigation I am using an Excel Spreadsheet that contains data on cars of differing ages and mileage along with other details listed in the screen below-

image00.png

Hypotheses: The older the car, and the higher the mileage of the car, the lower the used price will be.

Plan        

The data could also be analysed in many ways

  • I will obtain the information from a data base in the program excel named, ‘Car Sales’.
  • I will investigate the relationship through graphs and charts- created in excel
  • The fixed variable that I have chosen is the used price of the cars.
  • I will investigate what factors affect it.
  • I will be investigating a range of variables to go with used price. These include
  1. price new
  2. price used
  3. age
  4. colour
  5. engine
  6. fuel
  7. MPG
  8. mileage
  9. service
  10. owners
  11. length of MOT
  12. road tax
  13. insurance
  14. doors
  15. style
  16. C looking
  17. seats
  18. gears
  19. Air con.
  20. air bags

I will not be investigating every variable, but

...read more.

Middle

Pie charts

I have made pie charts for both age and make.

Age

image03.png

This shows that most cars are in the range of 5-9 years old.

Make

image04.png

This shows that most people drive fords.

Scatter Graphs

 In the first graph comparing the used price and the age of the car you can see that there is a clear negative correlation, as predicted.

image05.png

 These are the results of my second graph:

image06.png

As you can see there is no obvious correlation between the used price and mileage. (This doesn’t go with the prediction.) I think to resolve this problem I should re-do this graph using the mileage and the percentage change in price. I did this and the results are shown below:

image07.png

Anomalies-

As you can see this now gives a positive correlation, this still is not how I predicted the outcome but at least it shows a better result than the previous graph. But as you can see, some cars actually increased in price this gives a large anomaly. This anomaly could be caused by a car that instead of depreciating in value actually increases. When I went to remove this anomie I noticed that it was a classic/vintage car.  

.

Below is the same graph without this anomaly. I did this buy removing the outliers which were indicating an increase in price.

image08.png

Means & medians

...read more.

Conclusion

image02.png

        This shows that there is a strong negative correlation between the used price of the Fords, and their age of them. This means that, as the car gets older, the car deprecates in value. Fords depreciate in value slower than Mercedes.

        Unlike the Mercedes data the correlation here is strong as the R2 amount is above 0.5, which means it is a strong correlation.

Conclusion

My results show that as cars get older, they deprecate in value. Although there are a few anomalies, such as vintage cars that increase in value. The rule generally applies to all car makes and models.

        The R2 amount for the Ford data is higher than the amount for Mercedes; this means that Ford has the strongest correlation between the two.

Overall my prediction was correct, as I predicted ‘I predict that the older the car, and the higher the mileage of the car, the lower the used price will be.’

 ,my scatter graphs show this.

Evaluation:

If I was to redo my investigation I would have changed a few things, firstly I would have used a much larger database of information, this is because, although I collected some results that were acceptable, my results would be much more reliable if I had a larger amount of information to work with. And then my results might show stronger trends and correlations.

Also I would probably select different variables to instigate, I would try and choose variables that would show different correlations so that I could make better comparisons.

        26/02/2008

...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. CAR SALES MATHS COURSEWORK

    Now I am going to plot a graph for the price decrease per year and second hand price. ANALYSIS The graph appears to have to have a positive correlation inevitably indicating a relationship between the price decrease/age and the second hand price.

  2. The task for this investigation is to statistically analyse the data given to compare ...

    = 6.01 8900/4100 = 2.17 9000/6600 = 1.36 42000/8700 = 4.82 Rovers 14 15 22 23 24 28 40000/4995 = 8.00 82000/2600 = 31.5 17000/4600 = 3.69 11000/5400 = 2.03 26000/4800 = 5.41 142000/8000 = 17.7 Fiats 5 25 27 24000/6500 = 3.69 51000/2700 = 18.8 43000/2800 = 15.3 Fords

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

    Ford Escort 13310 900 12 29000 Ford Mondeo 93-96 12255 690 12 34000 Ford Fiesta 2002 10762 5995 5 58000 Ford Puma 13950 3940 9 60000 Ford Galaxy 95-00 26380 4560 11 60000 Ford Escort 13820 1365 11 60000 Ford Scorpio 17170 1035 12 60000 Ford Mondeo 2000 15267 5570

  2. Gary's Car Sales.

    to be made. The cars on the chart are ordered by age. The Bar chart can be found on the next page. Car No. Age (yrs) Price Cost When New Difference 9 1 �7,495.00 �9,770.00 �2,275.00 23 1 �5,400.00 �7,300.00 �1,900.00 24 1 �4,800.00 �7,300.00 �2,500.00 26 1 �11,000.00 �13,800.00

  1. Maths Coursework: Car Sales

    The residue value is getting smaller as age increases. In other words, it shows that for a relatively new car, its price maybe hard to determine by its age. But for a rather old car, its price maybe fairly accurately estimated from its age. For example, the price of 2 cars which are one year old can vary between

  2. Used second hand cars

    possibility of gaining a better sample than the one I already poses. So I have spent a little time trying to get a stratified sample of 30 cars. The results are followed. To obtain a stratified sample of 3o cars, first I need to make a tally chart of all the make of the cars.

  1. Statistically analyse the data given to me regarding Gary's used car sales.

    Below is a table of the Price differences and the age. No. Price Difference Age No. Price Difference Age 1 �4,630 3 19 �14,800 8 2 �3,750 7 20 �6,740 7 3 �9,805 6 21 �5,500 3 4 �11,000 6 22 �2,700 2 5 �2,200 3 23 �1,900 1 6

  2. Used car prices.

    I predict that an older car will have a higher mileage. I think that this is because an older car would have been driven more than a new car and therefore it would be a higher mileage. I also predict that there will be only a few/ hardly any cars when the mileage is extremely high (i.e.: 90000-150000).

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