http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FLinear_Regression_Functions%2FSTATS_T_TEST_ONE
Oracle PL/SQL Tutorial/Linear Regression Functions/STATS T TEST ONE - История изменений
2026-04-05T21:05:31Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Linear_Regression_Functions/STATS_T_TEST_ONE&diff=3466&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:46Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Linear_Regression_Functions/STATS_T_TEST_ONE&diff=3467&oldid=prev
Admin: 1 версия
2010-05-26T10:06:29Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== For degrees of freedom (DF): STATS_T_TEST_ONE(expr1, expr2, "DF")==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL><br />
SQL> -- create demo table<br />
SQL> create table myTable(<br />
2 id NUMBER(2),<br />
3 value NUMBER(6,2)<br />
4 )<br />
5 /<br />
Table created.<br />
SQL><br />
SQL> -- prepare data<br />
SQL> insert into myTable(ID, value)values (1,9);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (2,2.11);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (3,3.44);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (4,-4.21);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (5,10);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (6,3);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (7,-5.88);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (8,123.45);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (9,98.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (10,938.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (11,984.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (12,198.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (13,928.87);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (14,25.37);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (15,918.3);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (16,9.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (17,8.23);<br />
1 row created.<br />
SQL><br />
SQL> select * from myTable<br />
2 /<br />
ID VALUE<br />
---------- ----------<br />
1 9<br />
2 2.11<br />
3 3.44<br />
4 -4.21<br />
5 10<br />
6 3<br />
7 -5.88<br />
8 123.45<br />
9 98.23<br />
10 938.23<br />
11 984.23<br />
ID VALUE<br />
---------- ----------<br />
12 198.23<br />
13 928.87<br />
14 25.37<br />
15 918.3<br />
16 9.23<br />
17 8.23<br />
17 rows selected.<br />
SQL><br />
SQL><br />
SQL> SELECT STATS_T_TEST_ONE(value, 2, "DF") FROM myTable;<br />
STATS_T_TEST_ONE(VALUE,2,"DF")<br />
------------------------------<br />
16<br />
SQL><br />
SQL><br />
SQL><br />
SQL> -- clean the table<br />
SQL> drop table myTable<br />
2 /<br />
Table dropped.</source><br />
<br />
<br />
<br />
== For one-tailed significance level: STATS_T_TEST_ONE(expr1, expr2, "ONE_SIDED_SIG")==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL><br />
SQL> -- create demo table<br />
SQL> create table myTable(<br />
2 id NUMBER(2),<br />
3 value NUMBER(6,2)<br />
4 )<br />
5 /<br />
Table created.<br />
SQL><br />
SQL> -- prepare data<br />
SQL> insert into myTable(ID, value)values (1,9);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (2,2.11);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (3,3.44);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (4,-4.21);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (5,10);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (6,3);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (7,-5.88);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (8,123.45);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (9,98.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (10,938.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (11,984.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (12,198.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (13,928.87);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (14,25.37);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (15,918.3);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (16,9.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (17,8.23);<br />
1 row created.<br />
SQL><br />
SQL> select * from myTable<br />
2 /<br />
ID VALUE<br />
---------- ----------<br />
1 9<br />
2 2.11<br />
3 3.44<br />
4 -4.21<br />
5 10<br />
6 3<br />
7 -5.88<br />
8 123.45<br />
9 98.23<br />
10 938.23<br />
11 984.23<br />
ID VALUE<br />
---------- ----------<br />
12 198.23<br />
13 928.87<br />
14 25.37<br />
15 918.3<br />
16 9.23<br />
17 8.23<br />
17 rows selected.<br />
SQL><br />
SQL><br />
SQL> SELECT STATS_T_TEST_ONE(value, 2, "ONE_SIDED_SIG") FROM myTable;<br />
STATS_T_TEST_ONE(VALUE,2,"ONE_SIDED_SIG")<br />
-----------------------------------------<br />
.010545213<br />
SQL><br />
SQL><br />
SQL><br />
SQL> -- clean the table<br />
SQL> drop table myTable<br />
2 /<br />
Table dropped.</source><br />
<br />
<br />
<br />
== For two-tailed significance level: STATS_T_TEST_ONE(expr1, expr2, "TWO_SIDED_SIG")==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL><br />
SQL><br />
SQL> -- create demo table<br />
SQL> create table myTable(<br />
2 id NUMBER(2),<br />
3 value NUMBER(6,2)<br />
4 )<br />
5 /<br />
Table created.<br />
SQL><br />
SQL> -- prepare data<br />
SQL> insert into myTable(ID, value)values (1,9);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (2,2.11);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (3,3.44);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (4,-4.21);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (5,10);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (6,3);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (7,-5.88);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (8,123.45);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (9,98.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (10,938.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (11,984.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (12,198.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (13,928.87);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (14,25.37);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (15,918.3);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (16,9.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (17,8.23);<br />
1 row created.<br />
SQL><br />
SQL> select * from myTable<br />
2 /<br />
ID VALUE<br />
---------- ----------<br />
1 9<br />
2 2.11<br />
3 3.44<br />
4 -4.21<br />
5 10<br />
6 3<br />
7 -5.88<br />
8 123.45<br />
9 98.23<br />
10 938.23<br />
11 984.23<br />
ID VALUE<br />
---------- ----------<br />
12 198.23<br />
13 928.87<br />
14 25.37<br />
15 918.3<br />
16 9.23<br />
17 8.23<br />
17 rows selected.<br />
SQL><br />
SQL><br />
SQL> SELECT STATS_T_TEST_ONE(value, 2, "TWO_SIDED_SIG") FROM myTable;<br />
STATS_T_TEST_ONE(VALUE,2,"TWO_SIDED_SIG")<br />
-----------------------------------------<br />
.021090426<br />
SQL><br />
SQL><br />
SQL><br />
SQL> -- clean the table<br />
SQL> drop table myTable<br />
2 /<br />
Table dropped.</source><br />
<br />
<br />
<br />
== Stats_T_Test_One==<br />
<br />
<p>This function tests the mean of a population when the population variance is unknown.</p><br />
<p>This one-sample t-test returns one number.</p><br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL> -- create demo table<br />
SQL> create table myTable(<br />
2 id NUMBER(2),<br />
3 value NUMBER(6,2)<br />
4 )<br />
5 /<br />
Table created.<br />
SQL><br />
SQL> -- prepare data<br />
SQL> insert into myTable(ID, value)values (1,9);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (2,2.11);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (3,3.44);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (4,-4.21);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (5,10);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (6,3);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (7,-5.88);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (8,123.45);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (9,98.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (10,938.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (11,984.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (12,198.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (13,928.87);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (14,25.37);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (15,918.3);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (16,9.23);<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (17,8.23);<br />
1 row created.<br />
SQL><br />
SQL> select * from myTable<br />
2 /<br />
ID VALUE<br />
---------- ----------<br />
1 9<br />
2 2.11<br />
3 3.44<br />
4 -4.21<br />
5 10<br />
6 3<br />
7 -5.88<br />
8 123.45<br />
9 98.23<br />
10 938.23<br />
11 984.23<br />
ID VALUE<br />
---------- ----------<br />
12 198.23<br />
13 928.87<br />
14 25.37<br />
15 918.3<br />
16 9.23<br />
17 8.23<br />
17 rows selected.<br />
SQL><br />
SQL><br />
SQL> SELECT STATS_T_TEST_ONE(value, 2, "STATISTIC") FROM myTable;<br />
STATS_T_TEST_ONE(VALUE,2,"STATISTIC")<br />
-------------------------------------<br />
2.55728005<br />
SQL><br />
SQL><br />
SQL><br />
SQL> -- clean the table<br />
SQL> drop table myTable<br />
2 /<br />
Table dropped.</source></div>
Admin