LibGuides: Finding Data & Statistics: Excel

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 Library and WongAvery Library and in ETS labs.

Online Tutorials

Free open tutorials online.

Excel Training Documents
A set of very neat and clear training documents on basic Excel operations that you should really know before doing statistics with it.
For Excel 2013: A Beginner's Guide, An Intermediate Guide, Advanced Guides
Descriptive Statistics Online Training
Almost 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 Analysis
A 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

more... less...

Other topics: Chi-Square, t-test, z-test, F-statistics.
Physics Laboratory Excel Tutorials
Oh 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 Excel
RegressIt 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.

Find guide books and ebooks

UC Library Search: subject = Microsoft Excel