Data Mining & Statistical Analysis Using SQL

Description

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!

FEATURES:

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

CONTENTS:

Preface

 

* Chapter 1: Diagnostic Tree: How to approach your data.

* Chapter 2: Measures of Central Tendency and Dispersion

* Chapter 3: Goodness of Fit

* Chapter 4: Additional Tests of Hypothesis

* Chapter 5: Curve Fitting

* Chapter 6: Control Charting

* Chapter 7: Analysis of Variance

* Chapter 8: Time Series Analysis

Appendices

 

* Overview of Relational Databases and SQL

* Statistical Tables Referenced In This Book

* Various Statistical Distributions

* Visual Basic Routines For Performing Statistical Calculations