Javascript Menu by Deluxe-Menu.com

Stratified attribute sampling - assessment

Command processing parameters

There are two primary methods to classify amounts:

  1. Stratified using numeric ranges
  2. Classified according to a date value.

The purpose of the stratified attribute sampling command is to assess a population which was sampled in order to estimate an occurrence rate for the attribute 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:

DescriptionValue
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 sapop
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 attribute 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 N/A
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