EZ-Quant Version Release Notes
1. Statistical Sampling
- Upgraded functionality for sampling from Access databases, substantially improving performance with large data sets and eliminating conditions that caused occasional cut-off of listing of sample items.
- Minor enhancement in reporting of dollar unit sample evaluation to more clearly show user-specified confidence level and confidence interval type (one sided vs. two sided).
- Minor enhancement to the export of random number generation report to Excel, ensuring that the numbers themselves are exported as numbers and not as text.
2. Regression, Improvement Curves
- Revised to eliminate the use of an ActiveX object reported to possess, in its older versions, certain security vulnerabilities.
1. Statistical Sampling:
- Upgraded to enable import of sampling universes from Access 2007 and 2010 data bases. In the past, users had needed first to convert these data bases to the 2003 format.
- Resolved an issue related to links between spreadsheets that occurred when saving an EZ-Quant graph built in conjunction with Excel 2010.
3. Improvement Curves
- Enhanced Graphing Capabilities: Excel's charting capabilities are now used to produce graphs of lot data, improvement curves and projections. Similar to that available for EZ-Quant regression, the graphing feature has options within EZ-Quant to assist the auditor in customizing its contents and appearance. The graph may also be exported to Excel where it will appear as an Excel chart and may be further customized using the full capabilities of Excel charting.
This revision includes several significant enhancements and corrections to the EZ Quant applications, including:
1. Statistical Sampling:
- Enhancement to the Variable Sampling Projection screen to display the achieved precision percentage.
- Variable Sampling Projection screen (and related Excel output) modified to clearly differentiate between high dollar and sampling strata.
- Revision to correct a problem with reading an Excel sampling universe when the contents of a descriptive cell contained an error condition.
- Minor revisions to the sample plan screens and notification messages to improve overall software operation.
- Enhanced Graphing Capabilities - uses Excel's charting capabilities to produce a more robust, professional graph of the regression and projection(s).
- Inclusion of Two Curvilinear Equations.
- Inclusion of the Adjusted r2 Measure of Fit.
- Updated Formatting of Excel Output - provides enhanced appearance of statistical reports that are exported to Excel.
- Add capability to export regression reports and graphs to a single Excel workbook.
This revision repairs non-critical errors concerning null values in descriptive fields while reading an Access database and now alerts the user to the existence of empty descriptive fields in the universe file for all import file types (Access, Excel, text). It also repairs an error that occurred in some instances of exporting the sampling plan to Word.
In the sampling module, EZ-Quant now features:
- the ability to read audit universes directly from Excel worksheets
- the ability to direct all EZ-Quant Excel-formatted outputs to individual worksheets in a single Excel workbook
Regression and improvement curve modules have not been altered.
When sampling from an Access data base, the data base can now be in the 97 format, the 2000 format, or the 2002 format. Before, it was necessary for the user to convert data bases from the 2000 or 2002 formats to the 97 format in order for the database to be compatible with EZ-Quant.
In some cases of dollar unit sampling from a particularly small sampling universe, with version 1.0.1 a high dollar item might be erroneously listed as a sample item, masking a sample item. This problem has been resolved.
In the regression module, the table showing a comparison of actual dependent variable values with their counterparts read from the regression line was blank when sent to the printer. This has been remedied in version 1.0.2.
References to Windows 95 have been deleted. Versions 1.0.1 and 1.0.2 are compatible with Windows 2000 and Windows XP. References to the Special Programs Branch of the Technical Audit Services Division have been changed to that branch's new name, the Technical Support Branch.