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

Stratification 1 to 1

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

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


Back to Categorizing Excel Data Start

Stratification 1 to 1  
Stratification 1 to 1 was created to deal with the frequent need of stratifying a database, but stating a 1-to-1 correspondence
(note: this is not for value intervals --in that case, use Categorize database)
Analyze the following example:
Say you have a database and a stratification table.
From the database, choose the Category column, as the stratification table was created based on this field.



The result of the operation is shown below:



If in addition you would have wanted to create a pivot table with the results, you only would have to check the corresponding
checkbox, and choose the column to be analyzed and the desired mathematical operation.



The result is shown in the following picture. You may modify the pivot table created, by dragging and dropping the appropriate fields.


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.

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