• 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: 1815

The aim of this coursework is to find out what the different factors are that affect the value and price of different cars

Extracts from this document...

Introduction

Maria Fisher

Statistics Coursework: Used Car Sales

Aim:

The aim of this coursework is to find out what the different factors are that affect the value and price of different cars.

Hypothesis:

Different things affect the prices of second hand cars. The age of the car affects the price because if it is older then the engine and tyres etc. will be worn out. Also the mileage of a car will also decrease the price because of the same reasons. The higher the mileage the more the car has been used. The size of the car engine will increase the price because the bigger the engine the faster the car will go. More money is usually paid for this feature.

I think that an old car will be low in price but the make of the car could possibly change and make it higher or lower because more is paid for some makes of cars. So different makes of car will affect all of my graphs. If they do then they will probably be removed in the summary of data or in the outliers.

Cars that have extras, like air-conditioning, airbags and central locking etc.

...read more.

Middle

2: 5-7

3: 8-10

4: 11-13

Summarise and Interpret Data

This graph shows that the higher the mileage the lower the price of a car. It shows moderate negative correlation. The equation of the graph is y=-0.0775x+7876.1. It is appropriate and it can be used to predict the price of the car depending on the mileage. The mean of the data is 43,753 miles. The median is 43,000 miles. The lower quartile is 27,000 miles and the upper quartile of the data is 55,000 miles. These were found using Excel. The inter quartile range for this data is 28,000 miles.

In this data there are 12 outliers. Theses are found by using the equations:

LQ - 1.5 x IQR and

UQ + 1.5 x IQR

In this case it means that the outliers are less than 15,000 miles and over 97,000 miles.

Outliers

Car

Price

Mileage

Rover Club

£14,999

2,000

Fiat Bravo

£6,795

3,000

Volkswagen Polo

£7,550

5,000

Volkswagen Beetle

£13,500

6,500

Ford Orion

£7,999

7,000

Ford Focus

£8,800

7,200

Honda Civic

£7,995

9,500

Fiat Punto

£4,500

13,000

Mercedes A140 Classic

£10,999

14,000

Daewoo Nubira

£6,895

14,730

Renault Clio

£1,495

98,000

Audi 80

£3,995

103,000

These outliers will be removed to make the data more accurate.

A grouped frequency table has been drawn to sort the data. It will then be used to draw a cumulative frequency graph.

Miles (in thousands)

15-22

23-30

31-38

39-46

47-54

55-62

63-70

71-78

79-86

87-94

95-97

Frequency

8

9

12

8

19

7

7

6

1

2

2

Cumulative Frequency

8

17

29

37

56

63

70

76

77

79

81

...read more.

Conclusion

To improve my coursework I could gather more data to make everything more accurate and give me a better example of how prices in second hand cars decrease. Also I could do extra comparisons and more analysis of different variables.

I also decided to see if the number of owners that a car has had will affect the price.

image00.png

1 previous owner: drop of 53.43%(2d.p)

2 previous owners: drop of 65.72% (2d.p)

3 previous owners: drop of 79.69% (2d.p)

4 previous owners: drop of 82.14% (2d.p

This graph shows that the amount of previous owners does affect the price decrease. The more owners the car has had the more the price drops. At first the price decreases by around 12% or 13% but then it begins to slow down and the decrease from 3 owners to 4 owners is only 2.45%. I predict that if I collected extra data and found cars that had more owners then the price decrease would still rise but at a slower rate.

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. Statistics: Factors Affecting the Price of Used Cars

    My data is representative because I took a sample of four different types of cars. Also, for BMW and Ford, I got cars that are the same age so I can just compare the mileage and the price. For Audi and Peugeot, I got cars of different age so I can compare the age with the price.

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

    I have found out this information by reading of my graph, so the car will loose most of its value in the first year and then it will depreciate on a steady rate.

  1. GCSE statistics coursework

    40 Ford 16 56 Degrees to be plotted on the pie chart = (360 / total number of cars) times frequency. I intend to show the number of cars upon a pie chart, this would show how much of the total amount of cars are divided By looking at the

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

  1. Maths Coursework:Used Cars

    Fiat Median: The equation to find the median is (N+1)/2 (1500+1)/2=750.5 So the median value is 750.5 Lower Quartile: this is found by calculating N+1 then dividing it by 4. So 1501/4 = 375.25 Upper Quartile: this is found by multiplying the lower quartile by 3.

  2. Examine how the age of a second hand car affects its price. Also to ...

    In the box plot of price of old car, I know most definitely not to use highly priced cars as much as lowly priced. This is because there is a hugely vast distance from Q3 to the maximum point. I am going to pick 25 cars according to how frequently they appear.

  1. My maths coursework is based on a spreadsheet with information about cars.

    Age Price 9 1195 Total 9 1495 21594 9 1595 Average 9 2574 4318 9 14735 The ten year old cars are shown below. Age Price Total 10 1000 3514 10 850 Average 10 1664 1171 The average price of cars at each age is shown below.

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

    According to my graphs, it was a conclusive proves that as the mileage increases, the price decreases.

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