Data Handling Project
This Data Handling Project is looking at a database based in Excel where there is data from Key Stage 3 and 4 from 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
…show more content…
This is because all of the data really evens itself out.
The differences between the Blonde and Brunette Females IQ Levels only really showed that there were 2 more Brunettes that had between 96 - 100 IQ's than the Blondes. This is not really strong evidence to base the statement of fact that Brunettes are more intelligent as they have higher IQ's than the Blondes.
The Box and Whisker Diagram for the Blonde Females IQ has a larger Lower Quartile, a smaller Median area, and a larger Upper Quartile than the Brunette Females IQ.
The spacing of the sections in these diagrams shows to me that due to the Blonde Females having a smaller Lower Quartile IQ space there are less people in this section than in the Brunette Females section. As the Upper Quartile is larger for the Blondes than the Brunettes this agrees with the fact that the Blondes appear to be slightly
…show more content…
There was one anomaly in this data that I used to answer this Hypothesis. The piece of data that had the Anomaly was a girl in Yr. 11 with Blonde hair and an IQ Level of 11. I don't think that this is a real piece of data as in the whole IQ Levels for Key Stage 4 there was only 2 students with IQ Levels of under 76. These 2 levels were 11 and 14.
Therefore from conducting these graphs I can say that my Hypothesis is not true and that I didn't really find any great significant change in the IQ Levels.
Does the Average hours of TV Watched per week affect a persons Weight?
The hypothesis of this Question that I want to use the data from the Mayfield High School to prove is: ====================================================================
Is the increase in the amount of television watched by pupils in Year 10 reflected by their size, in weight? E.g. does the heaviest
This is the perfect opportunity to take that expression or equation that was built in the first half and start the process of finding x. Combining terms and subtracting numbers from both sides will aid in the process of the ultimate goal of finding the unknown number. Many times teachers us a balance with chess pieces and students have a hard time visualizing why 2 paws have to be taken from both sides. The Napping House (1984) clearly depicts how subtraction needs to occur on both sides of the equation. Ultimately, just like balancing equations, the story ends beautifully with everyone and everything
The point is valid and their reasoning is sound, but it does not prove that
make a mark on top of every number. Now draw a line from... At this point a girl said that she
One of the biggest problems that affect everyone is data aggregation. The more the technology develop, the powerful and dangerous it gets. Today there are many companies that aggregate a lot of information about us. Those companies gathering our data from different sources, which create a detailed record about us. Since all services have been computerized whether it is handled directly or indirectly through computers, there is no way to hide your information. We used computers, because they are faster, better, and accurate more that any human being. It solved many problems; however, it created new ones. Data does not means anything if it stands alone, because it is only recoded facts and figure, yet when it organized and sorted, it become information. These transformed information. Data aggregation raises many questions such as, who is benefiting from data aggregation? What is the impact on us (the users)? In this paper I will discuses data aggregation and the ethics and legal issues that affect us.
You can use the set of six questions, below, to investigate this. Before describing the false
The coded years (0-7) will be placed in the X ranges representing the independent variable. With this model the first cell title will also be included. The Excel QM provides the analysts with the simple linear regression analysis as seen in FIGURE 1-3.
Name: Change the labels adapted in the first row of Excel file into new variable names (regard the variables background of the conceptual framework, must be short, no space), as indicated in the below table.
Text Box: Using the same method: (3 x 7) – (1 x 9) 21 - 9 = 12 Answer = 12
I will then use to that information to support my argument as well as acknowledge and counter any benefits of
first column I have the number of cubes and in the second I have the
"Although fully searchable text could, in theory, be retrieved without much metadata in the future, it is hard to imagine how a complex or multimedia digital object that goes into storage of any kind could ever survive, let alone be discovered and used, if it were not accompanied by good metadata" (Abby Smith). Discuss Smith's assertion in the context of the contemporary information environment
To do this I needed to use the software Microsoft Excel 2003 as it was easier to use than other software products. As well Microsoft Excel can perform more useful functions such as Absolute Cell Reference, Functions (MIN, MAX and AVERAGE),Conditional Formatting and many more. Each of these useful in a case such as this.
This in mind, there is really no way to prove this too a person who