Data Analysis: 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.

Analysis Tutorials

Keeping Data Tidy in Excel
This tutorial from UC Davis DataLab This workshop introduces learners to best practices for data entry and organization for data-driven projects. Topics include: data validation tools including filters, controlled vocabularies, flags, and general best practices for working with data in Microsoft Excel.
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
Excel tutorial made by Physics Lab of Clemson University, but 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.

Featured Books

UC Library Search: subject = Microsoft Excel