• 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
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  • Level: GCSE
  • Subject: Maths
  • Word count: 3022

Data Handling

Extracts from this document...

Introduction

MATHS

COURSEWORK

YEAR 11

image00.png

11GRS

CAR’S COURSEWORK


Maths Coursework

      2004

 I will be investigating about what influence second hand car prices. This coursework is worth 21 marks and therefore I’m going to work hard in order to achieve the highest grade possible.

In this coursework I will be showing how factors such as mileage, age, engine size etc. affect the prices of second hand cars. I will be presenting graphs for all the factors that affect the prices and showing a comparison between the prices and each of the factors that I have stated.


PLAN

The aim of this investigation is to find out what influences the price of second hand cars. Second hand cars cost less than brand new cars due to factors such as mileage, Age, etc.

First, I will be deciding the key factors, which could influence second hand car prices and also the factors that have a low or zero affect on the prices of second hand cars. I will be deleting these factors from the database.

Here are the key factors.

  1. Age
  1. Engine size
  1. Mileage
  1. Insurance
  1. Number of Doors
  1. MPG
  1. Number of Owners

Here are the low affect factors.

  1. Style
  1. Central locking
  1. Seats
  1. Air conditioning
  1. Airbags

I have decided to use the first 48 cars on my database to gain an evaluation of what affects second hand car prices. I could not use all my database because the results will be vary also it will be very complicated, to understand and find out if the factor has any affection.

My next step is comparing. I will be comparing the key factors with price using scatter graph.

...read more.

Middle

 ¼

   11+1 × ¼

                       =12 × ¼

                       =3                             lower value=0

Interquartile range =1 - 0= 1

Here is another cumulative frequency table for the engine size 1.6

NO

Price

Frequency

Mid point

F x x

Cumulative frequency

0

0>p>3000

3

1500

4500

3

1

3000>p>6000

4

4500

18000

3+4=7

2

6000>p>9000

2

7500

1500

7+2=9

3

9000>p>12000

0

10500

0

9

  1. Median

Median=Total +1 ÷ 2

                  9+1 ÷ 2

                  10 ÷2 = 5

INTER QUARTILE

Inter quartile range = upper value – Lower value

  1. Upper value= Total +1 × ¾

                      =  9+1 × ¾

                      = 10 × ¾

                      = 7.5                                    upper value=2

  1. Lower value= total + 1 × ¼

   9+1 × ¼

                       =10 × ¼

                       =2.5                                    Lower value=0

Inter quartile range=2 - 0 =2

My third table is for the engine size 1.8. As my database contains 48 cars I find it difficult to have another widely spread engine like 1.4 and therefore I decided to use 1.8.

NO

Price

Frequency

Mid point

F x x

Cumulative frequency

0

0>p>3000

1

1500

1500

1

1

3000>p>6000

2

4500

9000

1+2=3

2

6000>p>9000

2

7500

15000

3+2=5

3

9000>p>12000

0

10500

0

  1. Median

Median=Total +1 ÷ 2

                  5+1 ÷ 2

                  6 ÷2 = 3

INTER QUARTILE

Inter quartile range = upper value – Lower value

Upper value= Total+1 × ¾

                      =  5+1 × ¾

                      = 6 × ¾

                      =    4.5                                 upper value=2

Lower value= total + 1 × ¼

   5+1 × ¼

                       =6 × ¼

                       =1.5                                    Lower value=1

Inter quartile = Upper value – lower quartile

                                2 – 1= 1

My second comparison is between age and prices. In order to find out what effect has age on second hand car prices I have decide to use graphs to compare them. I have chosen scatter graph for this comparison.  

The graph below shows the result of my comparison.  

image02.png

The result above shows, as the age of the car increases the price decrease. This graph is a negative correlation graph because the car price decreases. The result above shows that age has influence on second hand car prices and age is considered as a key factor when you purchase it. The result which been circled is different from other results. The

...read more.

Conclusion

In my investigation I have found that the age affects the second hand price the most since the correlation was strong and there were fewer outliers in the scatter graphs. This is followed by mileage as identical correlations were found and fewer outliers. The least most influential factor to the second hand price of the cars will be the engine size, as it had the most outliers and the graph correlations were not the same for each car make. This means that my hypothesis was incorrect because the mileage follows the age.

If I had additional time I would have used standard deviation which measure the spread and results are more reliable. I also would have proved using coefficient of covariance that age is the factor that affects the second hand price the most. Coefficient of covariance or r gives a value which can terminate which factor is most important. If r = +1, this indicates the correlation is positive. If the value of r is close to +1 then that means the correlation is stronger that the value that is away from +1. The same thing is with -1 which indicates that the correlation is negative. So the closer the value of r is to -1, the stronger the negative correlation. I would’ve used this method to find the values of r for mileage, age and engine size for all four makes. This would have proved which factor influences the second hand price of a car the most.

If I had used more data for this investigation, then the results would have been more concise and reliable. Also, the gradients of the scatter graphs would have been clearer and so would the box plots.

...read more.

This student written piece of work is one of many that can be found in our GCSE Miscellaneous 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 Miscellaneous essays

  1. For our GCSE statistics coursework, we were given the question Where are houses most ...

    North Again I am going to calculate if there are any outliers, but this time within my north house prices data set.

  2. MATHS COURSEWORK - Mayfield High - To analyse data provided by Mayfield High School ...

    This includes collecting data from every tenth individual from the data. I will do this by counting every tenth piece of data. Invalid Data Some of the data collected contained invalid information. To deal with this I simply decide it would be better for my results if I did not include the record in my sample.

  1. Maths Statistics Coursework

    and Key Stage 3 is further still (-6.16). This means on average Key Stage 4 were much more accurate than Key Stage 5, and the skew only emphasizes this point. We can see that in Key Stage 4's box plot, there is a positive skew as the median (-1.36)

  2. Statistics coursework

    Females: INT (N�RANDOM�124+1) Males: INT (N�RANDOM�116+1) But before I do this I had to group the data by gender or else I will get an incorrect average. When the same number comes up on repeat I will ignore this and continue to generate a different number on my calculator.

  1. maths estimation coursework

    This will only prolong the analysis of the estimations with the task of converting these units.

  2. GCSE STATISTICS/Data Handling Coursework 2008

    of best fit, in terms of y = mx + c . I will measure how correlated the data is using Spearman's correlation coefficient, which will give me a value of correlation between 1 and -1 showing me how strong the correlation is.

  1. Maths Coursework

    this appears to be because the album had low chart ratings and the correlation shows that albums with higher chart positions have higher sales. Table 3 Showing average chart position. Blood Sugar Sex Magik 20.1 One Hot Minute 3 Califorication 2.545454545 By the Way 1.363636364 Stadium Arcardium 1 Table 1

  2. Investigation into 100m times and long jump distances

    In all three diagrams, there seems to be a negative correlation as when the 100m time increases, the distance jumped tends to decrease. This means that the faster somebody runs (the lower the 100m time), the further s/he will jump (the higher the long jump distance).

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