ODWS icon

The Open Door Web Site
HOMEPAGE BIOLOGY HOMEPAGE CHEMISTRY PHYSICS ELECTRONICS HISTORY HISTORY OF SCI & TECH MATH STUDIES LEARNING FRENCH STUDY GUIDE  PHOTO GALLERY
IB BIOLOGY HOMEPAGE TOPIC CHAPTERS SCIENTIFIC INVESTIGATIONS DRAWING IN BIOLOGY DRAWING TABLES ERROR ANALYSIS IN BIOLOGY ALL ABOUT GRAPHS STATISTICS SCIENTIFIC POSTERS MOLECULAR IMAGES
WS

 

Using MS Excel as a Calculator

Creating Your Own Functions
Adjusting the Decimal Places

 

ICT in Biology Index

Using MS Excel : Going Further with Graphs
Using MS Excel as a Database

IB Biology Homepage

 

Note about this Tutorial

This tutorial has been updated. It was originally published using Excel 2003. The new images are screenshots from Excel 2013.

There may be very slight differences for those of you using Excel 2016 but, essentially, the layout is much the same as Excel 2013.

Download the Excel Data File used for this tutorial to practice with

Excel icon

StDevFile.xlsx

 

 

 

 

ICT IN BIOLOGY

Custom Search

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.

  • Enter your data in a new spread sheet

  • Select a cell at the bottom of a column where you want the mean (average) to be calculated.

  • Click on the functions button in the tool bar

  • Select Average and click on it.

EXCEL01

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.

Excel02

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.

Excel03

If you have used it recently it will be there. If not, look use the 'Search for a function' box by typing STDEV.

Excel04

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.

Excel05

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

Excel06

The Standard deviation will appear in the cell you selected.

Excel07

If you need to adjust the number of decimal places use the buttons on the tool bar.

Excel08

The advantage of a spread sheet is that you can make it repeat a calculation over and over for similar series of data.

  • Highlight the boxes for mean and standard deviation.

  • Place the mouse cursor on the bottom right of the box and hold down the left mouse button.

Excel09

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.

Excel10

 

Next: Creating Your Own Functions

 

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

SITE MAP
WHAT'S NEW?
ABOUT

PRIVACY

COPYRIGHT

SPONSORSHIP

DONATIONS

ADVERTISING

© Paul Billiet 2018
Any questions or problems regarding this site should be addressed to the webmaster

Hosted By
Web Hosting by HostCentric


SiteLock