1.
()
:
¨ .
¨ .
1. .
2. .
3. () .
4. Microsoft Excel .
5. Excel .
6. .
7. , 5 6.
8. .
, , .. , . , , (). . , , , , . , , . , . () . .
, . . , . . . , .
|
|
.
(1)
:
.
, .
, , 1 .
1. .
, .. , (1) .
, .
. (2)
(. 1):
(3)
. , , , ..
, .
. 1.
, , ..
(4)
.
, , , , , .
, (4) . . . :
(5)
, , . Excel .
, Excel - . - . . . , , , , - .
1. , 2.
2.
, . | |||||||
1,45 | 1,32 | 1,20 | 1,14 | 1,10 | 1,06 | 1,04 |
, :
1. , (. .2). .2, : ( ) - ; ( ) - . : ( ); ( ); . , : - ; - ; - ; - .
|
|
.2.
2. 3.
3. .2
A | B | C | D | E | F | |
xi | xi2 | yi | fi(xi)=a0+a1xi+a2xi2 | ei=fi(xi)-yi | ei2 | |
=A2^2 | 1,45 | =$A$11+$B$11*A2+$C$11*B2 | =D2-C2 | =E2^2 | ||
ß | 1,32 | ß | ß | ß | ||
ß | 1,20 | ß | ß | ß | ||
ß | 1,14 | ß | ß | ß | ||
ß | 1,10 | ß | ß | ß | ||
ß | 1,06 | ß | ß | ß | ||
ß | 1,04 | ß | ß | ß | ||
S(a0,a1,a2)= | = (F2:F8) | |||||
a0 | a1 | a2 | e= | =(F9/7) | ||
.
1. ß 3 , , .
2. . .