Clackamas Math Department logo
Clackamas CC logo
Trouble? Contact
Bruce Simmons
bruces@clackamas.edu

Math 244 Statistics II
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)

Interpreting a Regression Report
Finding the Test Statistic t and the p-value


Excel Workbooks Video Links
Introduction to Excel
Download this file to work practice problems that go along with the videos.

This is not a graded assignment.
Intro to Excel 2010 Intro to Excel 2007
Intro to Excel on a Mac Intro to Spreadsheets on openoffice.org
Troubleshooting: tabs cannot be seen Number and text formats
Cell formats Sorting, copying, pasting
Resizing rows, columns, and cells Inserting or deleting rows, columns, and cells
Working with text boxes Introduction to calculations with formulas
Copying and pasting formulas Absolute and relative cell references in formulas
Review of Excel from Statistics I
Download this file to work practice problems corresponding to the videos.

This is not a graded assignment.
Introduction to Excel functions Standard deviation and z-scores
Finding a five-number summary Testing for outliers using the IQR
Installing the Data Analysis ToolPak Creating a basic histogram using the Data Analysis ToolPak
Creating a custom histogram using the Data Analysis ToolPak Histograms Using the FREQUENCY Function
Normal probabilities using NORMSDIST Using the NORMSINV Function
Sampling distribution of  p̂ (p-hat) Sampling distribution of  x̄ (x-bar)
Excel Assignment Chapter 10 Typing subscripts, superscripts, Greek letters, hats, and bars Finding z* using the NORMSINV function
Checking conditions for a confidence interval for one population proportion Calculating a confidence interval for one population proportion
Interpreting a confidence interval for one population proportion Checking conditions for a confidence interval for the difference in two population proportions
Calculating and interpreting an interval for the difference in two population proportions  
Excel Assignment 11.1-11.2 Finding t* using the TINV function Checking conditions for a confidence interval for one population mean
Calculating and interpreting a confidence interval for one population mean  
Excel Assignment 11.3-11.5 Checking conditions for a confidence interval for the mean of paired differences Calculating a confidence interval for the mean of paired differences
Interpreting a confidence interval for the mean of paired differences Checking conditions for a confidence interval for the difference in two population means
Unpooled: calculating and interpreting a confidence interval for the difference in two population means Pooled: calculating and interpreting a confidence interval for the difference in two population means
Excel Assignment chapter 12 Writing hypotheses for one population proportion Hypothesis test for one population proportion: checking conditions
Hypothesis test for one population proportion: computing the test statistic and p-value Interpreting a p-value in context
Review of statistical significance Hypothesis test for one population proportion: assessing significance and writing a conclusion
Writing hypotheses for the difference in two population proportions Hypothesis test for the difference in two population proportions: checking conditions
Hypothesis test for the difference in two population proportions: computing the test statistic and p-value Hypothesis test for the difference in two population proportions: assessing significance and writing a conclusion
Excel Assignment chapter 13 Hypothesis test for one population mean: checking conditions Hypothesis test for one population mean: finding the test statistic and p-value
Hypothesis test for the mean of paired differences: checking conditions Hypothesis test for the mean of paired differences: finding the test statistic and p-value
Hypothesis test for the difference in two population means: checking conditions Pooled hypothesis test for the difference in two population means: finding the test statistic and p-value
Unpooled hypothesis test for the difference in two population means: finding the test statistic and p-value  
Excel Assignment Linear Regression
(Chapters 3 and 14)

This is a graded assignment for some classes, not for others. Check with your instructor to be sure.
Scatterplots and the regression (trend) line Computing r and r2
Finding the intercept and slope of the regression equation Displaying the regression equation and r2 on a scatterplot
Computing residuals Creating a residual plot
Calculating SSE and the standard deviation s for a regression model Create a regression report using the Data Analysis ToolPak
Using a regression report to find the test statistic t and the p-value  
Chi-Square Tests Using Excel
Chapter 15

This is not a graded assignment.
Computing expected counts and checking conditions for Goodness of Fit Computing the χ2 (chi-square) test statistic and p-value for Goodness of Fit
Computing expected counts and checking conditions for two-way tables Computing the χ2 (chi-square) test statistic and p-value for two-way tables