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

 

Going Further with Graphs Index

Trend Lines
Calculating Slopes
Plotting Derived Data
Error Bars Showing Precision
Entering Error Bars on a Scatter Plot

ICT in Biology Index

Using MS Excel as a Calculator
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

EBSDFile.xlsx

 

 

About the Data

These data come from an investigation on the growth of moulds sampled from different parts of two cheeses (Camembert and Rocquefort) and grown on malt agar in a Petri dish. The growth of the mould was measured after one week.

Data

The data is entered on a spread sheet. The spread sheet is used to calculate the mean and the standard deviations. A bar chart is drawn of the results.

 

 

 

 

ICT IN BIOLOGY

Custom Search

Using MS Excel 2013 : Going Further with Graphs

Error Bars Showing Standard Deviations

If you want to show standard deviations as error bars then you need to use a slightly different approach.

Data source shown in left column.

From the Chart Elements menu select Format Error Bars and Custom. Click on Specify Value.

Graph01

Now the data that is to be used for the error bars has to be selected. You need to select the cells containing in the standard deviation (line 14) for both positive and negative error values.

Left click on the first cell and hold the button down whilst you run along the line for standard deviations. You will see the cell coordinates appear in the positive error values box. Repeat the same procedure for the negative error box.

 

Graph02

Press Enter or click OK and the error bars will appear on the graph.

Graph03

 

Next : Entering Error Bars on a Scatter Plot

 

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