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.
2. Regression
- 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.
Original Release
