Data Mining and Statistical Analysis Using SQL

  • 5h 38m
  • John N. Lovett, Jr., Robert P. Trueblood
  • Apress
  • 2001

This book is not just another theoretical text about statistics or data mining. No, instead it is aimed for you DBAs who want to use SQL, or bolster your understanding of statistics to support data mining and customer relationship management analytics.

Each chapter is self-contained, with examples tailored to real business applications. And each analysis technique will be expressed in a mathematical format for coding as either a database query or a VB procedure using SQL. Chapter contents include formulas, graphs, charts, tables, data mining techniques, and more!

About the Authors

John N. Lovett, Jr., is a senior engineering consultant at QuantiTech, Inc. and co-owner, with his anthropologist/archaeologist wife, Jane, of Falls Mill and Museum in Belvedere, Tennessee. He has a Ph.D. in industrial engineering, a master's degree in operations research, and a bachelor's degree in mathematics.

Robert P. Trueblood is an analyst at QuantiTech, Inc. He has a Ph.D. in computer science and applications, and taught at the university level for 18 years before transitioning into private industry. He enjoys designing and implementing systems in Visual Basic.

In this Book

  • Basic Statistical Principles and Diagnostic Tree
  • Measures of Central Tendency and Dispersion
  • Goodness of Fit
  • Additional Tests of Hypothesis
  • Curve Fitting
  • Control Charting
  • Analysis of Experimental Designs
  • Time Series Analysis