Statistical Data Analysis In Excel Section F: Curve Linear Regression
Note: it is assumed that you are familiar with the content of the modules Statistical Data Analysis In Excel Section C: Simple Linear Regression, Statistical 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.
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.
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.
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
BenefitsUnderstanding 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.
Topic: Audit & Assurance
Sub-Topic: Internal Audit
Proficiency Level: Foundation, Intermediate
CPD: Upto 0.75 hours