Statistical Services Centre Ltd
  • Home
  • Training
    • Course Registration
    • Terms and Conditions
    • Bespoke Training
    • Mailing List Request
  • Consultancy
    • Expertise
  • Team
    • James Gallagher
    • Sandro Leidi
    • Dankmar Böhning
  • SSC-Stat
  • Resources
  • Contact us
  • Products

A Review of Basic Statistics using Excel

Overview
This course builds up the basic ideas of statistics systematically and quickly.  It provides a review of the methods of summarising and presenting data, estimation, standard errors, confidence intervals, hypothesis testing and p-values.  Mathematical details are kept to a minimum.

Much of the course is practical work using Microsoft Excel. Practical work also requires our Excel add-in, SSC-Stat.  SSC-Stat is freely available..

Who Should Attend?
Scientists and related who have had some previous training in, or exposure to, statistics but who now wish to understand basic statistical ideas more thoroughly.

How You Will Benefit
This course provides a practical review of statistical methods.  There will be plenty of opportunity for discussion with course staff on appropriate methods of analysing data and help will be provided with interpreting results.

What Do We Cover?
  • Descriptive statistics - graphical and numerical summarisation of data
  • Introduction to Excel for statistics/SSC-Stat
  • Distributions - binomial and normal
  • Sampling distribution of the mean; standard error
  • The t-distribution
  • Confidence intervals
  • Hypothesis testing ideas; single-sample and two-sample problems; t-tests
  • Paired samples - their analysis and importance
  • Estimating and testing for proportions

Choice of Software
Practical work may be done in: Excel
Note: For practical work participants must bring their own laptop, using the Windows operating system, with a fully licensed version of the software.  You will also need to pre-install our Excel Add-In, SSC-Stat.

Extra Information
Follow-on Courses: Regression Models - A Hands-on Approach; Introduction to Analysis of Variance (ANOVA); Sample Size Determination using Excel


Course Dates
Next run to be announced

Duration: 2 days
Price: £TBC

Apply Now
(terms and conditions apply)

Return to full course listing
  • Home
  • Training
    • Course Registration
    • Terms and Conditions
    • Bespoke Training
    • Mailing List Request
  • Consultancy
    • Expertise
  • Team
    • James Gallagher
    • Sandro Leidi
    • Dankmar Böhning
  • SSC-Stat
  • Resources
  • Contact us
  • Products