• Home
  • Statistical Data Analysis In Excel Section D: Setting Bounds for Regression

Statistical Data Analysis In Excel Section D: Setting Bounds for Regression


This activity is presented by Audit Smarter.

Note: It is assumed that you are familiar with the content of the moduleStatistical Data Analysis In Excel Section C: Simple Linear Regression before commencing this module.

Brief Description

This e-learning module explains how to build statistical bounds/tolerances and add benchmarks to your analysis.

Course Module available for 30 days after purchase.

About

Content Description

Auditors live in a world of uncertainty, requiring judgement calls and professional scepticism.

In this module you will learn how to overlay some proven mathematics onto your regression analysis which helps you to eliminate the need for judgement calls by statistically defining outliers.

You will confirm the importance of overlaying statistical bounds/tolerances and benchmarks onto your analysis to determine whether the analysed dataset is within expectations. You will also move your testing into the realms of substantive analytical procedures and be able to speak to your conclusions with mathematical confidence.

Learning Outcomes

At the end of this activity you will be able to: 
• Construct statistical tolerances around your regression analyses. 
• Draw mathematical audit conclusions about the level of your analyses reliability. 
• Understand the value of adding a benchmark against which to compare your analysis.

Benefits

By eliminating the need for judgement calls, your analysis moves into the realms of substantive analytical procedures allowing you to speak to your conclusions with mathematical confidence.

This activity is presented by Audit Smarter.

Course Module available for 30 days after purchase.

EVENT DETAILS


Topic: Audit & Assurance

Sub-Topic: Internal Audit

Format: Self-paced

Proficiency Level: Foundation, Intermediate

CPD: 1.5 hours