Лабораторные работы Савенко
.pdf. 2.8 -
, Ctrl+Shift+Enter
“ ”), ( . 2.9).
. 2.9 -
F3 m, G3 - b.
( .
) .
F5 R2.
[0, 1]. 1,
. G5
y. F6
F - , G6 - . (
)
(10)
(14), ,
1.
21
m b.
,
.
: m -
, b - , .
( _y; _x);
( _x; _y).
5. 1 m b
.
,
, Excel
, y
.
. y,
_x
_x
_y.
:
( _y; _x;
_x; ), - ,
, , b 0.
:
(x; _y; _x), x -
, .
6.
1 .
. 1, Excel
8; 3: 7; 3: 7)
3: 7; 3: 7; 8)
8 .
3480
.
22
7.
( . 2.1).
.
2.1
|
|
|
|
|
|
|
|
|
|
|
|
|
2460 |
1590 |
|
3926 |
2542 |
|
2476 |
1595 |
|
2994 |
1947 |
|
2596 |
1672 |
|
2996 |
5450 |
|
2668 |
1724 |
|
3015 |
2009 |
|
2833 |
1835 |
|
3036 |
2036 |
,
.
:
;
-;
-,
;
-.
8. ,
3.
. 3 Excel,
. 2.10. 3: 7 .
“ ”.
“ ”. “ ”
” , 2 ( . 2.11).
” “ ”.
. 2.10 -
23
. 2.11 - “ ” “ ”
. 2.12 - “ ” “ ”
. 2.13).
24
. 2.13 -
3.
, “ ”
“ ” “ ” “ 2
”. , 350
, – 470.
9. 1 ,
.
1.3 ,
.
.
2.5.
3.6.
4.7.
5.9.
25
3.
Statistica
«STATISTICA», StatSoft,
, , , .
, , ,
.
: , ,
, ,
, . , ,
, .
«STATISTICA»
.
«STATISTICA»
.
1.
)
,
:
) n ,
) k – ,
= { ij} " – " (n*k), n = 50,
k = 3, (n = 25, k = 3)
X =(x1, x2,…,xk) , ,
.
)
.
) .
2. Statistica
MathCad Microsoft Office STATISTICA,
.
26
STATISTICA,
( ),
.
, Basic Statistics and Tables « »),
,
,
Multiple Regression .
3.1
STATISTICA.
3.1 –
|
X1 |
X2 |
X3 |
1 |
58 |
339 |
122 |
2 |
62 |
353 |
138 |
3 |
65 |
377 |
137 |
4 |
61 |
348 |
133 |
5 |
66 |
394 |
140 |
6 |
67 |
385 |
143 |
7 |
62 |
395 |
137 |
8 |
68 |
389 |
131 |
9 |
64 |
353 |
130 |
10 |
55 |
405 |
145 |
11 |
68 |
365 |
143 |
12 |
64 |
310 |
114 |
13 |
63 |
395 |
142 |
14 |
64 |
368 |
130 |
15 |
67 |
361 |
135 |
16 |
69 |
383 |
137 |
17 |
70 |
401 |
145 |
27
18 |
68 |
398 |
142 |
19 |
69 |
401 |
153 |
20 |
68 |
388 |
141 |
21 |
70 |
408 |
153 |
22 |
63 |
388 |
142 |
23 |
63 |
417 |
158 |
24 |
68 |
375 |
126 |
25 |
64 |
373 |
133 |
STATISTICA
10 (cases) 10 (variables).
(n*k), n=25, k=3,
15 .
.
3.2.
3.2
Basic Statistics and Tables ( ).
( 3.3):
28
3.3
orrelation matrices ( ).
3.4).
3.4
,
.
One variable list
). ( 3.5),
.
, Select All.
, .
,
29
[Ctrl] .
3.5
,
.
:
Corr.Matrix (highlight p) – ,
, ,
.
Corr.Matrix (display p&N) ,
, . Detailed table of results .
, ,
, ,
: ( ),
.
Corr.Matrix (display p&N).
3.6.
3.6
r23= r32 = 0.84, .
(
, )
Multiple
30