Other Commands
Other Commands Benford's Law Fraud detectionDownloads First digits lawSite Map
Home Page | Population | Sampling | Fraud | Other | Tutorial | Macros
Other Commands

Command Overview - Other

 

 
Command Description
Age amounts
Execute a series of commands from a worksheet
List the five smallest values on the current selected worksheet range
Perform calculations based upon column values
Compute Chi Square Value for the selected range, show degrees of freedom and critical value at 95%
Clear text from a worksheet
The control facility for handling repetitive command line arguments ("set" command)
Prepare a table of cross tabulations
Extract data meeting specified criteria
Check for Gaps in Numerical Sequences (e.g. check numbers)
Set colors for charts displayed
Identify dates falling on federal holidays
Compare Financial Statements
Load historical commands from registry
Logging facility (text of commands entered, and the time)
Check Validity of Credit Card Numbers using the LUHN-10 algorithm
List the sum of counts and amounts for zero, positive and negative values within the current selected range
Load worksheet using database query
Test for round numbers
Save commands from WorkSheet to the Registry
Set a command line argument (such as a file name or column name)
Specify a worksheet range to be processed (for batch processing)
Show current settings
List the five largest values within the current selected range
Chart data points from a series
Trend analysis of amounts over time, using "best fit" linear regression
Remove specification of a worksheet range to be processed (for batch processing)
Display a count of each week day for the selected range

Main Page

Complete Auditor resources
Links | Privacy Policy | FAQ | Downloads | Trademarks
Web Page last updated on 10-13-2007
© EZ-R Stats, LLC 2005-2007