
64
ɫɢɜɭ ɡɚ ɞɨɩɨɦɨɝɨɸ ɮɭɧɤɰɿʀ MS Excel =ɉɂɊɋɈɇ(B3:B17;C3:C17). Ʉɨɟɮɿɰɿɽɧɬ
ɤɨɪɟɥɹɰɿʀ ɞɨɪɿɜɧɸɜɚɬɢɦɟ ɩɪɢɛɥɢɡɧɨ ɧɭɥɸ (r
xy
§ –0,04), ɳɨ ɫɜɿɞɱɢɬɶ ɩɪɨ (ɧɿ-
ɛɢɬɨ) ɜɿɞɫɭɬɧɿɫɬɶ ɛɭɞɶ-ɹɤɨɝɨ ɡɜ'ɹɡɤɭ ɦɿɠ ɡɦɿɧɧɢɦɢ;
x
ɪɨɡɪɚɯɭɜɚɬɢ ɤɨɟɮɿɰɿɽɧɬɢ ɤɨɪɟɥɹɰɿʀ ɨɤɪɟɦɨ ɞɥɹ ɱɚɫɬɢɧ ɦɚɫɢɜɭ: ɭ ɤɨɦɿɪ-
ɰɿ D22 ɞɥɹ ɜɿɤɭ ɜɿɞ 10 ɞɨ 22, ɭ ɤɨɦɿɪɰɿ D23 ɞɥɹ ɜɿɤɭ ɜɿɞ 26 ɞɨ 38 .
Ɉɬɠɟ, ɞɥɹ ɜɿɤɭ ɜɿɞ 10 ɞɨ 22 ɪɨɤɿɜ ɤɨɟɮɿɰɿɽɧɬ ɤɨɪɟɥɹɰɿʀ ɦɚɽ ɜɢɫɨɤɟ ɞɨɞɚɬɧɟ
ɡɧɚɱɟɧɧɹ (r
xy
§+0,83), ɳɨ ɩɿɞɬɜɟɪɞɠɭɽ ɩɪɹɦɢɣ ɡɜ'ɹɡɨɤ, ɹɤɢɣ ɦɨɠɧɚ ɫɩɨɫɬɟɪɿɝɚ-
ɬɢ ɧɚ ɞɿɚɝɪɚɦɿ. Ⱦɥɹ ɜɿɤɭ ɜɿɞ 26 ɞɨ 38 ɪɨɤɿɜ ɤɨɟɮɿɰɿɽɧɬ ɤɨɪɟɥɹɰɿʀ ɦɚɽ ɜɿɞ'ɽɦɧɟ
ɡɧɚɱɟɧɧɹ (r
xy
§–0,69), ɳɨ ɿɧɬɟɪɩɪɟɬɭɽɬɶɫɹ ɹɤ ɡɜɨɪɨɬɧɢɣ ɡɜ'ɹɡɨɤ. Ɂɧɚɱɟɧɧɹ ɤɨ-
ɪɟɥɹɰɿɣɧɨɝɨ ɜɿɞɧɨɲɟɧɧɹ
67,0
2
,
|
xy
K
ɩɿɞɬɜɟɪɞɠɭɽ ɜɢɫɨɤɿɣ ɪɿɜɟɧɶ ɧɟ ɥɿɧɿɣɧɨɫɬɿ
ɡɜ’ɹɡɤɭ ɡɦɿɧɧɢɯ X Y.
ɋɥɿɞ ɡɜɟɪɧɭɬɢ ɭɜɚɝɭ ɧɚ ɬɟ, ɳɨ ɞɥɹ ɤɨɟɮɿɰɿɽɧɬɚ Ș
2
y,x
ɫɩɨɱɚɬɤɭ ɜɤɚɡɭɸɬɶ ɿɧ-
ɞɟɤɫ y, ɚ ɩɨɬɿɦ – ɯ, ɹɤɢɣ ɽ ɦɿɪɨɸ ɩɪɨɝɧɨɡɭɜɚɧɧɹ Y ɩɨ X. ȼɚɠɥɢɜɨ ɡɚɡɧɚɱɢɬɢ,
ɳɨ ɞɥɹ ɥɿɧɿɣɧɨɝɨ ɤɨɪɟɥɹɰɿɣɧɨɝɨ ɡɜ'ɹɡɤɭ ɜɢɤɨɧɭɽɬɶɫɹ ɫɩɿɜɜɿɞɧɨɲɟɧɧɹ r
xy
= r
yx
,
ɩɪɨɬɟ Ș
2
y,x
ɿ Ș
2
x,y
ɦɚɬɢɦɭɬɶ ɪɿɡɧɿ ɡɧɚɱɟɧɧɹ. əɤɳɨ ɡɜɟɪɧɭɬɢɫɹ ɞɨ ɞɿɚɝɪɚɦɢ ɪɨɡɫɿ-
ɹɧɧɹ (ɪɢɫ. 2.57), ɬɨ ɦɨɠɧɚ ɜɿɞɡɧɚɱɢɬɢ ɬɨɣ ɮɚɤɬ, ɳɨ ɞɥɹ ɨɫɨɛɢ, ɧɚɩɪɢɤɥɚɞ, ɜɿ-
ɤɨɦ 10 ɪɨɤɿɜ (ɏ=10), ɦɨɠɧɚ ɩɪɨɝɧɨɡɭɜɚɬɢ ɫɟɪɟɞɧɸ ɨɰɿɧɤɭ ɬɟɫɬɭ ɭ 8 ɛɚɥɿɜ
(Y=(7+9)/2=8), ɭ ɬɨɣ ɱɚɫ ɹɤ ɞɥɹ ɨɰɿɧɤɢ ɬɟɫɬɭ, ɧɚɩɪɢɤɥɚɞ, ɭ 8 ɛɚɥɿɜ ɜɿɤ ɨɫɨɛɢ
ɦɨɠɟ ɛɭɬɢ ɹɤ ɛɥɢɡɶɤɨ 10, ɬɚɤ ɿ ɛɥɢɡɶɤɨ
38 ɪɨɤɿɜ.
Ɋɨɡɪɚɯɭɧɤɢ ɜɚɠɥɢɜɢɯ ɞɥɹ ɩɫɢɯɨɥɨɝɨ-ɩɟɞɚɝɨɝɿɱɧɢɯ ɞɨɫɥɿɞɠɟɧɶ ɤɨɟɮɿɰɿɽɧ-
ɬɿɜ ɤɨɪɟɥɹɰɿʀ ɩɪɢɜɟɞɟɧɨ ɪɚɡɨɦ ɡ ɨɰɿɧɤɨɸ ʀɯɧɶɨʀ ɜɿɪɨɝɿɞɧɨɫɬɿ ɭ ɪɨɡɞɿɥɿ 5.6.
Ʉɨɟɮɿɰɿɽɧɬɢ ɜɡɚɽɦɧɨʀ ɡɜ'ɹɡɚɧɨɫɬɿ
Ʉɨɟɮɿɰɿɽɧɬɢ ɜɡɚɽɦɧɨʀ ɡɜ'ɹɡɚɧɨɫɬɿ
, ɧɚɩɪɢɤɥɚɞ, ɑɭɩɪɨɜɚ K ɿ ɉɿɪɫɨɧɚ ɋ ɡɚ-
ɫɬɨɫɨɜɭɸɬɶɫɹ ɞɥɹ ɨɰɿɧɤɢ ɡɜ'ɹɡɤɭ ɭ ɫɢɬɭɚɰɿɹɯ, ɤɨɥɢ ɤɨɠɧɚ ɹɤɿɫɧɚ ɨɡɧɚɤɚ ɫɤɥɚ-
ɞɚɽɬɶɫɹ ɛɿɥɶɲ ɧɿɠ ɡ ɞɜɨɯ ɝɪɭɩ. Ʉɨɟɮɿɰɿɽɧɬ ɑɭɩɪɨɜɚ Ʉ ɜɢɤɨɪɢɫɬɨɜɭɽɬɶɫɹ ɭ ɪɚɡɿ
ɧɟɨɞɧɚɤɨɜɨʀ ɤɿɥɶɤɨɫɬɿ ɪɹɞɤɿɜ ɿ ɫɬɨɜɩɱɢɤɿɜ ɬɚɛɥɢɰɿ ɫɩɪɹɠɟɧɨɫɬɿ (k
1
k
2
):
)1)(1(
21
2
kk
K
M
, (2.25)