Sorry, should have said I'm using MS SQL 2000. I'm pulling data from survey results which will have a value in the range 1 - 5 so if I have 50 surveys, I'll want to find the max, min, upper and lower quartiles and median of the dataset for each individual quesion. i.e. 1 question = 1 box in the graphical output. Failing that, is there any way I can get Excel to generate these charts on the fly if I dump the data into a spreadsheet (automatically on the server)? At the end of the day the client wants a boxplot to be generated and isn't too concerned about how we go about getting it, as long as he doesn't have to do any work! Thanks, Ryan
On 6/8/05, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > Ryan Edgar wrote: > > I have a client who wants some data represented by boxplots. > > I've been unable to find software for CF which will automatically > calculate > > and graph the required information (upper quartile, lower quartile, > median) > > from raw data passed, so I need to find a way of performing these > > calculations myself and pass them to the graph software. > > I've got a Median function from cflib.org <http://cflib.org> < > http://cflib.org> but where > > things fall apart slightly is in the calculation of the upper and lower > > quartiles. I had been taught that to calculate these, you find the > average > > of the top and bottom half of the dataset respectively. > > I have been taught that the top quartile is the 25% of data > points with the highest values :) > > Where do you get these data from? If you get them from a > database, what native functions does that database have for doing > statistics? For instance, PostgreSQL has the R language for > statistical computing as a loadable module and you can use it as > a procedural language. > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209040 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54