Javascript Menu by Deluxe-Menu.com

Stratified attribute sampling

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 analyze a population to be sampled in order to determine the number of samples to be selected. This command prepares a count for each strata. From this information a sample may be determined and then assessed using the saacc command - stratified attribute sampling - assessment).

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 The count or number of samples to be determined using Neyman's allocation method logy
parm2 The precision of the confidence interval, e.g. .95. If amount expressed is larger than 1, then it is divided by 100 to arrive at an amount between 0 and 1.
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