Data Handling

            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 Random Sampling method that I am going to use is a computer generated one. The method of doing this is as follows:.
             1. Filter or sort the necessary data, copy and paste into a new sheet. Add 2 extra columns before this data. In Column 1 leave blank, and in Column 2 type the numbers 1 to X. .
             2. In the top of Column 2 type =RAND()*X, this makes a number between 1 and X. In the top of Column 1 put SUM in. In Column 1 next to that number put the number 1 and press enter, a new number will appear, put a 1 next to that number etc The amount of 1's you have typed will in the top of Column 1 - continue until 30.
             3. Copy and paste the selected data into a new sheet so that you can draw graphs and analyse it etc .
             Do Female Brunettes have higher IQ's that Blonde Females?.
             The hypothesis of this Question that I want to use the data from the Mayfield High School to prove is:.
             The Females from the Mayfield High School in key Stage 4 that have Brown hair are more intelligent, as shown in their IQ Level, that Females in the same age range and from the same School but with Blonde coloured hair?.