Data Mining and Statistical Analysis Using SQL / Edition 1 by John Lovett, Robert P. Trueblood | | 9781893115545 | Paperback | Barnes & Noble
Data Mining and Statistical Analysis Using SQL / Edition 1

Data Mining and Statistical Analysis Using SQL / Edition 1

by John Lovett, Robert P. Trueblood
     
 

ISBN-10: 1893115542

ISBN-13: 9781893115545

Pub. Date: 09/18/2001

Publisher: Apress

This book is not just another theoretical text about statistics or data mining. No, instead it is aimed for database administrators who want to use SQL or bolster their 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

Overview

This book is not just another theoretical text about statistics or data mining. No, instead it is aimed for database administrators who want to use SQL or bolster their 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 Visual Basic procedure using SQL. Chapter contents include formulas, graphs, charts, tables, data mining techniques, and more!

Product Details

ISBN-13:
9781893115545
Publisher:
Apress
Publication date:
09/18/2001
Edition description:
2001
Pages:
410
Product dimensions:
7.52(w) x 9.25(h) x 0.36(d)

Table of Contents

Dedicationiii
About the Authorsiv
Introductionxi
Acknowledgmentsxvi
Chapter 1Basic Statistical Principles and Diagnostic Tree1
Categories of Data2
Sampling Methods2
Diagnostic Tree5
SQL Data Extraction Examples7
Chapter 2Measures of Central Tendency and Dispersion9
Measures of Central Tendency10
Mean10
Median12
Mode16
Geometric Mean17
Weighted Mean20
Measures of Dispersion22
Histogram Construction22
Range32
Standard Deviation33
Conclusion40
Chapter 3Goodness of Fit41
Tests of Hypothesis43
Goodness of Fit Test46
Fitting a Normal Distribution to Observed Data47
Fitting a Poisson Distribution to Observed Data62
Fitting an Exponential Distribution to Observed Data68
Conclusion71
T-SQL Source Code72
Make_Intervals73
Combine_Intervals74
Compare_Observed_And_Expected80
Procedure Calls82
Chapter 4Additional Tests of Hypothesis85
Comparing a Single Mean to a Specified Value88
Comparing Means and Variances of Two Samples94
Comparisons of More Than Two Samples101
Conclusion104
T-SQL Source Code105
Calculate_T_Statistic105
Calculate_Z_Statistic107
Compare_Means_2_Samples108
Contingency_Test113
Procedure Calls117
Chapter 5Curve Fitting119
Linear Regression in Two Variables121
Linear Correlation in Two Variables127
Polynomial Regression in Two Variables130
Other Nonlinear Regression Models136
Linear Regression in More Than Two Variables141
Conclusion147
T-SQL Source Code147
Linear_Regression_2_Variables148
Gaussian_Elimination150
Array_2D158
Polynomial_Regression160
Exponential_Model169
Multiple_Linear_Regression172
Procedure Calls179
Chapter 6Control Charting181
Common and Special Causes of Variation183
Dissecting the Control Chart193
Control Chorts for Sample Range and Mean Values195
Control Chart for Fraction Nonconforming206
Control Chart for Number of Nonconformities213
Conclusion215
T-SQL Source Code216
Sample_Range_and_Mean_Charts216
Standard_P_Chart219
Stabilized_P_Chart222
C_Chart224
Procedure Calls227
Chapter 7Analysis of Experimental Designs229
One-Way ANOVA231
Two-Way ANOVA238
ANOVA Involving Three Factors245
Conclusion260
T-SQL Source Code261
ANOVA261
Procedure Calls275
Chapter 8Time Series Analysis277
Simple Moving Average278
Single Exponential Smoothing286
Double Exponential Smoothing292
Incorporating Seasonal Influences300
Criteria for Selecting the Most Appropriate Forecasting Technique308
Conclusion311
T-SQL Source Code311
Simple Moving Average312
Weighted Moving Average315
Single Exponential Smoothing318
Double Exponential Smoothing322
Seasonal Adjustment327
Procedure Calls332
Appendix AOverview of Relational Database Structure and SQL337
Appendix BStatistical Tables359
Appendix CTables of Statistical Distributions and Their Characteristics373
Appendix DVisual Basic Routines381
Bibliography397
Index399

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >