Hi Nick, >>> I guess a work around would be using SQL to create a new table of frequency counts within specified intervals, then use a "column" graph to plot the results - but the SQL to do that is well beyond me!
The SQL to create binned data isn't too difficult. The following query creates a table with ranges 0-<10, 10-<20, 20-<30 etc based on column ColN: Select ColN \ 10 * 10 "Binned_data", Count(*) from My_Source_Table group by "Binned_data" order by "Binned_data" into "My_Binned_Table" "Binned_data" is a derived variable used for grouping and sorting based on MapInfo's integer division operator "\", a shorter version of int(ColN / 10) * 10. Ian >>> "Nick McWilliam (APU)" <[EMAIL PROTECTED]> 29/11/2005 17:10:14 >>> To plot frequency distribution graphs, I'm using: MapInfo 8.0 > Window > New Graph Window > Histogram >From the reference manual: "Histograms show frequency distribution. This graph type groups your values into ranges based on value. It measures the number of data values that fall within each range. The ranges are displayed as bars." The question is - how do I determine the _ranges_ that are used for counting frequencies? I can't find any clue as to how MapInfo does this. The reference manual (above) isn't exactly specific, "ranges [are] based on value". Ideally, I'd like to be able to specifiy the ranges (bins) that are used (in the same way as you can specify the ranges for a "Ranges" thematic map in MI). I guess a work around would be using SQL to create a new table of frequency counts within specified intervals, then use a "column" graph to plot the results - but the SQL to do that is well beyond me! Thanks in advance for any help - Nick. _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
