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.1-2.3
Note:
This is a new version created Winter 2015. You may download the old versions using these links:
2010 Excel Assignment 1 (2.1-2.3)
2013 Excel Assignment 1 (2.1- 2.7)
|
Introduction to Excel functions |
Bar graphs, part 3 (multi-bar graphs for two-way 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 two-way tables |
2015 Excel Assignment 2 (2015 version)
Sections 2.4-2.7
Note:
This is a new version created Winter 2015. You may download the old version using these links:
2010 Excel Assignment 2 (2.4-2.7)
|
Finding a five-number summary |
Histograms on Excel for Mac |
Testing for outliers using the IQR |
Histograms on Excel 2013 |
Standard deviation and z-scores |
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.1-8.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 two-step 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̂ (p-hat) |
Sampling distribution of x̄ (x-bar) |