Friday, 21 May 2010

Still playing with the data.

I'm still crunching on all those numbers and will be for a while, I guess. Next item coming up will be to handle all the samples again: Spooling them back into cops from their skein-state for better handling and easier storage and measuring thread diameter as well as making an "inspection card" for each of the samples. These are cards in a contrasting colour to the thread, where the thread is wound on in parallel lines - that gives a quite good first impression on how even the thread is.

And for now, I think I need a better graph program than ol' MS Excel. Any suggestions?

2 comments:

A Life Long Scholar said...

I still use Excel for most things, and then copy the graph as a picture and paste it into a drawing program to clean it up for publications. There are a number of "add-ons" that make it useable, some of which will get it to plot data with error bars, others while permit triangle graphs. I could give you URL's for some Excel add-ons for geologists, but that might not be as helpful as your doing a search for ones better suited to the kind of data you are dealing with.

Now, if you want power to do any kind of calculations and graphs, try something like Mathmatica--it is really hard to set up the formulas and files in the first place, but once they are working it is wonderful...

Phiala said...

Ew. Excel both makes ugly graphs and is known to have all kinds of pernicious statistical problems. MS has known some of their algorithms are wrong for years...

I use R (www.r-project.org) for data analysis and graphing. It is very powerful and not easy to get started with because of that, but with new addons like R-Commander that provide menus for common tasks it has gotten to be quite straightforward, no worse than any other software package. And it's both free and open source. :)