.


:




:

































 

 

 

 


Microsoft Excel




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. , .




:


: 2015-05-07; !; : 1034 |


:

:

, .
==> ...

2425 - | 2220 -


© 2015-2024 lektsii.org - -

: 0.012 .