Introducing statistics

Summary

This intermediate course will teach you how to use statistics functions when performing analysis in Microsoft Excel. This set of Excel functions enables you to calculate averages, standard deviations, percentiles and even correlations. You will use these Excel functions to generate insights for a fictional client.  Created & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €50.00  (€50.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
2.00
CPD hours:  
2.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This course is suitable for intermediate learners who have a basic level of familiarity with writing Microsoft Excel formulas. No prior knowledge of statistics is necessary. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 7 lessons, 2 exercises and 1 Exam. It covers the following topics:

  • Introduction to statistics
  • Average, median and mode
  • Interpreting percentiles
  • Creating databins
  • Variance and standard deviation
  • Finding trends in data
  • Correlation

Key Outcomes

Once you have completed this course you will know how to use all of Excel’s most popular statistics functions (e.g. MEDIAN, CORREL, PERCENTILE.EXC) and be able to deploy these functions in formulas that perform calculations on various datasets. You will also know when to correctly use these functions as many are only relevant certain datasets. Consequently, you will be able to avoid many common statistical errors that users make in Excel.