Determining IQ Level

Determining IQ Level

Introduction

For this project we were given data about an imaginary High School

called Mayfield. Data was given to us about all students and included:

Name, age, year group, IQ, weight, height, hair colour, eye colour,

distance from home to school, usual method of travel to school,

average number of TV hours watched per week, number of brothers and

sisters, key stage 2 results in English, Mathematics and Science and

others.

Year Group

Number of Boys

Number of Girls

Total

7

151

131

282

8

145

125

270

9

118

143

261

10

106

94

200

11

84

86

170

Looking at the data I have decided to compare the average number of

hours TV watched per week with IQ and Gender.

Hypothesis

I believe that the average number of hours TV watched per week is a

greater factor in determining IQ level, rather than the gender is.

Getting the Data

To get my data, I used stratified sampling. This means that I have to

separate my data e.g. into every year group and then take random

samples. In my case I used a sample size of 100 and because I had two

groups, Male and Female I had to half the sample size of 100 to 50 for

the Males and the Females. For each group I used a random sampling

method. First I went onto Microsoft Excel and then type in =RAND()*604

for the boys and put that onto one cell than expanded it onto50,which

gave me all the random numbers I needed for the boys. Then for the

girls I did exactly the same but then I typed in =RAND()*579 instead

of =RAND()*604. From those random numbers, for each group I selected

the people and so I had the people to compare.

Conclusion