For a one or two term course in introductory statistics using Excel. Appropriate for a variety of disciplines including mathematics, the social sciences, and business. This manual provides statistics students with a complete introduction to statistics using Excel. Its availability, easy-to-understand, basic spreadsheet operations, and analysis tools make Excel a superb software package to carry out statistical analyses in required core courses.
Table of Contents
1. Getting Started. 2. Entering, Saving, and Editing Information. 3. Formulas. 4. Frequency Distributions. 5. Descriptive Statistics. 6. Probability Distributions. 7. Testing Hypotheses about One Sample Means.
8. Testing Hypotheses about the Difference between Two Means. 9. Analysis of Variance. 10. Correlation. 11. Regression. 12. Cross Tabulations.