, Excel, , .
MS l :
- - ;
- Analysis ToolPak VBA .
Analysis ToolPak - V , MS l , irosft Office. l . , Analysis ToolPak - V , , :
- - ;
- . 16.3 .
16.3
16.2 , .
: (Y ), MS Excel.
: Y' = 10,5386 + 0,563197 (d Y' = + b) R2=0,608373=60,84%.
, .
16.2
MS Excel
| R | 0,7800 | |||||
| R- | 0,6084 | |||||
| R- | 0,5692 | |||||
| 2,3436 | ||||||
| df | SS | MS | F | F | ||
| 85,3243 | 85,3243 | 15,5345 | 0,0028 | |||
| 54,9257 | 5,4926 | |||||
| 140,2500 | ||||||
| - | - | t- | - * | 95% | 95% | |
| 10,5836 | 2,1796 | 4,8558 | 0,0007 | 5,7272 | 15,4401 | |
| 0,563197 | 0,1429 | 3,9414 | 0,0028 | 0,2448 | 0,8816 | |
| * X, 0,0028 , 0,28%- , , 0563197. |
16.3 , Minitab .
16.3 Minitab
| : FO=10,6+0,563 DLH | |||||
| t- | P | ||||
| 10,584 | 2,180 | 4,86 | 0,000 | ||
| DLH | 0,5632 | 0,1429 | 3,94 | 0,003 | |
| s=2,344 | R-=60,8% | R- ()=56,9% | |||
| DF | SS | MS | F | P | |
| 85,324 | 85,324 | 15,53 | 0,003 | ||
| 54,926 | 5,493 | ||||
| 140,250 |
|
|
|
C . - . , . Y = + b. , ( ) .
MS l . , .
17. :
