, MS Excel, , .
2.1. ?
2.2. .
2.3. ?
2.4. MS Excel?
2.5. ?
2.6. ?
2.7. ?
2.8. .
2.9. ?
2.10. MS Excel?
2.11. ?
2.12. .
2.13. .
2.14. MS Excel.
2.15. ?
2.16. ?
2.17. MS Excel
2.18. MS Excel?
2.19. MS Excel?
2.20. , .
1.
1 .
1. .
2. .
3. .
4. .
5. .
6. .
7. .
8. .
9. .
10. X3.
11. .
, .
. 1.
. | X1 | X2 | X3 | X4 | X5 | X6 | X7 |
0,1517 | 0,2341 | 0,4451 | 0,9813 | 0,2341 | 0,1496 | 0,6308 | |
1,2237 | 1,4317 | 1,9311 | 1,2237 | 1,4613 | 1,9773 | 1,1698 | |
2,1563 | 2,2416 | 2,1563 | 2,8113 | 2,9224 | 2,3348 | 2,6313 | |
3,8317 | 3,5142 | 3,0580 | 3,1703 | 3,0580 | 3,6812 | 3,5556 | |
4,1122 | 4,2211 | 4,1112 | 4,1551 | 4,1238 | 4,1122 | 4,1233 | |
5,1552 | 5,1463 | 5,1272 | 5,1481 | 5,1463 | 5,5336 | 5,2234 | |
6,5530 | 6,5011 | 6,3088 | 6,4057 | 6,3088 | 6,9907 | 6,0306 | |
7,0803 | 7,1193 | 7,9111 | 7,9422 | 7,1193 | 7,5462 | 7,9936 | |
8,5118 | 8,6157 | 8,7188 | 8,7919 | 8,8834 | 8,8463 | 8,5118 | |
9,1161 | 9,1081 | 9,1183 | 9,1156 | 9,1389 | 9,1518 | 9,1183 | |
10,1553 | 10,1148 | 10,2112 | 10,2814 | 10,2814 | 10,1144 | 10,5534 | |
11,4610 | 11,4513 | 11,4895 | 11,4399 | 11,9915 | 11,4895 | 11,5863 | |
12,1134 | 12,1242 | 12,1388 | 12,1516 | 12,5544 | 12,1242 | 12,8194 | |
13,4851 | 13,5182 | 13,8498 | 13,9552 | 13,4851 | 13,8216 | 13,9437 | |
14,1594 | 14,7531 | 14,2589 | 14,9637 | 14,7531 | 14,1236 | 14,6548 | |
15,8523 | 15,5378 | 15,9786 | 15,9786 | 15,1954 | 15,1582 | 15,0324 |
|
|
.
.
2.
2. .
2, .
.
, 60 .
.
, 179 , 183 .
, 53 .
.
.
. 2
A | B | C | D | |
3.
. 3, :
k1 |
k2 |
k3 |
k4 |
k5 |
> k6, < k7 |
() , >k8 |
k1- k8 4.
.3
Volkswagen | Rabbit DL | 21,5 | ||||
Mazda | RX-7 GS | 12,5 | ||||
Chevrolet | MonteCarlo | 13,2 | ||||
Buick | RegalTurbo | 13,4 | ||||
Ford | Futura | 11,2 | ||||
Volkswagen | Dasher | 23,7 | ||||
Chrysler | Lebaron | |||||
Mazda | GLCDeluxe | 19,4 | ||||
Toyota | Starlet | 16,9 | ||||
Buick | Estate SW | 14,9 | ||||
Toyota | Corona | 14,2 | ||||
Volvo | 264GL | 13,6 | ||||
Mercedes | 300D | 20,1 | ||||
Cadillac | Eldorado | 17,4 | ||||
Nissan | Accord | 14,5 | ||||
Honda | Corolla | 14,5 |
.4
k1 | k2 | k3 | k4 | k5 | k6 | k7 | k8 | |
Buick | Volkswagen | |||||||
Volkswagen | Buick | 12,2 | ||||||
Buick | Volkswagen | 12,4 | ||||||
Volkswagen | Buick | 12,6 | ||||||
Buick | Volkswagen | 12,8 | ||||||
Volkswagen | Buick | |||||||
Buick | Volkswagen | 13,2 | ||||||
Volkswagen | Buick | 13,4 | ||||||
Buick | Volkswagen | 13,6 | ||||||
Volkswagen | Buick | 13,8 | ||||||
Buick | Volkswagen | |||||||
Volkswagen | Buick | 14,2 | ||||||
Buick | Volkswagen | 14,4 | ||||||
Volkswagen | Buick | 14,6 | ||||||
Buick | Volkswagen | 13,2 | ||||||
Volkswagen | Buick | 13,4 |
|
|
.
.
1
Widows Microsoft Excel () . MS Excel .
2,7,5,9,4,6,5 1...7.
= (A1:A7)
5,428571
= (A1:A7)
3.
=(A1:A7)
=(A1:A7)
= (1:A7)
=(A1:A7)
4,976588
=(A1:A7)
4,456796
= (A1:A7)
4,952381
=(A1:A7)
4,244898
= (A1:A7)
29,71429
9.
= (9;A1:A7;1)
=(A1:A7)
2,225395
=(A1:A7)
2,060315
. ( ). :
2,4,5,5,6,7,9