y = f (x) 1:
1.
0.76 | 4.67 | 7.12 | 48.54 | 11.54 | 79.98 | 16.75 | 112.34 | 21.45 | 149.43 |
1.23 | 8.56 | 7.97 | 55.89 | 12.23 | 85.91 | 17.45 | 119.05 | 22.23 | 154.45 |
3.84 | 25.78 | 8.55 | 57.76 | 13.86 | 91.25 | 18.81 | 125.87 | 23.45 | 161.54 |
5.43 | 38.65 | 9.65 | 64.86 | 14.53 | 100.56 | 19.64 | 135.45 | 24.67 | 168.54 |
5.94 | 40.76 | 10.78 | 71.45 | 15.48 | 105.43 | 20.35 | 140.76 | 25.78 | 180.65 |
: , 1.
:
() , . , . , 1 , , y x .
2, Microsoft Excel.
2.
, 2.
1. A1:A25 .
2. B1:B25 .
3. C1 =A1^2.
4. C2:C25 .
5. D1 =A1*B1.
6. D2:D25 .
7. F1 =A1^4.
8. F2:F25 .
9. G1 =A1^2*B1.
10. G2:G25 .
11. H1 =LN(B1).
12. H2:H25 .
13. I1 =A1*LN(B1).
14. I2:I25 .
.
15. A26 =(A1:A25).
16. B26 =(B1:B25).
17. C26 =(C1:C25).
18. D26 =(D1:D25).
19. E26 =(E1:E25).
20. F26 =(F1:F25).
21. G26 =(G1:G25).
22. H26 =(H1:H25).
23. I26 =(I1:I25).
y = f (x) . (4). 2, A26, B26, C26 D26, (4)
(11)
, .
,
(12)
(11) , Microsoft Excel. 3.
3.
A34:B35 {=(A30:B31)}.
|
|
E34:E35 {=(A34:B35,C30:C31)}.
y = f (x) . (5). 2, A26, B26, C26, D26, E26, F26 G26 (5)
(13)
, ,
,
(14)
(13) , Microsoft Excel. 4.
4.
A43:C45 {=(A38:C40)}.
F43:F45 {=(A43:C45,D38:D40)}.
y = f (x) . , 2, A26, C26, H26 I26
(15)
.
(10) .
,
(16)
(15) , Microsoft Excel. 5.
5.
A52:B53 {=(A48:B49)}.
E51:E53 {=(A52:B53,C48:C49)}.
E53 =EXP(E51).
:
Microsoft Excel 6.
6.
B56 =A26/25.
B57 =B26/25.
7, 2.
7.
, 7 .
A1:A26 B1:B26 (. . 2).
.
1. J1 =(A1-$B$56)*(B1-$B$57).
2. J2:J25 .
3. K1 =(A1-$B$56)^2.
4. K2:K25 .
5. L1 =(B1-$B$57)^2.
6. L2:L25 .
7. M1 =($E$34+$E$35*A1-B1)^2.
8. M2:M25 .
9. N1 =($F$43+$F$44*A1+$F$45*A1^2-B1)^2.
10. N2:N25 .
11. O1 =($E$53*EXP($E$52*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).
(8) ( ) (10). Microsoft Excel 8.
8.
8 B59 =J26/(K26*L26)^(1/2).
B61 =1- M26/L26.
B63 =1- N26/L26.
|
|
B65 =1- O26/L26.
, .