Clackamas Math Department logo
Clackamas CC logo
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)

Bar Graphs, part 2
Categories and Data are Not Adjacent
Excel Assignment 1


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)