Excel Workbooks 
Video Links 
Introduction to Excel
(Download this to see all the examples and exercises that go along with the videos) 
Intro to Excel 2010 
Sorting, copying, pasting 
Intro to Excel 2007 
Resizing rows, columns, and cells 
Intro to Excel on a Mac 
Inserting or deleting rows, columns, and cells 
Intro to Spreadsheets on openoffice.org 
Working with text boxes 
Troubleshooting: tabs cannot be seen 
Introduction to calculations with formulas 
Number and text formats 
Copying and pasting formulas 
Cell formats 
Absolute and relative cell references in formulas 

2015 Excel Assignment 1
Sections 2.12.3
Note:
This is a new version created Winter 2015. You may download the old versions using these links:
2010 Excel Assignment 1 (2.12.3)
2013 Excel Assignment 1 (2.1 2.7)

Introduction to Excel functions 
Bar graphs, part 3 (multibar graphs for twoway tables) 
Bar graphs, part 1 (the basics) 
Relative frequencies for one variable 
Bar graphs, part 2 (categories and data are not adjacent) 
Relative frequencies for twoway tables 
2015 Excel Assignment 2 (2015 version)
Sections 2.42.7
Note:
This is a new version created Winter 2015. You may download the old version using these links:
2010 Excel Assignment 2 (2.42.7)

Finding a fivenumber summary 
Histograms on Excel for Mac 
Testing for outliers using the IQR 
Histograms on Excel 2013 
Standard deviation and zscores 
Histograms on OpenOffice 
Calculating the standard deviation 
Optional: Installing the Data Analysis ToolPak (Windows only) 
Histograms Using the Frequency Function 
Optional: Creating a basic histogram using the Data Analysis ToolPak (Windows only) 

Optional: Creating a custom histogram using the Data Analysis ToolPak (Windows only) 

2015 Excel Assignment 3
Sections 8.18.3
Note: These have been renumbered. This used to be Assignment 2. 
Expected value (mean) of a random variable 
Histogram of a random variable 
Variance and standard deviation of a random variable 
Checking the empirical rule for a random variable 

2015 Excel Assignment 4
Sections 8.4, 8.6
Note: These have been renumbered. This used to be Assignment 3. 
Finding basic binomial probabilities 
Finding twostep binomial probabilities 
Normal probabilities using NORMSDIST 
Normal probabilities using NORMSINV 

2015 Excel Assignment 5
Sections 9.4, 9.6
Note: These have been renumbered. This used to be Assignment 4. 
Sampling distribution of p̂ (phat) 
Sampling distribution of x̄ (xbar) 