• 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. 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 T-totals coursework

    51 52 53 54 T-number=12 T-total= 1+10+19+11+12=53 I will now try and find a formula The difference between each t-total is 5 so again the formula will start with 5, I will then multiply 5 with 12 the t-number.

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

  1. GCSE STATISTICS/Data Handling Coursework 2008

    In order to study the second hypothesis I shall use box plots. I will be able to compare difference as the children grow older easily the median averages and how data is spread, i.e. inter quartile range. I will group the data by year, then create box plots using autograph which will show lower quartile, median, upper quartile, and outliers.

  2. Data handling - calculating means and standard deviations

    29.8 27.0 28.4 34.4 29.6 31.8 32.0 27.4 26.0 26.0 32.8 * The mean () is calculated using the equation below: = * The standard deviation () is calculated* using the equation below: = 3.417463322 Multiplying a set of data by 'a', where a>1 will result in the multiplication of the standard deviation ()

  1. The relationship between level of parental education and SAT scores

    to reject the null hypothesis and support the claim that the proportions are different. Again, since the P-value which is 0.0271 is less than the significance level a = 0.5, the null hypothesis can be rejected.

  2. Statistical Experiment Plan to investigate the ability to estimate 30 and 60 seconds.

    To do this I shall use Spearman's Rank Correlation Coefficient(SRCC). Spearman?s rank is good as it gives me a numeric value of the correlation and allows me to see if the correlation is positive or negative. My value will between -1 and +1.

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