How do divide a column of data ranging from 100 to 10,000 into Quartiles and Percentiles? I don't see a function for this or something called "TILES"
RobbThis message has been edited. Last edited by: FP Mod Chuck,
I've never tried it but this might be helpful.
WebFOCUS 8204, Unix, Windows
An example of quartiles in code which creates the quartiles based on the DOLLARS field:
TABLE FILE ibisamp/ggsales PRINT SEQ_NO BY DOLLARS IN-GROUPS-OF 4 TILES ENDApp Studio Report Canvas supports this too:
Sort on the DOLLARS field, right-click it, and select Options....
In the pop-up window, select the Grouping tab and make your choices for the tiling you want.
I did not see any of these options in InfoAssist. I was able to get InfoAssist to produce quartiles by using hold files and computes. If you're interested, I can provide the code that InfoAssist generated for this.
|Powered by Social Strata|