Statistical Data Analysis in Excel Section C: Simple Linear Regression - eLearning
This activity is presented by Audit Smarter.
To confirm the member price please use the discount code camember5pc.
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.
NZ Members will be charged in Australian Dollars (AUD). The price of this e-learning module is $189AUD.
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.
This module arms you with the knowledge and skills to apply regression analysis in an audit context, identify outliers and target your testing.
Assessments required to complete:
Nine short quiz questions
Topic: Audit & Assurance, Reporting
Sub-Topic: Financial Reporting, Financial Statement Audit
Proficiency Level: Foundation, Intermediate
CPD: Upto 2 hours