Data Mining and Statistical Analysis Using SQL by Robert P. Trueblood, John N. Lovett Jr. (auth.)

By Robert P. Trueblood, John N. Lovett Jr. (auth.)

This booklet is not only one other theoretical textual content approximately information or information mining. No, as an alternative it really is aimed for database directors who are looking to use SQL or bolster their figuring out of records to help facts mining and buyer dating administration analytics.

Each bankruptcy is self-contained, with examples adapted to actual enterprise purposes. and every research method should be expressed in a mathematical layout for coding as both a database question or a visible uncomplicated process utilizing SQL. bankruptcy contents comprise formulation, graphs, charts, tables, information mining recommendations, and more!

Show description

Read or Download Data Mining and Statistical Analysis Using SQL PDF

Best mining books

Air and Gas Drilling Manual

Be ready for drilling's most popular pattern in keeping with the U. S. division of strength, by way of 2005, 30% of all wells may be drilled utilizing gasoline and air. The Air and fuel Drilling handbook, via William Lyons -- an the world over identified professional and holder of 9 drilling patents -- lays out every thing you must observe air and fuel drilling to all types of operations, from the main simple to the main advanced, and for the shallowest to the inner most.

Well Completion Design

Completions are the conduit among hydrocarbon reservoirs and floor amenities. they seem to be a basic a part of any hydrocarbon box improvement undertaking. The must be designed for correctly maximising the hydrocarbon restoration from the good and will need to final for a few years below ever altering stipulations.

Changing Barnsley: From Mining Town to University Town

Altering Barnsley appears at how Barnsley has advanced, in the course of the eyes of the previous Mining and Technical collage on Church road, which now hosts Barnsley's personal collage. overlaying the seventy five years of its life, it tracks the interval from 1932, while the construction used to be first equipped, till 2007, whilst the collage used to be totally up and operating.

Extra info for Data Mining and Statistical Analysis Using SQL

Example text

08 Table 2-7. 07 We can calculate the weighted mean by executing Query 2_14. Observe how the Sum function was used twice--once in the numerator and again in the denominator. To obtain the percentage, we multiply by 100. 55% and it shows the average increase in the total costs of running the business. 21 Chapter2 John's Jewels If Only More Than Half Were Above the Median Once I was talking with a high school counselor. " "Yes, that would make sense," I thought to myself. "If we could only get more students above the median, I think we would be in a better placement position," he concluded.

The reason is that it resets the counter to one; otherwise, the counter continues to increment from its last value. 15 Chapter2 John's Jewels Mean or Median? When my students asked me when a median was a better measure of "average" than a mean, I offered the exam score example. It goes something like this: Now suppose I graded your exams, and the scores generally ranged from the 70s through the 90s, but one poor devil made a 15%. Now if you asked me the average score, I could quote the mean, but it would be somewhat biased, or artificially low, due to the "outlier" score of 15.

A visual inspection of the histogram indicates that the mean most likely falls between 19 and 22, in the highest bar, since the shape is relatively symmetric (or "mirrored") around this bar. 85 or about 20. The data are dispersed between 4 and 29. We can determine the extent of either the absolute dispersion or the average dispersion, by employing two new statistical concepts presented below. Before we do, however, let's use SQL to generate the histogram. ,... ~ E z= 12 8 4 0 5 1 [4-7) 0 [7-10) 1 [10-13) [13-16) (16-19) [19-22) [22-25) [25-28) [28-31) Stock Price ($) Figure 2-2.

Download PDF sample

Rated 4.90 of 5 – based on 23 votes