Software Tutorials
Software Tutorials
Excel for PC
This tutorial is for Excel 2010 for PCs
Getting Started with Spreadsheets; Worksheet Basics; Introduction to the Ribbon; Cell Manipulations; Formatting Cells; Copying, Cutting, & Pasting; Inserting & Deleting; Manipulating Data I; Manipulating Data II
Creating Charts; Formatting Charts; Formatting the Chart Plot Area; Formatting the Chart Axes; Formatting the Chart Legend; Copying, Cutting, & Pasting Charts; Trendlines and Error Bars; Linest Function; Pivot table
Formula Basics; Using Excel's Functions; Common Function & Formula Error Messages; Some Useful Statistical Functions; Macros; An Application of Functions: Budget Spreadsheet
Analysis ToolPak; ANOVA
Excel for Macs
This tutorial is for Excel 2011 for Macs
Getting Started with Spreadsheets; Worksheet Basics; Introduction to the Ribbon; Cell Manipulations; Formatting Cells; Copying, Cutting, & Pasting; Inserting & Deleting; Manipulating Data I; Manipulating Data II
Creating Charts; Formatting Charts; Formatting the Chart Plot Area; Formatting the Chart Axes; Formatting the Chart Legend; Copying, Cutting, & Pasting Charts; Trendlines and Error Bars; Linest Function; Pivot table
Formula Basics; Using Excel's Functions; Common Function & Formula Error Messages; Some Useful Statistical Functions; Macros
SPSS
This tutorial is for SPSS Version 20. (This tutorial can also be used with previous versions of SPSS.)
Getting Started: Three Windows; Open or Merge Files; Saving Files; Reading an Output File; Using the Data Editor; The Edit Menu and Toolbar; Transforming Variables; Sort and Filter Data
Central Tendency; Dispersion and Variability; Distribution and Normality; Z-Scores;
Frequency Tables; Frequency Charts
T-Tests; ANOVA Tests; Chi-Square Tests
Pearson's r; Simple Linear Regression; Scatterplots; Multiple Regressions
Stata
This tutorial is version BETA meaning it is still under construction.
What Stata Looks Like; Exploring a Dataset; Setting Up Your Research; Initial Analysis; Handy Tricks; More Advanced Regression Models; Data Visualization; Potential Problems; Opening and Creating .dta Data Files