Request for consultation
Your form is submitting...
Overview
Learning Statistics and EXCEL in Tandem shows how to solve most statistical business problems taught in an introductory statistics subject using the Microsoft EXCEL spreadsheet software. The major difference between this book and other EXCEL books is that, before using EXCEL for an application, in this book, we discuss the selection of the appropriate statistical technique required to solve the problem. In other words, the aim of the book is to teach in tandem the appropriate statistical techniques as well as the use of EXCEL to execute them. In this sense, this book may be used as a stand-alone book by managers and analysts who have knowledge in statistics. However, those with no statistics knowledge should use this as a supplement to a statistics textbook. Learning Statistics and EXCEL in Tandem is primarily designed to cater for undergraduate students enrolled in a statistics subject. The book is also useful for postgraduate students as well as managers and analysts in analysing their day-to-day basic statistical problems using EXCEL.
This customised eBook has been created with the content you need for your studies. Due to the process used to produce this customised eBook, it doesn’t offer the same functionality available in other Cengage eBooks, including read aloud and copy text.
1. Introduction to Microsoft EXCEL
2. Data entry and data manipulation
Part 2: Descriptive statistics and probability theory
3. Graphical descriptive methods: Summarising data in tables
4. Numerical descriptive measures: Summary statistics
5. Probability
6. Discrete probability distributions
7. Continuous probability distributions
Part 3. Statistical inference
8. Sampling and sampling distributions
9. Interval estimation: Describing a single population
10. Interval estimation: Comparing two populations
11. Hypothesis testing: Describing a single population
12. Hypothesis testing: Comparing two populations
13. Inference about population variances
Part 4. Applications
14. Analysis of variance
15. Correlation and regression analysis
16. Index numbers