|
|
|
|
|
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 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? To get my data and graphs I am going to sort and filter data from the key Stage 4 information.
|
|
|
|
|
