Media Player Instructional Files to use Excel for Statistics
Robert L. Andrews, Media File Creator
Page last updated on September 9, 2008

To view the media files I have saved at this location you need Windows Media Player. If you not have it on your computer it can be downloaded for free from Mircrosoft by going to http://www.microsoft.com/windows/windowsmedia/player/ Microsoft updates its version of Windows Media Player over time and you can see which works best for you. Also I view the file in full screen mode. If you are not able to install the Windows Media Player on your computer you can go to one of the computer labs on campus, such as the basement of the library or room B2127 of Snead Hall.

If you want to play a media file you may be able to douple click on the link to play the file or you may need to first download the file to your computer and then play the file using Windows Media Player. To download with Explorer, right mouse click on the name below for the file and then select "Save Target As" to allow you to select where you want to save the file on your computer. I have two sets of Media Player files below. The first set uses Excel 2007 and the second set is for Excel prior to 2007.

The files below illustrate using Excel 2007 and are not for a specific text.
Creating a Run Chart using Excel 2007
Frequency Tables & Charts for Qualitative Data using Excel 2007
 
 
 


The files below are for Excel prior to 2007.
The Section numbers below refer to the Canavos and Miller text, An Introduction to Modern Business Statistics (second edition).
Section
File Description
1.5
Creating a Run Chart using Excel Chart Wizard (Line)
2.3.2
Creating a Frequency Table and a Histogram
2.4, 2.5 & 2.6
Measures of Location, Variation and Relative Standing for a Quantitative Variable
2.7.1
Creating an XY Scatter Diagram for 2 Quantitative Variables
2.7.2
Creating a Contingency or Cross-classification Table from an Excel Data List
Ch. 6 & up
Finding Probabilities & Table Values for t & Z with Excel
7.4
Confidence Interval for the Mean Difference of Paired Data
7.4
Paired t-test with Excel
7.3
Graphing to Compare 2 Groups with Independent Samples
7.3
Testing for Differences between 2 Means - Independent Samples
7.3
Confidence Interval for the Difference between 2 Means - Independent Samples
8.2
ANOVA with a Single Factor to Compare 2 or more Means
8.3
ANOVA with 2 Factors and No Replication
2.7.2 & 11.3
Creating a Contingency or Cross-classification Table from an Excel Data List
11.3
Chi-square Test of Independence using Excel
9.3
Introduction to Regression using Excel
 

 



This page does not reflect an official position of Virginia Commonwealth University.