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

• Excel tutorial files (from Excel 2007 and Excel 2003) which give the key-stroke steps for important data analysis calculations.
• Video demonstrations based on some of the tutorial files.
• Video examples of using Excel in solving 'Q' problems from the book.

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.2,  Q13.3; Calculating slope/intercept - Q4.20, Q4.21(LINEST), Q4.8,  Q4.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.8,  Q8.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.2,  Q13.3; Calculating slope/intercept - Q4.20, Q4.21(LINEST), Q4.8,  Q4.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.11,  Q5.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