# For within degrees of freedom (DF): STATS_ONE_WAY_ANOVA(expr1, expr2, 'DF_WITHIN') : STATS_ONE_WAY_ANOVA « Linear Regression Functions « Oracle PL/SQL Tutorial

Home
Oracle PL/SQL Tutorial
 1 Introduction 2 Query Select 3 Set 4 Insert Update Delete 5 Sequences 6 Table 7 Table Joins 8 View 9 Index 10 SQL Data Types 11 Character String Functions 12 Aggregate Functions 13 Date Timestamp Functions 14 Numerical Math Functions 15 Conversion Functions 16 Analytical Functions 17 Miscellaneous Functions 18 Regular Expressions Functions 19 Statistical Functions 20 Linear Regression Functions 21 PL SQL Data Types 22 PL SQL Statements 23 PL SQL Operators 24 PL SQL Programming 25 Cursor 26 Collections 27 Function Procedure Packages 28 Trigger 29 SQL PLUS Session Environment 30 System Tables Data Dictionary 31 System Packages 32 Object Oriented 33 XML 34 Large Objects 35 Transaction 36 User Privilege
 Oracle PL/SQL Tutorial » Linear Regression Functions » STATS_ONE_WAY_ANOVA
20.15.4.For within degrees of freedom (DF): STATS_ONE_WAY_ANOVA(expr1, expr2, 'DF_WITHIN')
 ```SQL> SQL> SQL> -- create demo table SQL> create table myTable(   2    id           NUMBER(2),   3    value        NUMBER(6,2)   4  )   5  / Table created. SQL> SQL> -- prepare data SQL> insert into myTable(ID,  value)values (1,9); 1 row created. SQL> insert into myTable(ID,  value)values (2,2.11); 1 row created. SQL> insert into myTable(ID,  value)values (3,3.44); 1 row created. SQL> insert into myTable(ID,  value)values (4,-4.21); 1 row created. SQL> insert into myTable(ID,  value)values (5,10); 1 row created. SQL> insert into myTable(ID,  value)values (6,3); 1 row created. SQL> insert into myTable(ID,  value)values (7,-5.88); 1 row created. SQL> insert into myTable(ID,  value)values (8,123.45); 1 row created. SQL> insert into myTable(ID,  value)values (9,98.23); 1 row created. SQL> insert into myTable(ID,  value)values (10,938.23); 1 row created. SQL> insert into myTable(ID,  value)values (11,984.23); 1 row created. SQL> insert into myTable(ID,  value)values (12,198.23); 1 row created. SQL> insert into myTable(ID,  value)values (13,928.87); 1 row created. SQL> insert into myTable(ID,  value)values (14,25.37); 1 row created. SQL> insert into myTable(ID,  value)values (15,918.3); 1 row created. SQL> insert into myTable(ID,  value)values (16,9.23); 1 row created. SQL> insert into myTable(ID,  value)values (17,8.23); 1 row created. SQL> SQL> select * from myTable   2  /         ID      VALUE ---------- ----------          1          9          2       2.11          3       3.44          4      -4.21          5         10          6          3          7      -5.88          8     123.45          9      98.23         10     938.23         11     984.23         ID      VALUE ---------- ----------         12     198.23         13     928.87         14      25.37         15      918.3         16       9.23         17       8.23 17 rows selected. SQL> SQL> SQL> SELECT STATS_ONE_WAY_ANOVA(id, value, 'DF_WITHIN') FROM myTable; STATS_ONE_WAY_ANOVA(ID,VALUE,'DF_WITHIN') -----------------------------------------                                         0 SQL> SQL> SQL> SQL> -- clean the table SQL> drop table myTable   2  / Table dropped.```
 20.15.STATS_ONE_WAY_ANOVA 20.15.1. For between sum of squares (SS): STATS_ONE_WAY_ANOVA(expr1, expr2,'SUM_SQUARES_BETWEEN') 20.15.2. For within sum of squares (SS): STATS_ONE_WAY_ANOVA(expr1, expr2, 'SUM_SQUARES_WITHIN') 20.15.3. For between degrees of freedom (DF): STATS_ONE_WAY_ANOVA(expr1, expr2, 'DF_BETWEEN') 20.15.4. For within degrees of freedom (DF): STATS_ONE_WAY_ANOVA(expr1, expr2, 'DF_WITHIN') 20.15.5. For mean square (MS) between: STATS_ONE_WAY_ANOVA(expr1, expr2, 'MEAN_SQUARES_BETWEEN') 20.15.6. For mean square (MS) within: STATS_ONE_WAY_ANOVA(expr1, expr2, 'SUM_SQUARES_WITHIN') 20.15.7. For F statistic: STATS_ONE_WAY_ANOVA(expr1, expr2, 'F_RATIO') 20.15.8. For significance level: STATS_ONE_WAY_ANOVA(expr1, expr2, 'SIG')