: g=0,95 a= 0,05.
4). () ( ) ; .
3.
1). ,
;
2).
Y , ; (e2:e81)
- , . (c2:c81). () 16.
, () . , . .
( 95%). R2 .
-. , , (.. b=0)
/ /
,
, .
, 
.
, y .
3). .
| 1 | ||||||||
| R | 0,698168 | |||||||
| R- | 0,487438 | |||||||
| R- | 0,458962 | |||||||
| 2,36666 | ||||||||
| 2 | ||||||||
| df | SS | MS | F | F | ||||
| 95,87757 | 95,87757 | 17,1177 | 0,000619 | |||||
| 100,8194 | 5,601079 | |||||||
| 196,697 | ||||||||
| 3 | ||||||||
| t- | P- | 95% | 95% | 95,0% | 95,0% | |||
| Y- | 3,76939 | 0,533002 | 7,071996 | 1,35E-06 | 2,649594 | 4,889187 | 2,649594 | 4,889187 |
| X(:0;1) | 2,251956 | 0,544299 | 4,137354 | 0,000619 | 1,108427 | 3,395485 | 1,108427 | 3,395485 |
|
|
|
4.
. Excel, .
(2 )
| df | SS | MS | F | |
| df=1 | SS= 
| MS= SS/df | 
| |
| dfoc=n-2 | SSoc= 
| MSoc= SSoc/ dfoc | ||
| Df=n-1 | SS= 
| MS= SS/ df |
:
- ;
- ;
- ( );
- ;
- ();
- , .
. , . , ( ) (n-1) , .. 
, 
,, 
n-1, , n . Þ . = . SS .
2 .
:
= + 
,
- ;
- ();
- ,
.. Y , . , , , , .. .
, SS , SSoc ( ). 
1 ( ):
SS>> SSoc, ();
SS< SSoc, ();
|
|
|
, (MS) (MS), F- (F-), :
Fp= 
, MS - , .
MS ;
F- - FT n1 (dfp) n2 (df).
2 ( ):
F>F, ( , );
F<F, . .
(1 )
| R | R= 
|
| R- | R2= 
|
| R- | |
| n |
, :
R2 ,
, , (SSp) (SScp).
R - , . :
R =
Y 
. , .
, R2 1, SSoc= 
0.
( R2):
1. R=1 , .. .
2. R=0 @ 0 , .
3. 0.3< R £ 0.5
0.5 < R £ 0.7 -
R > 0.7 -
3 .
:
1 ;
2 ;
3 Y;
4 Excel a b ().
, :
- ;
- ;
- .
, (, , -). . :
- ( );
- ;
- ;
- .
 |
