y=f(x) 1 1
.
|
|
|
|
|
|
|
|
|
|
12.85
| 154.77
| 9.65
| 81.43
| 7.74
| 55.86
| 5.02
| 24.98
| 1.86
| 3.91
|
12.32
| 145.59
| 9.63
| 80.97
| 7.32
| 47.63
| 4.65
| 22.87
| 1.76
| 3.22
|
11.43
| 108.37
| 9.22
| 79.04
| 7.08
| 48.03
| 4.53
| 20.32
| 1.11
| 1.22
|
10.59
| 100.76
| 8.44
| 61.76
| 6.87
| 36.85
| 3.24
| 9.06
| 0.99
| 1.10
|
10.21
| 98.32
| 8.07
| 60.54
| 5.23
| 25.65
| 2.55
| 6.23
| 0.72
| 0.53
|
- - , , 1.
. ,
. 2, Microsoft Excel. 2
. 2 . 1. A2:A26
. 2. B2:B26
. 3. C2 =A2^2. 4. C3:C26 . 5. D2 =A2*B2. 6. D3:D26 . 7. F2 =A2^4. 8. F3:F26 . 9. G2 =A2^2*B2. 10. G3:G26 . 11. H2 =LN(B2). 12. H3:H26 . 13. I2 =A2*LN(B2). 14. I3:I26 .
. 15. A27 =(A2:A26). 16. B27 =(B2:B26). 17. C27 =(C2:C26). 18. D27 =(D2:D26). 19. E27 =(E2:E26). 20. F27 =(F2:F26). 21. G27 =(G2:G26). 22. H27 =(H2:H26). 23. I27 =(I2:I26).
.
2, A27, B27, C27 D27,
,
. ,
. , Microsoft Excel. 3.
3
. 3 A37:B38 {=(A33:B34)}. {=(A33:B34) Ctrl+Shift+Enter D37:D38 {=(A37:B38;C33:C34)}.
.
,
2, A27, B27, C27, D27, E27, F27 G27
,
,
. ,
. , Microsoft Excel. 4.
4
. 4 E38:G40 {=(E33:G35)}. I38:I40 {=(E38:G40;H33:H35)}.
.
2, A27, C27, H27 I27
. ,
,
.
. ,
. , Microsoft Excel. 5. 5
. 5 D45:E46 {=(D42:943)}. G45:G46 {=(D45:E46;F42:F43)}. G47 =EXP(G45).
:
Microsoft Excel 6.
X Y. F49 =A26/25. F50 =B26/25. , 7, 2. 7
. 7 . A2:A27 B2:B27 (. . 2). . 1. J2 =(A2-$F$49)*(B2-$F$50). 2. J3:J26 . 3. K2 =(A2-$F$49)^2. 4. K3:K26 . 5. L2 =(B2-$F$50)^2. 6. L3:L26 . 7. M2 =($D$37+$D$38*A2-B2)^2. 8. M3:M26 . 9. N2 =($I$38+$I$39*A2+$I$40*A2^2-B2)^2. 10. N3:N26 . 11. O2 =($G$47*EXP($G$46*A2)-B2)^2. 12. O3:O26 .
. 13. J27 =(J2:J26). 14. K27 =(K2:K26). 15. L27 =(L2:L26). 16. M27 =(M2:M26). 17. N27 =(N2:N26). 18. O27 =(O2:O26).
( )
. Microsoft Excel 8. 8
. 8 D53 =J27/(K27*L27)^(1/2). D54 =1- M27/L27. D55 =1- N27/L27. D56 =1- O27/L27. , .