Feb 26th, 2008Lesson 8: Testing A Hypothesis Using Excel
The objectives of this video tutorial are:
To understand what a hypothesis is and how to test a hypothesis.
To learn how to pick out cells in an = sum function.
Feb 26th, 2008Lesson 7: Manipulating The Grid
This video tutorial will follow on from the previous lesson.
We will use autosum again – this time to calculate an average.
We will perform various spreadsheet manipulations – specifically moving cells, inserting a row, inserting a column, deleting a row and deleting a column.
There will be some discussion on what happens to the formulae when you […]
Feb 26th, 2008Lesson 6: Comparing Functions & Formulae
In this video tutorial we are going to learn:
What is a function and what is the difference between a function and a formula.
We’ll have practice in using 3 common functions – to add up a set of numbers using the autosum tool, to average a set of numbers and to find the range of a […]