) ( 16) V.
16
V | d=V-M | d2 | |
-11,88 | 141,02 | ||
-6,88 | 47,27 | ||
-6,88 | 47,27 | ||
-6,88 | 47,27 | ||
5 | -1,88 | 3,52 | |
-1,88 | 3,52 | ||
-1,88 | 3,52 | ||
120 | -1,88 | 3,52 | |
120 | -1,88 | 3,52 | |
3,13 | 9,77 | ||
3,13 | 9,77 | ||
3,13 | 9,77 | ||
3,13 | 9,77 | ||
14 | 8,13 | 66,02 | |
8,13 | 66,02 | ||
13,13 | 172,27 | ||
S) = =( ) | 643,75 | ||
= =( ) | 121,875 |
= , ; , = 120/.
Excel =( ).
) ( 17) (. 8).
17
V | p | ||||||
120 | 5 | ||||||
S= | |||||||
. 8. . |
) :
= = 120 / ( 5 ).
Excel =( ).
:
, .
) . , - - .
, . Office, Excel -> -> -> - VBA -> ʻ. Excel, , Microsoft Office. .
|
|
, , 18.
18
V | d=V-M | d2 | -> . | |||
1 | -1,88 | 3,52 | ||||
2 | 8,13 | 66,02 | 1 | |||
3 | -6,88 | 47,27 | 121,875 | |||
4 | -1,88 | 3,52 | 1,63777 | |||
5 | -1,88 | 3,52 | ||||
6 | 3,13 | 9,77 | ||||
7 | -11,88 | 141,02 | 6,551081 | |||
8 | 3,13 | 9,77 | 42,91667 | |||
9 | -6,88 | 47,27 | -0,16979 | |||
10 | -1,88 | 3,52 | 0,209598 | |||
11 | 3,13 | 9,77 | ||||
12 | 13,13 | 172,27 | ||||
13 | -6,88 | 47,27 | ||||
14 | 8,13 | 66,02 | ||||
15 | 3,13 | 9,77 | ||||
16 | -1,88 | 3,52 | (1) | |||
S= | 0,00 | 643,75 | (1) | |||
n=16 | (95,0%) | 3,490827 |
= -0,17. . = 0.
= 0,2. . = 0.
Excel . (m) , .
) P>95% = 2 m = 121,9 2*1,64 =
121,9 3,28/.