__________________________________________________
_____________
( )
:
________
: . -11 ___________ / ../
() (..)
:______________
:________
:
_____________ / ../
()
-
- ɻ
. / .. /
__ __________ 2012.
:
( )
-11 ..
( ) (...)
1. : .
2. : 11 X Y.
3. : , , (Microsoft Exel), , ( Turbo Pascal), , , , .
4. : .
: /____________/ / ../
() () (...)
: 08.09.2012
-
, , MS Excel Turbo Pascal v.7.0.
: 37 , 18 , 2 .
In this paper we present a solution to the problem, which is to determine the average temperature of heating the particles of the radius for different fillers, using MS Excel spreadsheet editor and a programming language Turbo Pascal v.7.0. is resulted.
The report contains: 37 pages of the text, 18 drawings, appendices and the bibliographic list from 2 points.
:
1. 充.5
2. 充..7
3. .........9
4. Microsoft Excel, 腅....12
|
|
5. ⅅ19
6. ꅅ...21
˅..22
7. ......23
8. TURBO PASCAL 7.0..24
9. 䅅..33
10. ...34
11. .....35
1. , , :
) ;
) ;
) .
2. .
3. ( ).
4. .
5. y x.
6. , .
7. α 1.
8. , , α 2.
9. Turbo Pascal.
10. , .
11. , .
( 1)
. NH4Cl.α1=0,05;α2=0,05.
1
3,1 | 1,2 |
1,5 | 1,3 |
1,1 | 1,4 |
0,7 | 1,5 |
0,5 | 1,6 |
0,4 | 1,7 |
0,2 | 1,9 |
0,15 | 2,0 |
0,1 | 2,2 |
0,05 | 2,3 |
0,02 | 2,5 |
0,01 | 2,7 |
3,0 |
, , Microsoft Excel Turbo Pascal 7.0.
( approximate-) , - . , , . , , .
() , , () , , . , . - . , ( ).
|
|
. , . , - , .
, , : , , , .
, .
, , , , .
, , ( ) , , Excel. , .
Turbo Pascal 7.0 , , Microsoft Excel 2003 Microsoft Office ; Microsoft World 2003 .
.
3.
. , :
:
(1)
, .
(2)
(3)
(3)
(3) :
(4)
(3) :
(5)
:
(6)
.
(6),
(7)
:
, (8)
, x y.
() :
(9)
(10)
(11)
(12)
(13)
m- x.
m=1, m=2.
:
(14)
(15)
:
(16)
F- :
(17)
:
(18)
:
(19)
. :
|
|
(20)
(21)
(22)
, Microsoft Excel, .
.2 .
.3. ().
:
1. A3:A16
2. B3:B16 x
3. C3 =B3^2
4. 4:16
5. D3 B3*A3
6. D4:D16
7. E3 B3^3
8. E4:E16
9. F3 =B3^4
10. F4:F16
11. G3 =B3^2*A3
12. G4:G16
13. H3 =LN(A3)
14. H4:H16
15. I3 =B3*LN(A3)
16. I4:I16
17. A3:A16
18. B3:B16 x
19. J3 =(B3-$B$19)*(A3-$A$19)
20. J4:J16
21. K3 =(B3-$B$19)^2
22. K4:K16
23. L3 =(A3-$A$19)^2
24. L4:L16
25. M3 =(A3-($E$26+$E$27*B3))^2
26. M4:M16
27. N3 =(A3-($F$40+$F$41*B3+$F$42*B3^2))^2
28. N4:N16
29. O3 ==(LN(A3)-$H$18)^2
30. O4:O16
31. P3 =(H3-(LN($E$56*EXP($E$55*B3))))^2
32. P4:P16
33. A17 =(A3:A16)
34. B17 =(B3:B16)
35. C17 =(C3:C16)
36. D17 =(D3:D16)
37. E17 =(E3:E16)
38. F17 =(F3:F16)
39. G17 =(G3:G16)
40. H17 =(H3:H16)
41. I17 =(I3:I16)
42. J17 =(J3:J16)
43. K17 =(K3:K16)
44. L17 =(L3:L16)
45. M17 =(M3:M16)
46. N17 =(N3:N16)
47. O17 =(O3:O16)
48. P17 =(P3:P16)
:
49. B18 =ר(B3:B16)
50. A19 =A17/$B$18
51. B19 =B17/$B$18
52. H18 =H17/$B$18
.4 .
.4 MS Excel .
53. A22 =$B$18
54. B22 =B17
55. A23 =B17
56. B23 =C17
57. C22 =A17
58. C23 =D17
59. A26:B27 =(A22:B23)
60. E26:E27 =(A55:B56;C51:C52)
61. E24 =J17/(K17*L17)^(1/2)
62. E25 =1-M17/17
63. B29 4,96 ( a=0,05,df=1 df2=12 .1 1.)
|
|
64. B30 =E25*(B18/2)-(1-E25)
65. B31 =M17/(B18-2)
66. B32 =((B31*C17)/(B18*K17)^(1/2)
67. B33 =(B3/K17)^(1/2)
68. C30 =(B30>B29; ; )
69. D31 2,201 ( a=0,05,df=1 df2=13 .2 2.)
70. D31 =ABS(E26)/B32
71. D33 = ABS(E27)/B33
72. F32 = =(D32>$D$31;"";" ")
73. F33 = =(D33>$D$31;"";" ")
:
y = -1,1498x + 2,84 (23)
, -, (23) .
.5 .
.5. MS Excel .
74. A35 =$B$18
75. A36 =B17
76. A35 C17
77. A37 =B17
78. B34 =C17
79. B35 =B17
80. B36 =C17
81. B37 =E17
82. C35 =C17
83. C36 =E17
84. C37 =F17
85. D35 =A17
86. D36 =D17
87. D37 =G17
88. A40:C42 {=(A35:C37)}
89. F40:F42 {=(A40:C42;D35:D37)}.
90. F38 =1-N17/L17
91. B44 5,12 ( a=0,05,df=1 df=11 .1 1.)
92. B45 =F38*(B18-3)/2(2*(1-F38)).
93. B46 =N17/(B18-3)
94. B47 =((N17/($B$18-3))*A40)^(1/2)
95. B48 =((N17/($B$18-3))*A41)^(1/2)
96. B49 =((N17/($B$18-3))*A42)^(1/2)
97. 45 =(B45>B44; ; ).
98. C45
99. D46 2,2281 ( a=0,05 df=12 .2 2.)
100. D47 =ABS(F40)/B47
101. C48 =ABS(F41)/B48
102. D49 =ABS(F42)/B49
103. F47 = =(D47>$D$46;"";" ")
104. F48 = =(D48>$D$46;"";" ")
105. F49 = =(D49>$D$46;"";" ")
:
y = 1,5998x2 - 7,7257x + 9,1069 (24)
, (24) . 2=0,891114 3= -7,59066E-05 , 1=0,197806347 . .
.6 .
.6. MS Excel .
106. A51 =$B$18
107. B51 =B17
108. A52 =B17
109. B52 =C17
110. C51 =H17
111. C52 = I17
112. 55:56 {=(51:52)}
113. E54:E55 {=(55:56;51:52)}
114. E56 =EXP(E54)
115. E53 =1-P17/O17
116. B58 = B29
117. B59 =E53*(B18-2)/(1-E53)
118. B60 =P17/(B18-2))
119. B61 = (P17/(($B$18-2)*K17))^(1/2).
120. B62 =((P17*C17)/(($B$18-2)*$B$*K17))^(1/2)
121. C59 = (B59>B58;" ";" ")
122. D60 =D31
123. D61 = ABS(E55)/B61
124. D62 =ABS(E56)/B62
|
|
125. F61 = (D61>$D$60;"";" ")
126. F62 = (D62>$D$60;"";" ")
(25)
- , (25) . , , .