Macro - Stratify Data

Sub RunStratify()

'
' stratify the population using the following parameters
'
' Infile - name of the file to be checked
' Column - name of the column value to be checked
' this will be a numeric column
' Report - where the report is to be written
' Strata - the bins for the strata - must be in ascending order
' Note that the sequence of parameters does not matter
'
Dim oEZ As New cEZ
oEZ.Stratify _
Infile:=BASEDIR & "clmdenbp.txt", _
Column:="paidamt", _
Report:=BASEDIR & "clmdenbp.str", _
Strata:="0 10 20 30 40 50 60 70 100"

LoadSheet _
ToSheet:="$Debug", _
Infile:=BASEDIR & "clmdenbp.str"

Set oEZ = Nothing

End Sub

Main Page

Complete Auditor resources
Links \| Privacy Policy \| FAQ \| Downloads \| Trademarks

	Macro - Stratify Data
	Benford's Law Downloads Site Map