Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Test the "Stratification Table Sufficiency"

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Back to Categorizing Excel Data Start

Test the"stratification table sufficiency"  
To stratify a database we need a stratification table. But what if the stratification table is not well designed? That is, what if the stratification
table does not consider all possible cases a given field may take?
Well, stratification would be carried out, anyway --but not right.
Thinking of this problem the Test the "stratification table sufficiency" function was developed, which examines the database and shows
in a column all values not included in the stratification table
Then, you would have to add any missing categories to the stratification table; only then database stratification could be done right.
Consider this simple example: We have a database and an incomplete stratification table (deliberately so created, naturally)
Click the corresponding button to active 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.



.Then, after knowing the cases not included in the stratification table, we proceed to modify them, as follows:



Now, you will be able to carry out a complete stratification of the database

Back to Categorizing Excel Data Start

Categorize Excel Data     Secure Payment Options

1 $59.95 USD
2 - 5 Licenses $50.95 USD
6 - 9 Licenses $44.95 USD
10+ Licenses $29.95 USD

Other Features

Extract unique cases
Test the "stratification table sufficiency"
Stratification 1 to 1
Categorize database
Time stratification
Split field
- Split field - By groups
- Split field - By date
Export sheets as...
Sheets manager
Workbooks manager
Freeze | divide panes
Toggle settings


Free Choice of Complete Excel Training Course OR OzGrid 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.

Software Categories Search Software

Excel Add-ins || Excel Training || Excel Templates || Employee Scheduling Software || Excel Password Recovery and Access & Word etc|| Excel Recovery and Access & Word etc || Financial Software || Financial Calculators || Conversion Software || Construction Estimating Software || Drilling Software || Real Estate Investment Software || Time Management Software || Database Software || Neural Network Software || Trading Software || Charting Software || Windows & Internet Software || Barcodes Fonts, ActiveX, Labels and DLL's || Code Printing Software || Outlook Add-ins


Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us