Whether or not we like EXCEL using for graphing and statistics, reality is that almost all people (business, academic, government, NGO, etc) use EXCEL for those purposes. Even those who use R regularly, use EXCEL for data entry and simple summary statistics. (How many of R users directly input data to R using "data <- c()"? ) I also know that many my coworkers took stats using R, but now most of them use EXCEL for data summary, graphing, and simple stats. In today's work environment, all graduating students must have fluency in EXCEL or similar spreadsheet programs.
For this reason, I use EXCEL for my introductory stats class. Even they forget all stats they were taught, they will remember how to use EXCEL, which will be their benefit for job. If EXCEL is costly, then Open Office Calc is a better alternative. Almost similar (EXCEL 2003) interface and functionality, and free. Yes, some of EXCEL Stats calculation is very questionable quality in precisions, but many ecologists often ignore fundamental statistical assumptions: unbiased sampling, assurance of samples representing a population of interest, valid replications, no measurement errors, assurance of independent and identically distributed random variables, etc. Ignoring those issues will result in wrong estimates, even using R or other best stats programs. Toshihide "Hamachan" Hamazaki, 濱崎俊秀PhD Alaska Department of Fish and Game Diivision of Commercial Fisheries 333 Raspberry Rd. Anchorage, AK 99518 Phone: (907)267-2158 Cell: (907)440-9934 -----Original Message----- From: Ecological Society of America: grants, jobs, news [mailto:[email protected]] On Behalf Of malcolm McCallum Sent: Wednesday, December 29, 2010 10:35 AM To: [email protected] Subject: Re: [ECOLOG-L] Graphing software for undergrad courses Use R, it will do any graphs you need and you are giving them the opportunity to work with a legit widely used program that everyone should use. malcolm On Wed, Dec 29, 2010 at 11:26 AM, Corbin, Jeffrey D. <[email protected]> wrote: > Hello Ecologgers - Does anyone have recommendations for alternatives to > Excel for graphing and/or spreadsheet applications in undergraduate > labs? I have finally decided that Excel's graphing is so nonintuitive > that it is not worth the waste of time to teach in an undergraduate lab. > > > > > Requirements: > > - It only needs to do very simple graphs - bar graphs of means > +/- SE for several treatments, regression, etc.; > > - I am very happy with SigmaPlot for my own research > applications, but I am looking for something (e.g. Freeware) that we can > install on dozens of Department computers without the licensing fees. > Also, may students complete assignments on their own laptops so having > something that they can install themselves would be preferable. > > - If it also has spreadsheet capabilities (e.g. sorting, > formulas, calculation of means and SE, etc.) it would be even better. > Could be a different program, though. > > > > While we're on the subject, any recommendations for free, but > user-friendly, stats packages for undergrad labs (t-test, ANOVA, > regression) would be helpful too. > > > > Thanks, and Happy New Year. > > > > -Jeff > > > > *************************** > > Jeffrey D. Corbin > > Department of Biological Sciences > > Union College > > Schenectady, NY 12308 > > (518) 388-6097 > > *************************** > > > -- Malcolm L. McCallum Managing Editor, Herpetological Conservation and Biology "Peer pressure is designed to contain anyone with a sense of drive" - Allan Nation 1880's: "There's lots of good fish in the sea" W.S. Gilbert 1990's: Many fish stocks depleted due to overfishing, habitat loss, and pollution. 2000: Marine reserves, ecosystem restoration, and pollution reduction MAY help restore populations. 2022: Soylent Green is People! Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
