When making sample selections from a population in Excel, auditors may be inclined to use the "=RAND()" formula without understanding the broader implications of this approach. For instance, what if you are testing approvals on purchase orders. Under this example, you want to validate that the approver(s) have an appropriate authorization. The "=RAND()" approach will … Continue reading Sample Selections