Analysing data

This page contains resources and tips for using statistical software to analyse secondary data and export results.

##### Resources on using statistical software for analysing data and exporting results

• Excel
• Descriptive Statistics Using Excel: A learning module that focuses on entering data, descriptive statistics, pivot tables, one-way ANOVA, and graphic in Excel.
• RegressIt: A guide to an Excel add-in called RegressIt that performs linear regression and multivariate data analysis.
• Top Excel Tips for Data Analysis: A set of tips for data cleaning, analysis, and visualization in Excel.
• NVivo
• DataLab at Tufts Workshops: The Tufts DataLab website features recordings of workshops on NVivo, including Unlocking Qualitative Data with NVivo.
• Python
• R
• Analyze Survey Data: A step-by-step guide for analyzing publicly available survey data using R.
• DataLab at Tufts Workshops: The Tufts DataLab website features recordings of workshops on R, including A Gentle Intro to R and Intermediate Statistics in R.
• Microeconomics in R: A set of lecture notes on using Stata and R for microeconomics. Topics include OLS regression, functional form, heteroskedasticity, clustering, instrumental variables, panel data, binary response models, and more.
• R Bootcamp: This set of R tutorials includes tutorials on regression and basic analytics, including OLS regression and regression diagnostics, as well as exporting your work in the form of image files and HTML notebooks and reports.
• SPSS
• SPSS Online Training Workshop: This set of tutorials, videos, and datasets includes a tutorial on descriptive statistics, t-tests, ANOVA, linear models, mixed models, cluster analysis, factor analysis, time series, and more in SPSS.
• SPSS Tutorials: This set of tutorials includes data analysis, chi-square tests, ANOVA, and t-tests in SPSS.
• Stata
• DataLab at Tufts Workshops: The Tufts DataLab website features recordings of workshops on Stata, including Stata Basic
• Guide to gologit2: A guide to using Stata’s gologit2 command for generalized ordered logit models for ordinal dependent variables.
• Guide to oglm: A guide to using Stata’s oglm command for ordinal generalized linear models.
• Stata YouTube channel: The StataYouTube channel includes hundreds of videos on data analysis in Stata. Each short video addresses a specific topic, such as t-tests, regression models, and many more.
• Microeconomics in Stata: A set of lecture notes on using Stata and R for microeconomics. Topics include OLS regression, functional form, heteroskedasticity, clustering, instrumental variables, panel data, binary response models, and more.
• South Africa Distance Learning Project: A hand-on distance learning tools that teaches students how to analyze South African household survey data in Stata, with a focus on investigating policy issues.
• Stata Web Books Regression with Stata: A set of materials to help users learn to perform regression analysis in Stata, including chapters on simple and multiple regression, regression diagnostics, regression with categorical predictors, and regression beyond OLS.
• Survival Analysis with Stata: A set of lessons, materials, do-files, and datasets to help users learn survival analysis in Stata.
• The 10 Commandments for Regression Tables: A guide to creating high quality regression tables written by Dr. Keith Head. This guide can be used with any statistical software but includes some Stata commands.