3 курс / Фармакология / Компьютерные_технологии_исследования_лекарственных_средств_Лазарев
.pdf
ɉɥɟɧɤɨɨɛɪɚɡɭɸɳɢɣ ɪɚɫɬɜɨɪ – ɮɚɤɬɨɪ Ⱥ. Ɉɧ ɜɚɪɶɢɪɭɟɬɫɹ ɧɚ ɱɟɬɵɪɟɯ ɭɪɨɜɧɹɯ:
ɚ1 – 5% ɫɩɢɪɬɨɜɵɣ ɪɚɫɬɜɨɪ Ɉɉɐ;
ɚ2 – 5% ɫɩɢɪɬɨɜɵɣ ɪɚɫɬɜɨɪ Ɉɉɐ ɫ ɩɨɫɥɟɞɭɸɳɟɣ ɨɛɫɵɩɤɨɣ ɚɷɪɨɫɢɥɨɦ;
ɚ3 – 5% ɫɩɢɪɬɨɜɵɣ ɪɚɫɬɜɨɪ Ɉɉɐ ɫ ɞɨɛɚɜɥɟɧɢɟɦ ɚɷɪɨɫɢɥɚ ɜ ɪɚɫɬɜɨɪ;
ɚ4 – ɫɚɯɚɪɧɵɣ ɫɢɪɨɩ.
|
A |
B |
C |
D |
E |
F |
1ɋɪɚɜɧɢɬɟɥɶɧɚɹ ɨɰɟɧɤɚ ɩɥɟɧɤɨɨɛɪɚɡɨɜɚɬɟɥɟɣ
2ɫ ɩɨɦɨɳɶɸ ɨɞɧɨɮɚɤɬɨɪɧɨɝɨ ɞɢɫɩɟɪɫɢɨɧɧɨɝɨ ɚɧɚɥɢɡɚ
3 |
ɫ ɨɞɢɧɚɤɨɜɵɦ ɱɢɫɥɨɦ ɨɩɵɬɨɜ |
|
|
||||||
4 |
ɂɫɯɨɞɧɵɟ ɞɚɧɧɵɟ: |
|
|
|
|
|
|
|
|
5 |
k = |
4 |
|
|
r = |
10 |
|
||
6 |
Ɋɚɫɩɚɞɚɟɦɨɫɬɶ |
|
Ɇɚɬɟɪɢɚɥ ɩɨɤɪɵɬɢɹ |
|
|
||||
|
yi m (ɦɢɧ) |
|
(ɮɚɤɬɨɪ Ⱥ) |
|
|
|
|
||
7 |
|
|
|
|
|
||||
|
|
|
|
|
|
|
|
|
|
8 |
Ɉɩɵɬɵ |
|
1 (ɚ1) |
2 (ɚ2) |
|
3 (ɚ3) |
|
4 (ɚ4) |
|
|
|
|
|
|
|
|
|
|
|
9 |
1 |
|
13 |
14 |
|
16 |
|
13 |
|
10 |
2 |
|
14 |
16 |
|
18 |
|
14 |
|
11 |
3 |
|
13 |
15 |
|
16 |
|
13 |
|
12 |
4 |
|
15 |
15 |
|
18 |
|
13 |
|
13 |
5 |
|
13 |
15 |
|
15 |
|
15 |
|
14 |
6 |
|
15 |
16 |
|
16 |
|
12 |
|
15 |
7 |
|
12 |
15 |
|
17 |
|
13 |
|
16 |
8 |
|
13 |
15 |
|
18 |
|
12 |
|
17 |
9 |
|
15 |
13 |
|
17 |
|
15 |
|
18 |
10 |
|
14 |
15 |
|
17 |
|
14 |
|
Ɋɢɫ.4. ɂɫɯɨɞɧɵɟ ɞɚɧɧɵɟ ɞɥɹ ɨɰɟɧɤɢ ɩɥɟɧɤɨɨɛɪɚɡɨɜɚɬɟɥɟɣ
Ɉɩɪɟɞɟɥɢɬɶ, ɤɚɤɨɣ ɢɡ ɩɥɟɧɤɨɨɛɪɚɡɭɸɳɢɯ ɪɚɫɬɜɨɪɨɜ ɨɛɟɫɩɟɱɢɜɚɟɬ ɦɢ-
ɧɢɦɚɥɶɧɨɟ ɜɪɟɦɹ ɪɚɫɩɚɞɚɟɦɨɫɬɢ ɬɚɛɥɟɬɨɤ ɷɤɫɬɪɚɤɬɚ ɜɚɥɟɪɢɚɧɵ. ɋɪɚɜɧɢɬɟɥɶ-
ɧɭɸ ɨɰɟɧɤɭ ɩɪɨɜɟɫɬɢ ɫ ɢɫɩɨɥɶɡɨɜɚɧɢɟɦ ɨɞɧɨɮɚɤɬɨɪɧɨɝɨ ɞɢɫɩɟɪɫɢɨɧɧɨɝɨ ɚɧɚɥɢɡɚ ɫ ɨɞɢɧɚɤɨɜɵɦ ɱɢɫɥɨɦ ɨɩɵɬɨɜ.
ɉɨɪɹɞɨɤ ɜɵɩɨɥɧɟɧɢɹ ɪɚɛɨɬɵ:
Ⱦɥɹ ɩɪɨɜɟɞɟɧɢɹ ɚɧɚɥɢɡɚ ɧɟɨɛɯɨɞɢɦɨ ɜɜɟɫɬɢ ɜ ɷɥɟɤɬɪɨɧɧɭɸ ɬɚɛɥɢɰɭ ɢɫ-
ɯɨɞɧɵɟ ɞɚɧɧɵɟ ɜ ɫɨɨɬɜɟɬɫɬɜɢɢ ɫ ɪɢɫ.4.
51
Ɂɚɞɚɧɢɟ 1
ɉɪɨɜɟɪɤɚ ɨɞɧɨɪɨɞɧɨɫɬɢ ɞɢɫɩɟɪɫɢɣ.
Ʉɪɚɬɤɢɟ ɬɟɨɪɟɬɢɱɟɫɤɢɟ ɫɜɟɞɟɧɢɹ. ɉɟɪɟɞ ɩɪɨɜɟɞɟɧɢɟɦ ɞɢɫɩɟɪɫɢɨɧɧɨɝɨ ɚɧɚɥɢɡɚ ɧɟɨɛɯɨɞɢɦɨ ɭɛɟɞɢɬɶɫɹ ɜ ɨɞɧɨɪɨɞɧɨɫɬɢ ɞɢɫɩɟɪɫɢɣ. ȼ ɫɥɭɱɚɟ ɨɞɢɧɚ-
ɤɨɜɨɝɨ ɱɢɫɥɚ ɩɨɜɬɨɪɧɵɯ ɨɩɵɬɨɜ ɞɥɹ ɨɰɟɧɤɢ ɨɞɧɨɪɨɞɧɨɫɬɢ ɞɢɫɩɟɪɫɢɢ ɩɪɢɦɟ-
ɧɹɟɬɫɹ ɤɪɢɬɟɪɢɣ Ʉɨɯɪɟɧɚ (ɍ):
ɍɷɤɫɩ. |
Smax2 |
ɝɞɟ: ɍɷɤɫɩ. |
– ɷɤɫɩɟɪɢɦɟɧɬɚɥɶɧɨɟ ɡɧɚɱɟɧɢɟ ɤɪɢɬɟɪɢɹ Ʉɨɯɪɟɧɚ; |
|
|
k |
Smax2 |
|
|
|
¦Si2 |
– ɦɚɤɫɢɦɚɥɶɧɚɹ ɞɢɫɩɟɪɫɢɹ; |
||
|
i |
1 |
k |
|
|
|
|
|
|
|
|
|
¦Si2 |
– ɫɭɦɦɚɜɫɟɯɞɢɫɩɟɪɫɢɣɩɨ k ɭɪɨɜɧɹɦɮɚɤɬɨɪɚȺ. |
|
|
|
i 1 |
|
Ⱦɢɫɩɟɪɫɢɹ ɞɥɹ i-ɬɨɝɨ ɭɪɨɜɧɹ ɪɚɫɫɱɢɬɵɜɚɟɬɫɹ ɩɨ ɮɨɪɦɭɥɟ:
|
Si2 |
1 |
¦r yi m yi cp 2 , |
|
|
||
|
|
r 1 m 1 |
|
ɝɞɟ yi cp |
– ɫɪɟɞɧɟɟ ɡɧɚɱɟɧɢɟ ɩɨ ɤɚɠɞɨɦɭ ɭɪɨɜɧɸ; |
||
yim |
– ɨɬɤɥɢɤɧɚi-ɨɦɭɪɨɜɧɟɜm-ɨɣɩɨɜɬɨɪɧɨɫɬɢ(i = 1,2,...k; m = 1,2,...r); |
||
k– ɤɨɥɢɱɟɫɬɜɨ ɭɪɨɜɧɟɣ ɮɚɤɬɨɪɚ Ⱥ (k = 4);
r– ɱɢɫɥɨ ɩɨɜɬɨɪɧɵɯ ɨɩɵɬɨɜ (r = 10).
Ⱦɥɹ ɬɨɝɨ ɱɬɨɛɵ ɩɪɨɜɟɪɢɬɶ ɨɞɧɨɪɨɞɧɨɫɬɶ ɞɢɫɩɟɪɫɢɣ ɧɟɨɛɯɨɞɢɦɨ ɜɵ-
ɩɨɥɧɢɬɶ ɨɩɪɟɞɟɥɟɧɧɭɸ ɩɨɫɥɟɞɨɜɚɬɟɥɶɧɨɫɬɶ ɞɟɣɫɬɜɢɣ.
(Ɋɟɡɭɥɶɬɚɬɵ ɤɚɠɞɨɝɨ ɲɚɝɚ ɜɵɱɢɫɥɟɧɢɣ ɧɟɨɛɯɨɞɢɦɨ ɡɚɧɨɫɢɬɶ ɜ
ɫɨɨɬɜɟɬɫɬɜɭɸɳɢɟ ɹɱɟɣɤɢ!)
ɉɨɪɹɞɨɤ ɜɵɩɨɥɧɟɧɢɹ.
1)ɉɨɞɫɱɢɬɚɬɶ ɫɭɦɦɭ ɡɧɚɱɟɧɢɣ ɨɬɤɥɢɤɨɜ ɩɨ ɤɚɠɞɨɦɭ ɭɪɨɜɧɸ ɮɚɤɬɨɪɚ Ⱥ ɢ ɨɛɳɭɸ ɫɭɦɦɭ ɨɬɤɥɢɤɨɜ ɞɥɹ ɜɫɟɯ ɭɪɨɜɧɟɣ ɮɚɤɬɨ-
ɪɚ. ɇɚɣɬɢ ɫɪɟɞɧɟɟ ɡɧɚɱɟɧɢɟ ɩɨ ɤɚɠɞɨɦɭ ɭɪɨɜɧɸ ɢ ɨɛɳɟɟ ɫɪɟɞɧɟɟ ɡɧɚɱɟɧɢɟ.
Ⱦɥɹ ɤɚɠɞɨɝɨ ɭɪɨɜɧɹ ɮɚɤɬɨɪɚ Ⱥ ɫɭɦɦɚ ɪɚɫɫɱɢɬɵɜɚɟɬɫɹ ɩɨ ɮɨɪɦɭɥɟ:
r
ɋɭɦɦɚi ¦ ym (i = 1,2,...k). ɇɟɨɛɯɨɞɢɦɨ ɩɪɨɫɭɦɦɢɪɨɜɚɬɶ (ɫɦ. ɪɢɫ.5) ɫɨ-
m 1
ɞɟɪɠɢɦɨɟ ɹɱɟɟɤ ȼ9:ȼ18 (ɞɥɹ ɮɚɤɬɨɪɚ ɚ1) ɢ ɪɟɡɭɥɶɬɚɬ ɡɚɧɟɫɬɢ ɜ ɹɱɟɣɤɭ ȼ19. Ⱥɧɚɥɨɝɢɱɧɨ ɩɪɨɫɭɦɦɢɪɨɜɚɬɶ ɨɬɤɥɢɤɢ ɞɥɹ ɮɚɤɬɨɪɨɜ ɚ2yɚ4 ɢ ɡɚɧɟ-
52
ɫɬɢ ɪɟɡɭɥɶɬɚɬɵ ɜ ɹɱɟɣɤɢ ɋ19:ȿ19. Ɉɛɳɚɹ ɫɭɦɦɚ ɧɚɯɨɞɢɬɫɹ ɩɨ ɮɨɪɦɭɥɟ
|
ɋɭɦɦɚ |
k |
|
|
|
|
|
|
|
|
|
|
|
|
|
¦ɋɭɦɦɚi |
: ɩɪɨɫɭɦɦɢɪɨɜɚɬɶ ɹɱɟɣɤɢ ȼ19:ȿ19 ɢ ɪɟɡɭɥɶɬɚɬ ɡɚɩɢ- |
||||||||||||
|
|
|
i 1 |
|
|
|
|
|
|
|
|
|
|
|
|
ɫɚɬɶ ɜ ɹɱɟɣɤɭ F19. ɋɪɟɞɧɢɟ ɡɧɚɱɟɧɢɹ ɞɥɹ ɤɚɠɞɨɝɨ ɭɪɨɜɧɹ ɮɚɤɬɨɪɚ Ⱥ ɧɚ- |
|||||||||||||
|
|
|
|
|
y |
|
|
ɋɭɦɦɚi |
, ɪɟɡɭɥɶɬɚɬɵ ɡɚɧɨɫɹɬ ɜ |
|||||
|
ɯɨɞɹɬ ɜ ɫɨɨɬɜɟɬɫɬɜɢɢ ɫ ɮɨɪɦɭɥɨɣ |
i cp |
|
|
|
|||||||||
|
|
|
|
|
|
|
r |
|
|
|
||||
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
ɹɱɟɣɤɢ ȼ20:ȿ20. Ɉɛɳɟɟ ɫɪɟɞɧɟɟ: ycp |
|
ɋɭɦɦɚ |
|
– |
ɜ ɹɱɟɣɤɭ F20. |
||||||||
|
|
|
||||||||||||
|
|
|
|
|
|
|
|
r k |
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A |
|
B |
C |
|
|
|
D |
|
|
|
|
E |
F |
8 |
Ɉɩɵɬɵ |
|
1 (ɚ1) |
2 (ɚ2) |
|
|
3 (ɚ3) |
|
|
|
|
4 (ɚ4) |
ɋɭɦɦɚ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
9 |
1 |
|
13 |
14 |
|
|
|
|
16 |
|
13 |
|
||
10 |
2 |
|
14 |
16 |
|
|
|
|
18 |
|
14 |
|
||
11 |
3 |
|
13 |
15 |
|
|
|
|
16 |
|
13 |
|
||
12 |
4 |
|
15 |
15 |
|
|
|
|
18 |
|
13 |
|
||
13 |
5 |
|
13 |
15 |
|
|
|
|
15 |
|
15 |
|
||
14 |
6 |
|
15 |
16 |
|
|
|
|
16 |
|
12 |
|
||
15 |
7 |
|
12 |
15 |
|
|
|
|
17 |
|
13 |
|
||
16 |
8 |
|
13 |
15 |
|
|
|
|
18 |
|
12 |
|
||
17 |
9 |
|
15 |
13 |
|
|
|
|
17 |
|
15 |
|
||
18 |
10 |
|
14 |
15 |
|
|
|
|
17 |
|
14 |
|
||
19 |
ɋɭɦɦɚi |
=ɋɍɆɆ(B9:ȼ18) |
=ɋɍɆɆ(ɋ9:ɋ18) |
=ɋɍɆɆ(D9:D18) |
=ɋɍɆɆ(E9:E18) |
=ɋɍɆɆ(B19:E19) |
||||||||
|
|
[137] |
[149] |
|
|
[168] |
|
|
|
[134] |
[588] |
|||
|
|
|
|
|
|
|
|
|||||||
20 |
yi cp |
|
=B19/$E$5 |
= C19/$E$5 |
|
=D19/$E$5 |
|
= E19/$E$5 |
= F19/(E5*ȼ5) |
|||||
|
|
[13,7] |
[14,9] |
|
|
[16,8] |
|
|
|
[13,4] |
[14,7] |
|||
|
|
|
|
|
|
|
|
|||||||
Ɋɢɫ.5. Ɋɚɫɱɟɬ ɫɭɦɦ ɢ ɫɪɟɞɧɢɯ ɡɧɚɱɟɧɢɣ
2)ɇɚɣɬɢ ɡɧɚɱɟɧɢɟ ɞɢɫɩɟɪɫɢɢ ɩɨ ɤɚɠɞɨɦɭ ɭɪɨɜɧɸ.
Ⱦɥɹ ɧɚɯɨɠɞɟɧɢɹ ɞɢɫɩɟɪɫɢɢ ɩɨ ɤɚɠɞɨɦɭ ɭɪɨɜɧɸ ɧɟɨɛɯɨɞɢɦɨ ɫɮɨɪɦɢɪɨɜɚɬɶ ɨɬɞɟɥɶɧɭɸɬɚɛɥɢɰɭ. Ɂɚɬɟɦɞɥɹɤɚɠɞɨɝɨɭɪɨɜɧɹi (i = 1,2,...k) ɜɵɱɢɫɥɢɬɶ:
a) ɪɚɡɧɨɫɬɶ yim yi cp ;
ɛ) ɤɜɚɞɪɚɬ ɪɚɡɧɨɫɬɢ ( y |
im |
y |
i cp |
)2 ; |
|
||
|
|
|
|
|
|
||
|
|
|
|
|
|
r |
|
ɜ) ɫɭɦɦɭ ɤɜɚɞɪɚɬɨɜ ɪɚɡɧɨɫɬɟɣ |
|
¦( yim yi cp )2 ; |
|||||
|
|
|
|
|
m 1 |
|
|
|
|
|
|
1 |
|
r |
|
ɝ) ɞɢɫɩɟɪɫɢɸ ɭɪɨɜɧɹ Si2 |
|
|
|
¦( yim |
yi cp )2 |
||
|
|
|
|
||||
|
|
|
r 1m 1 |
. |
|||
Ⱦɥɹ ɭɪɨɜɧɹ ɮɚɤɬɨɪɚ ɚ1 (ɩɪɢ k = 1) ɞɚɧɧɵɟ ɹɱɟɟɤ ȼ24:ȼ33 ɫɨɨɬɜɟɬɫɬɜɭɸɬ ɞɚɧɧɵɦ ɹɱɟɟɤ ȼ9:ȼ18. Ⱦɚɧɧɵɟ ɞɥɹ k = 2, 3 ɢ 4 ɛɟɪɭɬɫɹ ɚɧɚɥɨɝɢɱɧɨ ɪɢɫ.6.
53
|
A |
B |
C |
D |
|
|
E |
F |
22 |
Ɂɚɞɚɧɢɟ 1. ɉɪɨɜɟɪɤɚ ɨɞɧɨɪɨɞɧɨɫɬɢ ɞɢɫɩɟɪɫɢɣ |
|
ɍɪɨɜɟɧɶ ɮɚɤɬɨɪɚ k=1 |
|||||
23 |
ɨɩɵɬ |
y1m |
y1m y1cp |
Ʉɜ. ɪɚɡɧɨɫɬɢ |
ɋɭɦɦɚ ɤɜ. ɪɚɡɧ. |
Ⱦɢɫɩɟɪɫɢɹ |
||
24 |
1 |
13 |
=B24-$B$20 [-0,7] |
=C24^2 |
[0,49] |
|
|
|
25 |
2 |
14 |
=B25-$B$20 [0,3] |
=C25^2 |
[0,09] |
|
|
|
26 |
3 |
13 |
=B26-$B$20 [-0,7] |
=C26^2 |
[0,49] |
|
|
|
27 |
4 |
15 |
=B27-$B$20 [1,3] |
=C27^2 |
[1,69] |
|
|
|
28 |
5 |
13 |
=B28-$B$20 [-0,7] |
=C28^2 |
[0,49] |
|
|
|
29 |
6 |
15 |
=B29-$B$20 [1,3] |
=C29^2 |
[1,69] |
|
|
|
30 |
7 |
12 |
=B30-$B$20 [-1,7] |
=C30^2 |
[2,89] |
|
|
|
31 |
8 |
13 |
=B31-$B$20 [-0,7] |
=C31^2 |
[0,49] |
|
|
|
32 |
9 |
15 |
=B32-$B$20 [1,3] |
=C32^2 |
[1,69] |
ɋɍɆɆ |
=E33/(E5-1) |
|
|
= |
(D24:D33) |
||||||
33 |
10 |
14 |
=B33-$B$20 [0,3] |
=C33^2 |
[0,09] |
|
[10,1] |
[1,12222] |
34 |
ɍɪɨɜɟɧɶ ɮɚɤɬɨɪɚ k=2 |
|
|
|
|
|
||
35 |
1 |
14 |
=B35-$C$20 [-0,9] |
=C35^2 |
[0,81] |
|
|
|
36 |
2 |
16 |
1,1 |
1,21 |
|
|
|
|
37 |
3 |
15 |
0,1 |
0,01 |
|
|
|
|
38 |
4 |
15 |
0,1 |
0,01 |
|
|
|
|
39 |
5 |
15 |
0,1 |
0,01 |
|
|
|
|
40 |
6 |
16 |
1,1 |
1,21 |
|
|
|
|
41 |
7 |
15 |
0,1 |
0,01 |
|
|
|
|
42 |
8 |
15 |
0,1 |
0,01 |
|
|
|
|
43 |
9 |
13 |
-1,9 |
3,61 |
|
ɋɍɆɆ |
=E44/(E5-1) |
|
|
|
= |
(D35:D44) |
|||||
44 |
10 |
15 |
0,1 |
0,01 |
|
|
[6,9] |
[0,76667] |
45 |
ɍɪɨɜɟɧɶ ɮɚɤɬɨɪɚ k=3 |
|
|
|
|
|
||
46 |
1 |
16 |
=B46-$D$20 [-0,8] |
=C46^2 |
[0,64] |
|
|
|
47 |
2 |
18 |
1,2 |
1,44 |
|
|
|
|
48 |
3 |
16 |
-0,8 |
0,64 |
|
|
|
|
49 |
4 |
18 |
1,2 |
1,44 |
|
|
|
|
50 |
5 |
15 |
-1,8 |
3,24 |
|
|
|
|
51 |
6 |
16 |
-0,8 |
0,64 |
|
|
|
|
52 |
7 |
17 |
0,2 |
0,04 |
|
|
|
|
53 |
8 |
18 |
1,2 |
1,44 |
|
|
|
|
54 |
9 |
17 |
0,2 |
0,04 |
|
ɋɍɆɆ |
=E55/(E5-1) |
|
|
|
= |
(D46:D55) |
|||||
55 |
10 |
17 |
0,2 |
0,04 |
|
|
[9,6] |
[1,06667] |
56 |
ɍɪɨɜɟɧɶ ɮɚɤɬɨɪɚ k=4 |
|
|
|
|
|
||
57 |
1 |
13 |
ȿ |
=C57^2 |
[0,16] |
|
|
|
|
=B57-$ $20 [-0,4] |
|
|
|
||||
58 |
2 |
14 |
0,6 |
0,36 |
|
|
|
|
59 |
3 |
13 |
-0,4 |
0,16 |
|
|
|
|
60 |
4 |
13 |
-0,4 |
0,16 |
|
|
|
|
61 |
5 |
15 |
1,6 |
2,56 |
|
|
|
|
62 |
6 |
12 |
-1,4 |
1,96 |
|
|
|
|
63 |
7 |
13 |
-0,4 |
0,16 |
|
|
|
|
64 |
8 |
12 |
-1,4 |
1,96 |
|
|
|
|
65 |
9 |
15 |
1,6 |
2,56 |
|
=ɋɍɆɆ(D57:D66) |
=E66/(E5-1) |
|
66 |
10 |
14 |
0,6 |
0,36 |
|
|
[10,4] |
[1,15556] |
Ɋɢɫ. 6. ɉɪɨɜɟɪɤɚ ɨɞɧɨɪɨɞɧɨɫɬɢ ɞɢɫɩɟɪɫɢɣ
54
3)ɇɚɣɬɢ ɫɭɦɦɭ ɜɫɟɯ ɞɢɫɩɟɪɫɢɣ ɢ ɨɩɪɟɞɟɥɢɬɶ, ɤɚɤɨɟ ɡɧɚɱɟɧɢɟ
ɞɢɫɩɟɪɫɢɢ ɹɜɥɹɟɬɫɹ ɦɚɤɫɢɦɚɥɶɧɵɦ.
Ʉɨɥɢɱɟɫɬɜɨ ɞɢɫɩɟɪɫɢɣ ɪɚɜɧɨ ɤɨɥɢɱɟɫɬɜɭ ɭɪɨɜɧɟɣ ɮɚɤɬɨɪɚ, ɬ.ɟ. ɢɯ k, ɫɥɟ-
k
ɞɨɜɚɬɟɥɶɧɨ, ɫɭɦɦɚ ɞɢɫɩɟɪɫɢɣ ɧɚɯɨɞɢɬɫɹ ɩɨ ɮɨɪɦɭɥɟ: ¦Si2 = 4,111.
i 1
ɋɪɚɜɧɢɬɶ ɩɨɥɭɱɟɧɧɵɟ ɞɢɫɩɟɪɫɢɢ S12 ,... Sk2 ɢ ɧɚɣɬɢ ɦɚɤɫɢɦɚɥɶɧɭɸ:
Smax2 = 1,15556.
|
A |
B |
ɋ |
D |
E |
67 |
ɋɭɦɦɚ ɞɢɫɩɟɪɫɢɣ |
|
Ɇɚɤɫɢɦɚɥɶɧɚɹ ɞɢɫɩɟɪɫɢɹ: |
||
68 |
|
=F33+F44+F55+F66 [4,111] |
|
|
=ɆȺɄɋ(F33;F44;F55;F66) [1,15556] |
4)ȼɵɱɢɫɥɢɬɶ ɷɤɫɩɟɪɢɦɟɧɬɚɥɶɧɨɟ ɡɧɚɱɟɧɢɟ ɤɪɢɬɟɪɢɹ Ʉɨɯɪɟɧɚ
(ɍɷɤɫɩ) ɩɨ ɮɨɪɦɭɥɟ:
ɍ |
ɷɤɫɩ. |
Smax2 |
|
Ɇɚɤɫɢɦɚɥɶɧɚɹɞɢɫɩɟɪɫɢɹ |
1,15556 |
0,281 |
||
|
k |
|
ɋɭɦɦɚɞɢɫɩɟɪɫɢɣ |
|
4,111 |
|||
|
|
¦Si2 |
|
|
||||
|
|
i |
1 |
|
|
|
|
|
5)Ɉɩɪɟɞɟɥɢɬɶ ɫɬɟɩɟɧɢ ɫɜɨɛɨɞɵ ɢ ɬɚɛɥɢɱɧɨɟ ɡɧɚɱɟɧɢɟ ɤɪɢɬɟ-
ɪɢɹ Ʉɨɯɪɟɧɚ (ɍɬɚɛɥ).
Ɍɚɛɥɢɱɧɨɟ ɡɧɚɱɟɧɢɟ ɤɪɢɬɟɪɢɹ Ʉɨɯɪɟɧɚ ɛɟɪɟɬɫɹ ɞɥɹ r = 10 (ɱɢɫɥɨ ɨɩɵɬɨɜ), k = 4 (ɤɨɥɢɱɟɫɬɜɨ ɭɪɨɜɧɟɣ ɮɚɤɬɨɪɚ) ɢ ɜɵɛɪɚɧɧɨɝɨ ɭɪɨɜɧɹ ɡɧɚɱɢɦɨɫɬɢ D = 0,05 (5% ɩɨɝɪɟɲɧɨɫɬɶ). Ɂɧɚɱɟɧɢɟ ɤɪɢɬɟɪɢɹ Ʉɨɯɪɟɧɚ ɍɬɚɛɥ. = ɍ(D; r–1; k) =
ɍ(0,05; 9; 4) = 0,502 (ɉɪɢɥɨɠɟɧɢɟ 1), ɨɧɨɡɚɧɨɫɢɬɫɹɜɹɱɟɣɤɭ E70.
ȼɵɱɢɫɥɟɧɢɹ ɩɪɨɢɥɥɸɫɬɪɢɪɨɜɚɧɵ ɫɥɟɞɭɸɳɢɦ ɮɪɚɝɦɟɧɬɨɦ:
|
A |
|
B |
|
ɋ |
D |
E |
|
F |
69 |
Ʉɪɢɬɟɪɢɣ |
Ʉɨɯɪɟɧɚ (ɷɤɫɩɟɪɢɦɟɧɬ.): |
|
Ʉɪɢɬɟɪɢɣ Ʉɨɯɪɟɧɚ (ɬɚɛɥɢɱɧɵɣ): |
|||||
70 |
|
=E68/B68 |
|
[0,281] |
|
|
|
0,502 |
|
6)ɋɪɚɜɧɢɬɶ ɍɬɚɛɥ. ɢ ɍɷɤɫɩ. ɢ ɫɞɟɥɚɬɶ ɜɵɜɨɞ.
ȿɫɥɢ ɍɷɤɫɩ. ɍɬɚɛɥ. , ɬɨ ɷɤɫɩɟɪɢɦɟɧɬ ɜɨɫɩɪɨɢɡɜɨɞɢɦ (ɝɢɩɨɬɟɡɚ ɨɛ ɨɞɧɨ-
ɪɨɞɧɨɫɬɢ ɞɢɫɩɟɪɫɢɣ ɩɨɞɬɜɟɪɠɞɚɟɬɫɹ) ɢ ɦɨɠɧɨ ɩɪɢɫɬɭɩɚɬɶ ɤ ɞɢɫɩɟɪɫɢ-
ɨɧɧɨɦɭ ɚɧɚɥɢɡɭ ɷɤɫɩɟɪɢɦɟɧɬɚɥɶɧɵɯ ɞɚɧɧɵɯ, ɜ ɩɪɨɬɢɜɧɨɦ ɫɥɭɱɚɟ ɢɫɯɨɞɧɵɟ ɞɚɧɧɵɟ ɫɬɚɬɢɫɬɢɱɟɫɤɢ ɧɟ ɜɨɫɩɪɨɢɡɜɨɞɢɦɵ ɢ ɧɟ ɦɨɝɭɬ ɛɵɬɶ ɩɨɞɜɟɪɝɧɭɬɵɫɬɚɬɢɫɬɢɱɟɫɤɨɦɭ ɚɧɚɥɢɡɭ.
55
Ɂɚɞɚɧɢɟ 2
Ɏɨɪɦɭɥɢɪɨɜɤɚ ɢ ɩɪɨɜɟɪɤɚ ɝɢɩɨɬɟɡɵ ɇɨ.
1)Ɏɨɪɦɭɥɢɪɨɜɤɚ ɝɢɩɨɬɟɡɵ.
ȼ ɨɞɧɨɮɚɤɬɨɪɧɨɦ ɷɤɫɩɟɪɢɦɟɧɬɟ ɝɢɩɨɬɟɡɚ ɇɨ (ɢɥɢ ɧɭɥɶ-ɝɢɩɨɬɟɡɚ) ɫɨɫɬɨɢɬ ɜ
ɬɨɦ, ɱɬɨɷɮɮɟɤɬɵɭɪɨɜɧɟɣɮɚɤɬɨɪɚɪɚɜɧɵɦɟɠɞɭɫɨɛɨɣ (D1 = D2 = D3 = D4), ɬ.ɟ.
ɧɟɬɡɧɚɱɢɦɨɣɪɚɡɧɢɰɵɦɟɠɞɭɱɟɬɵɪɶɦɹɩɥɟɧɤɨɨɛɪɚɡɭɸɳɢɦɢɪɚɫɬɜɨɪɚɦɢ.
2)ȼɵɱɢɫɥɢɬɶ ɫɭɦɦɵ ɤɜɚɞɪɚɬɨɜ.
Ʉɪɚɬɤɢɟ ɬɟɨɪɟɬɢɱɟɫɤɢɟ ɫɜɟɞɟɧɢɹ. ɉɪɢ ɩɪɨɜɟɞɟɧɢɢ ɨɞɧɨɮɚɤɬɨɪɧɨɝɨ ɞɢɫɩɟɪɫɢɨɧɧɨɝɨ ɚɧɚɥɢɡɚ ɧɟɨɛɯɨɞɢɦɨ ɩɨɞɫɱɢɬɚɬɶ ɬɪɢ ɫɭɦɦɵ ɤɜɚɞɪɚɬɨɜ:
SSɨɛɳ., SSȺ ɢ SSɨɲ..
SSɨɛɳ. – ɫɭɦɦɚ ɤɜɚɞɪɚɬɨɜ ɨɬɤɥɨɧɟɧɢɣ ɨɬɞɟɥɶɧɵɯ ɧɚɛɥɸɞɟɧɢɣ ɨɬ ɨɛɳɟɣ ɫɪɟɞɧɟɣ. Ɉɧɚ ɯɚɪɚɤɬɟɪɢɡɭɟɬ ɩɨɥɧɭɸ ɜɚɪɢɚɰɢɸ ɧɚɛɥɸɞɟɧɢɣ.
SSɨɛɳ. |
¦ ¦(yim ycp )2 |
¦ ¦ yim2 |
ɋɭɦɦɚ |
2 |
|
|
k r |
k r |
|
|
|
|
|
|
|
|
|
|
i 1m 1 |
i 1m 1 |
|
k r |
|
SSȺ – ɫɭɦɦɚ ɤɜɚɞɪɚɬɨɜ ɨɬɤɥɨɧɟɧɢɣ ɫɪɟɞɧɢɯ ɩɨ ɭɪɨɜɧɹɦ ɮɚɤɬɨɪɚ Ⱥ ɨɬ ɨɛɳɟɣ ɫɪɟɞɧɟɣ (ɨɬɤɥɨɧɟɧɢɟ ɝɪɭɩɩɨɜɵɯ ɫɪɟɞɧɢɯ ɨɬ ɨɛɳɟɝɨ ɫɪɟɞɧɟɝɨ).
|
|
|
|
|
|
k |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
k |
r |
|
|
¦ɋɭɦɦɚi2 |
ɋɭɦɦɚ |
2 |
|
|
|
|||||||
|
|
SSA ¦ ¦( yi cp ycp ) |
2 |
i 1 |
|
|
|
|
|
|
|
|
||||||
|
|
|
|
|
|
r |
|
|
k r |
|
|
|
|
|||||
|
|
i |
1m 1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
Ɉɧɚ ɯɚɪɚɤɬɟɪɢɡɭɟɬ ɫɢɫɬɟɦɚɬɢɱɟɫɤɨɟ ɨɬɤɥɨɧɟɧɢɟ ɦɟɠɞɭ ɝɪɭɩɩɚɦɢ ɢ ɹɜɥɹ- |
|||||||||||||||||
|
ɟɬɫɹ ɦɟɪɨɣ ɪɚɡɥɢɱɢɹ ɦɟɠɞɭ ɭɪɨɜɧɹɦɢ ɮɚɤɬɨɪɚ Ⱥ. |
|
|
|
|
|
|
|
|
|
||||||||
|
SSɨɲ – ɫɭɦɦɚ ɤɜɚɞɪɚɬɨɜ ɨɬɤɥɨɧɟɧɢɣ ɨɬɞɟɥɶɧɵɯ ɧɚɛɥɸɞɟɧɢɣ ɨɬ ɫɪɟɞɧɟɣ ɢɡ |
|||||||||||||||||
|
ɩɨɜɬɨɪɧɵɯ ɨɩɵɬɨɜ ɩɨ ɭɪɨɜɧɹɦ ɢɫɫɥɟɞɭɟɦɨɝɨ ɮɚɤɬɨɪɚ. ɗɬɨ ɦɟɪɚ ɪɚɫɫɟɹɧɢɹ |
|||||||||||||||||
|
ɜɧɭɬɪɢɝɪɭɩɩɵ. Ɉɧɚɯɚɪɚɤɬɟɪɢɡɭɟɬɫɥɭɱɚɣɧɵɟɩɨɝɪɟɲɧɨɫɬɢɫɨɜɨɤɭɩɧɨɫɬɢ. |
|||||||||||||||||
|
ɉɨɫɤɨɥɶɤɭ SSɨɛɳ. |
SSA SSɨɲ. , ɫɥɟɞɨɜɚɬɟɥɶɧɨ SSɨɲ. |
SSɨɛɳ. |
SSȺ |
||||||||||||||
|
ɉɨɪɹɞɨɤ ɜɵɩɨɥɧɟɧɢɹ. ɉɨɞɝɨɬɨɜɢɬɶ ɬɚɛɥɢɰɭ ɫɨɝɥɚɫɧɨ ɨɛɪɚɡɰɭ: |
|
|
|
|
|||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
A |
|
B |
|
|
|
|
ɋ |
D |
|
|
|
|
E |
|
F |
||
71 |
Ɂɚɞɚɧɢɟ 2. ɉɪɨɜɟɪɤɚ |
ɝɢɩɨɬɟɡɵ ɇɨ. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
72 |
ȼɫɩɨɦɨɝɚɬɟɥɶɧɵɟ ɜɵɱɢɫɥɟɧɢɹ: |
|
|
|
|
|
ɋɭɦɦɵ ɤɜɚɞɪɚɬɨɜ: |
|
|
|||||||||
73 |
ɋɭɦɦɵ ɤɜ. yim |
=ɋɍɆɆɄȼ(B9:E18) |
[8752] |
|
|
SSɨɛɳ = =ȼ73-ȼ7 |
|
|
[108,4] |
|
||||||||
74 |
ɋɭɦɦɵ ɤɜ. ɋɭɦɦɚi /r =ɋɍɆɆɄȼ(B19:E19)/E5 [8715] |
|
SSȺ |
= =ȼ74-B75 |
|
|
[71,4] |
|
||||||||||
75 |
Ɉɛɳɟɟ ɫɪ.*ɋɭɦɦɚ |
=F19^2/(B5*E5) |
[8643,6] |
|
|
SSɨɲ |
= =E73-E74 |
|
|
[37] |
|
|||||||
56
3)ɇɚɣɬɢ ɫɬɟɩɟɧɢ ɫɜɨɛɨɞɵ ɢ ɫɪɟɞɧɢɟ ɤɜɚɞɪɚɬɵ.
Ʉɪɚɬɤɢɟ ɬɟɨɪɟɬɢɱɟɫɤɢɟ ɫɜɟɞɟɧɢɹ. Ⱦɥɹ ɤɚɠɞɨɣ ɫɭɦɦɵ ɤɜɚɞɪɚɬɨɜ ɪɚɫ-
ɫɱɢɬɵɜɚɟɬɫɹ ɫɬɟɩɟɧɶ ɫɜɨɛɨɞɵ:
dfɨɛɳ. = k r – 1 dfȺ = k – 1 dfɨɲ. = k (r – 1)
ɋɭɦɦɚ ɤɜɚɞɪɚɬɨɜ SS, ɞɟɥɟɧɧɚɹ ɧɚ ɱɢɫɥɨ ɫɬɟɩɟɧɟɣ ɫɜɨɛɨɞɵ df, ɧɚɡɵɜɚɟɬɫɹ ɫɪɟɞɧɢɦ ɤɜɚɞɪɚɬɨɦ MS. ȼ ɨɞɧɨɮɚɤɬɨɪɧɨɦ ɷɤɫɩɟɪɢɦɟɧɬɟ ɞɥɹ ɩɪɨɜɟɪɤɢ ɝɢɩɨɬɟɡɵ ɇɨ ɩɪɟɞɫɬɚɜɥɹɸɬ ɢɧɬɟɪɟɫ ɞɜɚ ɫɪɟɞɧɢɯ ɤɜɚɞɪɚɬɚ:
MSA = SSA / dfA MSoɲ = SSɨɲ / dfoɲ
ɋɪɚɜɧɢɜɚɹɷɬɢɤɜɚɞɪɚɬɵ, ɦɨɠɧɨɫɭɞɢɬɶɨɦɟɪɟɜɥɢɹɧɢɹɮɚɤɬɨɪɚȺɧɚɨɬɤɥɢɤy.
ɉɨɪɹɞɨɤ ɜɵɩɨɥɧɟɧɢɹ. ȼɵɱɢɫɥɟɧɢɹ ɨɮɨɪɦɢɬɶ ɜ ɫɨɨɬɜɟɬɫɬɜɢɢ ɫ ɨɛɪɚɡɰɨɦ:
|
A |
|
B |
|
ɋ |
D |
E |
|
F |
76 |
ɋɬɟɩɟɧɢ ɫɜɨɛɨɞɵ: |
|
|
ɋɪɟɞɧɢɟ ɤɜɚɞɪɚɬɵ: |
|
|
|||
77 |
dfɨɛɳ = |
=ȼ5*ȿ5-1 |
[39] |
|
|
|
|
|
|
78 |
dfȺ |
= |
=ȼ5-1 |
[3] |
|
MSȺ = |
=E74/B78 |
[23,8] |
|
79 |
dfɨɲ |
= |
=ȼ5*(ȿ5-1) |
[36] |
|
MSɨɲ = |
=E75/B79 |
[1,028] |
|
4)ȼɵɱɢɫɥɢɬɶ F-ɤɪɢɬɟɪɢɣ (ɤɪɢɬɟɪɢɣ Ɏɢɲɟɪɚ) ɩɨ ɮɨɪɦɭɥɟ:
Fɷɤɫɩ = MSA / MSoɲ
5)Ɉɩɪɟɞɟɥɢɬɶ ɬɚɛɥɢɱɧɨɟ ɡɧɚɱɟɧɢɟ F-ɤɪɢɬɟɪɢɹ.
Ɍɚɛɥɢɱɧɨɟ ɡɧɚɱɟɧɢɟ ɤɪɢɬɟɪɢɹ Ɏɢɲɟɪɚ ɧɚɯɨɞɢɬɫɹ ɩɨ ɬɚɛɥɢɰɟ ɞɥɹ ɫɨɨɬ-
ɜɟɬɫɬɜɭɸɳɢɯ ɫɬɟɩɟɧɟɣ ɫɜɨɛɨɞɵ dfȺ ɢ dfɨɲ. ɢ ɜɵɛɪɚɧɧɨɝɨ ɭɪɨɜɧɹ ɡɧɚɱɢ-
ɦɨɫɬɢ D = 0,05 (5% ɩɨɝɪɟɲɧɨɫɬɶ). Fɬɚɛɥ = 2,86. ɗɤɫɩɟɪɢɦɟɧɬɚɥɶɧɨɟ ɢ ɬɚɛɥɢɱɧɨɟ ɡɧɚɱɟɧɢɹ ɤɪɢɬɟɪɢɹ ɡɚɧɨɫɹɬɫɹ ɜ ɹɱɟɣɤɢ ȼ81 ɢ ȿ81.
80
81
A |
|
B |
|
C |
D |
E |
F |
Ʉɪɢɬɟɪɢɣ |
Ɏɢɲɟɪɚ (ɷɤɫɩɟɪɢɦɟɧɬ |
.): |
|
Ʉɪɢɬɟɪɢɣ Ɏɢɲɟɪɚ (ɬɚɛɥɢɱɧɵɣ): |
|||
|
=E78/E79 |
[23,1568] |
|
|
|
2,86 |
|
6)ɋɮɨɪɦɢɪɨɜɚɬɶ ɬɚɛɥɢɰɭ ɞɢɫɩɟɪɫɢɨɧɧɨɝɨ ɚɧɚɥɢɡɚ ɜ ɫɨɨɬɜɟɬ-
ɫɬɜɢɢ ɫ ɨɛɪɚɡɰɨɦ:
|
A |
|
B |
|
C |
|
D |
E |
F |
83 |
Ɍɚɛɥɢɰɚ ɞɢɫɩɟɪɫɢɨɧɧɨɝɨ ɚɧɚɥɢɡɚ |
|
|
|
|
||||
84 |
ɂɫɬɨɱɧɢɤ |
ɋɭɦɦɚ |
ɑɢɫɥɨ ɫɬɟɩɟɧɟɣ |
ɋɪɟɞɧɢɣ |
Fɷɤɫɩ |
Fɬɚɛɥ. (0,05) |
|||
ȼɚɪɢɚɰɢɢ |
ɤɜɚɞɪɚɬɨɜ |
ɫɜɨɛɨɞɵ |
ɤɜɚɞɪɚɬ |
|
|
||||
85 |
Ɏɚɤɬɨɪ Ⱥ |
=E74 |
[71,4] |
=B78 |
[3] |
=E78 |
[23,8] |
=ȼ81 [23,16] |
=ȿ81 [2,86] |
86 |
Ɉɲɢɛɤɚ |
=E75 |
[37] |
=B79 |
[36] |
=E79 |
[1,028] |
|
|
87 |
ɂɬɨɝɨ |
=E73 |
[108,4] |
=B77 |
[39] |
|
|
|
|
57
7)ɋɪɚɜɧɢɬɶ ɬɚɛɥɢɱɧɨɟ ɢ ɷɤɫɩɟɪɢɦɟɧɬɚɥɶɧɨɟ ɡɧɚɱɟɧɢɹ F-ɤɪɢ-
ɬɟɪɢɹ ɢ ɫɞɟɥɚɬɶ ɜɵɜɨɞ.
ȿɫɥɢ Fɷɤɫɩ. ! Fɬɚɛɥ. , ɬɨ ɝɢɩɨɬɟɡɚ ɇɨ ɨɬɜɟɪɝɚɟɬɫɹ. ɗɬɨ ɨɡɧɚɱɚɟɬ, ɱɬɨ ɭɪɨɜɧɢ
ɮɚɤɬɨɪɚ Ⱥ ɨɤɚɡɵɜɚɸɬ ɡɧɚɱɢɦɨɟ ɜɥɢɹɧɢɟ ɧɚ ɨɬɤɥɢɤ (Di z 0). ȼ ɩɪɨɬɢɜɧɨɦ
ɫɥɭɱɚɟ ɝɢɩɨɬɟɡɚ ɇɨ ɩɨɞɬɜɟɪɠɞɚɟɬɫɹ: ɧɟɬ ɡɧɚɱɢɦɨɣ ɪɚɡɧɢɰɵ ɦɟɠɞɭ ɩɥɟɧ-
ɤɨɨɛɪɚɡɭɸɳɢɦɢ ɪɚɫɬɜɨɪɚɦɢ.
Ɂɚɞɚɧɢɟ 3
ɉɨɫɬɪɨɟɧɢɟ ɪɹɞɚ ɩɪɟɞɩɨɱɬɟɧɢɣ ɩɥɟɧɤɨɨɛɪɚɡɨɜɚɬɟɥɟɣ
ɩɨ ɜɪɟɦɟɧɢ ɪɚɫɩɚɞɚɟɦɨɫɬɢ.
Ʉɪɚɬɤɢɟ ɬɟɨɪɟɬɢɱɟɫɤɢɟ ɫɜɟɞɟɧɢɹ. ɂɫɩɨɥɶɡɨɜɚɧɢɟ F-ɤɪɢɬɟɪɢɹ ɜ ɞɢɫ-
ɩɟɪɫɢɨɧɧɨɦ ɚɧɚɥɢɡɟ ɩɨɡɜɨɥɹɟɬ ɫɞɟɥɚɬɶ ɥɢɲɶ ɨɛɳɢɣ ɜɵɜɨɞ ɨ ɜɥɢɹɧɢɢ ɮɚɤɬɨ-
ɪɚ Ⱥ: ɜɥɢɹɟɬ ɢɥɢ ɧɟ ɜɥɢɹɟɬ. Ɉɩɪɟɞɟɥɢɬɶ ɠɟ, ɤɚɤɢɟ ɢɦɟɧɧɨ ɭɪɨɜɧɢ ɮɚɤɬɨɪɚ Ⱥ ɨɬɜɟɬɫɬɜɟɧɧɵ ɡɚ ɨɬɛɪɚɫɵɜɚɧɢɟ ɝɢɩɨɬɟɡɵ ɇɨ, ɩɨɦɨɠɟɬ ɦɟɬɨɞ ɦɧɨɠɟɫɬɜɟɧɧɵɯ ɫɪɚɜɧɟɧɢɣ (ɦɧɨɠɟɫɬɜɟɧɧɵɣ ɤɪɢɬɟɪɢɣ Ⱦɭɧɤɚɧɚ).
ɉɨɪɹɞɨɤ ɜɵɩɨɥɧɟɧɢɹ.
1)Ɋɚɫɩɨɥɨɠɢɬɶ ɫɪɟɞɧɢɟ ɡɧɚɱɟɧɢɹ ɜ ɩɨɪɹɞɤɟ ɜɨɡɪɚɫɬɚɧɢɹ.
Ⱥɞɪɟɫɚ ɹɱɟɟɤ yi cp – ȼ20:ȿ20 ɪɚɫɩɨɥɨɠɢɬɶ ɜ ɹɱɟɣɤɚɯ ȼ91:ȿ91 ɜ ɩɨɪɹɞɤɟ
ɜɨɡɪɚɫɬɚɧɢɹ:
89
90
91
A |
B |
|
C |
D |
E |
Ɂɚɞɚɧɢɟ 3. ɉɨɫɬɪɨɟɧɢɟ ɪɹɞɚ ɩɪɟɞɩɨɱɬɟɧɢɣ |
|
|
|
||
Ɍɢɩɵ ɩɥɟɧɤɨɨɛɪɚɡɨɜɚɬɟɥɟɣ |
ɚ4 |
ɚ1 |
ɚ2 |
ɚ3 |
|
ɋɪ. ɡɧɚɱɟɧɢɟ ɨɬɤɥɢɤɚ =ȿ20 [13,4] =B20 [13,7] =C20 [14,9] =D20 [16,8]
2)ɇɚɣɬɢ ɧɨɪɦɢɪɨɜɚɧɧɭɸ ɨɲɢɛɤɭ ɫɪɟɞɧɟɝɨ.
ɇɨɪɦɢɪɨɜɚɧɧɚɹ ɨɲɢɛɤɚ ɫɪɟɞɧɟɝɨ ɧɚɯɨɞɢɬɫɹ ɩɨ ɮɨɪɦɭɥɟ:
|
|
Sy cp |
MSɨɲ. |
0,32059 |
|
|
|
|
r |
|
|||
|
|
|
|
|
|
|
Ɋɟɡɭɥɶɬɚɬ ɜɵɱɢɫɥɟɧɢɣ ɡɚɧɨɫɢɬɫɹ ɜ ɹɱɟɣɤɭ Ⱥ93. |
|
|||||
|
|
|
|
|
|
|
|
|
|
A |
|
B |
C |
92ɇɨɪɦɢɪɨɜɚɧɧɚɹ ɨɲɢɛɤɚ ɫɪɟɞɧɟɝɨ:
93=ɄɈɊȿɇɖ(E79/ȿ5) [0,32059]
58
3)Ɉɩɪɟɞɟɥɢɬɶ ɡɧɚɱɢɦɵɟ ɪɚɧɝɢ (ɋɦ. ɩɪɢɥɨɠɟɧɢɟ 2).
ɂɡ ɬɚɛɥɢɰɵ ɡɧɚɱɢɦɵɯ ɪɚɧɝɨɜ ɩɪɢ ɜɵɛɪɚɧɧɨɦ ɭɪɨɜɧɟ ɡɧɚɱɢɦɨɫɬɢ D = 0,05
(5% ɩɨɝɪɟɲɧɨɫɬɶ) ɢɱɢɫɥɟɫɬɟɩɟɧɟɣɫɜɨɛɨɞɵ dfɨɲ = 36, ɜɵɩɢɫɚɬɶ (k – 1) ɡɧɚ-
ɱɟɧɢɹɪɚɧɝɨɜ (Ɋ) ɜɹɱɟɣɤɢȼ95:D95.
4)ȼɵɱɢɫɥɢɬɶ ɧɚɢɦɟɧɶɲɢɟ ɡɧɚɱɢɦɵɟ ɪɚɧɝɢ (ɇɁɊ).
ɇɁɊɧɚɯɨɞɹɬɫɹɩɨɮɨɪɦɭɥɟ: ɇɁɊ = Ɋ Sy cp. Ɋɟɡɭɥɶɬɚɬɵɡɚɧɨɫɹɬɫɹɜɬɚɛɥɢɰɭ:
94
95
96
A |
B |
C |
D |
Ɋɚɧɝɢ |
2 |
3 |
4 |
Ɋ |
2,87 |
3,02 |
3,11 |
ɇɁɊ =B95*$A$93 [0,92] =ɋ95*$A$93 [0,968] =D95*$A$93 [0,997]
5)ɋɪɚɜɧɢɬɶ ɪɚɡɧɨɫɬɢ ɫɪɟɞɧɢɯ ɡɧɚɱɟɧɢɣ ɨɬɤɥɢɤɨɜ ɞɥɹ ɭɪɨɜɧɟɣ
ɮɚɤɬɨɪɚ ɫ ɩɨɦɨɳɶɸ ɫɨɨɬɜɟɬɫɬɜɭɸɳɢɯ ɇɁɊ.
Ɂɧɚɱɟɧɢɟ ɇɁɊ ɞɥɹ ɪɚɡɧɨɫɬɟɣ ɛɟɪɟɬɫɹ ɢɡ ɹɱɟɟɤ ȼ96:D96 ɜ ɫɨɨɬɜɟɬɫɬɜɢɢ ɫ ɪɢɫ.7:
Ɋɢɫ. 7. ȼɵɛɨɪ ɧɚɢɦɟɧɶɲɢɯ ɡɧɚɱɢɦɵɯ ɪɚɧɝɨɜ
Ɍɚɛɥɢɰɚ ɡɚɩɨɥɧɹɟɬɫɹ ɪɚɡɧɨɫɬɹɦɢ ɫɪɟɞɧɢɯ ɡɧɚɱɟɧɢɣ ɨɬɤɥɢɤɨɜ ɜ ɩɨɪɹɞɤɟ ɭɛɵɜɚɧɢɹ, ɢɫɩɨɥɶɡɭɹ ɪɹɞ ɫɪɟɞɧɢɯ ɡɧɚɱɟɧɢɣ ȼ91:ȿ91.
ɇɟɨɛɯɨɞɢɦɨ ɫɪɚɜɧɢɬɶ ɫɨɨɬɜɟɬɫɬɜɭɸɳɢɟ ɡɧɚɱɟɧɢɹ ɹɱɟɟɤ ȼ98:ȼ103 ɢ D98:D103, ɩɨɫɥɟ ɫɪɚɜɧɟɧɢɹ ɜ ɹɱɟɣɤɢ ɋ98:ɋ103 ɡɚɧɟɫɬɢ ɫɨɨɬɜɟɬɫɬɜɭɸɳɢɟ ɡɧɚɤɢ (" < " ɢɥɢ " > "). ȼ ɹɱɟɣɤɢ F98:F103 ɡɚɩɢɫɚɬɶ "ɡɧɚɱɢɦɨ", ɟɫɥɢ ɡɧɚɤ ɫɪɚɜɧɟɧɢɹ " > " ɢ "ɧɟ ɡɧɚɱɢɦɨ", ɟɫɥɢ ɡɧɚɤ ɫɪɚɜɧɟɧɢɹ " < ":
|
A |
|
B |
|
|
C |
|
D |
E |
F |
97 |
ɋɪɚɜɧɟɧɢɟ ɭɪɨɜɧɟɣ |
ɮɚɤɬɨɪɚ |
|
|
|
|
|
|
|
|
98 |
y3 ɫɪ – y4 ɫɪ = |
=E91-B91 |
[3,4] |
> |
=D96 |
[0,997] |
ɇɁɊ4 |
Ɂɧɚɱɢɦɨ |
||
99 |
y3 ɫɪ – y1 ɫɪ = |
=E91-C91 |
[3,1] |
> |
=C96 |
[0,968] |
ɇɁɊ3 |
Ɂɧɚɱɢɦɨ |
||
100 |
y3 ɫɪ – y2 ɫɪ = |
=E91-D91 |
[1,9] |
> |
=B96 |
[0,92] |
ɇɁɊ2 |
Ɂɧɚɱɢɦɨ |
||
101 |
y2 ɫɪ – y4 ɫɪ = |
=D91-B91 |
[1,5] |
> |
=C96 |
[0,968] |
ɇɁɊ3 |
Ɂɧɚɱɢɦɨ |
||
102 |
y2 ɫɪ – y1 ɫɪ = |
=D91-C91 |
[1,2] |
> |
=B96 |
[0,92] |
ɇɁɊ2 |
Ɂɧɚɱɢɦɨ |
||
103 |
y1 ɫɪ – y4 ɫɪ = |
=C91-B91 |
[0,3] |
< |
=B96 |
[0,92] |
ɇɁɊ2 |
ɇɟ ɡɧɚɱɢɦɨ |
||
59
6)ɉɨɫɬɪɨɢɬɶ ɪɹɞ ɩɪɟɞɩɨɱɬɟɧɢɣ.
Ɋɹɞ ɩɪɟɞɩɨɱɬɟɧɢɣ ɫɬɪɨɢɦ ɧɚ ɨɫɧɨɜɚɧɢɢ ɫɪɚɜɧɟɧɢɹ ɫɪɟɞɧɢɯ ɡɧɚɱɟɧɢɣ ɨɬ-
ɤɥɢɤɚ (ȼ91:ȿ91) ɢ ɫ ɭɱɟɬɨɦ ɬɨɝɨ, ɱɬɨ ɦɚɬɟɪɢɚɥɵ ɩɨɤɪɵɬɢɹ ɚ1 ɢ ɚ4 ɫɬɚɬɢ-
ɫɬɢɱɟɫɤɢ ɧɟ ɪɚɡɥɢɱɢɦɵ, ɬ.ɤ. ɪɚɡɥɢɱɢɟ ɦɟɠɞɭ ɧɢɦɢ ɧɟ ɡɧɚɱɢɦɨ.
ɉɨɥɭɱɟɧɧɵɣ ɪɹɞ ɩɪɟɞɩɨɱɬɟɧɢɣ ɡɚɧɨɫɢɦ ɜ ɹɱɟɣɤɭ Ⱥ105.
|
A |
B |
C |
D |
E |
F |
104 Ɋɹɞ ɩɪɟɞɩɨɱɬɟɧɢɣ ɩɥɟɧɤɨɨɛɪɚɡɨɜɚɬɟɥɟɣ ɩɨ ɜɪɟɦɟɧɢ ɪɚɫɩɚɞɚɟɦɨɫɬɢ
105 a4 = a1 < a2 < a3
Ɂɚɞɚɧɢɟ 4
ɉɨɫɬɪɨɟɧɢɟ ɞɨɜɟɪɢɬɟɥɶɧɵɯ ɢɧɬɟɪɜɚɥɨɜ.
1)ȼɵɱɢɫɥɢɬɶ ɞɨɜɟɪɢɬɟɥɶɧɵɟ ɢɧɬɟɪɜɚɥɵ.
Ʉɪɚɬɤɢɟ ɬɟɨɪɟɬɢɱɟɫɤɢɟ ɫɜɟɞɟɧɢɹ. ɉɨɫɥɟ ɩɪɨɜɟɞɟɧɢɹ ɞɢɫɩɟɪɫɢɨɧɧɨɝɨ ɚɧɚɥɢɡɚ ɧɟɨɛɯɨɞɢɦɨ ɭɫɬɚɧɨɜɢɬɶ ɞɨɜɟɪɢɬɟɥɶɧɵɟ ɢɧɬɟɪɜɚɥɵ ɞɥɹ ɭɪɨɜɧɟɣ ɮɚɤɬɨɪɚ ɩɨ ɮɨɪɦɭɥɟ:
yi cp r tD |
MSɨɲ. |
yi cp r tD Sy cp , |
|
r |
|||
|
|
ɝɞɟ tD – ɤɪɢɬɟɪɢɣ ɋɬɶɸɞɟɧɬɚ ɞɥɹ ɭɪɨɜɧɹ ɡɧɚɱɢɦɨɫɬɢ D = 0,05 (5% ɩɨ-
ɝɪɟɲɧɨɫɬɶ) ɢ r = 10 ɱɢɫɥɚɨɩɵɬɨɜ; Sy cp – ɧɨɪɦɢɪɨɜɚɧɧɚɹɨɲɢɛɤɚɫɪɟɞɧɟɝɨ.
ɉɨɪɹɞɨɤ ɜɵɩɨɥɧɟɧɢɹ.
Ʉɪɢɬɟɪɢɣ ɋɬɶɸɞɟɧɬɚ ɞɥɹ ɜɟɪɨɹɬɧɨɫɬɢ D ɢ ɫɬɟɩɟɧɟɣ ɫɜɨɛɨɞɵ r ɪɚɫɫɱɢɬɵ-
ɜɚɟɬɫɹ ɫ ɩɨɦɨɳɶɸ ɮɭɧɤɰɢɢ ɋɌɖɘȾɊȺɋɉɈȻɊ.
|
A |
B |
|
C |
107 |
Ɂɚɞɚɧɢɟ 4. ɉɨɫɬɪɨɟɧɢɟ |
ɞɨɜɟɪɢɬɟɥɶɧɵɯ ɢɧɬɟɪɜɚɥɨɜ |
|
|
108 |
Ʉɪɢɬɟɪɢɣ ɋɬɶɸɞɟɧɬɚ =ɋɌɖɘȾɊȺɋɉɈȻɊ(0,05;10) |
[2,228] |
|
|
109 |
tD * Sy cpC= |
=B109*A93 |
[0,714] |
|
ɇɚɯɨɞɢɦ ɧɢɠɧɢɟ ɢ ɜɟɪɯɧɢɟ ɝɪɚɧɢɰɵ ɞɨɜɟɪɢɬɟɥɶɧɵɯ ɢɧɬɟɪɜɚɥɨɜ ɞɥɹ ɤɚ-
ɠɞɨɝɨ ɦɚɬɟɪɢɚɥɚ ɩɨɤɪɵɬɢɹ:
|
A |
B |
C |
|
D |
|
111 |
Ⱦɨɜɟɪɢɬɟɥɶɧɵɟ ɢɧɬɟɪɜɚɥɵ: |
|
|
|
|
|
112 |
ɉɥɟɧɤɨɨɛɪɚɡɭɸɳɢɣ ɪɚɫɬɜɨɪ: |
ɇɢɠɧɹɹ ɝɪɚɧɢɰɚ |
ȼɟɪɯɧɹɹ ɝɪɚɧɢɰɚ |
|||
113 |
|
ɚ |
=B20-B110 |
[12,99] |
=B20+B110 |
[14,41] |
|
1 |
|
|
|
|
|
114 |
|
ɚ2 |
=C20-B110 |
[14,19] |
=C20+B110 |
[15,61] |
115 |
|
ɚ3 |
=D20-B110 |
[16,09] |
=D20+B110 |
[17,51] |
|
|
ɚ4 |
=E20-B110 |
[12,69] |
=E20+B110 |
[14,11] |
116 |
|
|||||
P.S. ȾɨɜɟɪɢɬɟɥɶɧɵɟɢɧɬɟɪɜɚɥɵɦɨɝɭɬɛɵɬɶɨɩɪɟɞɟɥɟɧɵɫɢɫɩɨɥɶɡɨɜɚɧɢɟɦɮɭɧɤɰɢɢȾɈȼȿɊɂɌ.
60