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 $0.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 Databases

Storytelling with Data

A Data Visualization Guide for Business Professionals, 10th Anniversary Edition

Python All-in-One For Dummies

3rd Edition

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Database Systems

A Practical Approach

Tools and Applications of Data Mining

Big Data Analytics

A Practical Guide

The Data Science and Psychology

Data Mining

Concepts, Techniques and Applications

SPSS Survival Manual

7th Edition - A step by step guide to data analysis using IBM SPSS

Building a Scalable Data Warehouse with Data Vault 2.0

The Art of Explanation

How to Communicate with Clarity and Confidence

Microsoft 365 Access For Dummies

Access for Dummies

Hands-On Programming with R

Write Your Own Functions and Simulations

Data Science for Business

What You Need to Know About Data Mining and Data-Analytic Thinking

Fundamentals of Database Systems, Global Edition

7th edition

Modern Data Analytics in Excel

Using Power Query, Power Pivot and More for Enhanced Data Analytics

Learning Data Science

Data Wrangling, Exploration, Visualization, and Modeling with Python

Interactively exploring high-dimensional data and models in R

1st Edition

Interactively exploring high-dimensional data and models in R

1st Edition

Data Analytics for Accounting ISE

3rd Edition

Artificial Intelligence for HR

Use AI to Support and Develop a Successful Workforce

Data Science from Scratch

First Principles with Python

Database Systems 6ed

A Practical Approach to Design, Implementation, and Management, Global Edition

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

This product is categorised by