• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Mayfield High school

Extracts from this document...

Introduction

Adnan Sarayqum

Statistic Coursework

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)

...read more.

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

image00.png

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

image01.png

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

image02.png

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

image03.png

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

image04.png

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

Extension

To develop my investigation and understanding, I have decided to do some widespread research. In the following section I will look at the data which states what IQ a person required to attain a level 4 KS2 result.

...read more.

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.  

...read more.

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. 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
    improve your own work