How can I use the tool to analyze and make a stratified sample from a large excel data?

Question

I have an excel financial data of a company for auditing, how can I use the tool to analyze, like duplicate finding and others? also, I want to make a stratified sample to get sample based on some information, how can I do that?

Answer 1

To answer your question about using the ESKORT Computer Audit (SESAM) tool for Windows to analyze Excel data:

To analyze your financial Excel data using ESKORT Computer Audit (SESAM), you typically need to follow these steps:

1. Import the Data: Open SESAM and import your Excel file. This usually involves selecting the file and specifying which worksheet or range of cells to analyze.

2. Analyzing Data:

   • Duplicate Finding: Use the tool's duplicate detection feature to identify and manage duplicates within your data. This feature will help you locate entries that are repeated in your dataset.
   • Other Analysis: SESAM may also offer other functionalities such as identifying outliers, calculating statistics, or verifying data integrity based on its specific feature set. Refer to the tool's documentation for detailed functionalities.

3. Stratified Sampling: To create a stratified sample:

   • Determine the strata based on the information you want to segment your data by (e.g., department, transaction type).
   • Use SESAM's sampling functionality to specify the strata and the sample size or percentage you wish to draw from each stratum. The tool should allow you to set these parameters.
   • Generate and export the stratified sample, which you can then analyze further or integrate into your audit processes.

It's important to refer to the specific user manual or help resources for ESKORT Computer Audit (SESAM) as the exact steps and capabilities can vary depending on the version you are using. If you don't have access to adequate documentation, contacting their support might provide additional guidance.