1 / 1 2011-12 .
4 :
- , , .. -, .. ,
- ()
- ( 1-4 Excel 2 , 3 4
- 5 (.. ),
- (, , ..)
- .
. MS Excel ( 1-4) , :
- MS Excel 2003, XP / // /
- MS Excel 2007-10 Office// / 2003
1. Excel :
) ,
) , .
(, )
Excel :
(<1>,<2>) , 1 2;
(<>) , ;
(<>) . .
X=A-1*B
, -1 , :
) Excel 1
) 4:6
) - E4:E6
) A9:11
) ( )
) A4:6, CTRL+SHIFT+ENTER
) E9:E11 ( )
) ( )
) A9:11 ( )
) E4:E6 ( )
) CTRL+SHIFT+ENTER. 20 , 4:6 ENTER
) / / ,
) 1 11
) 2, 1 .
- 2003, XP ///
- 2007-10 / /
) ) (.. ).
|
|
(.. 2- ).
2. Excel h . , , , 1/0, ln(-2) ..
[a; b] h .
.
: a, b, x. , x . [1, 2] h, a b 1, .. x=1 1(1+1×1)/(1-1), .. 2/0, .
, (=).
h | ||||
x | 0,05 | [1; 2] | ||
n | 0,05 | [2; 3] | ||
c | 0,05 | [1; 2] | ||
x | 0,05 | [0; 1] | ||
y | 0,05 | [0; 1] | ||
y | 0,05p | [p; 2p] | ||
x | 0,05p | [p/2; p] | ||
x | 0,05 | [0; 1] | ||
x | 0,05 | [0; 1] | ||
x | 0,05 | [1; 2] |
. 1. , , , , ( XP / / , 2007-10 / )
- :
- , (x, , n y, )
- 1- , , 8,
- , , (-), 2 .., (-3) (3*2) .. (, , 3)
2. exp(x) exp(-x) , x , x.
|
|
3. , 0,5, ^ ( =2^0,5+). , , , =(A3+2*B3)^0,5
( ):
1) 3 2
2) , ( , ), . . (cosx+2x)/ex [p; 2p] 0,4. =() p , ex ( / );
A | B | ||
1 | 2 | ||
2 | .___ | h | |
=() | =(s(A2)+ 2*A2))/exp(A2) | 0,4 | |
=2+$C$3 | =(s(A3)+ 2*A3))/exp(A3) | ||
=3+$C$3 | =(s(A4)+2*A4))/exp(A4) | ||
=4+$C$3 | =(s(A5)+2*A5))/exp(A5) | ||
=5+$C$3 | =(s(A6)+2*A6))/exp(A6) | ||
=6+$C$3 | =(s(A7)+2*A7))/exp(A7) | ||
=7+$C$3 | =(s(A8)+2*A8))/exp(A8) | ||
=8+$C$3 | =(s(A9)+2*A9))/exp(A9) | ||
, , , 6,28 = 2p.
3 4
3) 4 ( - - , 6,28 ); 1-10 , [a; b] h
4) 3, ;
5) , ( /) )
6) ), ), ) 1
7) 2 4;
8) , ( )/ ( 4 . ( ) 4.
3. Excel . -( N ) . N (, D3) ($ D$3).
, , , . . (.. ).
5 3.
1) , 2, 1
2) (2) //
3) , =. , 4 =3200,0+$D$3
4) 5- : 100 ( 100, //2 2007-10).
|
|
5) , , :
- ,
-
- 3:14 ENTER).
A | B | C | D | |
3 | ||||
% | N | |||
3205,7 | . | |||
=3200,0+N | ||||
=2100+N*2 | ||||
3254,3 | ||||
=2960,8 | ||||
=3000,8-N | ||||
=3090,1 | ||||
=3280-N/2 | ||||
3105,5 | ||||
=3250+N/3 | ||||
3190,7 | ||||
=3100+2*N | ||||
6) , .. , , 2,
7) 3 14 (.. ) , CRL, , , 3 14 ( ).
- 2003, ( /) )
- Excel 2007 / , 1
8) ), ), ), ) 1
8) 3 6.
4. (. ) . 1 2 1 3 (.. !).
4.
A | B | C | D | |
4 | ||||
N ( -) | ||||
17,5 | . | |||
17,8 | ||||
=18+N*1,5 | ||||
=16-N*1,5 | ||||
=27+N/2 | ||||
=N | =N*5 | |||
=15+2*N | =15+N/4 | |||
16,5 | ||||
19,7 | =38,3-N*5 | |||
=17-N/1,5 | 5,3 | |||
7,5 | ||||
4 3, 2 , . 1 - . :
1) - 7 , , / (!), 6,
- 7 4
- ( 2007- ) 1. 3:14 ( ) 3
- 3:14 ( ), CTRL 3:14, 3
|
|
2) ), ), ) ) 1
3) 4 8
5. (.. ) , , :
, ,
, , | , , | , , | , , | (16 ) | , , , | - | ||
0,11 | 0,082 | 0,08 | 0,1 | 0,07 | 0,56:16=0,035 | 0,0018 | 1,00 |
.
25
(N) | pi | log2(1/pi) | N*log2(1/pi) | ||
1 | 2 | 3 | 4 | 5 | 6 |
1 | 0,0018 | 9,117787378 | 9,117787378 | ||
2 | 0,082 | 3,60823228 | 7,21646456 | ||
2 | 0,082 | 3,60823228 | 7,21646456 | ||
2 | 0,1 | 3,321928095 | 6,64385619 | ||
1 | 0,035 | 4,83650127 | 4,83650127 | ||
2 | 0,1 | 3,321928095 | 6,64385619 | ||
2 | 0,035 | 4,83650127 | 9,673003 | ||
2 | 0,082 | 3,60823228 | 7,21646456 | ||
1 | 0,035 | 4,83650127 | 4,83650127 | ||
1 | 0,035 | 4,83650127 | 4,83650127 | ||
1 | 0,1 | 3,321928095 | 3,321928095 | ||
3 | 0,11 | 3,184424571 | 9,553273713 | ||
3 | 0,08 | 3,64385619 | 10,93156857 | ||
1 | 0,035 | 4,83650127 | 4,83650127 | ||
1 | 0,08 | 3,64385619 | 3,64385619 | ||
1 | 0,08 | 3,64385619 | 3,64385619 | ||
25 | 104,1683843 | 13,02 |
, , , 104,17 104,17:8 ()=13,02
1. . 2
2. pi
3. 4
4. 5 4 2
5. 5 ( )
6. 8,
7. - Excel, Excel () 2, 1/pi, () . 5 , . ( ) (=) 2 5. 5 8.
Excel .
1. , , , . , , (*)
2. . . ASCII. (*)
3. . , .
4. ( , , , ). (*)
5. . , , . (*)
6. . . . Windows. ( , , , , ). (*) . (*)
7. . Excel. Excel.
8. Excel. . Excel. .
|
|
9. , , , .
10. . (*)
11. .
12. .
13. , . .
14. . .
15. .
, (*), .
▼ 1. . / . : - 2005
▼2. .. . - -: - 2005, 2003
3. .. . . . .:-2003
▼4. .. . .: - 2002
, ▼, .