I'm looking for good ideas again I'm afraid.
I have an array of objects that can be best described as a set of categories with an associated value. Something along the lines of [Cat1:String, Cat2:String, Cat3:String, Value:Float]. The general idea is that the user would select one of the categories and then the project would calculate a set of statistics across that category. For example the categories could be "Age", "Sex", "Height" and the Value may be, say, weight. What I am trying to do is develop a generic module/class accepting the input array that will return another array of objects being the statistical analysis of the input array across the specified category. The statics are fairly basic (at this stage) being the average for each category, the sample standard deviation and the sample standard error. Generally the input array length is reasonably short, ~30 to ~300 items. Also the category domains are demonstrably short, between 3 and ~10 identities. I could (and have done) use the database (postgresql) statistics functions and re-query the entire dataset given the user category selection. However, the time to execute this is unacceptably slow (the full dataset is over 3,000,000 rows). Furthermore, I would have to devise a generic way to build the specific query required each time. Another way could be to develop an interface to r or something but I am hesitant to embark on that path given my knowledge of stats libraries like that. So, just looking for a "good idea". regards Bruce ------------------------------------------------------------------------------ Get 100% visibility into Java/.NET code with AppDynamics Lite! It's a free troubleshooting tool designed for production. Get down to code-level detail for bottlenecks, with <2% overhead. Download for free and get started troubleshooting in minutes. http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user