IDEA 10: Random Sampling
IDEA 10: Random Sampling
In this section we’re going to look at how to pull a random sample from your data.
First, ensure the Customer Database is open in the database window and that Data is selected in the Properties window. Click the Analysis Tab, then select Random in the Sample Group. This is the Random Record Sampling Dialog box.
Enter the number of records you want to select – in this case, I want 10 - and accept the Random number seed value provided by IDEA. This number is used by IDEA as a starting point for the algorithm to calculate the random numbers. If the sample needs to be extended then entering the same random number seed but with a larger sample size produces the same original selection plus the required additional records.
Accept the default values in the Starting record number to select and the Ending record number to select fields. Leave the Allow duplicate records checkbox empty.
Click Fields to pick and choose which fields appear in the output database. Values highlighted in blue are selected. To remove an entry, click it.
Click OK to return to the Random Record Sampling dialog box. Provide a name for the new database you are creating. I’ll call mine Sample of Customers. Click OK to run the sampling task.
The new Sample of Customers database is now the active database and is shown as a child of the Customer Database. There is also a new field been added called SAM_RECNO which stands for Sample Record Number. This is the record number in the master database. In other words, record number 1 is record number x in the Customer database.
To close the Sample of Customers database, click the x in the database tab.
SUBSCRIBE: http://bit.ly/29BfMuV
About CaseWare Analytics:
CaseWare Analytics is home to IDEA® Data Analysis and CaseWare Monitor. Our software solutions are built on a foundation of industry best practices and domain expertise enabling audit, compliance and finance professionals to assess risk, accumulate audit evidence, uncover trends, identify issues and provide the necessary intelligence to make informed decisions, ensure compliance and improve business processes.
WEBSITE: http://bit.ly/1fbul6J
BLOG: http://bit.ly/1i7s1vu
TWITTER: http://bit.ly/29BTBan
Sur cette page du site, vous pouvez voir la vidéo en ligne IDEA 10: Random Sampling durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Caseware IDEA 29 avril 2016, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 45,715 fois et il a aimé like téléspectateurs. Bon visionnage!
