Life Science Tutorials

Microsoft Office

Plotting compound XY data from Excel into Graphpad Prism

This was a request from a student who...

This was a request from a student who had a compound data set in Excel that they were trying to plot is GraphPad Prism. Here is how to plot data from Excel as an XY plot where there are multiple datasets sharing the same X axis.

Normalising grouped data in Excel for plotting graphs

This short tutorial shows how to normalise grouped...

This short tutorial shows how to normalise grouped data in Excel for the production of graphs showing change in outcome over time where the baseline may be variable but the change in outcome consistent.

Plotting a graph with error bars in Excel (PC version, 2013)

Plotting graphs in excel can be complicated...

Plotting graphs in excel can be complicated, especially as Excel does not have very sensible Scientific Graphics tools. Error bars are often a problem, so this tutorial shows how to produce a graph with means and error bars showing the standard deviation of the mean of our data.

Plotting a graph with error bars in Excel (Mac version, 2011)

Plotting graphs in excel can be complicated...

Plotting graphs in excel can be complicated, especially as Excel does not have very sensible Scientific Graphics tools. Error bars are often a problem; so this tutorial shows how to produce a graph with means and error bars shown standard deviation.

Plotting graphs with MEAN and SD or SEM in Microsoft Excel

Plotting graphs with MEAN and SD-SEM in EXCEL...

Plotting graphs with MEAN and SD-SEM in EXCEL

Normalising repeated-measures data in Microsoft Excel

A method for normalising data form repeated-measures experiments...

A method for normalising data form repeated-measures experiments in Excel

Running a t-test in Microsoft Excel

Tutorial showing how to run a t-test in...

Tutorial showing how to run a t-test in Microsoft excel using the built-in data analysis took pack.

One-Way ANOVA in Microsoft Excel

A tutorial demonstrating how to run a One-way...

A tutorial demonstrating how to run a One-way Analysis of Variance (ANOVA) using the built-in analysis tool pack in Excel. This tutorial also described the use of post-hoc t-tests with the Bonferonni correction to determine statistical differenced between groups.

Normalising grouped data in Microsoft Excel

A tutorial demonstrating one way of normalising grouped...

A tutorial demonstrating one way of normalising grouped data from intependant experiments with examples of a technique that might be applicable for data from a laboratory experiment.

Making Publication-quality graphs in Excel

Who would have believed it, you CAN use...

Who would have believed it, you CAN use Excel to make publication -quality graphs!

© King's College London