The aim of my investigation is to use and apply my understanding of statistics and statistical techniques to investigate the two following hypothesis - There is a correlation between Key Stage 3 (KS3) and GCSE results.

Authors Avatar
INTRODUCTION

The aim of my investigation is to use and apply my understanding of statistics and statistical techniques to investigate the two following hypotheses:

SCHOOL A -Highgram School

Hypothesis 1: There is a correlation between KS3 & GCSE results.

RAW DATA (table 1)

GENDER

KS3 LEVEL

GCSE GRADE

GENDER

KS3 LEVEL

GCSE GRADE

BOY

3

U

BOY

7

A

BOY

3

U

GIRL

3

E

GIRL

3

G

GIRL

3

D

BOY

4

U

BOY

4

F

BOY

5

E

GIRL

5

E

GIRL

5

C

BOY

5

D

GIRL

5

E

GIRL

5

D

GIRL

5

E

BOY

5

D

GIRL

6

D

BOY

5

E

BOY

6

D

GIRL

5

D

BOY

6

D

GIRL

5

C

GIRL

6

C

BOY

5

D

BOY

6

D

BOY

5

D

GIRL

6

C

GIRL

5

C

GIRL

6

E

BOY

6

B

BOY

6

D

GIRL

6

C

GIRL

6

C

BOY

6

D

BOY

6

D

GIRL

6

D

GIRL

7

B

GIRL

6

A

BOY

7

A

GIRL

6

C

GIRL

3

F

GIRL

6

D

BOY

3

G

GIRL

6

C

GIRL

4

F

GIRL

7

A

BOY

4

U

GIRL

4

U

GIRL

5

E

BOY

5

E

GIRL

5

E

GIRL

6

B

GIRL

6

B

GIRL

6

C

BOY

6

B

BOY

6

E

GIRL

6

C

GIRL

6

C

GIRL

6

B

GIRL

6

B

With my acquired raw data (table 1) I will construct a frequency table (table 2) to condense the information and make it easier to read, understand and utilise.

FREQUENCY TABLE (table 2)

KS3

Level 3

Level 4

Level 5

Level 6

Level 7

TOTAL

Boys

3

3

7

9

2

24

Girls

4

2

0

8

2

36

TOTAL

7

5

7

27

4

60

GCSE

U

G

F

E

D

C

B

A

TOTAL

Boys

4

4

0

0

2

2

24

Girls

2

7

6

2

5

2

36

TOTAL

5

2

3

1

6

2

7

4

60

To make it easier to compare values and grades graphically I will use the Microsoft Excel package on my computer to construct bar charts and pie charts. Bar charts will make it easier to compare grades because they illustrate and from looking at them I will be able to compare frequencies. Yet, they can only be constructed using discrete data. Pie charts are useful as they can be used for both discrete and continuous data and from them I can compare ratios.
Join now!


The charts that I will construct are:

i. Bar Chart showing KS3 results (chart 1, page 4)

ii. Bar Chart showing GCSE results (chart 2, page 5)

iii. Pie Chart showing KS3 results (chart 3, page 6)

iv. Pie Chart showing GCSE results (chart 4, page 7)

From viewing the bar charts I can see that there is a correlation between KS3 and GCSE results as the trend lines are the same shape. From looking at the pie charts it is difficult to see if there is a comparison a at KS3 ...

This is a preview of the whole essay