• 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
  • Level: GCSE
  • Subject: Maths
  • Word count: 2041

This piece of coursework is designed to test the use and interpretation of statistics in relation to used car prices.

Extracts from this document...

Introduction

MATHS COURSEWORK: USED CAR PRICES

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

My investigations will include scatter diagrams and correlation. I will also use cumulative frequency curves to achieve the best mark possible.

During this investigation I will try to out what influences the price of a second hand car.

I have been given a database, which contains information about some used cars. The database includes many different makes of cars, their length, no of doors, air conditioning, engine size, mileage and more. All these features have been included to find out whether or not they affect the price of used cars.

Hypotheses

  1. I predict that the original price of the car will affect the price of the car when second hand. This is because, for example, after one year, a car with an original price of £40,000 would be expected to cost more than a car after one year with an original cost of £10,000.
  2. I predict that the age of a car will also influence the second-hand price of a car. The older the car, the bigger the decrease in value.
  3. I predict that the mileage of a car will make a considerable difference to the price of a car, as the higher the mileage, the less value the car will have.
...read more.

Middle

The distribution of the data is not to the highest standard, as the curve is not particularly tight. This means that the results are not incredibly consistent because there is quite a wide variation.

I think this is due to the fact that there may be a few anomalies in the data, which has made a slight difference to the overall result. Also other car features may cause the result of this hypothesis to vary slightly. These factors are not surprising and will be taken into consideration throughout the course of every hypothesis in this investigation.

Overall the cumulative frequency graph does show a relevant curve, which proves that there is a relationship between the original price of a car and the second-hand price of a car.

The higher the original price of the car, the higher the second-hand price of a car. This proves my hypothesis correct.

Hypothesis 2

The older the car, the bigger the decrease in value.

For this part of the investigation I will need to use 2 sections of the car records, however it would also be helpful to include a new column, as shown below:

Car no.

Price when new

Price (second hand)

Price Decrease

Age

1

16000

7999

8001

1

3

18580

7999

10581

2

6

13610

4999

8611

4

8

22980

6999

15981

4

10

13510

7499

6011

4

12

18140

6499

11641

4

15

8601

3995

4606

4

The column in red is the new section. I created this new column on Microsoft Excel by deducting the second-hand price from the price when new.

...read more.

Conclusion

I have formulated a table with only one column, which shows the amount of extra features that apply to each car. This column is titled ‘No. Of Extra Features’.

Here is the table that I have remade to acquire the relevant information:

Car no.

Price when new

Price (second hand)

No. of Extra Features

1

16000

7999

3

3

18580

7999

4

6

13610

4999

2

8

22980

6999

4

10

13510

7499

3

12

18140

6499

4

15

8601

3995

1

With all the required information now in place I can create scatter diagram, which is shown below:

image03.png

The diagram shows that there is a relationship between the second-hand price of car and the number of extra features that are included. The graph shows that the more extra features the car has, the more expensive it is likely to be.

Of course, there are a few anomalies, which have been pointed out. This is not unusual and luckily they have not interfered with the overall result.

Overall, my hypothesis theory was correct.

To conclude this piece of coursework I have found that all the results of my calculations and graphs have supported my original hypotheses. This indicates that I produced relevant theories to investigate what influences the price of a second hand car.

Kitty Stewart        11B2 – 11Y1        Maths Coursework

...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. GCSE statistics coursework

    I predict that as the age of car increases the mileage would increase. 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 would provide tally charts for the most popular cars.

  2. GCSE Math's Statistics Coursework Introduction: I have been given a database which contains information ...

    and this will show how much money the car has lost in over a period of time. This graph shows that I have compared price to age. I am not too happy with this graph due to the trendline appears to have been drawn wrong by the outliers.

  1. Data Handling Coursework

    Make The Average Price of A Car (�) Ford 6,864 Renault 10,246 Volkswagen 12,047 Peugeot 12,048 Honda 12,895 Rover 14,678 Vauxhall 14,691 Mitsubishi 15,338 Mercedes 19,588 Porsche 32,995 Rolls Royce 94,651 BMW 99,526 Bentley 170,841 The table on the left shows the cost of the average car from a make, according to my sample.

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

    Stratified Sampling There may often be factors which divide up the population into sub-populations (groups / strata) and we may expect the measurement of interest to vary among the different sub-populations. This has to be accounted for when we select a sample from the population in order that we obtain a sample that is representative of the population.

  1. Statistic coursework-what has the most influence on the price of a second hand car?

    Mercedes Ford In order to compare the depreciation rate per year of Mercedes and Ford, I will use the arithmetic mean. Here is the formula I used to find this out. =average (E2:E39). The average depreciation rate per year for ford is 11.39% and for Mercedes is 10.46%.

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

    10700 12000 148 Chrysler GrandVoyager 6690 15000 156 Land Rover Range Rover 7735 12000 166 Mercedes M-Class 25810 19000 169 Ford Explorer 4715 10000 177 Mercedes A-Class 12320 80000 190 Ford Escort 1225 10000 Analysing and Calculating To analyse my data I will use a "XY scatter graph" as I

  1. Maths - statistical driving test

    40 240 A population of 240 students is too many to work with, so in order to investigate my hypothesis I will take a sample of sixty students. The reason that I chose sixty students is because it is a quarter of the population, however my sample group will be randomly selected.

  2. Handling data Used car prices

    To avoid any bias I will be make sure that each group has varied value of depreciation. Representation & Interpretation of Data Hypothesis 1 - I predict that as the age of the car increases, the percentage of depreciation in the value of the car increases.

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