SPREADSHEETS FOR DATA ANALYSIS
We can use a spreadsheet to analysis data. We can get it to count things in cells. We can get it to find averages.
We can get it to make meaningful graphs. We make graphs because they are easier to read than a whole pile of numbers.
Consider this pile of data about class 7X.
How many are boys?
What is the average age?
What is the average height?
How many have brown hair?
Well you would have to look through the lists and count everything up?
We can get the spreadsheet to do all of the hard work for you. We can write formulas to find all of these things out.
Following are some formulas that you will need for the analysis of the data for class 7X.
The computer works out the average of all the numbers in cells C3 to C32
To count entries in cells
The computer looks in cells B3 to B32 and counts all the “B”s it sees
The computer counts all the “brown”s it sees in cells F3 to F32
The computer adds up all the numbers in cells J19 to J23
The formulas are really easy once you practice them a few times. Honest!
Print out the worksheet and complete it.
The data for class 7 X is also here for you to complete.
This task should take you 1 hour to complete.