Analysing Experimental Data (with Excel and Minitab)

This section of the website is being actively developed between September 2011 and April 2012, and new content will be added on a day-to-day basis during this period. Please send any comments/suggestions to graham.currell@uwe.ac.uk

The links on this page are designed to provide both the theory and practice of the various aspects of analysing experimental data (including the use of Microsoft Excel and Minitab).

Drawing and analysing x-y graphs using Excel (video tutorials):
- Drawing x-y graph; 'Best-fit' trendlines; Error bars; Regression & Correlation (Slope & Intercept); Data Analysis Tools + download associated Excel file
Presenting results in an acceptable format:
- scientific notation, significant figures 
- QVA Tutorial: Accuracy and precision
Handling scientific units:
- Units, SI units and their interconversionMoles, grams and concentrations 
Statistical variations in experimental data:
- accuracy and precision; mean, median and standard deviation; frequency distribution.
- QVA Tutorial: Uncertainty and the normal distribution 
Experimental errors and uncertainties:
- describing, combining and presenting errors
- QVA Tutorials: Errors and uncertaintiesConfidence interval
- QVA Tutorials: Combination/propagation of errors; Errors in concentrations/dilutions 
Analysing replicate measurements using Excel:
 - mean, standard deviation, standard uncertainty, confidence interval.
Analysing linear and proportional data:
-
Mathematics of the straight line, 'best-fit' straight line, linear regression and linear calibration 
- QVA Tutorial: Proportionality and calibration: Video Tips - Constants of proportionality, Interpolation in calibration 
Uncertainties in linear regression and calibration using Excel:
 - Uncertainies in linear regression, Calculating the error when using a calibration graph
Plotting and interpreting frequency data:
- QVA Tutorial: Frequency distribution of data
Performing an hypothesis test to identify a difference, effect or association:
- Hypothesis testing
Analysing a non-linear relationship:
- in development

book cover

This on-line Study Guide has been developed by Graham Currell in association with:
University of the West of England,
"Essential Mathematics and Statistics for Science", 2nd Edition,
Graham Currell and Antony Dowman, Wiley-Blackwell, 2009