• Home
  • Statistical Data Analysis In Excel Section C: Simple Linear Regression

Statistical Data Analysis In Excel Section C: Simple Linear Regression


This activity is presented by Audit Smarter.


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.

About

Content Description

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.

Learning Outcomes

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.

Benefits

This module arms you with the knowledge and skills to apply regression analysis in an audit context, identify outliers and target your testing.

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: 2 hours