| 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 |
|
Excel Assignment 1
1.1-1.3, 2.1-2.3 |
Bar graphs, part 1 (the basics) |
Introduction to Excel functions |
| Bar graphs, part 2 (categories and data are not adjacent) |
Relative frequencies for one variable |
| Bar graphs, part 3 (multi-bar graphs for two-way tables) |
Relative frequencies for two-way tables |
|
Excel Assignment 2
Sections 2.4-2.7 |
Finding a five-number summary |
Histograms Using the Frequency Function |
| Testing for outliers using the IQR |
Optional: Installing the Data Analysis ToolPak (Windows only) |
| Standard deviation and z-scores |
Optional: Creating a basic histogram using the Data Analysis ToolPak (Windows only) |
| Calculating the standard deviation |
Optional: Creating a custom histogram using the Data Analysis ToolPak (Windows only) |
|
Excel Assignment 3
Sections 8.1-8.3 |
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 |
|
Excel Assignment 4
Sections 8.4, 8.6 |
Finding basic binomial probabilities |
Finding two-step binomial probabilities |
| Normal probabilities using NORMSDIST |
Normal probabilities using NORMSINV |
|
Excel Assignment 5
Sections 9.4, 9.6 |
Sampling distribution of p̂ (p-hat) |
Sampling distribution of x̄ (x-bar) |
