Essential Mathematics and Statistics for Science, 2nd Edition
Graham Currell and Antony Dowman, Wiley-Blackwell, 2009

This page is up-dated regularly by the authors.       Return to the home page.

Using Microsoft Excel for Data Analysis - Tutorial files + Video examples

Link below for:

Topics:


Data Analysis of Replicate Data: Use of equations, functions and data analysis tools
Tutorial files: ExcelDataUncert01 (2007)
Video tutorials:
Functions (video), Data Analysis Tools (video), Random data (video)
  Video examples from book:  Confidence interval - Q8.5, Q8.6, Q8.7  
   

Data Analysis using Linear Regression: Use of equations, functions and data analysis tools
Tutorial files: ExcelDataUncert01 (2007)
Video tutorials:
X-Y Graph(video), Functions (video), Data Analysis Tools (video),  Random data and Error Bars (video)
  Video examples from book:  Drawing x-y graph - Q3.37, Q4.19, Q5.24, Q6.2Q13.3; Calculating slope/intercept - Q4.20, Q4.21(LINEST), Q4.8Q4.9, Q4.24;  Adding trendline - Q4.21; Use of line of regression Q4.14, Q4.15, Q4.22(LINEST),  Q13.3,  Q4.10
Linearization - change of variable car skid distance (Excel 2003)
Linearization - change of variable Michaelis-Menten (Excel 2003) 
   

Data Analysis of Linear Calibration: Use of equations, functions and data analysis tools
Tutorial files: BeersLaw
Video tutorials:
Residuals and correlation coefficients (video), Best-estimate x-value (video), Uncertainty in calculated x-value (video)
  Video examples from book:  Q13.4
   

Basic Skills: Formatting, Editing, Calculations, Functions, Addressing, Output
Tutorial files: Basic skills (2007)Basic skills (2003)
Video tutorials:
Formatting, Editing, Calculations, Functions, Addressing,
  Video examples from book:    Basic calculations - Q2.8Q8.10, Q7.1; Trigonometry (Data Sort operation) - Q2.28; Functions - Q4.22, Q5.22; Addressing - Q4.2
   

Solving Equations: Quadratic equations, Simultaneous equations
Tutorial files: Equations (2007), Equations (2003)
  Video examples from book:    Quadratic equations - Q3.33; Simultaneous equations - Q3.35
   

X-Y Graph: X-Y Graph, Trendline, Error Bars, Regression
Tutorial files: X-Y Graph (2007) , X-Y Graph (2003)
Video tutorials:
Drawing x-y graph; 'Best-fit' trendlines; Error bars; Regression & Correlation (Slope & Intercept);
Data Analysis Tools
  Video examples from book:   Drawing x-y graph - Q3.37, Q4.19, Q5.24, Q6.2Q13.3; Calculating slope/intercept - Q4.20, Q4.21(LINEST), Q4.8Q4.9, Q4.24;  Adding trendline - Q4.21; Use of line of regression Q4.14, Q4.15, Q4.22(LINEST),  Q13.3,  Q4.10
Linearization - change of variable car skid distance (Excel 2003)
Linearization - change of variable Michaelis-Menten (Excel 2003)
   

Logarithms & Exponentials:  Functions, Linearization of Exponential Growth
Tutorial files: Logs & Exps (2007), Logs & Exps (2003)  
Video tutorial:
In production
  Video examples from book:   Functions - Q5.2, Q5.10, Q5.11Q5.12  Exponential Growth - Q5.22, Q5.24
   

Modelling Change: Rates of Change, Integration
Tutorial files: Modelling (2007) , Modelling (2003)   
  Video examples from book:   Q6.2
   

Statistics Intro: Functions, Frequency, Charts, Histogram, Cumulative, Permutations & Combinations
Tutorial files: Statistics (2007) Statistics (2003)  
  Video examples from book:   Functions - Q7.7, Q7.8
   

Distributions: Normal, z-Areas, x-Areas, Differences, Reverse, Confidence, Binomial, Poisson
Tutorial files: Distributions (2007), Distributions (2003) 
  Video examples from book:  Confidence interval - Q8.5, Q8.6, Q8.7 Binomial - Q8.11, Q8.12 Poisson - Q8.13 Combining uncertainties - Q8.9, Q8.10,
   

Parametric Tests: F-Test, 1-sample t-Test, 2-sample t-Test, Paired t-Test, Correlation
Tutorial files: Param Tests (2007) Param Test (2003)   
Video tutorial:
In production
  Video examples from book: t-Test - Q10.1 Correlation - Q13.1
   

Chi-Squared Tests: Frequency, Contingency, Yates, Critical Values
Tutorial files: Chi-Squared (2007) Chi-Squared (2003)  
  Video examples from book: Contingency table - Q14.5
   

ANOVAs: 1-way ANOVA, 2-way ANOVA, 2-way ANOVA with Replication, Transferring Data from Excel to statistics software.
Tutorial files: ANOVAs (2007) , ANOVA (2003)   
Video tutorial:
In production
  Video examples from book:
   

End of page