. .. ()
..
44.03.01
()
: ,
- 2016
51. (075.8)
22.1873
37
.., ...,
37
44.03.01
____ ________________ 20____ .
__________________________ /________________ /_________ /
(, , ) ( ) ()
.. / /_________ /
(, , ) ( ) ()
____ _________ 20____ .
__________________________ /________________ /_________ /
(, , ) ( ) ()
. ___________________ /_______________/
() ()
51. (075.8)
22.1873
,
(. ), 2016
.., 2016
..4
I. 5
II. , 1 14
III. 2 ..18
IV. 3 ..20
V. .25
VI. 27
. . .
, .
|
|
1. .
2. ( 1, . 25).
3. , .
4. .
5. , .
6. , . .
7. , . . , , , .
8. , , , .
9. , , ( ).
10. , . .
1
1.
: 15; 20; 18; 20; 25; 11; 12; 13; 24; 23; 23; 24; 21; 22; 21; 23; 23; 22; 21; 14; 14; 22; 15; 16; 20; 20; 16; 16; 20; 17; 17; 17. :
1. ;
2. , k (k = 7);
3. ;
4. : ( , , ); ( , );
5. . α = 0,05.
2.
: 44; 78; 47; 79; 54; 52; 56; 50; 56; 55; 48; 51; 66; 74; 60; 42; 60; 76; 49; 45; 69; 51; 45; 46; 59; 61; 44; 62; 70; 45; 47; 80. :
1. ;
2. , k (k = 8)
3. ;
4. : ( , , ); ( , );
5. . α = 0,05.
3.
: 15,4; 15,5; 16,2; 15,9; 13,6; 15,6; 13,7; 16; 16,2; 16,0; 14,2; 16,1; 15,8; 15,2; 16,2; 15,3; 14,5; 15,0; 15,0; 16,3; 15,8; 14,2; 15,3; 15,2; 16,0; 14,2; 14,5; 14,2; 15,6; 15,0; 16,8, 16,8. :
|
|
1. ;
2. , k (k = 4);
3. ;
4. : ( , , ); ( , );
5 . α = 0,05.
4.
: 14; 14; 25; 15; 12; 8; 18; 23; 14; 11; 18; 18; 12; 29; 16; 17; 13; 15; 20; 10; 17; 16; 18; 16; 14; 9; 15; 13; 20; 28; 9; 20. :
1. ;
2. , k (k = 7);
3. ;
4. : ( , , ); ( , );
5. . α = 0,05.
5.
: 35; 39; 24; 30; 47; 28; 31; 41; 36; 38; 40; 25; 31; 36; 38; 36; 27; 29; 30; 31; 35; 31; 35; 41; 36; 51; 36; 38; 33; 29; 32. :
1. ;
2. , k (k = 9);
3. ;
4. : ( , , ); ( , );
5. . α = 0,05.
6.
:182; 184; 176; 177; 180; 184; 186; 186; 179; 190; 170; 172; 185; 184; 182; 180; 177; 176;172; 189; 174; 176; 172; 174; 175; 182; 186; 186; 183; 165; 177; 172. :
1. ;
2. , k (k = 5);
3. ;
4. : ( , , ); ( , );
5. . α = 0,05.
7.
: 64; 60; 66; 62; 64; 68; 70; 66; 70; 68; 62; 68; 70; 72; 60; 76; 70; 74; 62; 70; 72; 72; 64; 70; 72; 66; 76; 68; 70; 58; 76; 74; 76; 82; 76; 72; 76; 74; 79; 78; 74; 78; 74; 74; 74; 78; 76; 78; 76; 80; 80; 80; 78; 78; 81. :
1. ;
2. , k (k = 6);
3. ;
4. : ( , , ); ( , );
5. . α = 0,05.
|
|
8.
: 24; 11; 12; 13; 24; 23; 23; 24; 21; 22; 21; 23; 22; 21; 14; 14; 22; 20; 20; 20; 15; 15; 16; 20; 20; 16; 16; 20; 17; 17; 19; 19; 19; 18; 18; 18; 18; 19; 19; 18; 18; 17; 17; 19; 26. :
1. ;
2. , k (k = 5);
3. ;
4. : ( , , ); ( , );
5. . α = 0,05.
9.
: 12; 14; 13; 15; 16; 16; 16; 19; 19; 20; 20; 20; 19; 13; 15; 12; 15; 13; 14; 12; 17; 12; 17; 16; 17; 13; 16; 17; 18; 14; 15; 16; 18; 14; 15; 14; 17; 18; 14; 18; 20; 17; 18; 19; 20; 21; 22. :
1. ;
2. , k (k = 5);
3. ;
4. : ( , , ); ( , );
5. . α = 0,05.
10.
: 3; 8; 14; 14; 7; 6; 4; 12; 13; 3; 4; 5; 10; 11; 15; 10; 10; 11; 12; 8; 9; 7; 7; 8; 9; 9; 7; 8; 12; 6; 10; 9. :
1. ;
2. , k (k = 4);
3. ;
4. : ( , , ); ( , );
5. . α = 0,05.
2
1.
:
0,95.
2.
:
0,95.
3.
:
0,95.
4.
:
0,95.
|
|
5.
:
0,95.
6.
:
0,95.
7.
:
0,95.
8.
:
0,95.
9.
:
0,95.
10.
:
0,3 | 2,75 | 3,5 |
0,95.
3
1.
. . ?
/ | ( .). | ( .). | ( .). |
2.
. . ?
/ | ( .). | ( .). | ( .). |
3.
. . ?
/ | ( .). | ( .). | ( .). |
4.
. . ?
/ | ( .). | ( .). | ( .). |
5.
. . ?
/ | ( .). | ( .). | ( .). |
6.
|
|
. . ?
/ | ( .). | ( .). | ( .). |
7.
. . ?
/ | ( .). | ( .). | ( .). |
8.
. . ?
/ | ( .). | ( .). | ( .). |
9.
. . ?
/ | ( .). | ( .). | ( .). |
10.
. . ?
/ | ( .). | ( .). | ( .). |
1. : 20, 21, 22, 23, 25, 25, 26, 27, 27, 25, 26, 27, 25, 22, 23, 24, 39, 23, 40, 22, 26, 30, 24, 24, 25, 24, 25, 24, 28, 24, 29, 25, 26, 27, 30, 31, 34, 31, 35, 32, 30, 30, 25, 35, 38, 39, 28, 34, 35, 36. :
1) n = 50;
2) , k (k=5);
3) ;
4) : ( , , ); ( , );
5) . α = 0,05.
.
.
() .
( ) .
, , , .
. i , mi i- .
mi Ʃ mi = n = mi / n.
, ().
, , (me).
: , D, σ.
:
= -
D = -
σ = -
S2 = -
δ = tα,n , tα,n , , , δ , .
, ( ) :
( δ, + δ) .
:
1)
20, 21, 22, 22, 22, 23, 23, 23, 24, 24, 24, 24, 24, 24, 25, 25, 25, 25, 25, 25, 25, 25, 26, 26, 26, 26, 27, 27, 27, 27, 28, 29, 30, 30, 30, 30, 31, 31, 32, 34, 34, 35, 35, 35, 36, 38, 38, 39, 39, 40
n = 50
i | |||||||||||||||||||
xi | |||||||||||||||||||
mi |
2) , k (k=5)
max = 40; xmin = 20.
h = = = 4,
k . , .
mi | |||
20-24 | 14/50 = 0,28 | ||
24-28 | 17/50 = 0,34 | ||
28-32 | 8/50 = 0,16 | ||
32-36 | 6/50 = 0,12 | ||
36-40 | 5/50 = 0,1 |
3) , (xi) , () ( .1.).
.1.
4)
= = +
+ = 28,12
D = = +
+ +
+ +
+ +
+ = = 28,0737
σ = = = 5,3
- 25.
29.
5) ( μ) , α = 0,05.
S2 = = = = 28,6466
S = = = 5,35
( ) tα,n= 2,009 α = 0,05 n = 50
δ = tα,n
δ = 2,009 = 0,28
( δ< μ< + δ)
(28,12 - 0,28 < μ < 28,12 + 0,28) (27,84; 28,40)
: = 28,12; 0 = 25; me = 29; D = 28,0737; σ = 5,3; (27,84; 28,40) .
2. :
0,95.
, :
r = , n ( iyi),
- i yi, σ σ .
:
,
= = 11,2 = = 11
Ʃiyi = = 782
σ = = = =
= 14,59
σ = = = = 5,14
r = = 0,44
0,95, .
(,) . n r, . , , , , .. . , , , .. .
:
p = 0,95
t = r = 0,44 = 0,84
t k = n 2 . ( ) , p = 0,95 k = 3 t(p;k) = 3,18
|t| < t, , |t| > t, .
|t| = 0,84, t = 3,18. .. 0,84 < 3,18, .
: r = 0,44 - .
3. . . ?
/ | ( .). | ( .). | ( .). |
. , , . , . .
. , .
, , . , . .
() H. , ( ) .
() H1, .
:
α = 0,05 (H) .
,
/ | |||
( .). | ( .). | ( .). | |
7,2 | 13,8 | 8,8 |
:
= 9,93
, , , ,
, , q .
/ | |||
( .). | ( .). | ( .). | |
Ʃ |
2501 98,6049 = 2402,4
, , .. ,
6(51,84 + 190,44 + 77,44 295,8147) = = 23,9
= 2402,4 23,9 = 2378,5
= = =
α = 0,05 2 15 ( ).
(0,05; 2; 15) = 3,68
, , (H) , .. (H1), .
: .
.
Excel , , .. (, ..) , . - , 3-5 ( ) , . . .
, , . Excel , , .
Excel . MS Office. Excel .
.
I. MS Office 2003
1.1.
1.2.
1.3. . ʻ. , , MS Office ʻ.
1.4. , .
II. MS Office 2007 2010
2.1. Office Excel. Excel 腻. ʻ. Excel , . . .
, ( , ) , , , . , .
1. , . . : / . . , . . , . . . .: , 2012. 400 . ( ).
2. , . . : / . . . 12- . .: ; , 2012. 479 . ( ).
3. -, . . : / . . -. 4- ., . . .: , 2012. 511 . ( ).
1. , . . [ ]: .: : -, 2013. 272 . - : http://znanium.com
2. , . . [ ]: / . . . 4- . .: .- ʻ, 2012. 244 . - : http://znanium.com
3. , . . [ ]: / . . . 3- . (.) .: , 2012. 472 .- : http://znanium.com
4. , . . [ ]: / . . , . . , . . . 2- . (.). .: , 2012. 260 .- : http://znanium.com
5. , . . [ ]: / . . . 2- . (.). .: , 2012. 312 .- : http://znanium.com
6. , . . [ ]: / . . , . . , . . . 4- . .: .- ʻ, 2011. 472 .- : http://znanium.com
7. , . . , [ ]: - / . . , . . . .: , 2011. 135 . ( ). - : http://znanium.com
:
1. http://www.ieml-math.narod.ru - (. ).
2. http://de.ifmo.ru/bk_netra/select.php - - , .
3. http://office.microsoft.com/ru-ru/excel-help - Microsoft Excel .
4. http://citforum.ru/pp/excel70.shtml - MS Excel.
5. http://window.edu.ru/window .
6. http://www.exponenta.ru - .
7. http://www.edu.ru - .
1
. .. ()