Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Categorize Excel Tables

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


Excel: Test the "Stratification Table Sufficiency" 

BUY |Categorizing Excel Data Start

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

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

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

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

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.

See Also:

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

Microsoft Excel - From Beginner to Expert in 6 Hours

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

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