Nt1330 Unit 3 Quiz
A.
1. The ACL Benford command counts the times each digit or digit combination occurs in a data set and makes a comparison between actual count and expected count. The output of the command is showed in a graph and includes Z-statistic for each count to help evaluate the significance of deviation between actual and expected counts.
2. The use of Benford command provides auditors and other data analysts caution on that there are possible anomalies in large data sets which deserve further analysis.
3. The Benford command is activated by benford formula. Users can select Analyze from the menu bar and choose Perform Benford Analysis to display the Benford dialog box.
B.
1. These Characteristics are following: comprised of similar sized values for similar phenomena; without built-in …show more content…
to set parameters for the Last Two Digit test and for creating suspicious output databases.
6) Select the required tests
7) Create a result output
3. These fields are contained in the database: First Digit, First Two Digits, First Three Digits, and Second Digit Last Two Digits, Second Order and Summation Suspicious data, upper and lower boundaries, mean absolute deviation and parameters.
C.
1. Payroll fraud is usually paying a fictitious or ghost employee in a salary system automatically. One way is making electronic payments into bank accounts where no cheques need to be collected. Another way is not removing leavers (terminations), but changing their pay into another bank account, or submitting excessive overtime, expense, or allowance claims.
2. In most cases payroll frauds are found by accident, perhaps a query by the revenue authorities or a colleague who notices something suspicious.
3. Payroll fraud tests include following:
A. Duplicates
Test for duplicate employees on the entire payroll file, using the employees' Social Insurance, Social Security or National Insurance Numbers as a unique employee identifier.
B. Check for duplicate bank accounts.
1. The ACL Benford command counts the times each digit or digit combination occurs in a data set and makes a comparison between actual count and expected count. The output of the command is showed in a graph and includes Z-statistic for each count to help evaluate the significance of deviation between actual and expected counts.
2. The use of Benford command provides auditors and other data analysts caution on that there are possible anomalies in large data sets which deserve further analysis.
3. The Benford command is activated by benford formula. Users can select Analyze from the menu bar and choose Perform Benford Analysis to display the Benford dialog box.
B.
1. These Characteristics are following: comprised of similar sized values for similar phenomena; without built-in …show more content…
to set parameters for the Last Two Digit test and for creating suspicious output databases.
6) Select the required tests
7) Create a result output
3. These fields are contained in the database: First Digit, First Two Digits, First Three Digits, and Second Digit Last Two Digits, Second Order and Summation Suspicious data, upper and lower boundaries, mean absolute deviation and parameters.
C.
1. Payroll fraud is usually paying a fictitious or ghost employee in a salary system automatically. One way is making electronic payments into bank accounts where no cheques need to be collected. Another way is not removing leavers (terminations), but changing their pay into another bank account, or submitting excessive overtime, expense, or allowance claims.
2. In most cases payroll frauds are found by accident, perhaps a query by the revenue authorities or a colleague who notices something suspicious.
3. Payroll fraud tests include following:
A. Duplicates
Test for duplicate employees on the entire payroll file, using the employees' Social Insurance, Social Security or National Insurance Numbers as a unique employee identifier.
B. Check for duplicate bank accounts.