The Open Door Web Site
Using MS Excel as a Calculator
ICT in Biology Index
ICT IN BIOLOGY
Using MS Excel 2013 as a Calculator
Using Preset Functions
Each of the cells in a spread sheet can carry out calculations. Either you choose from the collection of functions in the tool bar or you type in your own function.
An equation will appear in the cell indicating the function and the cells it will use with this function. Check that they are the correct cells and click OK or press Enter.
The mean will appear in the box.
The same thing can be done if you want to calculate the Standard Deviation of this sample.
Select a cell, Click on the function button. This time you will have to search for Standard deviation amongst the Other functions.
If you have used it recently it will be there. If not, look use the 'Search for a function' box by typing STDEV.
Click on Standard deviation. The dialogue box will tell you which cells it is using to calculate the Standard Deviation. This time you will see that it does not select the correct cells automatically.
Hold down the left mouse button and run the mouse down the correct series of figures and the cells will change in the dialogue box. Click OK or press Enter
The Standard deviation will appear in the cell you selected.
If you need to adjust the number of decimal places use the buttons on the tool bar.
The advantage of a spread sheet is that you can make it repeat a calculation over and over for similar series of data.
Pull the cursor across the bottom of the table and then let go of the mouse. The means and standard deviations of each column will appear in the boxes.
The Open Door Web Site is non-profit making. Your donations help towards the cost of maintaining this free service on-line.
Donate to the Open Door Web Site using PayPal