• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month
• Level: GCSE
• Subject: Maths
• Word count: 1895

# Mayfield High school

Extracts from this document...

Introduction

 Adnan Sarayqum Statistic Coursework Mayfield High School Mr Bailey[Pick the date]

Mayfield High School Coursework

In this investigation I have compared IQ and KS2 results of Mayfield high school to see if there is any relationship between these two factors. I have also planned to show how I have carried out my investigation.

I have been given a dataset of 1200 students of Mayfield High School as held in our school computers and home computers, from which I have chosen a random sample of 30 students. To help me in my coursework I have used Microsoft Excel as it is the most appropriate software to use. I have generated a random sample using Microsoft Excel and I have used this software to generate all my graphs, tables, and box and whisker diagrams.

I have used the data from the computer because it is easy to collect the data from there to avoid logistical problems and time consuming problems.

## My hypothesis / prediction:

‘My prediction is that the higher the IQ the higher the KS2 results will be.’

## How I will prove my prediction

To be able to prove my prediction I have worked out Mean, Median, Mode and Range using Steam and Leaf table. I have also worked out Cumulative Frequency and drawn Cumulative Frequency graphs to find out Median, Lower Quartile (Q1), Upper Quartile (Q3)

Middle

27

97-101

||

29

102-106

|

30

## Level 4

 IQ Frequency Cumulative Frequency 89-93 || 2 94-98 ||||| 7 99-103 |||||||||||||||| 23 104-108 |||| 27 109-113 || 29 114-118 | 30

## Level 5

 IQ Frequency Cumulative Frequency 101-105 ||||||| 7 106-110 ||||||||| 16 111-115 ||||| 21 116-120 |||||||| 29 121-125 | 30

## Level 6

 IQ Frequency Cumulative Frequency 108-114 ||| 3 115-121 ||| 6 122-127 || 8 128-134 | 9

 The minimum value 74 The lower quartile 74.5 The median 77 The upper quartile 81.75 The maximum value 86

Using the cumulative frequency graph

Median = n ÷ 2= 31 ÷ 2 = 15

Lower quartile = n ÷ 4 = 30 ÷ 4 = 7.5

Upper quartile = 3n ÷ 4 = 90 ÷ 4 = 22.5

Inter quartile range = upper quartile – lower quartile

 The minimum value 78 The lower quartile 88 The median 90.5 The upper quartile 94 The maximum value 102

Using the cumulative frequency graph

Median = n ÷ 2= 31 ÷ 2 = 15

Lower quartile = n ÷ 4 = 30 ÷ 4 = 7.5

Upper quartile = 3n ÷ 4 = 90 ÷ 4 = 22.5

Inter quartile range = upper quartile – lower quartile

 The minimum value 90 The lower quartile 100 The median 102 The upper quartile 103 The maximum value 116

Using the cumulative frequency graph

Median = n ÷ 2= 31 ÷ 2 = 15

Lower quartile = n ÷ 4 = 30 ÷ 4 = 7.5

Upper quartile = 3n ÷ 4 = 90 ÷ 4 = 22.5

Inter quartile range = upper quartile – lower quartile

 The minimum value 101 The lower quartile 106 The median 110 The upper quartile 116 The maximum value 121

Using the cumulative frequency graph

Median = n ÷ 2= 31 ÷ 2 = 15

Lower quartile = n ÷ 4 = 30 ÷ 4 = 7.5

Upper quartile = 3n ÷ 4 = 90 ÷ 4 = 22.5

Inter quartile range = upper quartile – lower quartile

 The minimum value 111 The lower quartile 115 The median 117 The upper quartile 126.5 The maximum value 131

Using the cumulative frequency graph

Median = n ÷ 2= 31 ÷ 2 = 15

Lower quartile = n ÷ 4 = 30 ÷ 4 = 7.5

Upper quartile = 3n ÷ 4 = 90 ÷ 4 = 22.5

Inter quartile range = upper quartile – lower quartile

Conclusion

## Evaluation

In terms of my expectations, it showed that the higher the IQ the higher the KS2 results proved to be a success because it matched my hypothesis. I had accurate data and made them onto tables, graph and box plots to test my hypothesis. My results were all clear and it was easy to originate a conclusion.

However, I did perceive some complications involving the investigation. The first problem being is some of the abnormal curves on my cumulative frequency graph. Instead of having a smooth and consistent line, some graph show irregularity (graph 1 level 2). This could have been due to two reasons. The first reason could be mistakes in the data. There could have been false information given. The second reason could be due to the small sample size of level 2 and level 6.

Although I have some anomalous results I still consider my data is to a certain extent accurate as it has helped me to prove my prediction. Furthermore I think my conclusions are reliable as I believe if I done this investigation again I will have similar results. I think my results are valid because I have similar results to my class members who have done the same investigation.

If I had the chance to conduct this investigation in the future. I would choose a larger sample size; this may eliminate the inconsistency in graphs.

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

# Related GCSE Height and Weight of Pupils and other Mayfield High School investigations essays

1. ## mayfield high statistics coursework

Comparison I can compare that from the tables that I have produced and also by looking straightforwardly at the sample I have created which is that the children who watch a large sum or amount of TV on average per week rather peculiarly have an IQ which is above average

2. ## Mayfield High School

A sample is a small proportion of the data which can be applied for the whole of the population of data. The advantages of sampling are that it is much faster and cheaper to collect data. Sample size is very important as if it is not large enough it cannot be representative of the whole set of data.

1. ## I would like to know whether there is a link between ability in Maths ...

Frequency (f ) fx fx2 2 3 4 5 2 5 13 9 4 15 52 45 8 45 208 225 29 116 486 Mean = Mode = 4 Median = 15th value = 4 Standard Deviation, s = Skewness = Mixed Science (y)

2. ## Mayfield High School

I haven't got enough to show that my hypothesis is correct just yet so I will now move on to cumulative frequency. This will help me further in my investigation. Cumulative Frequency Tables: Cumulative frequency is when you add up the frequency as you go along.

1. ## mayfield high school handling data coursework

46 0.343807 8 Dave Davina Female 1.55 52 0.591392 8 Brocklehurst Kaylea Ann Female 1.60 51 0.360874 8 Berry Alice Ann Female 1.45 49 0.548915 8 Kent Shabnum Female 1.56 74 0.736989 8 Lomas Victoria Kirie Female 1.56 54 0.177367 8 Rooster Hally Gertrude Female 1.52 52 0.119105 8 House

2. ## Statistics Mayfield High

median 102.5 IQR 9.75 Outliers 14.625 UQ 109.75 124.375 =UQ + (1.5*IQR) max 124 Boys = 151/282 x 50 = 27 Therefore I will use 27 pieces of data from the boys. min 87 LQ 96.5 80.75 =LQ - (1.5*IQR)

1. ## Handling Data - Mayfield High School

decide whether there is strong positive correlation between IQ and Key Stage 2 results or not. If there is strong positive correlation I am going to draw a line of best fit on this graph and I will find its equation, which will further show the relationship between IQ and Key Stage 2 results.

2. ## Mayfield School Mathematics Statistics Coursework

any student granted a 0 in Maths and a 0 in Science would have been absent on the day and therefore these values will only distort my analysis. So, to start, I will initially calculate the measures of spread and location listed in the table below: Maths Science Mean 4

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