Macro - Sample Size

Sub RunSS()
'
' sample size and attribute comands
'
' RequiredConfidence - the confidence level as a percentage
' this will range from .10 - .99999, often .95
' PopulationSize - size of the population if known, otherwise 0
' ExpectedErrorrate - use .50 if rate is unknown
' RequiredPrecision - the desired precision to achieve
'
Dim oEZ As New cEZ
Dim lSize As Long
oEZ.SS _
RequiredConfidence:=0.95, _
PopulationSize:=10000, _
ExpectedErrorRate:=0.2, _
RequiredPrecision:=0.1

' in order to obtain the size within Excel,
' call the function as follows
lSize = oEZ.SS(0.95, 10000, 0.1, 0.2)

'MsgBox "required sample size is " & lSize
Set oEZ = Nothing

End Sub

Main Page

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

	Macro - Sample Size
	Benford's Law Downloads Site Map