Question

from the following information find the s.d of x,y sumx=235,sumy=250,sumx^2=6750, sumy^2=6840,n=10
​

Answer 1

Step-by-step explanation:

Linear regressions in EQL

Using the syntax described in this topic, you can produce linear regressions in EQL.

Using the following data set:

IDXY1603.12613.63623.846345654.1

The following simple formulation:

y = A + Bx

Can be expressed in EQL as:

RETURN Regression AS SELECT COUNT(ID) AS N, SUM(X) AS sumX, SUM(Y) AS sumY, SUM(X*Y) AS sumXY, SUM(X*X) AS sumX2, ((N*sumXY)-(sumX*sumY)) / ((N*sumX2)-(sumX*sumX)) AS B, (sumY-(B*sumX))/N AS A GROUP

With the result:

NsumXsumYsumXYsumX2BA5311.00000018.6000001159.70000019359.0000000.187838-7.963514

Using the regression results

For y = A + Bx:

DEFINE Regression AS SELECT COUNT(ID) AS N, SUM(X) AS sumX, SUM(Y) AS sumY, SUM(X*Y) AS sumXY, SUM(X*X) AS sumX2, ((N*sumXY)-(sumX*sumY)) / ((N*sumX2)-(sumX*sumX)) AS B, (sumY-(B*sumX))/N AS A GROUP RETURN Results AS SELECT Y AS Y, X AS X, Regression[].A + Regression[].B * X AS Projection ...

As a final step in the example above, you would need to PAGE or GROUP what could be a very large number of results.

Oracle® Endeca Server Query Language Reference · Version 2.3.0 · June 2012 · Rev. A

Copyright © 2003, 2012, Oracle and/or its affiliates. All rights reserved.