There are two primary methods to classify amounts:
- Stratified using numeric ranges
- Classified according to a date value.
The purpose of the stratified variable sampling command is to assess a population which was sampled in order to estimate a total value for the variable being sampled. This command prepares an estimate for each strata, as well as an overall estimate for the population. Based upon this information a determination can be made as to whether further sampling is desirable.
An example of the report is available.
To perform such a test and have the results available in electronic work paper format, the following processing information is explained below:
|
|
| Description | Value |
|---|
| Select | Specify 'OK' to have this row processed, otherwise it will be skipped |
| Data Source | Specify the name of the Excel workbook, including directory or the name of the Access database which has the data to be analyzed |
| Command Name |
svpop |
| Command Description |
Count the number of items in the population by strata. |
| Table | Must enter either a sheet name followed by $ or else enter an Access table name |
| Where | An optional row selection statement may be made to narrow the analysis to just certain rows |
| Column |
The name of the strata column must be specified here |
| Column String |
Must be a series of three column names as follows: column with variable amount to be tested, name of strata column, name of column which contains a selection indicator, i.e. whether the row has been selected for sampling. |
| Parm1 |
The count of samples to be prepared using Neyman's allocation algorithm. |
| parm2 | This command does not accept a second parameter |
| Theme | A theme, such as summer, fall, winter, spring, pink, orange, green etc |
| Title | A chart title, if desired, may be specified here |
| Example Chart |
|
Return to electronic work paper home page
|
