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 zscores 
Finding a fivenumber 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̂ (phat) 
Sampling distribution of x̄ (xbar) 

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.111.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.311.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 pvalue 
Interpreting a pvalue 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 pvalue 
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 pvalue 
Hypothesis test for the mean of paired differences: checking conditions 
Hypothesis test for the mean of paired differences: finding the test statistic and pvalue 
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 pvalue 
Unpooled hypothesis test for the difference in two population means: finding the test statistic and pvalue 


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 r^{2} 
Finding the intercept and slope of the regression equation 
Displaying the regression equation and r^{2} 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 pvalue 


ChiSquare Tests Using Excel
Chapter 15
This is not a graded assignment. 
Computing expected counts and checking conditions for Goodness of Fit 
Computing the χ^{2} (chisquare) test statistic and pvalue for Goodness of Fit 
Computing expected counts and checking conditions for twoway tables 
Computing the χ^{2} (chisquare) test statistic and pvalue for twoway tables 