Using Microsoft Excel to do Statistical Analyses

I have created some screen movies using Lotus Screen Cam to describe how to do the statistical analyses on Microsoft Excel. These files have been "zipped." The table below gives a brief description of the files. To download the files, simply click on the file name. If you have any questions or comments about the movies, please e-mail me at mgtdgw@business.utah.edu. If you are interested in movies that show how to do simulation, click here.


File Descriptions

File Zipped Size Unzipped Size Description
scrncamp.zip214 Kb589 Kb The screencam player needed to show the movie. If you don't have LOTUS Screen Cam, you need to download this file
addins.zip 677 Kb 2,275 Kb Shows how to load the Data Analysis Tools into Excel if they do not already appear under the Tools menu
freqdist.zip493 Kb 2,005 Kb Shows how to create a frequency distribution for one qualitative variable using Excel's Pivot Table capability
pienbar.zip560 Kb 2,635 Kb Shows how to create bar graphs and pie charts from a frequency distribution
histo.zip441 Kb 2,143Kb Shows how to create a frequency distribution and histogram for quantitative data
histocti.zip352 Kb 1,836 Kb Shows how to create a frequency distribution and histogram for quantitative data using the CTI add-in from the Berk and Carey text
twoway.zip384 Kb 1,790 Kb Shows how to create a two-way contingency table (cross-tabulation) using Excel's Pivot Table capability
scatter.zip 855 Kb 2,548 Kb Shows how to construct a scatter plot
descrptv.zip 425 Kb 2,091 Kb Shows how to find descriptive statistics for one or more variables
boxplot.zip 775 Kb 3,821 Kb Shows two methods for constructing box plots
corelate.zip 533 Kb 1,615 Kb Shows how to construct a sample correlation matrix
confint.zip 1,351 Kb 3,860 Kb Shows how to build confidence intervals on the mean of a continuous (normal) distribution for two cases: when the population standard deviation is unknown; and when the population standard deviation is known
ttest1.zip 1,395 Kb 3,599 Kb Shows how to test a hypothesis on the mean of a continuous (normal) distribution
ftest.zip 596 Kb 1,633 Kb Shows how to test if the population variances of two normal populations are the same
ttest2.zip 745 Kb 2,062 Kb Shows how to test if the population means of two normal populations are the same
anova.zip423 Kb 1,416 Kb Shows how to test if the population means of several normal populations with equal variances are the same
pairwise.zip 603 Kb 1,949 Kb Shows how to construct confidence intervals on the difference between means. This procedure is a follow-up to ANOVA, if we reject the hypothesis, to see which means are different.
regress.zip 1,143 Kb 3,274 Kb Shows how to run a multiple linear regression analysis
histogrm.zip 1,182 Kb 3,289 Kb Shows how to construct a histogram, specifically of a set of residuals from a regression analysis.


If you do not have a utility to unzip zipped files, you can visit the PKWARE Inc. homepage by clicking on the icon below. You can then download PKZIP that will allow you to unzip the screen movies.

PKWARE, Inc.


Back to Wardell's Home Page


Last updated Mar. 25, 1997