Data Handling Project looking at a database based in Excel where there is data from Key Stage 3 and 4 from Mayfield High School

Data Handling Project looking at a database based in Excel where there is data from Key Stage 3 and 4 from Mayfield High School
Introduction.

This Data Handling Project is looking at a database based in Excel where there is data from Key Stage 3 and 4 from Mayfield High School. This data consists of several columns containing both Quantative and Qualitative Information. Examples of this data are:

· Year Group

· Name; Surname, Forename 1 and Forename 2

· Age in Months and Years

· Month of Birthday

· Gender

· Hair Colour

· Eye Colour

· Left/Right Handed

· Favourite Colour

· Average number of Hours TV Watched per week

· SATS Results etc…


In this project I am going to make up several Hypothesises that I will use the data from the Data Base to help me prove. However I will not use all of the data, and for each Hypothesis I will Random Sample using the computer 30 entries which fit into certain restrictions applying to that Aim.

The R...