Introduction to Statistics for Research & Development Using XLSTAT

Product code: XL-Intro-2020

XLSTAT, Bordeaux

March 25, 2020 - March 26, 2020

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 using XLSTAT through “hands on exercises” for which annotated solutions are provided. You will need a laptop with XLSTAT loaded, or you can hire a machine for the day for an additional small fee.

 

Course Outline

Day 1

  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
  1. 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

    1. Analysis of Binary (Yes/No)Data
    • Estimating Response Rates with uncertainty
    • Testing for significance

 

    1. 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. Correlation & Simple Regression
    • Correlation – what is measures
    • Simple trend modelling – assessment of fit
    • Diagnostics

 

    1. Multiple Regression & Further Modelling
    • Variable selection techniques
    • Pitfalls for the unwary
    • Modelling curvature

 

    1. Study Design
    • Issues to consider

Select currency

$1,353.57$1,794.30 (Excluding any applicable taxes)

Clear

Other course information

About The Trainer
Anne Hasted began her career as an academic statistician at Reading University, but is now senior consultant at Qi Statistics Ltd offering statistical training, software and consultancy support to research and industry. She has wide training and consultancy experience in many different commercial fields and has an international reputation for “user friendly” training.

Venue

XL STAT, 35 Rue Thiac, 33000, Bordeaux, FRANCE

Software
You will need to bring a laptop with the latest version of XLSTAT installed. If you don’t have a licence you can download a 30 day trial version. If you cannot bring a computer we can arrange laptop hire for an additional £50 (+VAT).

Prices
Commercial Delegate price: £1,150 +VAT
Academic Delegate price: £1,035 +VAT
10% reduction for multiple bookings from same organisation

Please contact us for more details.

Course leaflet

Please click the button below to access the PDF leaflet for this course