| |
| |
| |
Getting Started with Excel | |
| |
| |
Getting Started | |
| |
| |
Special Files for This Book | |
| |
| |
Installing the StatPlus Files | |
| |
| |
Excel and Spreadsheets | |
| |
| |
Launching Excel | |
| |
| |
Viewing the Excel Window | |
| |
| |
Running Excel Commands | |
| |
| |
Excel Workbooks and Worksheets | |
| |
| |
Opening a Workbook | |
| |
| |
Scrolling through a Workbook | |
| |
| |
Worksheet Cells | |
| |
| |
Selecting a Cell | |
| |
| |
Moving Cells | |
| |
| |
Printing from Excel | |
| |
| |
Previewing the Print Job | |
| |
| |
Setting Up the Page | |
| |
| |
Printing the Page | |
| |
| |
Saving Your Work | |
| |
| |
Excel Add-Ins | |
| |
| |
Loading the StatPlus Add-In | |
| |
| |
Loading the Data Analysis ToolPak | |
| |
| |
Unloading an Add-In | |
| |
| |
Features of StatPlus | |
| |
| |
Using StatPlus Modules | |
| |
| |
Hidden Data | |
| |
| |
Linked Formulas | |
| |
| |
Setup Options | |
| |
| |
Exiting Excel | |
| |
| |
| |
Working with Data | |
| |
| |
Data Entry | |
| |
| |
Entering Data from the Keyboard | |
| |
| |
Entering Data with Autofill | |
| |
| |
Inserting New Data | |
| |
| |
Data Formats | |
| |
| |
Formulas and Functions | |
| |
| |
Inserting a Simple Formula | |
| |
| |
Inserting an Excel Function | |
| |
| |
Cell References | |
| |
| |
Range Names | |
| |
| |
Sorting Data | |
| |
| |
Querying Data | |
| |
| |
Using the AutoFilter | |
| |
| |
Using the Advanced Filter | |
| |
| |
Using Calculated Values | |
| |
| |
Importing Data from Text Files | |
| |
| |
Importing Data from Databases | |
| |
| |
Using Excel's Database Query Wizard | |
| |
| |
Specifying Criteria and Sorting Data | |
| |
| |
Exercises | |
| |
| |
| |
Working with Charts | |
| |
| |
Introducing Excel Charts | |
| |
| |
Introducing Scatter Plots | |
| |
| |
Editing a Chart | |
| |
| |
Resizing and Moving an Embedded Chart | |
| |
| |
Moving a Chart to a Chart Sheet | |
| |
| |
Working with Chart and Axis Titles | |
| |
| |
Editing the Chart Axes | |
| |
| |
Working with Gridlines and Legends | |
| |
| |
Editing Plot Symbols | |
| |
| |
Identifying Data Points | |
| |
| |
Selecting a Data Row | |
| |
| |
Labeling Data Points | |
| |
| |
Formatting Labels | |
| |
| |
Creating Bubble Plots | |
| |
| |
Breaking a Scatter Plot into Categories | |
| |
| |
Plotting Several Variables | |
| |
| |
Exercises | |
| |
| |
| |
Describing Your Data | |
| |
| |
Variables and Descriptive Statistics | |
| |
| |
Frequency Tables | |
| |
| |
Creating a Frequency Table | |
| |
| |
Using Bins in a Frequency Table | |
| |
| |
Defining Your Own Bin Values | |
| |
| |
Working with Histograms | |
| |
| |
Creating a Histogram | |
| |
| |
Shapes of Distributions | |
| |
| |
Breaking a Histogram into Categories | |
| |
| |
Working with Stem and Leaf Plots | |
| |
| |
Distribution Statistics | |
| |
| |
Percentiles and Quartiles | |
| |
| |
Measures of the Center: Means, Medians, and the Mode | |
| |
| |
Measures of Variability | |
| |
| |
Measures of Shape: Skewness and Kurtosis | |
| |
| |
Outliers | |
| |
| |
Working with Boxplots | |
| |
| |
Concept Tutorials: Boxplots | |
| |
| |
Exercises | |
| |
| |
| |
Probability Distributions | |
| |
| |
Probability | |
| |
| |
Probability Distributions | |
| |
| |
Discrete Probability Distributions | |
| |
| |
Continuous Probability Distributions | |
| |
| |
Concept Tutorials: PDFs | |
| |
| |
Random Variables and Random Samples | |
| |
| |
Concept Tutorials: Random Samples | |
| |
| |
The Normal Distribution | |
| |
| |
Concept Tutorials: The Normal Distribution | |
| |
| |
Excel Worksheet Functions | |
| |
| |
Using Excel to Generate Random Normal Data | |
| |
| |
Charting Random Normal Data | |
| |
| |
The Normal Probability Plot | |
| |
| |
Parameters and Estimators | |
| |
| |
The Sampling Distribution | |
| |
| |
Concept Tutorials: Sampling Distributions | |
| |
| |
The Standard Error | |
| |
| |
The Central Limit Theorem | |
| |
| |
Concept Tutorials: The Central Limit Theorem | |
| |
| |
Exercises | |
| |
| |
| |
Statistical Inference | |
| |
| |
Confidence Intervals | |
| |
| |
z Test Statistic and z Values | |
| |
| |
Calculating the Confidence Interval with Excel | |
| |
| |
Interpreting the Confidence Interval | |
| |
| |
Concept Tutorials: The Confidence Interval | |
| |
| |
Hypothesis Testing | |
| |
| |
Types of Error | |
| |
| |
An Example of Hypothesis Testing | |
| |
| |
Acceptance and Rejection Regions | |
| |
| |
p Values | |
| |
| |
Concept Tutorials: Hypothesis Testing | |
| |
| |
Additional Thoughts about Hypothesis Testing | |
| |
| |
The t Distribution | |
| |
| |
Concept Tutorials: The t Distribution | |
| |
| |
Working with the t Statistic | |
| |
| |
Constructing a t Confidence Interval | |
| |
| |
The Robustness of t | |
| |
| |
Applying the t Test to Paired Data | |
| |
| |
Applying a Nonparametric Test to Paired Data | |
| |
| |
The Wilcoxon Signed Rank Test | |
| |
| |
The Sign Test | |
| |
| |
The Two-Sample t Test | |
| |
| |
Comparing the Pooled and Unpooled Test Statistics | |
| |
| |
Working with the Two-Sample t Statistic | |
| |
| |
Testing for Equality of Variance | |
| |
| |
Applying the t Test to Two-Sample Data | |
| |
| |
Applying a Nonparametric Test to Two-Sample Data | |
| |
| |
Final Thoughts about Statistical Inference | |
| |
| |
Exercises | |
| |
| |
| |
Tables | |
| |
| |
PivotTables | |
| |
| |
Removing Categories from a PivotTable | |
| |
| |
Changing the Values Displayed by the PivotTable | |
| |
| |
Displaying Categorical Data in a Bar Chart | |
| |
| |
Displaying Categorical Data in a Pie Chart | |
| |
| |
Two-Way Tables | |
| |
| |
Computing Expected Counts | |
| |
| |
The Pearson Chi-Square Statistic | |
| |
| |
Concept Tutorials: The �<sup>2</sup> Distribution | |
| |
| |
Working with the �<sup>2</sup> Distribution in Excel | |
| |
| |
Breaking Down the Chi-Square Statistic | |
| |
| |
Other Table Statistics | |
| |
| |
Validity of the Chi-Square Test with Small Frequencies | |
| |
| |
Tables with Ordinal Variables | |
| |
| |
Testing for a Relationship between Two Ordinal Variables | |
| |
| |
Custom Sort Order | |
| |
| |
Exercises | |
| |
| |
| |
Regression and Correlation | |
| |
| |
Simple Linear Regression | |
| |
| |
The Regression Equation | |
| |
| |
Fitting the Regression Line | |
| |
| |
Regression Functions in Excel | |
| |
| |
Exploring Regression | |
| |
| |
Performing a Regression Analysis | |
| |
| |
Plotting Regression Data | |
| |
| |
Calculating Regression Statistics | |
| |
| |
Interpreting Regression Statistics | |
| |
| |
Interpreting the Analysis of Variance Table | |
| |
| |
Parameter Estimates and Statistics | |
| |
| |
Residuals and Predicted Values | |
| |
| |
Checking the Regression Model | |
| |
| |
Testing the Straight-Line Assumption | |
| |
| |
Testing for Normal Distribution of the Residuals | |
| |
| |
Testing for Constant Variance in the Residuals | |
| |
| |
Testing for the Independence of Residuals | |
| |
| |
Correlation | |
| |
| |
Correlation and Slope | |
| |
| |
Correlation and Causality | |
| |
| |
Spearman's Rank Correlation Coefficient s | |
| |
| |
Correlation Functions in Excel | |
| |
| |
Creating a Correlation Matrix | |
| |
| |
Correlation with a Two-Valued Variable | |
| |
| |
Adjusting Multiple p Values with Bonferroni | |
| |
| |
Creating a Scatter Plot Matrix | |
| |
| |
Exercises | |
| |
| |
| |
Multiple Regression | |
| |
| |
Regression Models with Multiple Parameters | |
| |
| |
Concept Tutorials: The F Distribution | |
| |
| |
Using Regression for Prediction | |
| |
| |
Regression Example: Predicting Grades | |
| |
| |
Interpreting the Regression Output | |
| |
| |
Multiple Correlation | |
| |
| |
Coefficients and the Prediction Equation | |
| |
| |
t Tests for the Coefficients | |
| |
| |
Testing Regression Assumptions | |
| |
| |
Observed versus Predicted Values | |
| |
| |
Plotting Residuals versus Predicted Values | |
| |
| |
Plotting Residuals versus Predictor Variables | |
| |
| |
Normal Errors and the Normal Plot | |
| |
| |
Summary of Calc Analysis | |
| |
| |
Regression Example: Sex Discrimination | |
| |
| |
Regression on Male Faculty | |
| |
| |
Using a SPLOM to See Relationships | |
| |
| |
Correlation Matrix of Variables | |
| |
| |
Multiple Regression | |
| |
| |
Interpreting the Regression Output | |
| |
| |
Residual Analysis of Discrimination Data | |
| |
| |
Normal Plot of Residuals | |
| |
| |
Are Female Faculty Underpaid? | |
| |
| |
Drawing Conclusions | |
| |
| |
Exercises | |
| |
| |
| |
Analysis of Variance | |
| |
| |
One-Way Analysis of Variance | |
| |
| |
Analysis of Variance Example: Comparing Hotel Prices | |
| |
| |
Graphing the Data to Verify ANOVA Assumptions | |
| |
| |
Computing the Analysis of Variance | |
| |
| |
Interpreting the Analysis of Variance Table | |
| |
| |
Comparing Means | |
| |
| |
Using the Bonferroni Correction Factor | |
| |
| |
When to Use Bonferroni | |
| |
| |
Comparing Means with a Boxplot | |
| |
| |
One-Way Analysis of Variance and Regression | |
| |
| |
Indicator Variables | |
| |
| |
Fitting the Effects Model | |
| |
| |
Two-Way Analysis of Variance | |
| |
| |
A Two-Factor Example | |
| |
| |
Two-Way Analysis Example: Comparing Soft Drinks | |
| |
| |
Graphing the Data to Verify Assumptions | |
| |
| |
The Interaction Plot | |
| |
| |
Using Excel to Perform a Two-Way Analysis of Variance | |
| |
| |
Interpreting the Analysis of Variance Table | |
| |
| |
Summary | |
| |
| |
Exercises | |
| |
| |
| |
Time Series | |
| |
| |
Time Series Concepts | |
| |
| |
Time Series Example: The Rise in Global Temperatures | |
| |
| |
Plotting the Global Temperature Time Series | |
| |
| |
Analyzing the Change in Global Temperature | |
| |
| |
Looking at Lagged Values | |
| |
| |
The Autocorrelation Function | |
| |
| |
Applying the ACF to Annual Mean Temperature | |
| |
| |
Other ACF Patterns | |
| |
| |
Applying the ACF to the Change in Temperature | |
| |
| |
Moving Averages | |
| |
| |
Simple Exponential Smoothing | |
| |
| |
Forecasting with Exponential Smoothing | |
| |
| |
Assessing the Accuracy of the Forecast | |
| |
| |
Concept Tutorials: One-Parameter Exponential Smoothing | |
| |
| |
Choosing a Value for w | |
| |
| |
Two-Parameter Exponential Smoothing | |
| |
| |
Calculating the Smoothed Values | |
| |
| |
Concept Tutorials: Two-Parameter Exponential Smoothing | |
| |
| |
Seasonality | |
| |
| |
Multiplicative Seasonality | |
| |
| |
Additive Seasonality | |
| |
| |
Seasonal Example: Liquor Sales | |
| |
| |
Examining Seasonality with a Boxplot | |
| |
| |
Examining Seasonality with a Line Plot | |
| |
| |
Applying the ACF to Seasonal Data | |
| |
| |
Adjusting for Seasonality | |
| |
| |
Three-Parameter Exponential Smoothing | |
| |
| |
Forecasting Liquor Sales | |
| |
| |
Optimizing the Exponential Smoothing Constant (optional) | |
| |
| |
Exercises | |
| |
| |
| |
Quality Control | |
| |
| |
Statistical Quality Control | |
| |
| |
Controlled Variation | |
| |
| |
Uncontrolled Variation | |
| |
| |
Control Charts | |
| |
| |
Control Charts and Hypothesis Testing | |
| |
| |
Variable and Attribute Charts | |
| |
| |
Using Subgroups | |
| |
| |
The <$>\bar {x}<$> Chart | |
| |
| |
Calculating Control Limits When � Is Known | |
| |
| |
<$>\bar {x}<$> Chart Example: Teaching Scores | |
| |
| |
Calculating Control Limits When � Is Unknown | |
| |
| |
<$>\bar {x}<$> Chart Example: A Coating Process | |
| |
| |
The Range Chart | |
| |
| |
The C Chart | |
| |
| |
C Chart Example: Factory Accidents | |
| |
| |
The P Chart | |
| |
| |
P Chart Example: Steel Rod Defects | |
| |
| |
Control Charts for Individual Observations | |
| |
| |
The Pareto Chart | |
| |
| |
Exercises | |
| |
| |
Appendix | |
| |
| |
Excel Reference | |
| |
| |
Bibliography | |
| |
| |
Index | |