On Mon, 2007-01-10 at 19:06 -0700, Johnny Stork wrote: > Spreadsheets are a good starting point since you can do your organizing > and data cleaning in a familiar interface. Once you collect, clean and > organize (grouping etc) your daya you can then export as CSV to import > into any stats package, or, you can do some basic stats in Excel (Open > Office Calc). I am also guessing you are only looking at doing some > descriptive stats (counts, means, variance, sd etc) and so these are > easoly done in Excel. You can also do many different basic means tests > (is this mean/average statistically larger than the other mean), in > Excel (T-Tests)
In regards to working with OpenOffice.org Calc, I am unsure about how I would work with non-numerical values. For example, if I have one column that records User ID's and I want to categorize the number/percentage of users in various categories [ie. one-time posters (1 post), light posters (2-5 posts), all the way to heavy posters (80+ posts)] and then correlate this data with another column that records ideology of the posts, how would I go about doing this? Jesse _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
