Introduction to Statistics for Research & Development Using XLSTAT – POSTPONED

This basic but wide-ranging course covers the easy to use features in XLSTAT for investigating, visualising and performing basic statistical techniques on data sets typical to research and industry settings. There are many basic concepts that need to be understood before statistics can be used to its full potential to give useful and informative answers. This course ensures that these concepts are understood in a non-technical way and then practised using real data examples.

Mathematical details are kept to a necessary minimum and we focus on the interpretation of the outputs from XLSTAT and illustrate applications with case studies using data from surveys, instrumental analysis, manufacturing processes, clinical trials and biological data.

We aim to explain the objectives of the techniques and to send you away with a better understanding of which technique to use when.

No previous knowledge of statistics is necessary with this course, as we start right from the beginning. It also serves as a useful refresher course to those who once studied statistics as part of a college course.

There is plenty of opportunity for practice during the webinar using XLSTAT through “hands on exercises” for which annotated solutions are provided.

Course Outline

Day 1 (23 November)

1. Back to the beginning – Refresh the absolute basics of statistics
   • Types of data
   • Summary Measures
   • What is variability?
2. How sure are we? – Assessing Variability
   • Data Visualisation
   • Frequency Distributions
   • Measures of Variability
   • Degrees of Freedom
   • Descriptive Statistics
3. The answer could be…? – Estimation

• • Estimation
  • Confidence Intervals
  • Presenting Results
  • Data Requirements

4. Which is better? – Making Statistical Comparisons
   • Testing against a target (T Tests)
   • General Hypothesis tests
   • Comparison of 2 samples (means and variance) inc ANOVA
   • Problems with statistical significance and p-values

Day 2 (25 November)

1. 5. Analysis of Binary (Yes/No)Data

• • Estimating Response Rates with uncertainty
  • Testing for significance

1. 6. Power & Sample Size

• • How big a sample do I need to meet my objectives?
  • What is statistical power?
  • Statistical performance v practical considerations
  • Power & Sample Size

1. 7. Correlation & Simple Regression

• • Correlation – what is measures
  • Simple trend modelling – assessment of fit
  • Diagnostics

1. 8. Multiple Regression & Further Modelling

1. • Variable selection techniques
   • Pitfalls for the unwary
   • Modelling curvature

1. 9. Study Design

• • Issues to consider