Statistical Data Analysis In Excel Section C: Simple Linear Regression
This e-learning module will build your understanding of how to run regression analysis and show you how to apply the concepts in an audit context.
Course Module available for 30 days after purchase.
Regression is based on the concept of analysing plausible relationships in data. So it is of real benefit to you since business data is full of logical and plausible relationships.
In this module you will learn how this analytical procedure is an effective audit tool by quickly and efficiently identifying outliers, targeting your testing and saving you audit time and costs.
You will develop your skills and confidence to run regression in Microsoft Excel and learn how to apply the concepts in an audit context, enabling you to run complex analytics without the need for purchasing expensive audit software.
At the end of this activity you will be able to:
- Run linear regression via the Chart Wizard in Microsoft Excel.
- Identify and label outliers.
- Run the maths for regression in Microsoft Excel’s Analysis ToolPak.
- Test your data for representativeness.
- Perform sensitivity analysis and learn how to isolate outliers.
BenefitsThis module arms you with the knowledge and skills to apply regression analysis in an audit context, identify outliers and target your testing.
Topic: Audit & Assurance
Sub-Topic: Internal Audit
Proficiency Level: Foundation, Intermediate
CPD: Upto 2 hours