Software Resources for Excel
Below is a list of resource pages for using Excel to do statistics. On
each page a set of data are explored with the software. Some commentary
is given on interpretation but the main focus is on getting the software
to do the work. What the numbers mean should come from your prior
statistical training or the statistics.com course you are currently
taking. Each page listed below has a title you can click on to read the
page. Beneath the title is a list of topics covered on that page.
- Entering data
- Simple summary statistics
- Stem and leaf plots
- Boxplots
- Dotplots
- Logarithmic transformations
- Simple summary statistics comparing two groups
- Boxplots comparing two groups
- Transformations
- Interpreting outliers
- Mode
- Tables
- Bar charts
- Pie charts
- One- and Two-Way Tables
- Bar charts
- Pie charts
- Probability and two-way tables
- Fixing data errors
- Confidence interval
- Hypothesis test
- Recoding data
- Confidence interval
- Hypothesis test
- One-way (Goodness of Fit)
- Two-way (Contingency Tables)
- Confidence interval
- Hypothesis test
- Confidence interval
- Hypothesis test
- Confidence interval
- Hypothesis test
- Opening data files
- Simple plots for each variable
- Scatterplots
- Correlation and covariance
- Running a regression
- Scatterplot with regression line
- Inference for regression coefficients
- Regression through the origin
- Making predictions
- Durbin-Watson statistic
- Correlations
- Regression with one or two independent variables
- Brief discussion of multicollinearity and autocorrelation
- Basic residual plots
The link takes you to a page describing the example data from which you
can then link to pages for different software packages.
- Scatterplots
- Running a multiple regression
- Regression diagnostics
- Detecting and dealing with outliers
- Predictions
- Residual plots
- Added variable plots
- Boxplot of one variable
- Scatterplot of two variables
- Doing common transformations with Excel
- Assessing the impact of a transformation
The link takes you to a page describing the example data from which you
can then link to pages for different software packages.
- Scatterplots with subgroups shown
- Creating indicator (0-1) variables
- Running a multiple regression with a 0-1 variable
- Interpreting a multiple regression with a 0-1 variable
- Creating interaction terms
- Running a multiple regression with an interaction term
- Interpreting a multiple regression with an interaction term
- Predictions
- Scatterplots with three or more subgroups shown
- Creating indicator (0-1) variables for three or more groups
- Running a multiple regression with multiple 0-1 variables
- Regression diagnostics
- Interpreting a multiple regression with multiple 0-1 variables
- Creating interaction terms
- Running a multiple regression with two or more interaction terms
- Interpreting a multiple regression with two or more interaction terms
- Testing a subset of the independent variables
- Stacking data
- Boxplots comparing multiple groups
- ANOVA
- ANOVA diagnostics
- Finding subgroup means
- Fitting an additive model
- Checking for interaction
© 2007 statistics.com