| 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 |
| Excel 2013 or 2016: Histograms |
Excel on a Mac: Histograms |
| OpenOffice.org:: Histograms |
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
This is a graded assignment for some classes, not for others. Check with your instructor to be sure. |
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
This is a graded assignment for some classes, not for others. Check with your instructor to be sure. |
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 |
