UCL Learning Portfolio

 

DSD: Advanced statistics with Excel 2016 (Campus-based)
Course Description:

This is not a statistics course. Participants must already have adequate statistical knowledge.

The purpose of this course to introduce you to the functions in the Microsoft Analysis ToolPak and to consolidate your skill in building complex formulae by hand. The course covers major descriptive measures, some parametric tests, chi-square testing of association, and linear regression.

The course consists of one two-hour face-to-face campus-based session.

PREREQUISITES:

There are a number of pre-requisites for this course. Please visit the Digital Skills Development Moodle course for details.

You should ensure that you have all the relevant pre-requisite skills OR attend our Excel Essential Skills Workshops 1, 2 and 3 prior to attending this course.

IMPORTANT:

Once you have enrolled, please check that you have received a confirmation email from MyLearning. You will also receive an email with a joining link at least one day before the session.

Courses start on the hour but please join during the 5 minutes prior to this to download resources and test out your connection/audio.

For more details on how to book, cancel and join sessions please visit our practical course information page.


Objectives:
At the end of this course you will be able to:
  • Activate the analysis tool-pak
  • Perform simple descriptive statistics
  • Compare means for two groups
  • Conduct a chi-square test
  • Conduct an ANOVA
  • Compute regression coefficients
  • Carry out regression using the tool-pak
Intended Audience:
This course is aimed at those with statistical knowledge who wish to learn how to use Excel to carry out statistical analysis of their data.
Target Audience: All
Register Interest in future dates Register Interest

Back to MyLearning Catalogue