Skip Ribbon Commands
Skip to main content
The Institute of Internal Auditors North AmericaBreadcrumb SeparatorLearning and EventsBreadcrumb SeparatorCoursesBreadcrumb SeparatorData Analysis and Sampling
Course Description Course Outline Bring Us On Site  

Data Analysis and Sampling

Course Description

​Print-friendly Course Description and Outline

In order to perform successful internal audits, you must know how to reduce a large data set down to critical subsets based on risk or importance, which method of sampling is most appropriate for different situations, and be able to estimate and allocate the sample size to get the most information at the lowest cost.

This three-day course provides the opportunity to learn about population analysis — specifically frequency, time series, and correlational analyses. It will also explore the pitfalls facing auditors in selecting the most appropriate sampling methods, calculating and adjusting sample size, and integrating this knowledge into audit planning and reporting.

This course is appropriate for auditors, managers, and executives working in both the public and private sectors.

Course Objectives

  • Summarize introductory terminology and methodology related to Data Analysis and Statistical Sampling.
  • Evaluate shapes of distribution relevant to their important characteristics.
  • Determine which measure of central tendency and variation to use based on the frequency distribution.
  • Evaluate the important differences between a set of data and a chosen benchmark standard using shape, central tendency, and variation.
  • Determine when to use correlation and time series analysis.
  • Employ random sampling techniques.
  • Understand why haphazard sampling should not be used.
  • Identify the criteria for non-random selection techniques.
  • Apply the binomial equation formula to calculate sample size.
  • Employ methods for adjusting sample size.
  • Practice combining results, given a scenario.
  • Describe elements within the report.
  • Balance resources by tracking the various evidence collection methods and tests of controls in the audit program.
Course Duration: 3 day(s)
CPEs Available: 24
Knowledge Level: Intermediate
Field of Study: Auditing
Prerequisites: 
Data Analysis Overview course, Data Sampling course, Defining Populations for Data Analytics course, or equivalent knowledge.
Advance Preparation: 
​None
Delivery Method: On-site Training (Group-Live); Seminar (Group-Live)

Introduction to Data Analysis

  • Defining Data Analysis
  • Data Analysis and Audit Planning
  • Population
  • Random Sample
  • Variables

Population Analysis: Shapes of Frequency Distributions

  • Descriptive Statistics
  • Graphical Presentation
    • Uniform Distribution
    • Skewed Distribution
    • Bimodal Distribution
    • Normal Distribution

Population Analysis: Measures of Central Tendency and Variation

  • Measures of Central Tendency
    • Mode
    • Median
    • Mean
  • Shape of Distribution and Central Tendency
  • Measures of Variability
    • Range
    • Quartile Deviation
    • Standard Deviation

Population Analysis: Comparison to Benchmarks

  • Practice Advisory 2320-1
  • IPPF Standard 2320
  • Benchmarking
  • Recalculations
  • Non-Random Selection

Case Study Using Frequency Distributions

Population Analysis: Time Series and Correlational Analysis

  • Time Series Analysis
  • Case Study Using Time Series Analysis
  • Correlational Analysis

Case Study Using Correlations

Random Sampling

  • The Randomness Assumption
  • Types of Random Sampling
    • Simple Random Sampling
    • Stratified Random Sampling
    • Haphazard Sampling

Non-Random Selection

  • Defining Non-Random Selection
  • Fraud Red Flags
  • How to Perform Non-Random Selection
  • The Credibility Obstacle
  • Case Study Using Non-Random Selection

Calculating Sample Size

  • Drivers of Sample Size
  • Binomial Equation
  • Confidence Level
  • Expected Error Rate
  • Precision
  • Pilot Studies

Adjustments to Sample Size

  • Population Size
  • Resource Constraints
  • Strength of Generalization
  • Bias and Ethics

Knowledge Check

  • Practical Exercises in Calculating Sample Size, Adjusting Sample Size, and Interpreting Results

Combining Results

  • Nomenclature
  • Combining Error Rates
  • Other Weighted Averages
  • Combining Non-Random Data
  • Generalization and Extrapolation
  • Statistical Tests

Reporting

  • Mock Report
  • What to Include

Audit Program

  • Why Do an Audit Program?
  • Audit Program Example
  • Sortable Audit Program
  • Audit Program vs. Audit Sampling

Most courses can be delivered through on-site training. You might be surprised that the organization leading the profession is just as committed to the delivery of affordable training.

Contact us by calling +1-407-937-1388 or send an e-mail to GetTraining@theiia.org.

LocationsDates
Micro Tek Training Facility - New York
New York, NY
Details and pricing
April 11-13,
2018
Micro Tek Training Facility- San Francisco, CA (New location)
San Francisco, CA
Details and pricing
May 16-18,
2018
Planet Hollywood Resort & Casino Las Vegas
Las Vegas, NV
Details and pricing
June 13-15,
2018
Embassy Suites - Lake Buena Vista
Orlando, FL
Details and pricing
December 5-7,
2018