Oracle PLSQL Tutorial Linear Regression Functions 51 codes

1 For another equivalent test statistic

2 For average value of dependent (y) variables

3 For average value of independent (x) variables

4 For between degrees of freedom (DF)

5 For between sum of squares (SS)

6 For chi-square degrees of freedom

7 For chi-square significance level

8 For chi-square value

9 For degrees of freedom

10 For degrees of freedom (DF)

11 For F statistic

12 For mean square (MS) between

13 For mean square (MS) within

14 For one-tailed significance level

15 For other related test statistics

16 For significance level

17 For significance level for one-sided test

18 For significance level for two-sided test

19 For significance level of one-sided test

20 For significance level of two-sided test

21 For sum of cross-product xy

22 For sum of squares x

23 For sum of squares y

24 For the coefficient of determination (R-square)

25 For the number of observations

26 For the test statistic value

27 For the y-intercept of the line

28 For two-tailed significance level

29 For within degrees of freedom (DF)

30 For within sum of squares (SS)

31 REGR_AVGX returns the average of x after eliminating x and y pairs where either x or y is null

32 REGR_COUNT(salary, city) AS count

33 REGR_SLOPE(expr1, expr2) gives a least square regression line to a set of pairs of numbers

34 REGR_SYY(salary, city) AS syy

35 SELECT STATS_WSR_TEST(value, id, ONE_SIDED_SIG)

36 STATS_CROSSTAB(expr1, expr2, COHENS_K)

37 STATS_CROSSTAB(expr1, expr2, CONT_COEFFICIENT)

38 STATS_CROSSTAB(expr1, expr2, CRAMERS_V)

39 STATS_F_TEST(expr1, expr2, DF_DEN)

40 STATS_MODE(expr) returns the mode of a set of numbers

41 STATS_MW_TEST(expr1, expr2, STATISTIC)

42 STATS_T_TEST_INDEPU(expr1, expr2, STATISTIC)

43 Stats_T_Test_One

44 STATS_T_TEST_PAIRED(expr1, expr2, STATISTIC)

45 STATS_WSR_TEST(expr1, expr2, STATISTIC)

46 STDDEV([DISTINCT ALL] value) [OVER (analytic_clause)] returns the standard deviation value

47 STDDEV_SAMP(expr) [OVER(analytic_clause)] computes the cumulative sample standard deviation

48 Using the Linear Regression Functions

49 VAR_POP(expr) calculates the population variance

50 VAR_SAMP(expr) calculates the sample variance

51 VARIANCE([DISTINCT ALL] expr) gives the variance of all values of a group of rows