• 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 I know that the secondary data is based on a real school, under a fictitious name, meaning the data that I am using is not made up. This table in the introduction shows that 51% of the school is boys and 49% of the school is girls.

  1. Maths: Data Handling Coursework

    The reason why I chose this method was because I felt that my results would be more representative if my sample size was in proportion to the original totals. I also felt that this way, I could keep my investigation from being biased.

  2. mayfield high school handling data coursework

    Year 9 boys 118�261�55=24.8654= 25(2 sig fig) Year 9 girls= 143�261�55=30.13409=30(2 sig fig) Year 10=200�1183�250=42.2654=42= (2 sig fig) Year 10 boys=106�200=�42=22.26=22(2 sig fig) Year 10 girls=94�200=�42=19.74=20(2 sig fig) Year 11=170�1183�250=35.92561285=36(2 sig fig) Year 11 boys= 84�170�36=17.7882=18(2 sig fig) Year 11 girls= 86�170�36=18.21176=18(2 sig fig) Table of results year Boys girls total 7 32 28 60 8 31

  1. Maths - Handling Data

    My sample of 60 was a stratified random sample as follows: Year 10 = 200 x 60 = 32 370 Year 11 = 170 x 60 = 32 370 Before presenting this data in tables, graphs and charts I should look at the data to check for any anomalies and to make sure the data is acceptable.

  2. Data Handling Project

    60?w<70 1 65 65 70?w<80 0 75 0 TOTAL 20 895 Mean = FX � X Mean = (frequency x midpoint) � frequency Mean = 895 � 20 Mean = 44.75 This shows that the mean weight for girls between the years 7 and 11 is 44.75kg.

  1. Data handling coursework

    Range The range is the numerical difference between the smallest and largest values in a set of data. To calculate the range I will need to take away the smallest hand span measurement from the biggest hand span measurement. I will find the range for each gender separately for all the years.

  2. Data handling

    stem and leaf in which the first digit is the stem and the second digit is the leaf. A steam and leaf diagram can also be used to work out the median value of the data. * Box and Whisker This is used the represent some of the values found

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