Using the Linear Regression Functions : Introduction « Linear Regression Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Linear Regression Functions
  3. Introduction

Linear regression functions fit an ordinary-least-squares regression line to a set of number pairs.

You can use the linear regression functions as aggregate, windowing, or reporting functions.

The following table shows the linear regression functions.

In the function syntax, y is interpreted by the functions as a variable that depends on x.

FunctionDescription
REGR_AVGX(y, x)Returns the average of x after eliminating x and y pairs where either x or y is null.
REGR_AVGY(y, x)Returns the average of y after eliminating x and y pairs where either x or y is null.
REGR_COUNT(y, x)Returns the number of non-null number pairs that are used to fit the regression line.
REGR_INTERCEPT(y, x)Returns the intercept on the y-axis of the regression line.
REGR_R2(y, x)Returns the coefficient of determination, or R-squared, of the regression line.
REGR_SLOPE(y, x)Returns the slope of the regression line.
REGR_SXX(y, x)Returns REG_COUNT(y, x) * VAR_POP(x).
REGR_SXY(y, x)Returns REG_COUNT(y, x) * COVAR_POP(y, x).
REGR_SYY(y, x)Returns REG_COUNT(y, x) * VAR_POP(y).


Quote from:

Oracle Database 10g SQL (Osborne ORACLE Press Series) (Paperback)

# Paperback: 608 pages

# Publisher: McGraw-Hill Osborne Media; 1st edition (February 20, 2004)

# Language: English

# ISBN-10: 0072229810

# ISBN-13: 978-0072229813

20.1.Introduction
20.1.1.Using the Linear Regression Functions