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?.
