Why Excel?
Why Excel?
In general, Excel is a poor choice for statistical analysis beyond textbook examples, the simplest descriptive statistics, or for more than a very few columns. However, Excel is quite easy-to-use for data entry and shape manipulating.
Where to Find Excel?
Excel is installed on every public PC in Geisel and BLB and in ETS labs.
Online Tutorials
Free open tutorials online.
-
Excel Training DocumentsA set of very neat and clear training documents on basic Excel operations that you should really know before doing statistics with it.
For Excel 2007: A Beginner's Guide, An Intermediate Guide, Advanced Guides -
Descriptive Statistics Online TrainingAlmost every detail you need for descriptive statistics in excel, great tutorials by Princeton University.
Topics include: descriptive statistics, pivot tables, one-way ANOVA -
Excel For Statistical Data AnalysisA web page made by Dr. Hossein Arsham from University of Baltimore. Though it's for Excel 97, the statistical operations are very similar.
Topics included: descriptive statistics, linear regression, ANOVA, etc -
Physics Laboratory Excel TutorialsOh yes, it's an excel tutorial made by Physics Lab of Clemson University, however, the contents are very useful for data analysis for social science data, especially the part of graphing
Topics include: basic Excel actions, graphing data, curve fitting, linear regression -
Regressions in ExcelRegressIt is a powerful Excel add-in which performs multivariate descriptive data analysis and regression analysis with high-quality table and chart output in native Excel format.
