Practical Applications of Data Mining

172 Chapter 4 StatiStiCS for Data Mining

These queries will retrieve the regression equation (4.43), R

2

(4.44), and

the ANOVA table as shown in Table 4.17. Hence, we conclude that the line

is a good fit for the data. Other retrieved metadata is not of interest to us and

is ignored here. For the other example, of a regression model for tax on the

attributes area, age, feature, northeast, and corner with no custom built-in feature,

we may use the following queries:

(Query 19)

Build the linear regression model for dependent variable tax and independent

variables area, age, feature, northeast, and corner from table RmSale with no

custom built-in observations.

(SQL 19)

Create table reg_anova as select tax, reg area, age, feature, northeast, cor