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> 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. However, when I put the dataset into Excel and use its statistical functions, the results are slightly different. Further investigation has shown that there are a few ways of calculating quartiles but this is where I start getting out of my depth. Does anyone know: a) Is there any graphing software compatible with CF which can create boxplots from raw data? I've looked at ChartFX Statistical but it's only available for .NET. b) Is there software or functions around which can quickly and accurately calculate quartiles? I'm using CF5 by the way. Thanks, Ryan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208973 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
