( Ctrl+Shift+E). . .
̳ ( Ctrl+Shift+D). ̳ .
3. г . ϳ ( Ctrl+Shift+F). . г .
ϳ {Ctrl+Shift+C) . г .
4. ϳ (Ctrl+Shift+G) ϳ ( ). ϳ (Ctrl+Shift+H) , , .
, , IIonnT.XLS. .
2
-
10*
. , , , .
, , , , , , 䳿 , ' . , , ' , () .
' , , , ', .
, , , , . . - - . .
|
|
|
. ' . , .
, . , , . ̳ , .
- . -
, , , , , . , -- , , .
- - , , . :
, ;
1,2,..., , .
- :
1) , ;
2) , ', , ;
3) ;
4) .
, . . 곭 , . ' . . , , , .
³ , ', , , , :
|
|
=-2 .
t . t>tpk, ' ( ).
t < t , 0.
|
|
|
, ' , .
' (, , 1 2 ). .
' -
|
, MS Excel .
MS Excel , .
(. 40).
, : '
1. , , .
2. 23, 24 ( ) ( , ), AVERAGE ().
2.1. 23 24 , , =AVERAGE (B2:B20), =AVERAGE (C2:C20).
2.2. D2 =2 $23, 2 =2 $24, 2- =D2 * 2, G2 =D2 * D2, = = 2 * 2.
2.3. , 3 20.
2.4. 볭 F21 . G21 21. 21, 21, D21, 21.
2.5. 25 , SQRT (). 25 =F21 / SQRT(G21*H21).
CORREL ().
|
|
Analysis ToolPak MS Office 97. , Tools > Add-Ins ' . - ' MS Excel. Analysis ToolPak Solver. (') ('). ( , chekbox on). - , .
3. 26. Insert > Function fx CORREL () Statistical ().
3.1. (2:20), (2:20).
3.2. () (26) .
4. 27 t- . - TINV ().
4.1. 28, tak -.
4.2. TINV Statistical ().
4.3. = - ( 0,95), ( - 2), 17, ().
|
|
|
4.4. (28) tak -. ^- ( 28) .
.
MS Excel , . 䳿:
1. D2 2 =2 * 2 =2 * 2 D3:D20, E3:E20.
41
в ί ˲Ͳί Ѳ
|
:
, ;
, ;
N .
|
346
|
|
|
, , \,..., , , '.
X , , X '. , .
|
= b + mlxl +m2x2 / 2 :
|
|
|
|
6. 2 ; LINEST . F2 ; Edit ( ).
7. Ctrl+Shift+Enter. - ( , ). .
' +\ , . , LINEST () , .
8.
, ,
:
| ' | |
| _2 | F2 |
| _1 | G2 |
| _ | 2 |
| G5 |
9. J2 = _2 * + _1 * + _0. J3:J20, .
10. , , , -. LINEST .
11. ij () t (^-). . F13 =F2/F3 G13:H13.
12. - TINV (). , . F14
|
|
|
=TINV(ABS(F13); )
G14:H14. ABS , TINV '.
- , ( ). , , (1, 2,..., ) ( + 1, + 2,...). ( , ), .
Ĵ), : { = f{t)) ,, : y-f{t) + zt.
|
:
27 =SQRT(B25/B24). 24 =H17/(G18-1) 2.
11. \ () /-, 29 . tak TINV.
12. 28 , =1/G18*Q17*100.
13. S2:T16 , .
14. , - , .
|
| . 37. ˳ |
.37 , 15 . .38 , ﳭ 3 .
:
1. Insert > Chart, ( Chart Wizard).
2. (Step 1 of 4) (Standard Types) (Custom Types). ' 䳭 (Lines).
3. . .
|
. 38. ˳
4. (Step 2 of 4) : Data Range ( ) Series (). ֳ , , , , , .
126
Date Range . Series in ( ) : (Rows, ) (Columns, ). Data Range , .
Series () Add () Remove () . ϳ Series Name Values, . Values , Name .
Category (X) axis labels ( X) , (, ). , X .
5. (step
of 4) 6
: Titles, Axes, Gridlines, Legend, Data Labels, Data Table.
.
|
|
|
ij , 䳭. Legend (): Show Legend ( ) , , Placement () , : Bottom , , Right , Left . Corner , .
( ). Titles (). Chart Title ( ) , Category (X) axis X, Value (Y) axis Y.
6. , (Step 4 of 4) : (As new Sheet, ) ' (As object in, ).
7. Finish ().
8. MS Excel . ', , ' Windows.
9. Chart, Ⳮ ' .
4 6
( ) , , .
MS Access . 糭 (shortcut) MS Access; Target ( ) MS Access, , C:\Msoff97\Office\Msaccess.exe. , , ,
C:\Msoff97\Office\Msaccess.exe C:\ARMMTP\ARMMTP97.MDB.
