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

Data handling - IQ correlation

Extracts from this document...


COURSEWORK- MATHS DATA HANDLING MAYFIELD HIGH SCHOOL Mayfield High School is a fictitious high school. There are 1183 pupils in the database I have on the school. This data has come from the exam board, and so is made up. I am going to examine the many features of the data, and investigate the inter-effect they all have on each other. The data base has 27 features for each pupil: Year group, surname, forename 1 and 2, age in years and months, month of birthday, gender, hair colour, eye colour, whether the person is left or right handed, favourite colour, favourite sport, favourite lesson, favourite TV program, Average number of hours TV watched per week, IQ, height, weight, distance travelled to school every day, type of transport to school number of siblings, number of pets, and Key Stage Three results in maths, science and English. The data that I am most interested in examining is IQ. The IQ is an intelligence test, and I will be investigating how the IQ of a person relates to the other aspects of that person. I will investigate these three hypotheses from the data I have: 1. The lower the IQ of a person is, the more hours of TV that person will watch per week. 2. The older a person is, the higher that persons IQ is. ...read more.


Although it is possible for someone to get these scores, the average IQ is 100, so I have considered the evidence and decided to discount it, as the final result may be anomalous if I choose to include this data. Likewise, I have not only discounted data in the "hours of TV watched" column that claims over 168 hours (the number of hours in a week) of TV time but I have discounted data that is under 126 hours. The reason for this is that I have subtracted 6 hours of sleep for each night, as this is around the minimum sleep a person can survive on. Even if there is 168 hours in a week, no one could watch 168 hours of non-stop television. When the data has been discounted, felt that it would be appropriate to draw a scatter graph for this data. A scatter graph is more suitable, because grouping the data would be much too difficult, and consequently drawing a box and whisker diagram would be to difficult with this variety of data. I will be looking for negative correlation between IQ and number of hours of TV watched, as my hypothesis was... ... 1. The lower the IQ of a person is, the more hours of TV that person will watch per week. This is the graph that I have drawn. ...read more.


The 14 year olds have normal distribution, and the 15 year olds have a slight negative skew. My second hypothesis (The older a person is, the higher that persons IQ is) was wrong. The data above shows that there is no relation between age and IQ. I will now investigate my third hypothesis:- Males have higher IQs than females. I will again discount incorrect data and delete data that is incorrect. I will ignore any gender other than male or female. I will discount any data in the IQ column that is <30 or >170. I will now modify my data sheet again. To see if the data is skewed or un-skewed, I will draw a frequency curve. I am doing this to help me decide which measures of central tendency and dispersion to use. (If the data is skewed, I will use median and interquartile range, if not I will use mean and standard deviation). This data is not skewed, so I will use standard deviation and mean as my methods of measure. Gender Mean Standard Deviation Lowest IQ Highest IQ Male 101.3289 9.345069578 68 134 Female 101.9878 8.939091418 69 132 The female mean is slightly higher than the males, which proves my hypothesis wrong once again. Also, the males have a larger standard deviation, which means that the spread of data is bigger in the males, meaning that they are less consistent than their female counterparts. However, if you look at the above frequency graph, and also look at the ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Height and Weight of Pupils and other Mayfield High School investigations 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 Height and Weight of Pupils and other Mayfield High School investigations essays

  1. A hypothesis is the outline of the idea/ideas which I will be testing and ...

    The Data I will input in Microsoft Excel and this will help me produce an efficient and successful graph in which I can then evaluate on the trend. LINE OF BEST FIT TO SHOW TREND CLEARLY IS ALSO INCLUDED. This Scatter Graph that I have produced shows that there is

  2. Maths Data Handling

    Also, the stratified sampling eliminates the bias of gender and age so I will be able to find clear results relating to the whole population in Mayfield High School. Once I have created my stratified sample, I will need to use random sampling, so that each student in the school

  1. Maths data investgation

    MEAN MODE MEDIAN RANGE BOYS GIRLS GCSE Maths (%) MEAN MODE MEDIAN RANGE BOYS GIRLS Evaluation After carrying out this investigation I have found that I could have imroved the accuracy of my data by using primary data. I would use primary data because it is first hand therefore more accurate and it will be to date.

  2. we can see if there is any correlation between a person's height and weight ...

    Cumulative Frequency Up to 1.40 0 Up to 1.45 0 Up to 1.50 0 Up to 1.55 2 Up to 1.60 3 Up to 1.65 8 Up to 1.70 11 Up to 1.75 12 Up to 1.80 13 Up to 1.85 15 From looking at the cumulative frequency graph that

  1. Emotional Intelligence

    Einstein was academically brilliant, yet socially inept. The point is, that despite his lack of high emotional intelligence, Einstein continued his research, his passions, and pursued knowledge.

  2. Maths: Data Handling Coursework

    Year group Number of Boys Number of Girls Total 7 151 131 282 9 118 143 261 11 84 85 169 Total 353 359 712 The first column in the table for Mayfield Secondary School shows the year groups 7, 9 and 11.

  1. mayfield high school handling data coursework

    Median=1.555=1.56(3 sig fig) Upper quartile=1.6125=1.61(3 sig fig) range=1.8-1.2=0.6 mean=1.609 Lower quartile=1.5525=1.55(3 sig fig) Median=1.61 Upper quartile=1.65 range =1.8-1.35=0.45 year 9 boys 3 5 4 0,2,3,5,5,6,6,7,8 5 1,1,2,2,2,3,4,4,7 6 0,0,0,5,5,9 year 11 boys 4 8 5 0,0,1,4,4,6 6 0,0,3,4 7 2,2,2,5,6,7 8 6 mean=51.68 lower quartile=46 median=52 upper quartile=57 range=69-35=34 mean=63.3333=63.3(3 sig fig)

  2. Maths - Handling Data

    I will interpret the data showing the year group, height and weight of each student in a table. Out of 370 students in year 10 and 11 together, 200 of them were from year 10 and 170 of the students were from year 11.

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