.


:

:



,



( , )

:

































 

 

 

 
FAQ

⇐ 1234 ⇒



1. : MS Excel

 

, , . , .

: , , , (1). , . , ( . ). , 2 л, ( Enter) 3 , . , C, D, E.

. 2. 1959-89 .

  1959 . 1970 . 1979 . 1989 .
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       

 

() , NumLock. ( ) ( , , , ). , . , , +, , , . , Excel , .

, , ( ). : , , , , . , , .. , . : , , .

Excel. (+), (-), (*), (/). , (=), , . , 1959-89 . 1989 . 1959 . : =2B2. , 30 77,8 . .

1959 . , . ( B3 B17, [∑] ). . 30 . B2 E2, [∑] .

(, ) (, , , ) . , 1979 . . ( D3) ( D2). =D3/D2. 0,524132. , . 52,41%. . , ( ) . , ($) , . , =D3/D$2. , .

, . , . . . ( ), (), ().

1959 . 1989 . , . 1 3:17 ( 1959 .), 2, 3:17 ( 1989 .), . 0,9976336 .

. ( 2:2) . , . . ( 1:1), . . . . . .

. 3.

1989 . . ( ) . 3:17, , Ctrl, 3:17. . . .

. 4. 1989 .

 

Excel. -, .

:

A X (), B Y (). A1 20 (1 ), B1 (1 ). (A1 = 20, B1 = 30). . a b . (a = b = 1) ( C1 D1 1), 1 k =0,01 , F1 D t = 0,05. , :

. 5. Excel

        0,01 0,05

, A2 xi+1, . :

= A1 + F$1 * (C$1*A1 + E$1 * A1 * B1)

B2 yi+1, .

= B1 + F$1 * (D$1 * B1 E$1 * A1 * B1)

($), a, b, k, Δt ( , ). , 200 200 . 200 .

. 6. -

, . , (.. ), , . . , .

:

1. :

25,8  
14,5  
27,9  
17,6 3,3
26,4  
13,4 3,3
36,8 11,4
  1,4
20,1  
17,9  

2. , ;

3. ( );

4. ;

5. ;

6. , .

7. .

 
 
     
     
     
     
     
     

 

8. .

9. .

10. .

11. , .

12. .

13.

14. .

15.

16.

 


2. : MS ACCESS

 

: Microsoft Access ( ). , , -1. . , () . , . , . , . , . . , . . ( ). , . , .

. 7. Access

 
 

 

. () . : , , , , . .

. 8. Access

 
 
 
 
 

 

. : , , , , . . , . . :

.9. Access

3
       
       
       
       
       
       
       
       
       
       

. . (, , ). , . , .

. 1) ; 2) , ; 3) ; 4) ( , , , , , ) 5) .

. . , 4 5. , . >3 ( ). ( (!) ). , :

. 10. Access

 
 
 
 
 
 

 

, , , . , , , , . 2 .

. 11. Access

 
 

 

, , , . * ( * , .. * ).

. 12. Access

 
 
 
 
 

 

, , 1. , , (2003 .) 30 , .. 1973 . λ, . >1973. . , , 4.

. 13. Access

 
 
 
 
 
 
 
 
 

: , , . Σ . :

.

Sum , ,

Avg . , 1952,8886364, . , .

Min . 1928, , .

Max . 1976, .

Count , . 440, , 440 .

StDev . 22,130156667, , 22 .

First .

Last .

. : 1 ( ), 2 (Avg), 3 (StDev).

 

. 14. Access

Avg- StDev-
1953,51839464883 18,9908710698425
1939,40425531915 43,2815150695537
  8,75332449159589
- - 1950,72727272727 12,6892939842287
1955,7619047619 8,41370763637983
1955,25 10,367442836483

 

, , , , .

, . 1 ( ), 2 (Count).

. 15. Access

Count-
 
 
 
- -  
 
 

. . , . . ( ). . : 1 ( , ), 2 (, ), 3 (Count, ). .

. 16. Access

   
   
   
- -    
   
   

Count Avg, ( ) .

. 17. Access

1955,61764705882 1953,24905660377
1947,83333333333 1938,17073170732
  1964,58620689655
- -   1949,8
1951,5 1956,76470588235
   

, ( ) . : 1 (, ), 2 (, ), 3 (Count, ).

. 18. Access

     
     
     
     
     

 

, . , , . , , , 4 .

:

DUMA 1 ( 1- , 1906 .) :

1. ;

2. ;

3. -;

4. 40 ;

5. ;

6. ;

7. ;

8. ;

9. ;

10. .

COMANDARM ( ) :

11. , .

12. .

13. -.

14. 1941 .

15. , .

16. .

17. , 1917 .

18. , , .

19. .

20. .


3. : SPSS.

 

SPSS (Statistical Package for Social Science) , .

SPSS. SPSS ( SPSS for Windows) , , . SPSS : ( SPSS) ( ), . . :

(Name) , .. ( 8, ).

(Type) : (, 10345); (, 10,345); (, 10.345); (, 1200 12102); , ; () , , .

(Values) , (, ).

( ), , , . , , . 1, , . 1,00=. 2 , . , . , .

SPSS, , , (1=, 0=, .. ).

SPSS. World95 ( SPSS World95.sav), 1995 . . : Country ; Populatn (Population in thousands) ; Density (Number of people / sq. Kilometer) .; Urban (People living in cities (%)) ; Religion (Predominant religion) ; Lifeexpf (Average female life expectancy) ; Lifeexpm (Average male life expectancy) ; Literacy (People who read (%)) ; Pop_incr (Population increase (% per year)) ( %); Babymort (Infant mortality (deaths per 1000 live births)) 1000 ; Gdp_cap (Gross domestic product / capita) ; Region (Region or economic group) ; Calories (Daily calorie intake) ; Aids (Aids cases) ; Birth_rt (Birth rate per 1000 people) 1000 ; Death_rt (Death rate per 1000 people) 1000 ; Aids_rt (Number of aids cases / 100000 people) 100000 ; Lit_male (Males who read (%)) ; Lit_fema (Females who read (%)) ; Climate (Predominant climate) .

Predominant religion, . ( ) Predominant religion , , ( ). , , . . Output1. Output1 ( ), . . Output1 (. . 19, 20.).

: Frequency ( 108 , (Valid), 41 , 8 , 7 ..) (Missing). Percent , (.. 109). 37,6%, 7,3%, 6,4%. Valid Percent (.. 108 ). Cumulative Percent .

. 19. Output1. Statistics Predominant religion

N Valid    
  Missing    

. 20. Output1. Predominant religion

    Frequency Percent Valid Percent Cumulative Percent  
Valid Animist   3,7 3,7 3,7  
  Buddhist   6,4 6,5 10,2  
  Catholic   37,6 38,0 48,1  
  Hindu   ,9 ,9 49,1  
  Jewish   ,9 ,9 50,0  
  Muslim   24,8 25,0 75,0  
  Orthodox   7,3 7,4 82,4  
  Protstnt   14,7 14,8 97,2  
  Taoist   1,8 1,9 99,1  
  Tribal   ,9 ,9 100,0  
  Total   99,1 100,0    
Missing     ,9      
Total     100,0      

(Crosstab) Predominant religion Predominant climate, . ( ) Predominant religion , , (), Predominant climate (). -. . Output2.

: . 21. Output2 () (Valid) (Missing). . 22. (Crosstabulation Count) . . 23. χ2 - (Value) , (Asymp. Sig.) , 0,05, .

 

. 21. Output2. Case Processing Summary

  Cases            
  Valid   Missing   Total    
  N Percent N Percent N Percent  
Predominant religion * Predominant climate   97,2%   2,8%   100,0%  

. 22. Output2. Predomin. religion * Predomin. climate Crosstabulation Count

    climate                 Total  
    desert arid / desert arid   tropical mediterranean maritime temperate arctic / temp    
Predominant religion Animist                      
  Buddhist                      
  Catholic                      
  Hindu                      
  Jewish                      
  Muslim                      
  Orthodox                      
  Protstnt                      
  Taoist                      
  Tribal                      
Total                        

. 23. Output2. Chi-Square Tests

  Value Asymp. Sig. (2-sided)  
Pearson Chi-Square ,106 ,005  
N of Valid Cases      

 

: -. : People living in cities (%), People who read (%), Infant mortality (deaths per 1000 live births), Gross domestic product / capital, Number of aids cases / 100000 people. . Output3.

: . 24. . (Pearson Correlation), (Sig.), (N) . , Infant mortality People living in cities, People who read, , . (Sig.). , , Number of aids cases People who read Gross domestic product / capital, .

 

. 24. Output3. ..

    People living in cities (%) People who read (%) Infant mortality (deaths per 1000 live births) Gross domestic product / capita Number of aids cases / 100000 people  
People living in cities (%) Pearson Correlation   ,650 -,718 ,605 -,287  
  Sig. (2-tailed) , ,000 ,000 ,000 ,003  
  N            
People who read (%) Pearson Correlation ,650   -,900 ,552 -,160  
  Sig. (2-tailed) ,000 , ,000 ,000 ,104  
  N            
Infant mortality (deaths per 1000 live births) Pearson Correlation -,718 -,900   -,640 ,285  
  Sig. (2-tailed) ,000 ,000 , ,000 ,003  
  N            
Gross domestic product / capita Pearson Correlation ,605 ,552 -,640   -,031  
  Sig. (2-tailed) ,000 ,000 ,000 , ,749  
  N            
Number of aids cases / 100000 people Pearson Correlation -,287 -,160 ,285 -,031    
  Sig. (2-tailed) ,003 ,104 ,003 ,749 ,  
  N            

: . Infant mortality , , , People living in cities . . . Output4.

: . 25. R R Square. , , . . 26. -1,131 , 106,55 ( Constant). : Infant mortality = 106,55+(-1,131* People living in cities). , 1% 1,1%. t- ; , .

 

. 25. Output4. Model Summary

Model R R Square Adjusted R Square Std. Error of the Estimate  
  ,718 ,516 ,511 26,6580  

 

. 26. Output4. Coefficients

    Unstandardized Coefficients   Standardized Coefficients t Sig.  
Model   B Std. Error Beta      
  (Constant) 106,550 6,543   16,285 ,000  
  People living in cities (%) -1,131 ,106 -,718 -10,622 ,000  

 

: . : People living in cities, People who read, Infant mortality, Gross domestic product, Daily calorie intake, Number of aids cases. , , (Principal components). . Output5.

 

. 27. Output5.Total Variance Explained

  Initial Eigenvalues     Extraction Sums of Squared Loadings      
Component Total % of Variance Cumulative % Total % of Variance Cumulative %  
  3,955 65,919 65,919 3,955 65,919 65,919  
  ,988 16,468 82,386        
  ,451 7,517 89,903        
  ,337 5,623 95,527        
  ,212 3,527 99,053        
  5,681E-02 ,947 100,000        

. 28. Output5.Component Matrix

  Component  
     
People living in cities (%) ,849  
People who read (%) ,884  
Infant mortality (deaths per 1000 live births) -,946  
Gross domestic product / capita ,818  
Daily calorie intake ,887  
Number of aids cases / 100000 people -,319  

 

: . 27. . (Component 1) (Total) 3,955 65,9% . , . . 28. . , , , Number of aids cases, , .

: . , , Country. , , : People who read, Average male life expectancy, Daily calorie intake. Dendrograma, , . Output6.

: . 29. . () ( ), , . , .

. 29.

C A S E 0 5 10 15 20 25

Label Num +---------+---------+---------+---------+---------+

 

Netherlands 70 òø

UK 101 òú

Turkey 99 òú

Australia 4 òú

Iran 52 òôòòòòòø

Libya 64 òú ó

New Zealand 71 òú ùòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòø

Norway 74 ò÷ ó ó

Greece 43 òûòø ó ó

Ireland 54 ò÷ ó ó ó

Austria 5 òø ó ó ó

Italy 56 òú ùòòò÷ ó

Canada 21 òú ó ó

Germany 42 òôò÷ ó

Hungary 48 òú ó

USA 102 ò÷ ó

China 24 òø ó

Uruguay 105 òôòø ó

Colombia 25 ò÷ ùòòòòòòòòòòòø ó

Brazil 15 òø ó ó ó

Costa Rica 26 òôò÷ ó ó

Saudi Arabia 87 ò÷ ó ó

Bolivia 12 òø ó ó

Somalia 90 òú ó ó

Bangladesh 8 òôòòòø ó ó

Cent. Afri.R 22 òú ó ùòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòòò÷

Zambia 109 ò÷ ó ó

Guatemala 44 òø ó ó

Cameroon 20 òú ùòòòòòòòø ó

Nicaragua 72 òú ó ó ó

Cambodia 19 òú ó ó ó

Uganda 103 òú ó ó ó

Kenya 59 òú ó ó ó

Peru 79 òôòòò÷ ó ó

Liberia 63 òú ùò÷

Nigeria 73 òú ó

Burkina Faso 17 ò÷ ó

Ethiopia 36 òòòòòòòòòòòòò÷

:

SPSS .

: 1-18; 19-25; 26-45; 46-60; <60

: ;

: ; ; ;

: ; ;

: ; ; ; , ()

: ; ; ; ; ; ;

: ; ; ; ; ; ; ;

: , , ,

2008 .: ; ; ;

 

WORLD95 .

 

1. Region or economic group, , .

2. , : Average male life expectancy, Females who read (%), Number of people / sq. Kilometer, deaths per 1000 live births. .

3. , People living in cities (%), Gross domestic product / capita, deaths per 1000 live births, .

4. .

 

INDUSTRY ( 1900 1908 .)

 

4. INDUSTRY ACCESS SPSS.

5. .

6. , , .

7.


⇐ 1234 ⇒


:

: 2016-10-06; !; : 346 |

:

:

, .
==> ...

1472 - | 1384 -


© 2015-2024 lektsii.org - -

: 0.242 .