| |
| |
| |
Getting Started | |
| |
| |
Introduction and Overview | |
| |
| |
Versions of Excel | |
| |
| |
Versions of Windows | |
| |
| |
What May Be Skipped | |
| |
| |
More Detailed Information on Excel | |
| |
| |
Excel Worksheet Basics | |
| |
| |
Using the Mouse | |
| |
| |
Starting Excel | |
| |
| |
Exiting Excel | |
| |
| |
Layout of Worksheets and Workbooks | |
| |
| |
Menus, Toolbars, and Dialog Boxes | |
| |
| |
Manipulating Windows | |
| |
| |
Ways to Get Help | |
| |
| |
Help on the Main Menu | |
| |
| |
Answer Wizard | |
| |
| |
| |
Entering, Saving, and Editing Information | |
| |
| |
Opening and Saving Documents | |
| |
| |
Opening a Brand-New Worksheet | |
| |
| |
Opening a File You Have Already Created | |
| |
| |
Entering Information | |
| |
| |
Addresses | |
| |
| |
Activating a Cell or Range of Cells | |
| |
| |
Types of Information | |
| |
| |
Changing Information | |
| |
| |
Moving and Copying Information | |
| |
| |
Dragging and Dropping | |
| |
| |
Formatting Numbers | |
| |
| |
Aligning Information | |
| |
| |
Formatting a Range | |
| |
| |
Inserting or Deleting Rows and Columns | |
| |
| |
Filling Adjacent Cells | |
| |
| |
Series | |
| |
| |
Sorting | |
| |
| |
Saving and Retrieving Information | |
| |
| |
Naming Workbooks | |
| |
| |
Printing | |
| |
| |
Page Setup | |
| |
| |
Enhancing Output | |
| |
| |
| |
Using Formulas and Functions | |
| |
| |
Operators | |
| |
| |
Order of Operations | |
| |
| |
Writing Equations | |
| |
| |
Entering Formulas | |
| |
| |
Relative References | |
| |
| |
Absolute References | |
| |
| |
| |
Frequency Distributions | |
| |
| |
Histogram Using Analysis Tools | |
| |
| |
Sorting the Data | |
| |
| |
Sorting: Potential Problems | |
| |
| |
Bins | |
| |
| |
Interpreting the Output | |
| |
| |
Modifying and Printing the Histogram Chart | |
| |
| |
Pivot Table | |
| |
| |
Sample Research Problem | |
| |
| |
Setting up a Pivot Table | |
| |
| |
Pivot Table: Frequency Distributions | |
| |
| |
| |
Descriptive Statistics | |
| |
| |
Data Analysis Tools: Descriptive Statistics | |
| |
| |
Sample Research Problem | |
| |
| |
Steps to Follow to Obtain Descriptive Statistics for a Single Variable | |
| |
| |
Interpreting the Output | |
| |
| |
Steps to Follow to Obtain Descriptive Statistics for Two or More Variables | |
| |
| |
Function Wizard: Descriptive Statistics | |
| |
| |
Sample Research Problem | |
| |
| |
Steps to Follow to Obtain Descriptive Statistics for One Variable | |
| |
| |
Interpreting the Output | |
| |
| |
Steps to Follow to Obtain Descriptive Statistics for More than One Variable | |
| |
| |
Interpreting the Output | |
| |
| |
Pivot Table: Descriptive Statistics | |
| |
| |
Sample Research Problem | |
| |
| |
Setting up a Pivot Table | |
| |
| |
| |
Probability Distributions | |
| |
| |
Discrete Probability Distributions | |
| |
| |
Binomial Distribution | |
| |
| |
Interpreting the Output | |
| |
| |
Hypergeometric Distribution | |
| |
| |
Interpreting the Output | |
| |
| |
Poisson Distribution | |
| |
| |
Interpreting the Output | |
| |
| |
Continuous Probability Distributions | |
| |
| |
Normal Distribution | |
| |
| |
t Distribution | |
| |
| |
F Distribution | |
| |
| |
Chi-Square Distribution | |
| |
| |
| |
Testing Hypotheses About One Sample Means | |
| |
| |
One-Sample Z-Test | |
| |
| |
Assumptions Underlying the Z-Test | |
| |
| |
Sample Research Problem | |
| |
| |
Steps to Follow to Analyze the Sample Research Problem | |
| |
| |
Interpreting the Output | |
| |
| |
Confidence Interval for the One-Sample Z-Test | |
| |
| |
Interpreting the Confidence Interval | |
| |
| |
One-Sample t-Test | |
| |
| |
Assumptions Underlying the t-Test | |
| |
| |
Sample Research Problem | |
| |
| |
Steps to Follow to Analyze the Sample Research Problem | |
| |
| |
Interpreting the Output | |
| |
| |
Confidence Interval for the One-Sample t-Test | |
| |
| |
Interpreting the Confidence Interval | |
| |
| |
| |
Testing Hypotheses About the Difference Between Two Means | |
| |
| |
t-Test for Two Independent Samples | |
| |
| |
Variances Are Not Known and Are Assumed to Be Equal | |
| |
| |
Assumptions Underlying the Independent Samples t-Test | |
| |
| |
Sample Research Problem | |
| |
| |
Using Analysis Tools for t-Test: Two-Sample Assuming Equal Variances | |
| |
| |
Steps to Follow to Analyze the Sample Research Problem | |
| |
| |
Interpreting the Output | |
| |
| |
Variances Are Not Known and Are Assumed to Be Unequal | |
| |
| |
Assumptions Underlying the Independent Samples t*-Test | |
| |
| |
Sample Research Problem | |
| |
| |
Using Analysis Tools for t-Test: Two-Sample Assuming Unequal Variances | |
| |
| |
Interpreting the Output | |
| |
| |
Paired-Samples t-Test | |
| |
| |
Sample Research Problem | |
| |
| |
Using Analysis Tools for t-Test: Paired-Two-Sample for Means | |
| |
| |
Interpreting the Output | |
| |
| |
Z-Test for Two Independent Samples | |
| |
| |
Assumptions Underlying the Z-Test | |
| |
| |
Sample Research Problem | |
| |
| |
Using Analysis Tools for Z-Test: Two-Sample for Means | |
| |
| |
Steps to Follow to Analyze the Sample Research Problem | |
| |
| |
Interpreting the Output | |
| |
| |
| |
Analysis of Variance | |
| |
| |
One-Way Between-Groups ANOVA | |
| |
| |
F-Test | |
| |
| |
Assumptions Underlying the F-Test | |
| |
| |
Sample Research Problem | |
| |
| |
Using Analysis Tools for One-Way Between-Groups ANOVA | |
| |
| |
Interpreting the Output | |
| |
| |
One-Way Repeated Measures ANOVA | |
| |
| |
F-Test | |
| |
| |
Assumptions Underlying the F-Test | |
| |
| |
Sample Research Problem | |
| |
| |
Using Analysis Tools for One-Way Repeated Measures ANOVA | |
| |
| |
Interpreting the Output | |
| |
| |
Two-Way Between-Groups ANOVA | |
| |
| |
F-Test | |
| |
| |
Assumptions Underlying the F-Test | |
| |
| |
Sample Research Problem | |
| |
| |
Using Analysis Tools for Two-Way Between-Groups ANOVA | |
| |
| |
Interpreting the Output | |
| |
| |
| |
Correlation | |
| |
| |
Pearson Correlation Coefficient | |
| |
| |
Sample Research Problem | |
| |
| |
Function Wizard | |
| |
| |
Correlation Matrices | |
| |
| |
Scatterplot | |
| |
| |
Modifying the Scatterplot | |
| |
| |
| |
Regression | |
| |
| |
Two-Variable Regression | |
| |
| |
Sample Research Problem | |
| |
| |
Scatterplot | |
| |
| |
Steps to Follow to Analyze the Sample Research Problem | |
| |
| |
Interpreting the Output | |
| |
| |
Multiple Regression | |
| |
| |
Sample Research Problem | |
| |
| |
Steps to Follow to Analyze the Sample Research Problem | |
| |
| |
Interpreting the Output | |
| |
| |
| |
Cross Tabulations | |
| |
| |
Sample Research Problem | |
| |
| |
Cross Tabulation of Two Qualitative Variables | |
| |
| |
Cross Tabulation of a Qualitative and a Quantitative Variable | |
| |
| |
Cross Tabulation of Three Variables | |
| |
| |
Missing Data | |
| |
| |
Chi-Square Test of Independence | |
| |
| |
Assumptions Underlying the Chi-Square Test of Independence | |
| |
| |
Sample Research Problem | |
| |
| |
Using the Pivot Table for Observed Cell Frequencies | |
| |
| |
Using Formulas to Calculate Expected Cell Frequencies | |
| |
| |
Using the Function Wizard to Calculate Chi-Square | |
| |
| |
Using the Function Wizard to Find the Critical Value of Chi-Square | |
| |
| |
Using the Function Wizard to Find the P-Value | |
| |
| |
| |
How to Obtain Data Files on the Web | |
| |
| |
Taking the Long Way to the Site | |
| |
| |
Taking the Short Way to the Site | |
| |
| |
Description of the Data Sets | |
| |
| |
| |
Web Sites that Provide | |
| |
| |
Information About Excel and Statistics | |
| |
| |
http://www.nyu.edu/acf/socsci/statistics.html | |
| |
| |
http://www.census.gov/statab/freq | |
| |
| |
http://www.j-walk.com/ss/ssjokes.htm | |