IQ Investigation

Natalie Mansell                Mayfield High Maths Coursework

Mayfield High Maths

Coursework

I am investigating around data about a school called Mayfield High. Mayfield High is a database of secondary data and I will be using only the Key Stage 3 pieces of data. I am doing this investigation so that I can find links between different aspects of secondary school pupils, and create charts and graphs to show the patterns that I have found.

I am going to look at a database on excel. I will then take a stratified sample of years 7, 8 and 9, depending on my sample size I have chosen to be 60 (because I think that it is a viable size).

After I have worked out my stratified sample I will give each member of each year group a unique number and use random number tables to choose my final sample so that my sample is an unbiased one, giving no special interest to any specific data in particular.

I believe that the more people watch TV, the lower their IQ should be. I also believe that the further people go up the school, the higher their IQ should be and that girls are generally cleverer than boys throughout Key Stage 3. I also believe that there may be a relationship between people’s IQ and the amount of time they watch TV and that the relationship between IQ and TV shows a higher correlation as you move up the school. I will then perform a statistical analysis by investigating the areas using standard deviation, histograms, scatter diagrams and spearman’s rank correlation. Firstly I will have to work out my stratified sample. I chose the sample size of 60 because I believe it will be a viable size.

YEAR 7

282 x 60 = 20.8 (rounded up to the nearest whole number as 21).

813

This means that I should take 21 pupil’s sets of data from year 7 for my stratified sample.

YEAR 8

270 x 60 = 19.9 (rounded up to the nearest whole as 20)

813

This means that I should take 21 pupil’s sets of data from year 8 for my stratified sample.

YEAR 9

261 x 60 = 19.2 (rounded down to the nearest whole as 19)

813

This means that I should take 19 pupil’s sets of data from year 9 for my stratified sample.

Now I know how many people I need to sample from each year I will now give each student in each year a unique number and use a random number table to select an unbiased sample from each year (based on what I worked out the sample size needed to be). It needs to be unbiased so that the pupils are selected randomly and that I have not focused on specific criteria some students may have.

You will find the above mentioned samples with this work.

After selecting my samples from each year group, I then looked at how many males and females I had randomly selected from each year. From year 7 I found I had selected 10 males and 11 females, making up the 21 that I worked out I needed to take from year 7. From year 8 I found I had selected 12 males and 8 females, making up the 20 that I worked out I needed to take from year 8. From year 9 I found I had selected 7 males and 12 females, making up the 19 that I worked ...