Data Mining and Statistical Analysis Using SQL

Each chapter is independent and self-contained with examples that are tailored to business applications. Each analysis technique will be expressed in a mathematical format that lends itself to coding either as a database query or as a Visual Basic procedure using SQL.

Each chapter will include the following:

• Formulas (how to perform the required analysis)
• Numerical example using data from a database
• Data visualization and presentation options (graphs, charts, tables)
• SQL procedures for extracting the desired results
• Data mining techniques
• Separate database

This book is a perfect supplemental resource for a statistics course.

• Dedication iii
• About the Authors iv
• Introduction xi
• Acknowledgments Xvi
• Chapter 1 Basic Statistical Principles and Diagnostic Tree 1
• Chapter 2 Measures of Central Tendency and Dispersion 9
• Chapter 3 Goodness of Fit 41
• Chapter 4 Additional Tests of Hypothesis 85
• Chapter 5 Curve Fitting 119
• Chapter 6 Control Charting 181
• Chapter 7 Analysis of Experimental Designs 229
• Chapter 8 Time Series Analysis 277
• Appendix A Overview of Relational Database Structure and SOL 337
• Appendix B Statistical Tables 359
• Appendix C Tables of Statistical Distributions and Their Characteristics 373
• Appendix D Visual Basic Routines 381
• Bibliography 397
• Index 399