Test the "Stratification Table Sufficiency"
To stratify a database we need a stratification table. Using this tool the stratification table considers all possible cases a given field may take. It examines the database and shows all values not included in the stratification table
The following example shows a database and an incomplete stratification table
Click the corresponding button to activate the Test Stratification table sufficiency function.
Choose the field to be evaluated and select the stratification table.
Finally, click on the Testing… button
A new spreadsheet with the report of the test carried out will be created, as shown in the illustration below.
As you can see, cell C7 - to name just one - contains the value 87. This value was missing in the stratification table, which only includes categories up to 70.
Once we have analyzed our data using this tool, we can modify as follows:
Now, you will be able to carry out a complete stratification of the database
Categorize Excel Data Secure Payment Options
Test the "stratification table sufficiency"
Stratification 1 to 1
- Split field - By groups
- Split field - By date
Export sheets as...
Freeze | divide panes
Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Excel Add-ins Index & Excel Training Index & Excel Templates Index & Neural Network Software Index Trading Software Index & Charting Software Index Or, All Software
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft