Math 243 Statistics I
Clackamas Community College
Text: Mind on Statistics, 4th edition, Utts and Heckard (Cengage Learning), or
Introductory Statistics, 4th edition, Utts and Heckard (custom CCC edition of Mind on Statistics)
Resizing Rows, Columns, and Cells
Introduction to Excel
| 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) |
|
