| |
| |
How to Use This Book | |
| |
| |
Acknowledgments | |
| |
| |
About the Author | |
| |
| |
| |
Using Excel Functions | |
| |
| |
| |
Computing Averages | |
| |
| |
Excel QuickGuide 1 The Average Function | |
| |
| |
Excel QuickGuide 2 The Median Function | |
| |
| |
Excel QuickGuide 3 The Mode.sngl Function | |
| |
| |
Excel QuickGuide 4 The Geomean Function | |
| |
| |
| |
Looking at Variability | |
| |
| |
Excel QuickGuide 5 The Stdev.S Function | |
| |
| |
Excel QuickGuide 6 The Stdev.P Function | |
| |
| |
Excel QuickGuide 7 The Var.S Function | |
| |
| |
Excel QuickGuide 8 The Var.P Function | |
| |
| |
| |
Describing Data | |
| |
| |
Excel QuickGuide 9 The Frequency Function | |
| |
| |
Excel QuickGuide 10 The Norm.dist Function | |
| |
| |
Excel QuickGuide 11 The Percentile.inc Function | |
| |
| |
Excel QuickGuide 12 The Percentrank.inc Function | |
| |
| |
Excel QuickGuide 13 The Quartile.inc Function | |
| |
| |
Excel QuickGuide 14 The Rank.avg Function | |
| |
| |
Excel QuickGuide 15 The Standardize Function | |
| |
| |
| |
Looking at Relationships | |
| |
| |
Excel QuickGuide 16 The Covariance.S Function | |
| |
| |
Excel QuickGuide 17 The Correl Function | |
| |
| |
Excel QuickGuide 18 The Pearson Function | |
| |
| |
Excel QuickGuide 19 The Intercept Function | |
| |
| |
Excel QuickGuide 20 The Slope Function | |
| |
| |
Excel QuickGuide 21 The Trend Function | |
| |
| |
Excel QuickGuide 22 The Forecast Function | |
| |
| |
Excel QuickGuide 23 The RSQ Function | |
| |
| |
| |
Testing Independence | |
| |
| |
Excel QuickGuide 24 The Chisq.Dist Function | |
| |
| |
Excel QuickGuide 25 The Chisq.Test Function | |
| |
| |
| |
Testing Significance | |
| |
| |
Excel QuickGuide 26 The F.Dist Function | |
| |
| |
Excel QuickGuide 27 The F.Test Function | |
| |
| |
Excel QuickGuide 28 The T.Dist Function | |
| |
| |
Excel QuickGuide 29 The T.Test Function | |
| |
| |
Excel QuickGuide 30 The Z.Test Function | |
| |
| |
| |
Looking at Data | |
| |
| |
Excel QuickGuide 31 The Averageif Function | |
| |
| |
Excel QuickGuide 32 The Count Function | |
| |
| |
Excel QuickGuide 33 The Counta Function | |
| |
| |
Excel QuickGuide 34 The Countblank Function | |
| |
| |
Excel QuickGuide 35 The Countif Function | |
| |
| |
| |
Using the Analysis Toolpak | |
| |
| |
| |
Describing Data | |
| |
| |
Excel QuickGuide 36. Descriptive Statistics | |
| |
| |
Excel QuickGuide 37. Moving Average | |
| |
| |
Excel QuickGuide 38. Random Number Generation | |
| |
| |
Excel QuickGuide 39. Rank and Percentile | |
| |
| |
Excel QuickGuide 40. Sampling | |
| |
| |
| |
Comparing Means | |
| |
| |
Excel QuickGuide 41. z-Test: Two-Sample for Means | |
| |
| |
Excel QuickGuide 42. t-Test: Paired Two-Sample for Means | |
| |
| |
Excel QuickGuide 43. t-Test: Two-Sample Assuming Unequal Variances | |
| |
| |
Excel QuickGuide 44. t-Test: Two-Sample Assuming Equal Variances | |
| |
| |
Excel QuickGuide 45. Anova: Single Factor | |
| |
| |
Excel QuickGuide 46. Anova: Two-Factor With Replication | |
| |
| |
Excel QuickGuide 47. Anova: Two-Factor Without Replication | |
| |
| |
| |
Looking at Relationships | |
| |
| |
Excel QuickGuide 48. The Correlation Tool | |
| |
| |
Excel QuickGuide 49. The Regression Tool | |
| |
| |
| |
Illustrating Data | |
| |
| |
Excel QuickGuide 50. The Histogram Tool | |
| |
| |
| |
Answers to QuickGuide Questions | |
| |
| |
| |
Using the Macintosh Excel Formula Builder | |
| |
| |
Index | |