3
A50:C52 {=(A45:C47)}.
F50:F52 {=(A50:C52,D45:D47)}.
. 2, A26, C26, H26 I26 :
.
, , .
.
,
.
, Microsoft Excel.
.
4
A63:B64 {=(A59:B60)}.
E62:E63 {=(A63:B64,C59:C60)}.
E64 =EXP(E62).
:
Microsoft Excel.
X Y.
5
B66 =A26/25.
B67 =B26/25.
, 6, 1.
6
1. J1 =(A1-$B$54)*(B1-$B$55).
2. J2:J25 .
3. K1 =(A1-$B$54)^2.
4. K2:K25 .
5. L1 =(B1-$B$55)^2.
6. L2:L25 .
7. M1 =($E$32+$E$33*A1-B1)^2.
8. M2:M25 .
9. N1
=($F$41+$F$42*A1+$F$43*A1^2-B1)^2.
10. N2:N25 .
11. O1
=($E$51*EXP($E$50*A1)-B1)^2.
12. O2:O25 .
13. J26 =(J1:J25).
14. K26 =(K1:K25).
15. L26 =(L1:L25).
16. M26 =(M1:M25).
17. N26 =(N1:N25).
18. O26 =(O1:O25).
( )
.
.
7
69 =J26/(K26*L26)^(1/2).
B71 =1- M26/L26.
B73 =1- N26/L26.
B75 =1- O26/L26.
, .
Microsoft Excel. 1:25, (), , . , . . , .
|
|
8
9
10
8-10, , , . , 0,990 1.
, , , , Microsoft Excel.
11
Microsoft Excel ( ) . .
MathCAD
. , , (, , ), (). , .
1.
MathCAD Y :
intercept(X,Y) 1, ;
slope(X,Y) a2, .
y(x) = = a1+a2*x.
corr(Y,y(x)) . 1, .
2.
n MathCAD :
regress(X,Y,n) S, ai n- ;
ai S submatrix(S, 3, length(S)-1, 0, 0).
y(x) = = a1+a2*x+a3*x2
3.
, MathCAD. expfit(X,Y,S), , a1, a2 a3 y(x) = a1exp(a2x) + a3. S a1, a2 a3 .
MathCAD
|
|
12
MathCAD
13
( MathCAD
14
, MathCAD , Excel, . 0,995. :
Excel ( ) | Excel ( ) | Excel () | MathCAD | |
0,99047263 | 0,990 | 0,0990 | 0,995 | |
0,99063894 | 0,990 | 0,995 | ||
0,52482597 | 0,723 | 0,995 |
3
1. .. Windows 95 . - .: "", 1995.
2. . . .. . .: , 1991.
3. A., Excel 97 . : , 1997.
4. ., . - .: ..., 1996.
5. : . - . . .. , .. . , 1999