  Trouble? Contact Bruce Simmons bruces@clackamas.edu

## Math 243 Statistics I Clackamas Community College

Text: Mind on Statistics, 5th edition, Utts and Heckard (Cengage Learning), or
Introductory Statistics, 5th 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 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)