EVALUATE command

Concept Information

Evaluating errors in a record sample

Evaluating errors in a monetary unit sample

For record sampling or monetary unit sampling, projects errors found in sampled data to the entire population, and calculates upper limits on deviation rate, or misstatement amount.

Syntax

EVALUATE RECORD CONFIDENCE confidence_level SIZE sample_size ERRORLIMIT number_of_errors <TO {SCREEN|filename}>

Parameters

Note

Do not include thousands separators, or percentage signs, when you specify values.

Name Description
RECORD

Evaluate errors found in a record sample.
CONFIDENCE confidence_level

The same confidence level that you specified when you calculated the sample size.
SIZE sample_size

The number of records in the sample.

Note

Specify the actual sample size as drawn, which might differ from the sample size initially calculated by Analytics.
ERRORLIMIT number_of_errors

The total number of errors, or deviations, that you found in the sample.
TO SCREEN | filename

The location to send the results of the command to:

  • SCREEN displays the results in the Analytics display area

    Tip

    You can click any linked result value in the display area to drill down to the associated record or records in the source table.

  • filename saves the results to a file

    Specify filename as a quoted string with the appropriate file extension. For example: TO "Output.TXT"

    By default, the file is saved to the folder containing the Analytics project.

    Use either an absolute or relative file path to save the file to a different, existing folder:

    • TO "C:\Output.TXT"
    • TO "Results\Output.TXT"

Analytics output variables

Name Contains
MLEn

The Upper error limit frequency rate (computed upper deviation rate) calculated by the command.

Examples

Project errors found in the sampled data to the entire population

You have completed your testing of the sampled data and recorded the control deviations you found. You can now project the errors you found to the entire population.

The example below projects two errors found in the sampled data to the entire population, and calculates an upper error limit frequency rate (computed upper deviation rate) of 6.63%.

EVALUATE RECORD CONFIDENCE 95 SIZE 95 ERRORLIMIT 2 TO SCREEN

For a detailed explanation of how Analytics calculates values when evaluating errors, see Evaluating errors in a record sample.

Remarks

For more information about how this command works, see Evaluating errors in a record sample.

Syntax

EVALUATE MONETARY CONFIDENCE confidence_level <ERRORLIMIT book_value, misstatement_amount <,...n>> INTERVAL interval_value <TO {SCREEN|filename}>

Parameters

Note

Do not include thousands separators, or percentage signs, when you specify values.

Name Description
MONETARY

Evaluate errors found in a monetary unit sample.
CONFIDENCE confidence_level

The same confidence level that you specified when you calculated the sample size.
ERRORLIMIT book_value,misstatement_amount

All misstatement errors that you found in the sample.

Specify the book value of the amount and the misstatement amount, separated by a comma. For example, if an amount has a book value of $1,000 and an audit value of $930, specify 1000,70.

Specify overstatements as positive amounts, and understatements as negative amounts. For example, if an amount has a book value of $1,250 and an audit value of $1,450, specify 1250,-200.

Separate multiple book_value, misstatement_amount pairs with a comma:

1000,70,1250,-200
INTERVAL interval_value

The interval value that you used when you drew the sample.

Note

The interval value that you used might differ from the interval value initially calculated by Analytics.
TO SCREEN | filename

The location to send the results of the command to:

  • SCREEN displays the results in the Analytics display area

    Tip

    You can click any linked result value in the display area to drill down to the associated record or records in the source table.

  • filename saves the results to a file

    Specify filename as a quoted string with the appropriate file extension. For example: TO "Output.TXT"

    By default, the file is saved to the folder containing the Analytics project.

    Use either an absolute or relative file path to save the file to a different, existing folder:

    • TO "C:\Output.TXT"
    • TO "Results\Output.TXT"

Analytics output variables

Name Contains
MLEn

The Most Likely Error amount (projected misstatement) calculated by the command.
UELn

The Upper Error Limit amount (upper misstatement limit) calculated by the command.

Examples

Project errors found in the sampled data to the entire population

You have completed your testing of the sampled data and recorded the misstatements you found. You can now project the errors you found to the entire population.

The example below projects three errors found in the sampled data to the entire population, and calculates several values, including:

  • Basic Precision the basic allowance for sampling risk (18,850.00)
  • Most Likely Error the projected misstatement amount for the population (1,201.69)
  • Upper Error Limit the upper misstatement limit for the population (22,624.32)
EVALUATE MONETARY CONFIDENCE 95 ERRORLIMIT 1000,70,1250,-200,3200,900 INTERVAL 6283.33 TO SCREEN

For a detailed explanation of how Analytics calculates values when evaluating errors, see Evaluating errors in a monetary unit sample.

Remarks

For more information about how this command works, see Evaluating errors in a monetary unit sample.