• Home
  • Statistical Data Analysis In Excel Section F: Curve Linear Regression

Statistical Data Analysis In Excel Section F: Curve Linear Regression


This activity is presented by Audit Smarter.

Note: it is assumed that you are familiar with the content of the modules Statistical Data Analysis In Excel Section C: Simple Linear RegressionStatistical Data Analysis In Excel Section D: Setting Bounds for Regression and Statistical Data Analysis In Excel Section E: Noise Due to Sub-Populations and Time Lag before commencing this module.

Brief Description

This e-learning module explains how to run and interpret regression analysis when your data produces a curve-linear relationship on your chart.

Course Module available for 30 days after purchase.

About

Content Description

In this module you will explore the complexity where your data is not linear, i.e. where the data does not plot as a straight line when you run regression.

You will learn how to run and interpret regression where relationships in your audit data result in a curved line on your chart. Also learn how to recognise non-linear data patterns and the trendline that fits the data best.

Learning Outcomes

At the end of this activity you will be able to: 
• Plot and recognise non-linear data patterns, such as power, log, exponential and polynomial curves. 
• Learn how to determine which curve trendline fits the data best. 
• Differentiate linear data with a negative slope

Benefits

Understanding that much data in the business world is highly seasonal, and that peaks and troughs in demand will be reflected in your data, knowing how to recognise curve-linear data patterns and plot the trend line that fits the data best will help you to maximise your use of regression as an audit tool.

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