Обработка экспериментальных данных

. 2.15. 6&/ . 1 / 0.

. 2.16. 4 ,& &/ 0.

21

$ , &6+ 01 , + , & / &/ , 5 , ( , 01 + 0 0). 2

&/ 6 ., + 5 / & 6 .01

0 &/.

!0 0 . 9 & /

& 5 4 , & ,& &/ 0, , &6+ , , 0. 0+ . 0 Y # ( . 2.16). % . & 9 - 5 4 . &/ .6 6 , & &6+ & + 0,

.& 0. & 3 & 6 .0 0.

3.4 0 '-" (!# . /#.

3.1. ## +. '-0.

& 0 & / 6, / 01

. . + & . 69 &

. (. ) . 9 6 6. &6+ 0. , . & 4 ..

&/ 7 & &3+ 6 & 5

. . 9 6 & + . (5 0 &). ' . / . 9 6 . &/7 . + & . &6+ 01 , & 4 6+ . . .5 . 5 & 5 &

(0+ & + 01 . 9 01 -44 &

& 01 7). $0 . 0 & + 3 65 65 : . .

0+ & 9 .0. & 0. , .. !0 & 3

5 6,,0 1 ..

! , , &/ 6 !# . ! # ., / &3+

& + . 9 6 , . 0. & &6+, & .

+ , . & + 6 + . 65. ! 5 6,, . , &/ 6 !# . ! !#+5 !# 0, .,

, & 0 & 638 5 4: , & 3 & 0

+ 5 , . , & 0. + .

65 5 + 8, + . - . 9 : / &6+ 0. + .

&/.

9 6 . , . , &/ .

, . 0 + & . 9 6 , . - $,, .## +. 1 # .

' + 1 . , & / & + , /

. . 9 6 . 1 . 0

,& /, , & , + , 9 , & 6 .6 5 6 & & + 01 ,.

22

0 . -& & 0 . 0 & 0

3.1. , & . 3.1.

			& 3.1.
		&	, &
	,& /, 5/ .3	, + ,	6 .6 5 6,
		9,
"	0,67	54,0	0,028
	0,50	42,0	0,019
	0,44	34,0	0,014
&/	0,45	40,0	0,018
1	0,40	34,0	0,015
	0,65	47,0	0,041
&	0,71	51,5	0,040
" ,	0,47	34,0	0,026
	0,50	37,5	0,036
, &/	0,43	31,5	0,020

. 3.1. & 1 01 01 & , & 5 &.

& &/ 7 0 1 . 0 / . 6 5

. 3 Describe\Numeric Data\Multiple-Variable Analysis. -

, & 5 & . & 6 .01 , . 01.

23

1 . .07/3 0 & / & 6 .0 , . 0 9 . , & 1 & ,6 / 5 9 . & 7 .

! 6&/, , & . 9 , . 01, 5 , 9 , 1 , . 01 (, 10 &3 9).

& 5 + 0 0 - 6&/ 0 & 1 .

9 / , 6 & + 01 46 ( & 9 . 6 , &

6.) , 7 . 0 / ,6 Correlations.

0 7 & ( .3.2) , & . 6 . . 313 (, & + 6 , . 01), + 1 1 , + &.

. 3.2. & 6&/ & 5 &.

- & -44 . & , - , 0 & + &3 / - 9 6 /

+ . (p-Value).

+ + . / 6&/ , &

63 . 6 6 5 " " ( .0 & ", 0"). . ., (p- Value) - - , &/, 1 8 6 0 38 .

9 6&/. & 0 6 / + . 6

& .6 6 3 0 . . 9 6

24

, . 0.. $., 6 / + . , &

/ 7, , . &3 . 5

6&/ 3 , ,6& 3.

, ., 6 / + . = 0.05 ( . . 1/20) , 0, + . 5% /, + 0 / . 9 6 , . 0. & & 7/ &6+ /3 0. $0. & ., & . / , ,6& 6 6, , 0 -, . 0 , & / 0 . 5, , .

. , -, . . 9 0& 0 9 /

9 & & &/ . . 9 6 , . 0.. ! . 5 1

& 1 6 / + ., 0 0.05, .

", .& . 5" 6 7.

& + 6 -44 & . 9 6 /

, . 9 6 , . 0.: + . &/7 + -5-44 . , , + 6

+ . & 90% ( <0.100), . &/ - /. $ , + & 0 9 / 68 6 . 9 6

,& /3 (r) , & . , + , 9 ( ), .

0 9 – . 9 6 , & . , + ( ) , & . 6 .6 5 6 (s).

6&/ 0 & 5 & & 3 , + & , 1 &/ 7 1 &: &/ 7 5 0 & . .0 &, / & , . 01, . 38 1

& 0 9 63 /.

3.2. 2# '-0. 1# + # 2# +.

5 0 & & &. .. +

, : 38 . , + . 0 &

5 . . 9 6 & + . , + .

0.. = &/ 5 5 & , & 8 5

6 5, , 01 , ., 1 8 1 6 5, , + 1 5 , 5. $0. & ., 6 / 5 5 &

1 9 & + 5 0 9 . 9 6 , . 0..

1# -# 2# -0 . / y = f (x). ! , Statgraphics & 9 0 & 638 0 . & , 5, , & 0 & 3.2.

! + 1 01 01 6 . , &/ / & 3.1. & 0 , 6 , . & , 5 1 .

0, & / . 6 Relate/Simple regression. ! , 7 . & 5 0.

1 . 6 6 / 6&/ . & 5 &

25

0 / , , . 01 (r, E, s) + X Y, , & + 5 + /

& 9 . , .

	& 3.2.
, . &	& +
" (Linear)	Y = a + b*X
2 , &/ (Exponential)	Y = exp(a + b*X)
, Y (Reciprocal-X)	Y = 1/(a + b*X)
, # (Reciprocal-Y)	Y = a + b/X
9 0 (Double reciprocal)	Y = 1/(a + b/X)
" 5 4. , # (Logarithmic-X)	Y = a + ln(X)
6&/ ,& (Multiplicative)	Y = a*X^b
0 / , # (Square root-X)	Y = a + b*sqrt(X)
0 / , Y (Square root-Y)	Y = (a + b*X)^2
S- (S-curve)	Y = exp(a + b/X)
" 5 + (Logistic)

. 3.3. 6&/ , 5.

- , / + , 6 0 , 5

+ & & . &, .

, , 6. &+ 3 ( . 3.3).

26

. 3.4. 4 + 9 6&/ 5 5 &.

. 3.5. 6&/ 0 &/ 01 . &.

27

$ , &6+ , + , &6+ & . &/

+ & 6 -, . &/ 0. 0. ( -44

& correlation coefficient & 0,925111; -44

. R-squarted 85,5831%).

& 0 5 4 + 5 9 6&/ 1 .

9 / , 6 5 4 + 1 46 (/ & 9 , &

6.). - 0 & 5 6, 0.

. & 5 4 + . .. ' / 1 . 6

. & Plot of Fitted Model (5 4 , . &) Residual versus X (5 4 ) 9 / ( . 3.4). 5 4 6

. 9 6 / & + & 6 , + ., 0

& 6 .01 01.

& , . &/ 01 . & 1 . 9 /

, 6 & + 01 46 ( & 9 , &

6.) 6 / . , Comparison of Alternative Models ( &/ 01 . &) 9 / . ! 0 7

& ( . 3.5) , & 0 6&/ 0 & & 1 6, 01

, . Y #, 6, + 0 , -44 6 &

-, . &/ 0. 0..

$ , + , &6+ & . &/ (E = 9,64526 + +60,5455 r) & & & +.

3.3. 2# '-0. 1 % & + # 2# +.

& . &/ 5 , & & + 63

. / . 9 6 6. , . 0. Y # , 5

, & . Y = a0 + a1*X + a2*X2 + a3*X3 + … + an*Xn.

! + 1 01 01 /. . 9 , . 0, + , 0 68 . , . . , & . &/ 63 . / . 9 6 ..

& ,6 & 1 . 0, & / . 6 Relate/Polynomial Regression , 7 . & 5 . 6 /

.63 (Y) .63 (#) , . 0. & ,6 &

, , & . &/ 5

5 , ( . 3.6). $ & 6, + , &6+ 5 . &/

(E = 25,2749 + 2,25911 r + 52,1456 r2), & & +, + . , & 5. -. &/ 63 & 0-44 . R-squarted (85,8601%), &/7 +

6 + . P-Value (0,0011) , 6&/ . , 5

& . & Analysis of Variance 65 , &.

& 5 4 + 5 9 6&/ 1 .

0 / & 5 5 4 + 1 46 (/ , & 9 ,-

28

. 3.6. 6&/ 0 , , & . &/ . & 5 ,.

. 3.7. 4 + 9 . & 5 ,.

29

& 6.) 6 / . Plot of Fitted Model. & 6

, &6+ 0 5 4 ( . 3.7) . 9 . /, + 0 +

, , 3 6 / 95% &/ 5 (+ ,6 &). -.6 & 6 , , / , / , & . &/ 63 5 63 . &/ & 0 5 ,.

& -5, 1 . , & 0 . .3 (0 0 9 . , 63 , 6 .07) 0 / ,6 Analysis Options , 7 . & 5 . / , . &.

3.4. 2# '-0. 5 + # 2# +.

' + . 9 5 5 5 & & 1 9 + . 5 + .

&6+ & + 0 Y . 9 .01 & + #1, #2, …, #n. 2 6 . / & + . 9 , / & 638 . :

Y = a0 + a1X1 + a2X2 + … + anXn

$1 0 0 & . 9 5 5 5 &

, 0 & 3.3.

					& 3.3.
<	Y	X1	X2	X3	X4
,/,
1	113	80	107	44	87
2	124	94	93	72	106
3	122	95	115	81	186
4	124	99	126	87	74
5	112	117	53	94	122
6	87	78	80	58	112
7	97	91	95	120	82
8	111	104	52	45	113
9	70	55	54	65	140
10	123	130	109	51	34
11	76	64	66	70	186
12	75	81	82	94	167
13	69	58	144	49	53
14	80	91	144	49	49

& ,6 & 1 . 0, & / . 6 Relate/Multiple regression (. 9 5). ' , & . & 5

, . 01: , & Dependent Variable (. , .) . Y,

30