Data analysis for accountants: statistics
Use statistics and probability to enhance your role as an accounting and finance professional.
Partner products listed exclude VAT. You will be directed to an external site to complete purchase and VAT will be applied at checkout.
For your AAT exclusive discount apply AAT30 at partner checkout for an exclusive 30% off.
Course Type
E-learning
Length
3 - 5 hours
What you’ll achieve
- Understand the basics of probability functions in Excel
- Use statistics to summarise and describe data you’re working with
- Learn how to use pivot tables, COUNTIF and HYPGEOM.DIST to count probability
- Categorise random variables and use binomial distributions and Poisson variables
- Use Excel tools to select samples, calculate confidence and estimate a population size
- Test explanations or hypotheses you come up with using Excel.
About this course
This course explores the various ways you can use statistics and probability to enhance your role as an accounting and finance professional. Gain an understanding of basic probability functions and testing your hypotheses using Excel.
Overview
E-learning |
|
3 - 5 hours |
|
Data analysis |
Syllabus
Descriptive statistics
- Descriptive statistics in Excel
- Histograms
- Box plots
- Categorical and numerical data
- Summarising categorical data with PivotTables
- Categorical data and PivotTables
- Formulas for descriptive statistics
- RANK, LARGE and SMALL
- Geometric mean
Basic probability
- COUNTIF
- The law of complements
- Independent and mutually exclusive events
- Conditional probability
- DIST
- Joint probability PivotTable
Random variables
- What are random variables?
- Binomial distribution
- Poisson variables
- Normal distribution
Basics of sampling
- Populations and samples
- NORM and CONFIDENCE.T
- Population size
Hypothesis testing
- Z-tests
- What is a t-test?
- Correlation
- Two sample Z-test.
How to access
You will be directed to an external site to complete purchase and VAT will be applied at checkout.
