Use ACPD101 for 10% off any purchase.
This course will enable you to
- 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 the course
As accountants, we are all familiar with Excel. However, in a dynamic and ever-changing world, we need to be smarter about how we use the tools we have at our disposal. Using statistics and probability in Excel can help you to enhance your role as an accounting and finance professional. The techniques covered in this course can help you to understand how to use statistics to summarise and properly describe the data with which you're working.
You will cover the basics of probability, so that you can understand how to predict more accurately the likelihood of certain business outcomes. You'll also touch on the various issues you might discover related to sample size and then how to test explanations or hypotheses that you come up with.
Look inside
Contents
- 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
- HYPGEOM.DIST
- Joint probability PivotTable
- Random variables
- What are random variables?
- Binomial distribution
- Poisson variables
- Normal distribution
- Basics of sampling
- Populations and samples
- CONFIDENCE.NORM and CONFIDENCE.T
- Population size
- Hypothesis testing
- Z-tests
- What is a t-test?
- Correlation
- Two sample Z-test
How it works
Reviews
Recommended | ||||
Why not upgrade?Find the best way to complete your CPD | CourseNeed just a few unitshourshours? | Pick n MixAll you need for this year's CPD. | LicenceAll you need for this year and more. | TeamKeep your whole team up to date. |
---|---|---|---|---|
Access to this course | ||||
Total CPD unitshourshours | 4 unitshourshours | 21 units20 hours21 hours | 800+ unitshourshours | 800+ unitshourshours |
Access period | 120 days | 120 days | 12 months 2 years' access | 12+ months |
Audit-proof CPD completion certificate | ||||
Immediate access to our entire CPD catalogue | ||||
Exclusive news and CPD every week plus monthly webinars, all year round | ||||
Account manager on hand to support your team’s needs | ||||
Learn more | Learn more | Learn more | ||
Why not upgrade?
Find the best way to complete your CPD
You might also like
Take a look at some of our bestselling courses
Use ACPD101 for 10% off any purchase.