Data Mining & Statistical Analysis Using SQL

By: Robert Trueblood, John N. Jr. Lovett

Write A Review

Paperback | 18 September 2001

At a Glance

Paperback
436 Pages

Dimensions(cm)
22.86 x 18.42 x 3.18

Paperback

RRP $74.99

$74.75

or 4 interest-free payments of $18.69 with

Ships in 5 to 10 business days

This book is not just another theoretical text on statistics or data mining. Instead, it's designed for DBAs, database administrators, who want to buttress their understanding of statistics to support data mining and customer relationship management analytics and who want to use SQL, Structured Query Language. Each chapter is independent and self-contained with examples tailored to business applications. Each analysis technique is 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 includes: 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, and data mining techniques.About the authors: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 going into private industry. He enjoys designing and implementing systems in Visual Basic.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, TN. He has a Ph.D. in industrial engineering, with a BS in mathematics and MS in operations research.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Databases Data Mining Engineering & Technology Electronics & Communications Engineering Electronics Engineering Automatic Control Engineering Data Warehousing Mathematics Probability & Statistics Computer Programming & Software Development

Programming & Scripting Languages Database Programming Compilers & Interpreters Database Software Data Capture & Analysis Software Engineering

Dedication	p. iii
About the Authors	p. iv
Introduction	p. xi
Acknowledgments	p. xvi
Basic Statistical Principles and Diagnostic Tree	p. 1
Categories of Data	p. 2
Sampling Methods	p. 2
Diagnostic Tree	p. 5
SQL Data Extraction Examples	p. 7
Measures of Central Tendency and Dispersion	p. 9
Measures of Central Tendency	p. 10
Mean	p. 10
Median	p. 12
Mode	p. 16
Geometric Mean	p. 17
Weighted Mean	p. 20
Measures of Dispersion	p. 22
Histogram Construction	p. 22
Range	p. 32
Standard Deviation	p. 33
Conclusion	p. 40
Goodness of Fit	p. 41
Tests of Hypothesis	p. 43
Goodness of Fit Test	p. 46
Fitting a Normal Distribution to Observed Data	p. 47
Fitting a Poisson Distribution to Observed Data	p. 62
Fitting an Exponential Distribution to Observed Data	p. 68
Conclusion	p. 71
T-SQL Source Code	p. 72
Make_Intervals	p. 73
Combine_Intervals	p. 74
Compare_Observed_And_Expected	p. 80
Procedure Calls	p. 82
Additional Tests of Hypothesis	p. 85
Comparing a Single Mean to a Specified Value	p. 88
Comparing Means and Variances of Two Samples	p. 94
Comparisons of More Than Two Samples	p. 101
Conclusion	p. 104
T-SQL Source Code	p. 105
Calculate_T_Statistic	p. 105
Calculate_Z_Statistic	p. 107
Compare_Means_2_Samples	p. 108
Contingency_Test	p. 113
Procedure Calls	p. 117
Curve Fitting	p. 119
Linear Regression in Two Variables	p. 121
Linear Correlation in Two Variables	p. 127
Polynomial Regression in Two Variables	p. 130
Other Nonlinear Regression Models	p. 136
Linear Regression in More Than Two Variables	p. 141
Conclusion	p. 147
T-SQL Source Code	p. 147
Linear_Regression_2_Variables	p. 148
Gaussian_Elimination	p. 150
Array_2D	p. 158
Polynomial_Regression	p. 160
Exponential_Model	p. 169
Multiple_Linear_Regression	p. 172
Procedure Calls	p. 179
Control Charting	p. 181
Common and Special Causes of Variation	p. 183
Dissecting the Control Chart	p. 193
Control Chorts for Sample Range and Mean Values	p. 195
Control Chart for Fraction Nonconforming	p. 206
Control Chart for Number of Nonconformities	p. 213
Conclusion	p. 215
T-SQL Source Code	p. 216
Sample_Range_and_Mean_Charts	p. 216
Standard_P_Chart	p. 219
Stabilized_P_Chart	p. 222
C_Chart	p. 224
Procedure Calls	p. 227
Analysis of Experimental Designs	p. 229
One-Way ANOVA	p. 231
Two-Way ANOVA	p. 238
ANOVA Involving Three Factors	p. 245
Conclusion	p. 260
T-SQL Source Code	p. 261
ANOVA	p. 261
Procedure Calls	p. 275
Time Series Analysis	p. 277
Simple Moving Average	p. 278
Single Exponential Smoothing	p. 286
Double Exponential Smoothing	p. 292
Incorporating Seasonal Influences	p. 300
Criteria for Selecting the Most Appropriate Forecasting Technique	p. 308
Conclusion	p. 311
T-SQL Source Code	p. 311
Simple Moving Average	p. 312
Weighted Moving Average	p. 315
Single Exponential Smoothing	p. 318
Double Exponential Smoothing	p. 322
Seasonal Adjustment	p. 327
Procedure Calls	p. 332
Overview of Relational Database Structure and SQL	p. 337
Statistical Tables	p. 359
Tables of Statistical Distributions and Their Characteristics	p. 373
Visual Basic Routines	p. 381
Bibliography	p. 397
Index	p. 399
Table of Contents provided by Syndetics. All Rights Reserved.

Data Mining & Statistical Analysis Using SQL

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Software Engineering

Mobile and Ubiquitous Systems: Computing, Networking and Services

22nd EAI International Conference, MobiQuitous 2025, Shanghai, China, November 7-9, 2025, Proceedings, Part I

The Essence of Software Engineering

Design Patterns

Elements of Reusable Object-Oriented Software

Building Microservices

Designing Fine-Grained Systems 2nd Edition

The Manager`s Path

A Guide for Tech Leaders Navigating Growth and Change

Code

2nd Edition - The Hidden Language of Computer Hardware and Software

Git : Pocket Guide

A Working Introduction

Coding All-in-One For Dummies

2nd Edition

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

Refactoring 2ed

Improving the Design of Existing Code

Swim Training Patterns

1st Edition - Plan your Training Sessions with the Power of Mathematics

Hacking For Dummies

For Dummies (Computer/Tech)

Architecture Patterns with Python

Enabling Test-Driven Development, Domain-Driven Design, and Event-Driven Microservices

Arduino for Dummies

Blackwell Philosophy Anthologies

User Story Mapping

Discover the Whote Story, Build the Right Product

Site Reliability Engineering

How Google Runs Production Systems

Web Application Security

2nd Eidtion - Exploitation and Countermeasures for Modern Web Applications

The Engineering Leader

Strategies for Scaling Teams and Yourself

C# 12 Pocket Reference

Instant Help for C# 12 Programmers

Go Cookbook

Expert Solutions for Commonly Needed Go Tasks

Typescript Cookbook

Real World Type-Level Programming

C# 12 in a Nutshell

The Definitive Reference

Learning Modern C++ for Finance

Foundations for Quantitative Programming

Learning Algorithms

A Programmer's Guide to Writing Better Code

This product is categorised by