Probability & Statistics in Microsoft Excel™

Contents

  1. Introduction

  2. Using this leaflet

  3. Descriptive Statistics

  4. Grouped Frequency Data

  5. Graphical Representations

  6. Permutations and Combinations

  7. Standard Probability Distributions

  8. Test Statistics for Popular Significance Tests

  9. Critical Values and P-values for Statistical Tests

  10. Confidence Limits

  11. Simple Linear Regression

  12. Correlation

  13. Rank Correlation

  14. Time Series

  15. Access to a spreadsheet that implements the above facilities.