Oracle PL/SQL Tutorial/Linear Regression Functions/STATS T TEST ONE

Материал из SQL эксперт
Перейти к: навигация, поиск

For degrees of freedom (DF): STATS_T_TEST_ONE(expr1, expr2, "DF")

   <source lang="sql">

SQL> 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_T_TEST_ONE(value, 2, "DF") FROM myTable; STATS_T_TEST_ONE(VALUE,2,"DF") 

                           16

SQL> SQL> SQL> SQL> -- clean the table SQL> drop table myTable 

 2  /

Table dropped.</source>


For one-tailed significance level: STATS_T_TEST_ONE(expr1, expr2, "ONE_SIDED_SIG")

   <source lang="sql">

SQL> 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_T_TEST_ONE(value, 2, "ONE_SIDED_SIG") FROM myTable; STATS_T_TEST_ONE(VALUE,2,"ONE_SIDED_SIG") 

                              .010545213

SQL> SQL> SQL> SQL> -- clean the table SQL> drop table myTable 

 2  /

Table dropped.</source>


For two-tailed significance level: STATS_T_TEST_ONE(expr1, expr2, "TWO_SIDED_SIG")

   <source lang="sql">

SQL> SQL> 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_T_TEST_ONE(value, 2, "TWO_SIDED_SIG") FROM myTable; STATS_T_TEST_ONE(VALUE,2,"TWO_SIDED_SIG") 

                              .021090426

SQL> SQL> SQL> SQL> -- clean the table SQL> drop table myTable 

 2  /

Table dropped.</source>


Stats_T_Test_One

This function tests the mean of a population when the population variance is unknown.

This one-sample t-test returns one number.



   <source lang="sql">

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_T_TEST_ONE(value, 2, "STATISTIC") FROM myTable; STATS_T_TEST_ONE(VALUE,2,"STATISTIC") 

                          2.55728005

SQL> SQL> SQL> SQL> -- clean the table SQL> drop table myTable 

 2  /

Table dropped.</source>

Источник — «http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Linear_Regression_Functions/STATS_T_TEST_ONE&oldid=3467»