Module 250 Xls 1 Sol

Embed Size (px)

Citation preview

  • 7/25/2019 Module 250 Xls 1 Sol

    1/64

    Pratique des biostatistiques www.fundp.ac.bA propos du

    Ralise l!"nal#se en compostantes principales dles rsultats.

    Reference$ U.%. Department of &abor %tatistics"ut'oriation$ free useDescription$ Properties of () %tandard *etropolit,ensus ureau desination of t'e reion aroundcollected from a variet# of sources.

    1'e data include information on t'e social and e

    areas0 on t'eir climate0 and some indices of air pNumber of cases$ ()2ariable Names$3 cit#$ ,it# name4 5an1emp$ *ean 5anuar# temperature +derees7 5ul#1emp$ *ean 5ul# temperature +derees 6ar8 Rel9um$ Relative 9umidit#

    : Rain$ "nnual rainfall +inc'es( *ortalit#$ "e ad;usted mortalit#< Education$ *edian education= PopDensit#$ Population densit#> ?Non@'ite$ Percentae of non w'ites3) ?@,$ Percentae of w'ite collar worAers33 pop$ Population

    34 pop/'ouse$ Population per 'ouse'old37 income$ *edian income38 9,Pot$ 9, pollution potential3: NBxPot$ Nitrous Bxide pollution potential3( %B4Pot$ %ulfur Dioxide pollution potential

    http://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdfhttp://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdf
  • 7/25/2019 Module 250 Xls 1 Sol

    2/64

    city Mortality JanTemp JulyTemp RelHum

    Akron, OH 921.87 27 71 59Albany-Schenectady-Troy, NY 997.87 23 72 57Allentown, Bethlehem, PA-NJ 92.35 29 7! 5!Atlanta, GA 982.29 !5 79 5Baltimore, MD 1"71.29 35 77 55Birmingham, AL 1"3".38 !5 8" 5!Boston, MA 93!.7 3" 7! 5Bridgeport-Milford, CT 899.53 3" 73 5Buffalo, NY 1""1.9 2! 7" 1Canton, OH 912.35 27 72 59Chattanooga, TN-GA 1"17.1 !2 79 5Chicago, IL 1"2!.89 2 7 58Cincinnati, OH-KY-IN 97".!7 3! 77 57Cleveland, OH 985.95 28 71 "Columbus, OH 958.8! 31 75 58Dallas, TX 8".1 ! 85 5!Dayton-Springfield, OH 93.23 3" 75 58Denver, CO 871.77 3" 73 38Detroit, MI 959.22 27 7! 59Flint, MI 9!1.18 2! 72 1Grand Rapids, MI 871.3! 2! 72 1Greensboro-Winston-Salem-High Point, 971.12 !" 77 53Hartford, CT 887.!7 27 72 5Houston, TX 952.53 55 8! 59Indianapolis, IN 98.7 29 75 "Kansas City, MO 919.73 31 81 55Lancaster, PA 8!!."5 32 7! 5!Los Angeles, Long Beach, CA 81.2 53 8 !7Louisville, KY-IN 989.2 35 71 57

  • 7/25/2019 Module 250 Xls 1 Sol

    3/64

    Memphis, TN-AR-MS 1"".!9 !2 82 59Miami-Hialeah, FL 81.!! 7 82 "Milwaukee, WI 929.15 2" 9 !Minneapolis-St. Paul, MN-WI 857.2 12 73 58Nashville, TN 91."1 !" 8" 5New Haven-Meriden, CT 923.23 3" 72 58New Orleans, LA 1113.1 5! 81 2New York, NY 99!.5 33 77 58Philadelphia, PA-NJ 1"15."2 32 7 5!Pittsburgh, PA 991.29 29 72 5Portland, OR 893.99 38 7 73Providence, RI 938.5 29 72 5Reading, PA 9!.19 33 77 5!Richmond-Petersburg, VA 1"25.5 39 78 53Rochester, NY 87!.28 25 72 "St. Louis, MO-IL 953.5 32 79 57San Diego, CA

    839.71 55 7" 1San Francisco, CA 911.7 !8 3 71San Jose, CA 79".73 !9 8 71Seattle, WA 899.2 !" ! 72Springfield, MA 9"!.1 28 7! 5Syracuse, NY 95".7 2! 72 1Toledo, OH 972.! 2 73 59Utica-Rome, NY 912.2 23 71 "Washington, DC-MD-VA 97.8 37 78 52Wichita, KS 823.7 32 81 5!Wilmington, DE-NJ-MD 1""3.5 33 7 5

    Worcester, MA 895.7 2! 7" 5York, PA 911.82 33 7 5!Youngstown-Warren, OH 95!.!! 28 72 58

    source

    http://lib.stat.cmu.edu/DASL/Datafiles/SMSA.htmlhttp://lib.stat.cmu.edu/DASL/Datafiles/SMSA.html
  • 7/25/2019 Module 250 Xls 1 Sol

    4/64

    /biostats Eric Depiereux - Universit de Namur

    ces donnes et commente

    n %tatistical "reas +a standardcit# in t'e United %tates0

    onomic conditions in t'ese

    llution potentials.

    6aren'eiten'eit

  • 7/25/2019 Module 250 Xls 1 Sol

    5/64

    Rain #ducation $op%ensity &'on()ite &(* pop pop+)ouse

    3 11.! 32!3 8.8 !2. "328 3.3!

    35 11 !281 3.5 5".7 83588" 3.1!

    !! 9.8 !2" ".8 39.! 35!81 3.21

    !7 11.1 3125 27.1 5".2 2138231 3.!1

    !3 9. !!1 2!.! !3.7 2199531 3.!!

    53 1".2 3325 38.5 !3.1 8839! 3.!5

    !3 12.1 !79 3.5 !9.2 28"5911 3.23

    !5 1". 21!" 5.3 !".! !38557 3.29

    3 1".5 582 8.1 !2.5 1"15!72 3.31

    3 1".7 !213 .7 !1 !"!!21 3.3

    52 9. 23"2 22.2 !1.3 !25!" 3.39

    33 1".9 122 1.3 !!.9 "387 3.2

    !" 1".2 !1"1 13 !5.7 1!"1!91 3.21

    35 11.1 3"!2 1!.7 !!. 1898825 3.29

    37 11.9 !259 13.1 !9. 12!833 3.2

    35 11.8 1!!1 1!.8 51.2 1957378 3.22

    3 11.! !"29 12.! !! 9!2"83 3.35

    15 12.2 !82! !.7 53.1 1!2883 3.15

    31 1".8 !83! 15.8 !3.5 !!88"72 3.!!

    3" 1".8 39! 13.1 33.8 !5"!!9 3.53

    31 1".9 322 5.1 !5.2 "18" 3.37

    !2 1".! 229 22.7 !1.! 851851 3.!5

    !3 11.5 29"9 7.2 51. 715923 3.25

    ! 11.! 2!7 21 !.9 27357 3.35

    39 11.! !!12 15. !. 11575 3.23

    35 12 322 12. !8. 91!!27 3.1

    !3 9.5 321! 2.9 !3.7 323! 3.38

    11 12.1 !7"" 7.8 !8.9 7!775"3 2.

    3" 9.9 !!7! 13.1 !2. 9575 3.37

  • 7/25/2019 Module 250 Xls 1 Sol

    6/64

    5" 1".! 3!97 3.7 !3.3 913!72 3.!9

    " 11.5 !57 13.5 !7.3 125781 2.5

    3" 11.1 293! 5.8 !! 13971!3 3.2

    25 12.1 2"95 2 51.9 2137133 3.28

    !5 1".1 282 21 !.1 85"5"5 3.32

    ! 11.3 3327 8.8 !5.3 5""!7! 3.1

    5! 9.7 3172 31.! !5.5 12525 3.3

    !2 1".7 7!2 11.3 !8.7 827!91 3."3

    !2 1".5 "92 17.5 !5.3 !71818 3.32

    3 1". 3!37 8.1 !5.5 221887" 3.32

    37 12 3387 3. 5".3 11"599 2.

    !2 1".1 35"8 2.2 38.8 1851! 3.1

    !1 9. !8!3 2.7 38. 3125"9 3."8

    !! 11 378 28. !9.5 71311 3.32

    32 11.1 !355 5 !.! 97123" 3.21

    3! 9.7 51" 17.2 !5.1 18"821 3.23

    1" 12.1 3"33 5.9 51 1818! 3.1118 12.2 !253 13.7 51.2 1!88871 2.92

    13 12.2 27"2 3 51.9 1295"71 3.3

    35 12.2 32 5.7 5!.3 1"7!9 3."2

    !5 11.1 1883 3.! !1.9 515259 3.21

    38 11.! !923 3.8 5".5 !2971 3.3!

    31 1".7 32!9 9.5 !3.9 18! 3.22

    !" 1".3 171 2.5 !7.! 32"18" 3.28

    !2 12.3 53"8 25.9 59.7 325"822 3.25

    28 12.1 35 7.5 51. !11313 3.27

    5 11.3 3152 12.1 !7.3 523221 3.39

    5 11.1 378 1 !!.8 !"2918 3.252 9 999 !.8 2.2 381255 3.22

    38 1".7 3!51 11.7 37.5 53135" 3.!8

  • 7/25/2019 Module 250 Xls 1 Sol

    7/64

  • 7/25/2019 Module 250 Xls 1 Sol

    8/64

    income H*$ot ',-$ot "2$ot ',-

    295" 21 15 59 15

    31!58 8 1" 39 1"

    3185 33

    32!52 18 8 2! 8

    3238 !3 38 2" 38

    27835 3" 32 72 32

    3!! 21 32 2 32

    !7258 ! ! !

    312!8 18 12 37 12

    29"89 12 7 2" 7

    25782 18 8 27 8

    3593 88 3 278 3

    31!27 2 2 1! 2

    3572" 31 21 ! 21

    2971 23 9 15 9

    3879 1 1 1 1

    3"232 ! 1 !

    39"99 17 8 28 8

    33858 52 35 12! 35

    32""" 11 ! 11 !

    29915 5 3 1" 3

    29!5" 8 3 5 3

    3755 7 3 1" 3

    39558 5 1 5

    31!1 13 7 33 7

    3"783 7 ! ! !

    3"2!8 11 7 32 7

    32! !8 319 13" 319

    2921 38 37 193 37

  • 7/25/2019 Module 250 Xls 1 Sol

    9/64

    2791" 15 18 3! 18

    328"8 3 1 1 1

    35272 33 23 125 23

    35871 2" 11 2 11

    28!1 17 1! 78 1!

    3!3! ! 3 8 3

    327"! 2" 17 1 17

    3"!7 !1 2 1"8 2

    33!!9 29 32 11 32

    3293! !5 59 23 59

    33"2" 5 21 !! 21

    3""9! ! 18 !

    32!!9 11 11 89 11

    3351" 12 9 !8 9

    3!89 7 ! 18 !

    3!5! 31 15 8 15

    3258 1!! 2" !79 311 171 8 171

    !199! 1"5 32 3 32

    37"9 2" 7 2" 7

    29327 5 1 2" 1

    3"11! 8 5 25 5

    3"!97 11 7 25 7

    273"5 5 2 11 2

    !1888 5 28 1"2 28

    3!812 ! 2 1 2

    33927 1! 11 !2 11

    2937! 7 3 8 328985 8 8 !9 8

    289" 1! 13 39 13

  • 7/25/2019 Module 250 Xls 1 Sol

    10/64

    Pratique des biostatistiques www.fundp.ac.bcity Mortality JanTemp JulyTemp RelHumAkron, OH 921.87 27 71 59Albany-Schenectady-Troy, NY 997.87 23 72 57Allentown, Bethlehem, PA-NJ 92.35 29 7! 5!

    Atlanta, GA 982.29 !5 79 5Baltimore, MD 1"71.29 35 77 55Birmingham, AL 1"3".38 !5 8" 5!Boston, MA 93!.7 3" 7! 5Bridgeport-Milford, CT 899.53 3" 73 5Buffalo, NY 1""1.9 2! 7" 1Canton, OH 912.35 27 72 59Chattanooga, TN-GA 1"17.1 !2 79 5Chicago, IL 1"2!.89 2 7 58Cincinnati, OH-KY-IN 97".!7 3! 77 57Cleveland, OH 985.95 28 71 "

    Columbus, OH 958.8! 31 75 58Dallas, TX 8".1 ! 85 5!Dayton-Springfield, OH 93.23 3" 75 58Denver, CO 871.77 3" 73 38Detroit, MI 959.22 27 7! 59Flint, MI 9!1.18 2! 72 1Grand Rapids, MI 871.3! 2! 72 1Greensboro-Winston-Salem-High Point, 971.12 !" 77 53Hartford, CT 887.!7 27 72 5Houston, TX 952.53 55 8! 59Indianapolis, IN 98.7 29 75 "

    Kansas City, MO 919.73 31 81 55Lancaster, PA 8!!."5 32 7! 5!Los Angeles, Long Beach, CA 81.2 53 8 !7Louisville, KY-IN 989.2 35 71 57Memphis, TN-AR-MS 1"".!9 !2 82 59Miami-Hialeah, FL 81.!! 7 82 "Milwaukee, WI 929.15 2" 9 !Minneapolis-St. Paul, MN-WI 857.2 12 73 58Nashville, TN 91."1 !" 8" 5New Haven-Meriden, CT 923.23 3" 72 58New Orleans, LA 1113.1 5! 81 2

    New York, NY 99!.5 33 77 58Philadelphia, PA-NJ 1"15."2 32 7 5!Pittsburgh, PA 991.29 29 72 5Portland, OR 893.99 38 7 73Providence, RI 938.5 29 72 5Reading, PA 9!.19 33 77 5!Richmond-Petersburg, VA 1"25.5 39 78 53Rochester, NY 87!.28 25 72 "

    A propos du

    75" 8"" 85" 9"" 95" 1"""

    "

    ".5

    1

    1.5

    2

    2.5

    3

    3.5

    !

    $asser en re/ue les /aria0les cliuer sur les points saisir les donn4es encadr4es et aire 6li .

    %tatistiques univariede la line 6ort @ort'manquantesNBxPot et Nox redondNox1ransformation de po

    %)4Pot en &BC

    http://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdfhttp://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdf
  • 7/25/2019 Module 250 Xls 1 Sol

    11/64

  • 7/25/2019 Module 250 Xls 1 Sol

    12/64

    /biostats Eric Depiereux - Universit de NamurRain #ducation $op%ensity &'on()ite &(* pop pop+)ouse

    3 11.! 32!3 8.8 !2. "328 3.3!

    35 11 !281 3.5 5".7 83588" 3.1!

    !! 9.8 !2" ".8 39.! 35!81 3.21

    !7 11.1 3125 27.1 5".2 2138231 3.!1!3 9. !!1 2!.! !3.7 2199531 3.!!

    53 1".2 3325 38.5 !3.1 8839! 3.!5

    !3 12.1 !79 3.5 !9.2 28"5911 3.23

    !5 1". 21!" 5.3 !".! !38557 3.29

    3 1".5 582 8.1 !2.5 1"15!72 3.31

    3 1".7 !213 .7 !1 !"!!21 3.3

    52 9. 23"2 22.2 !1.3 !25!" 3.39

    33 1".9 122 1.3 !!.9 "387 3.2

    !" 1".2 !1"1 13 !5.7 1!"1!91 3.21

    35 11.1 3"!2 1!.7 !!. 1898825 3.29

    37 11.9 !259 13.1 !9. 12!833 3.235 11.8 1!!1 1!.8 51.2 1957378 3.22

    3 11.! !"29 12.! !! 9!2"83 3.35

    15 12.2 !82! !.7 53.1 1!2883 3.15

    31 1".8 !83! 15.8 !3.5 !!88"72 3.!!

    3" 1".8 39! 13.1 33.8 !5"!!9 3.53

    31 1".9 322 5.1 !5.2 "18" 3.37

    !2 1".! 229 22.7 !1.! 851851 3.!5

    !3 11.5 29"9 7.2 51. 715923 3.25

    ! 11.! 2!7 21 !.9 27357 3.35

    39 11.! !!12 15. !. 11575 3.23

    35 12 322 12. !8. 91!!27 3.1!3 9.5 321! 2.9 !3.7 323! 3.38

    11 12.1 !7"" 7.8 !8.9 7!775"3 2.

    3" 9.9 !!7! 13.1 !2. 9575 3.37

    5" 1".! 3!97 3.7 !3.3 913!72 3.!9

    " 11.5 !57 13.5 !7.3 125781 2.5

    3" 11.1 293! 5.8 !! 13971!3 3.2

    25 12.1 2"95 2 51.9 2137133 3.28

    !5 1".1 282 21 !.1 85"5"5 3.32

    ! 11.3 3327 8.8 !5.3 5""!7! 3.1

    5! 9.7 3172 31.! !5.5 12525 3.3

    !2 1".7 7!2 11.3 !8.7 827!91 3."3!2 1".5 "92 17.5 !5.3 !71818 3.32

    3 1". 3!37 8.1 !5.5 221887" 3.32

    37 12 3387 3. 5".3 11"599 2.

    !2 1".1 35"8 2.2 38.8 1851! 3.1

    !1 9. !8!3 2.7 38. 3125"9 3."8

    !! 11 378 28. !9.5 71311 3.32

    32 11.1 !355 5 !.! 97123" 3.21

    1"5" 11"" 115"

    ser. *liuer sur la-e des ordonn4es on6let ec)elle pour selec tionner le lo6arit)me.

    pop+)ouse

    $ suppression+donnes

    antes supprimer

    9,Pot NBxPot

  • 7/25/2019 Module 250 Xls 1 Sol

    13/64

    3! 9.7 51" 17.2 !5.1 18"821 3.23

    1" 12.1 3"33 5.9 51 1818! 3.11

    18 12.2 !253 13.7 51.2 1!88871 2.92

    13 12.2 27"2 3 51.9 1295"71 3.3

    35 12.2 32 5.7 5!.3 1"7!9 3."2

    !5 11.1 1883 3.! !1.9 515259 3.21

    38 11.! !923 3.8 5".5 !2971 3.3!

    31 1".7 32!9 9.5 !3.9 18! 3.22

    !" 1".3 171 2.5 !7.! 32"18" 3.28

    !2 12.3 53"8 25.9 59.7 325"822 3.25

    28 12.1 35 7.5 51. !11313 3.27

    5 11.3 3152 12.1 !7.3 523221 3.39

    5 11.1 378 1 !!.8 !"2918 3.25

    2 9 999 !.8 2.2 381255 3.22

    38 1".7 3!51 11.7 37.5 53135" 3.!8

  • 7/25/2019 Module 250 Xls 1 Sol

    14/64

    income H*$ot ',-$ot "2$ot ',-

    295" 21 15 59 15

    31!58 8 1" 39 1"

    3185 33

    32!52 18 8 2! 83238 !3 38 2" 38

    27835 3" 32 72 32

    3!! 21 32 2 32

    !7258 ! ! !

    312!8 18 12 37 12

    29"89 12 7 2" 7

    25782 18 8 27 8

    3593 88 3 278 3

    31!27 2 2 1! 2

    3572" 31 21 ! 21

    2971 23 9 15 93879 1 1 1 1

    3"232 ! 1 !

    39"99 17 8 28 8

    33858 52 35 12! 35

    32""" 11 ! 11 !

    29915 5 3 1" 3

    29!5" 8 3 5 3

    3755 7 3 1" 3

    39558 5 1 5

    31!1 13 7 33 7

    3"783 7 ! ! !3"2!8 11 7 32 7

    32! !8 319 13" 319

    2921 38 37 193 37

    2791" 15 18 3! 18

    328"8 3 1 1 1

    35272 33 23 125 23

    35871 2" 11 2 11

    28!1 17 1! 78 1!

    3!3! ! 3 8 3

    327"! 2" 17 1 17

    3"!7 !1 2 1"8 233!!9 29 32 11 32

    3293! !5 59 23 59

    33"2" 5 21 !! 21

    3""9! ! 18 !

    32!!9 11 11 89 11

    3351" 12 9 !8 9

    3!89 7 ! 18 !

  • 7/25/2019 Module 250 Xls 1 Sol

    15/64

    3!5! 31 15 8 15

    3258 1!! 2"

    !79 311 171 8 171

    !199! 1"5 32 3 32

    37"9 2" 7 2" 7

    29327 5 1 2" 1

    3"11! 8 5 25 5

    3"!97 11 7 25 7

    273"5 5 2 11 2

    !1888 5 28 1"2 28

    3!812 ! 2 1 2

    33927 1! 11 !2 11

    2937! 7 3 8 3

    28985 8 8 !9 8

    289" 1! 13 39 13

  • 7/25/2019 Module 250 Xls 1 Sol

    16/64

    Pratique des biostatistiques www.fundp.ac.b

    city Mortality JanTemp JulyTemp RelHumAkron, OH 921.87 27 71 59Albany-Schenectady-Troy, NY 997.87 23 72 57Allentown, Bethlehem, PA-NJ 92.35 29 7! 5!Atlanta, GA 982.29 !5 79 5Baltimore, MD 1"71.29 35 77 55Birmingham, AL 1"3".38 !5 8" 5!Boston, MA 93!.7 3" 7! 5Bridgeport-Milford, CT 899.53 3" 73 5Buffalo, NY 1""1.9 2! 7" 1Canton, OH 912.35 27 72 59Chattanooga, TN-GA 1"17.1 !2 79 5Chicago, IL 1"2!.89 2 7 58Cincinnati, OH-KY-IN 97".!7 3! 77 57Cleveland, OH 985.95 28 71 "Columbus, OH 958.8! 31 75 58Dallas, TX 8".1 ! 85 5!Dayton-Springfield, OH 93.23 3" 75 58Denver, CO 871.77 3" 73 38Detroit, MI 959.22 27 7! 59Flint, MI 9!1.18 2! 72 1Grand Rapids, MI 871.3! 2! 72 1Greensboro-Winston-Salem-High Point, 971.12 !" 77 53Hartford, CT 887.!7 27 72 5Houston, TX 952.53 55 8! 59Indianapolis, IN 98.7 29 75 "Kansas City, MO 919.73 31 81 55Lancaster, PA 8!!."5 32 7! 5!Los Angeles, Long Beach, CA 81.2 53 8 !7Louisville, KY-IN 989.2 35 71 57Memphis, TN-AR-MS 1"".!9 !2 82 59Miami-Hialeah, FL 81.!! 7 82 "Milwaukee, WI 929.15 2" 9 !Minneapolis-St. Paul, MN-WI 857.2 12 73 58Nashville, TN 91."1 !" 8" 5New Haven-Meriden, CT 923.23 3" 72 58New Orleans, LA 1113.1 5! 81 2New York, NY 99!.5 33 77 58Philadelphia, PA-NJ 1"15."2 32 7 5!Pittsburgh, PA 991.29 29 72 5Portland, OR 893.99 38 7 73Providence, RI 938.5 29 72 5Reading, PA 9!.19 33 77 5!Richmond-Petersburg, VA 1"25.5 39 78 53

    A propos du

    75" 8"" 85" 9"" 95" 1""" 1"5" 11

    "

    5

    1"

    15

    2"

    25

    3"

    35

    !"

    !5

    R : ".!18"3!77"7

    $asser en re/ue les /aria0les cliuer sur les points saisir les donn4es encadr4es et aire 6li .

    http://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdfhttp://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdf
  • 7/25/2019 Module 250 Xls 1 Sol

    17/64

    Rochester, NY 87!.28 25 72 "St. Louis, MO-IL 953.5 32 79 57San Diego, CA 839.71 55 7" 1San Francisco, CA 911.7 !8 3 71San Jose, CA 79".73 !9 8 71Seattle, WA 899.2 !" ! 72Springfield, MA 9"!.1 28 7! 5Syracuse, NY 95".7 2! 72 1Toledo, OH 972.! 2 73 59Utica-Rome, NY 912.2 23 71 "Washington, DC-MD-VA 97.8 37 78 52Wichita, KS 823.7 32 81 5!Wilmington, DE-NJ-MD 1""3.5 33 7 5Worcester, MA 895.7 2! 7" 5York, PA 911.82 33 7 5!Youngstown-Warren, OH 95!.!! 28 72 58

    moyenne 9!1.17 33.8" 7!.!1 57.75

    /ariance 389.!2 1"3." 21.18 28.95

    mod>le 0" 01

    ".95!"3 ?"."53779

    ".173!3"29 1 8.8

    ".!7222727 1 3.5

    ".2!!!! 1 ".8

    ?".8582!9! 1 27.1

    ?".7""!71 1 2!.!?1.5""9"32 1 38.5

    ".!7222727 1 3.5

    ".37"7!9"5 1 5.3

    ".21289!"! 1 8.1

    ".2918215! 1 .7

    ?".582"187 1 22.2

    ?".2!93952 1 1.3

    ?"."335222 1 13

    ?".1591927 1 1!.7

    ?"."89899 1 13.1

    ?".1!83"!! 1 1!.8

    ?"."295215 1 12.!

    ".!"!57512 1 !.7

    ?".2212"723 1 15.8

    ?"."89899 1 13.1

    ".382"2!!1 1 5.1

    ?".1"2"7"7 1 22.7

    ".233315 1 7.2

    source

    http://lib.stat.cmu.edu/DASL/Datafiles/SMSA.htmlhttp://lib.stat.cmu.edu/DASL/Datafiles/SMSA.html
  • 7/25/2019 Module 250 Xls 1 Sol

    18/64

    ?".51!353 1 21

    ?".2"993187 1 15.

    ?"."!"8"151 1 12.

    ".5""533! 1 2.9

    ".2298"7"8 1 7.8

    ?"."89899 1 13.1

    ?1.399!821 1 3.7

    ?"."915!"2 1 13.5

    ".3!25"5 1 5.8

    ".55792!5 1 2

    ?".51!353 1 21

    ".173!3"29 1 8.8

    ?1.1""8513 1 31.!

    "."32!8832 1 11.3

    ?".317"!777 1 17.5

    ".21289!"! 1 8.1

    ".!58959 1 3.

    ".5!5517"9 1 2.2".5173287 1 2.7

    ?".9!283"12 1 28.

    ".3872"9 1 5

    ?".3""13!73 1 17.2

    ".3392298 1 5.9

    ?".1"281597 1 13.7

    ".5""!15 1 3

    ".3!819833 1 5.7

    ".!778!95 1 3.!

    ".!5531!23 1 3.8

    ".13395! 1 9.5

    ".528"!" 1 2.5

    ?".79"1279 1 25.9

    ".2!72"11 1 7.5

    ?"."121311 1 12.1

    ".13192! 1 1

    ".398937!! 1 !.8

    ".""9937 1 11.7

    moyenne 1.9993#?"15

    /ariance ".2573"8R2 ."37#?""5

  • 7/25/2019 Module 250 Xls 1 Sol

    19/64

    /biostats Eric Depiereux - Universit de Namur

    Rain #ducation $op%ensity &'on()ite &(* ;,@ pop pop+)ouse

    3 11.! 32!3 8.8 !2. 5.81975971 3.3!

    35 11 !281 3.5 5".7 5.9221!393 3.1!

    !! 9.8 !2" ".8 39.! 5.8"31"257 3.21

    !7 11.1 3125 27.1 5".2 .33""5!2 3.!1

    !3 9. !!1 2!.! !3.7 .3!233""9 3.!!

    53 1".2 3325 38.5 !3.1 5.9!!2573 3.!5

    !3 12.1 !79 3.5 !9.2 .!!8"7389 3.23

    !5 1". 21!" 5.3 !".! 5.!2"2"5 3.29

    3 1".5 582 8.1 !2.5 .""795 3.31

    3 1".7 !213 .7 !1 5."8337 3.3

    52 9. 23"2 22.2 !1.3 5.299597 3.39

    33 1".9 122 1.3 !!.9 5.7827!988 3.2

    !" 1".2 !1"1 13 !5.7 .1!59"31 3.21

    35 11.1 3"!2 1!.7 !!. .278!8!9! 3.29

    37 11.9 !259 13.1 !9. 5."9329!1 3.2

    35 11.8 1!!1 1!.8 51.2 .2917!7 3.22

    3 11.! !"29 12.! !! 5.97!"8917 3.35

    15 12.2 !82! !.7 53.1 .15!98238 3.15

    31 1".8 !83! 15.8 !3.5 .52"5982 3.!!

    3" 1".8 39! 13.1 33.8 5.53!53 3.53

    31 1".9 322 5.1 !5.2 5.7793558 3.37

    !2 1".! 229 22.7 !1.! 5.93"33! 3.!5

    !3 11.5 29"9 7.2 51. 5.85!831 3.25

    ! 11.! 2!7 21 !.9 .!37"7895 3.35

    39 11.! !!12 15. !. ."9127 3.23

    35 12 322 12. !8. 5.911!9"! 3.1

    !3 9.5 321! 2.9 !3.7 5.559123!7 3.38

    11 12.1 !7"" 7.8 !8.9 .87375 2.

    3" 9.9 !!7! 13.1 !2. 5.98"8"119 3.37

    5" 1".! 3!97 3.7 !3.3 5.9"952! 3.!9

    " 11.5 !57 13.5 !7.3 .211"2"! 2.5

    3" 11.1 293! 5.8 !! .1!52!"8 3.2

    25 12.1 2"95 2 51.9 .32983155 3.28

    !5 1".1 282 21 !.1 5.929787 3.32

    ! 11.3 3327 8.8 !5.3 5.9938152 3.1

    5! 9.7 3172 31.! !5.5 ."99"7815 3.3

    !2 1".7 7!2 11.3 !8.7 .917759 3."3

    !2 1".5 "92 17.5 !5.3 .73!912 3.32

    3 1". 3!37 8.1 !5.5 .3!1318 3.32

    37 12 3387 3. 5".3 ."!3392 2.

    !2 1".1 35"8 2.2 38.8 5.7913!953 3.1

    !1 9. !8!3 2.7 38. 5.!9!8253 3."8

    !! 11 378 28. !9.5 5.881521 3.32

    "" 115"

    ser. *liuer sur la-e des ordonn4es on6let ec)elle pour selec tionner le lo6arit)me.

    &'on()ite

    ;inear

  • 7/25/2019 Module 250 Xls 1 Sol

    20/64

    32 11.1 !355 5 !.! 5.987322"9 3.21

    3! 9.7 51" 17.2 !5.1 .2573!757 3.23

    1" 12.1 3"33 5.9 51 .299!37 3.11

    18 12.2 !253 13.7 51.2 .172857"7 2.92

    13 12.2 27"2 3 51.9 .11229358 3.3

    35 12.2 32 5.7 5!.3 .2"1!21 3."2

    !5 11.1 1883 3.! !1.9 5.712"2559 3.21

    38 11.! !923 3.8 5".5 5.8"819139 3.3!

    31 1".7 32!9 9.5 !3.9 5.79"189!3 3.22

    !" 1".3 171 2.5 !7.! 5.5"539!2 3.28

    !2 12.3 53"8 25.9 59.7 .51199319 3.25

    28 12.1 35 7.5 51. 5.1!172!! 3.27

    5 11.3 3152 12.1 !7.3 5.7188517 3.39

    5 11.1 378 1 !!.8 5."5217 3.25

    2 9 999 !.8 2.2 5.58121555 3.22

    38 1".7 3!51 11.7 37.5 5.72538"8 3.!8

    38.51 1".97 391".!9 11.88 !.39 ."" 3.25

    133.9! ".72 2"78!8.8! 8".9 25.7" ".13 "."3

  • 7/25/2019 Module 250 Xls 1 Sol

    21/64

  • 7/25/2019 Module 250 Xls 1 Sol

    22/64

    income ;,@ H*$ot ;,@ ',-$ot ;,@ "2$ot *,R# ?B Mortality295" 1.32221929 1.17"912 1.77"852"1 ?".3"9

    31!58 ".9"3"8999 1 1.591"!1 ".9"8

    3185 ".77815125 ".77815125 1.5185139! ".339

    32!52 1.25527251 ".9"3"8999 1.38"2112! ".59

    3238 1.33!8! 1.579783 2.3138722 2."8!

    27835 1.!7712125 1.5"51!998 1.8573325 1.!29

    3!! 1.32221929 1.5"51!998 1.7923919 ?".1"!

    !7258 ".77815125 "."2"5999 "."2"5999 ?".7

    312!8 1.25527251 1."7918125 1.582"172 ".973

    29"89 1."7918125 ".8!5"98"! 1.3"1"3 ?".!2

    25782 1.25527251 ".9"3"8999 1.!31337 1.225

    3593 1.9!!!827 1.7993!"55 2.!!!"!!8 1.3!1

    31!27 1.!1!97335 1.!1!97335 2.1!3528 ".!9

    3572" 1.!91319 1.32221929 1.8"17997 ".717

    2971 1.317278! ".95!2!251 1.17"912 ".283

    3879 " " " ?1.299

    3"232 ".77815125 "."2"5999 1.2"!11998 ?"."79

    39"99 1.23"!!892 ".9"3"8999 1.!!7158"3 ?1.112

    33858 1.71""33! 1.5!!"8"! 2."93!219 ".289

    32""" 1."!13929 "."2"5999 1."!13929 "."""

    29915 ".9897 ".!7712125 1 ?1.119

    29!5" ".9"3"8999 ".!7712125 ".9897 ".!8"

    3755 ".8!5"98"! ".!7712125 1 ?".8"

    39558 ".77815125 ".9897 " ".182

    31!1 1.1139!335 ".8!5"98"! 1.5185139! ".!!1

    3"783 ".8!5"98"! "."2"5999 "."2"5999 ?".3!!

    3"2!8 1."!13929 ".8!5"98"! 1.5"51!998 ?1.55

    32! 2.811575"1 2.5"379"8 2.1139!335 ?1.28"

    2921 1.579783 1.582"172 2.28555731 ".77"

    2791" 1.17"912 1.25527251 1.531!7892 1."!

    328"8 ".!7712125 " " ?1.277

    35272 1.5185139! 1.317278! 2."991""1 ?".193

    35871 1.3"1"3 1."!13929 1.!1!97335 ?1.339

    28!1 1.23"!!892 1.1!128"! 1.892"9! ".318

    3!3! "."2"5999 ".!7712125 ".9"3"8999 ?".287

    327"! 1.3"1"3 1.23"!!892 " 2.755

    3"!7 1.127838 1.!1!97335 2."33!237 ".857

    33!!9 1.!2398 1.5"51!998 2.2"82588 1.183

    3293! 1.5321251 1.77"852"1 2.!1995575 ".8"3

    33"2" 1.7!8188"3 1.32221929 1.!3!528 ?".75

    3""9! ".77815125 "."2"5999 1.25527251 ?"."!3

    32!!9 1."!13929 1."!13929 1.9!939""1 "."8"

    3351" 1."7918125 ".95!2!251 1.812!12! 1.351

  • 7/25/2019 Module 250 Xls 1 Sol

    23/64

    3!89 ".8!5"98"! "."2"5999 1.25527251 ?1."72

    3!5! 1.!91319 1.17"912 1.8325"891 ".198

    3258 2.15832!9 1.8195!39! 1.3"1"3 ?1.25

    !79 2.!927"39 2.2329911 1.93!!98!5 ?".!72

    !199! 2."211893 1.5"51!998 ".!7712125 ?2.!1"

    37"9 1.3"1"3 ".8!5"98"! 1.3"1"3 ?".71

    29327 ".9897 " 1.3"1"3 ?".593

    3"11! ".9"3"8999 ".9897 1.3979!""1 ".152

    3"!97 1."!13929 ".8!5"98"! 1.3979!""1 ".5"1

    273"5 ".9897 ".3"1"3 1."!13929 ?".!!

    !1888 1.8129133 1.!!7158"3 2.""8""17 ".!27

    3!812 "."2"5999 ".3"1"3 " ?1.881

    33927 1.1!128"! 1."!13929 1.232!929 ".998

    2937! ".8!5"98"! ".!7712125 ".9"3"8999 ?".728

    28985 ".9"3"8999 ".9"3"8999 1.9"19"8 ?".!7"

    289" 1.1!128"! 1.1139!335 1.591"!1 ".213

    332!. 1.22 1."2 1.!1 ".""

    CCC ".2! ".27 ".!" 1.""

    MatriceMortality

    Mortality 1.""

    JanTemp ?"."2

    JulyTemp ".32

    RelHum ?".1"

    Rain ".!3

    #ducation ?".51$op%ensity ".25

    &'on()ite ".5

    &(* ?".29

    ;,@ pop "."9

    pop+)ouse ".37

    income ?".28

    ;,@ H*$ot ".13

    ;,@ ',-$ot ".28

    ;,@ "2$ot ".39

    ".2MortalityMortalityJanTempJulyTempRelHum

    Matrice

  • 7/25/2019 Module 250 Xls 1 Sol

    24/64

    Rain

    Education ".2PopDensity%NonWhite ".!2%WC

    LOG poppop/houseincomeLOG HCPotLOG NOxPot

    LOG S02Pot

  • 7/25/2019 Module 250 Xls 1 Sol

    25/64

    JanTemp JulyTemp RelHum Rain #ducation $op%ensity

    ?".9 ?".7!" ".233 ?".217 ".51" ?".!3

    ?1."! ?".523 ?".139 ?".3"3 "."!" ".257

    ?".!72 ?"."88 ?".9 ".!7! ?1.371 ".2!2

    1.1"! ".998 ?".32! ".73! ".157 ?".5!5

    ".119 ".5! ?".51" ".388 ?1." 1.755

    1.1"! 1.215 ?".9 1.252 ?".9"1 ?".!"

    ?".37! ?"."88 ?".32! ".388 1.333 ".533

    ?".37! ?".3" ?".32! ".51 ?".!3" ?1.228

    ?".95 ?".958 "."5 ?".217 ?".5!8 1.853

    ?".9 ?".523 ".233 ?".217 ?".313 ".21"

    ".8"8 ".998 ?".32! 1.1 ?1." ?1.11

    ?".78 ".3! "."!7 ?".!7 ?"."78 1.53!

    "."2" ".5! ?".139 ".129 ?".9"1 ".132

    ?".571 ?".7!" ".!19 ?".3"3 ".157 ?"."2

    ?".275 ".129 "."!7 ?".13" 1."98 ".2!2

    1.2"2 2.3"2 ?".9 ?".3"3 ".98" ?1.713

    ?".37! ".129 "."!7 ?".217 ".51" "."82

    ?".37! ?".3" ?3.7" ?2."31 1.!5" ".3!

    ?".9 ?"."88 ".233 ?".!9 ?".195 ".!1

    ?".95 ?".523 "."5 ?".735 ?".195 ?".15"

    ?".95 ?".523 "."5 ?".!9 ?"."78 ?".!75

    ".11 ".5! ?".882 ".3"2 ?".5 ?1.139

    ?".9 ?".523 ?".32! ".388 ".28 ?".95

    2."89 2."85 ".233 ".!7 ".51" ?".87

    ?".!72 ".129 ".!19 "."!2 ".51" ".3!8

    ?".275 1.!33 ?".51" ?".3"3 1.215 ?".!5"

    ?".177 ?"."88 ?".9 ".388 ?1.723 ?".!83

    1.892 ?1.392 ?1.997 ?2.377 1.333 ".5!8

    ".119 ?".7!" ?".139 ?".735 ?1.253 ".391

    ".8"8 1.5" ".233 ".993 ?".5 ?".287

    3.271 1.5" ".!19 1.857 ".28 ".518

    ?1.359 ?1.175 1.12 ?".735 ".157 ?".77

    ?2.1!7 ?".3" "."!7 ?1.17 1.333 ?1.259

    ".11 1.215 ?".32! ".51 ?1."18 ?".852

    ?".37! ?".523 "."!7 ".!7 ".393 ?".!"5

    1.99" 1.!33 ".791 1.339 ?1.!88 ?".512

    ?"."78 ".5! "."!7 ".3"2 ?".313 2.!3

    ?".177 ".3! ?".9 ".3"2 ?".5!8 1.513

    ?".!72 ?".523 ?".32! ?".217 ?".!3" ?".328

    ".!1! ?1.1" 2.835 ?".13" 1.215 ?".33

    ?".!72 ?".523 ?".32! ".3"2 ?1."18 ?".279

    ?"."78 ".5! ?".9 ".215 ?1." ".!7

    ".513 ".781 ?".882 ".!7! "."!" ?"."99

  • 7/25/2019 Module 250 Xls 1 Sol

    26/64

    ?".8 ?".523 ".!19 ?".52 ".157 ".3"8

    ?".177 ".998 ?".139 ?".39" ?1.!88 ".87

    2."89 ?".958 "."5 ?2.!3 1.333 ?"."9

    1.399 ?2.!79 2.!3 ?1.772 1.!5" ".238

    1.!98 ?1.392 2.!3 ?2.2"! 1.!5" ?".838

    ".11 ?2.21 2.!9 ?".3"3 1.!5" ?".197

    ?".571 ?"."88 ?".32! ".51 ".157 ?1.!"

    ?".95 ?".523 "."5 ?"."!! ".51" ".7"2

    ?".78 ?".3" ".233 ?".!9 ?".313 ?".!59

    ?1."! ?".7!" ".!19 ".129 ?".783 ?1.553

    ".31 ".781 ?1."8 ".3"2 1.58 ".99

    ?".177 1.!33 ?".9 ?".9"8 1.333 ?".17"

    ?"."78 ".3! ?".32! 2.289 ".393 ?".52

    ?".95 ?".958 ?".32! 2.289 ".157 ?".11

    ?"."78 ".3! ?".9 2."3" ?2.311 !."15

    ?".571 ?".523 "."!7 ?"."!! ?".313 ?".319

    "."" "."" "."" "."" "."" ".""

    1."" 1."" 1."" 1."" 1."" 1.""

    e corr4lation 1+n JanTemp JulyTemp RelHum Rain #ducation $op%ensity

    ?"."2 ".32 ?".1" ".!3 ?".51 ".25

    1."" ".32 "."9 "." ".11 ?"."8

    ".32 1."" ?".!! ".!7 ?".27 ?"."1

    "."9 ?".!! 1."" ?".12 ".19 ?".15

    "." ".!7 ?".12 1."" ?".!7 "."8

    ".11 ?".27 ".19 ?".!7 1."" ?".2!?"."8 ?"."1 ?".15 "."8 ?".2! 1.""

    ".! "." ?".12 ".3" ?".21 ?"."1

    ".21 ?"."1 "."1 ?".11 ".!9 ".25

    ".32 "."! ?"."2 ?".28 ".27 ".21

    ?".33 ".2 ?".1! ".2" ?".39 ?".17

    ".2" ?".19 ".13 ?".3 ".51 ".""

    ".23 ?".!1 ".18 ?".!8 ".18 ".2

    ".18 ?".3" ".1" ?".39 "."3 ".3!

    ?".31 ?".31 ?".11 ?".13 ?".25 ".!5

    JanTemp JulyTemp RelHum Rain Education PopDensity

    ".2

    ".22

    e d4termination

  • 7/25/2019 Module 250 Xls 1 Sol

    27/64

    ".22 ".22

    ".22

    ".21 ".3

    ".2!

    ".2

    ".23

    ".21

  • 7/25/2019 Module 250 Xls 1 Sol

    28/64

    &'on()ite &(* ;,@ pop pop+)ouse income ;,@ H*$ot

    ?".3!2 ?".7!7 ?".511 ".511 ?".82! ".217

    ?".931 ".851 ?".223 ?".583 ?".!"" ?".38

    ?1.231 ?1.378 ?".558 ?".2"" ?".311 ?".893

    1.92 ".752 ".92 ".893 ?".178 "."8"

    1.392 ?".53" ".9" 1."57 ?".19 ".852

    2.959 ?".!8 ?".15! 1.112 ?1.21" ".533

    ?".931 ".555 1.258 ?"."91 ".7" ".217

    ?".731 ?1.181 ?1."11 ".237 3.132 ?".893

    ?".!2" ?".77 "."15 ".3!7 ?".!!7 "."8"

    ?".575 ?1."2 ?1.111 ".2" ?".929 ?".279

    1.1!7 ?1.""3 ?1."!5 ".78! ?1.9 "."8"

    ".!92 ?".293 ?".15 ?".255 ".7!8 1.!8

    ".125 ?".135 ".!"9 ?".2"" ?".!"7 ".!"

    ".31! ?".352 ".781 ".237 ".553 ".52

    ".13 ".3! ?2.5!8 "."73 ?".779 ".297

    ".325 ".9!9 ".818 ?".1!5 1.235 ?2.!81

    "."58 ?".!71 ?"."7 ".55 ?".7! ?".893

    ?".798 1.32! ".!33 ?".528 1.3"8 "."29

    ".!3 ?".59 1.833 1."57 ".137 1."2"

    ".13 ?2.!83 ?".979 1.5!9 ?".279 ?".35

    ?".753 ?".23! ?".25 ".75 ?".7!5 ?1."55

    1.2"3 ?".98! ?".2"" 1.112 ?".8!9 ?".38

    ?".52" 1."28 ?".!12 "."19 ".95 ?".757

    1."1! ".1"1 1.227 ".55 1.!11 ?".893

    ".!1! "."!2 ".185 ?"."91 ?".399 ?".2"8

    "."8" ".!37 ?".113 ?".8"1 ?".551 ?".757

    ?".998 ?".53" ?1.2!5 ".729 ?".7" ?".35

    ?".!53 ".!9 2.!57 ?3.2"7 ".755 3.25

    ".13 ?".7!7 ?"."58 ".75 ?".811 ".7!2

    2.759 ?"."9 ?".11! 1.331 ?1.193 ?"."81

    ".18" ".18" ".591 ?3.22 ?"."98 ?1.5"8

    ?".75 ?".!71 ".!"5 "."73 ".!53 ".17

    ?1."98 1."88 ".925 ".183 ".587 ".173

    1."1! ?"."57 ?".2"2 ".!"1 ?1."3" "."29

    ?".3!2 ?".21! ?".85" ?".!73 ".25" ?1.253

    2.17" ?".175 ".275 ".2" ?".121 ".173

    ?"."! ".!5 2.581 ?1.18! ".2 ".81"

    ".25 ?".21! 1.893 ".!"1 "."!5 ".5"3

    ?".!2" ?".175 ".971 ".!"1 ?"."7" ".892

    ?".92" ".772 ".119 ?3.2"7 ?"."51 1."8

    ?1."75 ?1.!9 ?".591 ?".!73 ?".7"5 ?".893

    ?1."2" ?1.53 ?1.!2 ?".911 ?".178 ?".35

    1.859 ".1! ?".337 ".!"1 "."59 ?".279

  • 7/25/2019 Module 250 Xls 1 Sol

    29/64

    ?".7! ".""3 ?"."39 ?".2"" ".39 ?".757

    ".592 ?".25! ".721 ?"."91 ".29" ".52

    ?".! ".91" ".757 ?".7!7 ?".1!8 1.923

    ".2"3 ".9!9 ".!83 ?1.78 3.291 2."5

    ?".987 1."88 ".313 ".2" 1.95 1.!3

    ?".8 1.51 ".577 ?1.239 ".855 ".173

    ?".9!2 ?".885 ?".81! ?".2"" ?".87 ?1."55

    ?".898 ".811 ?".5!! ".511 ?".7"" ?".38

    ?".2! ?".!9" ?".59! ?".1!5 ?".15 ?".35

    ?1."!2 ".2"" ?1.39 ".183 ?1.328 ?1."55

    1.559 2.2 1.!38 "."19 1.932 1.218

    ?".!8 1."28 ?1."9" ".128 ".35" ?1.253

    "."25 ".18" ?".79 ".78! ".152 ?".1!3

    ?1.2"9 ?".313 ?1.115 "."19 ?".8 ?".757

    ?".78 3.119 ?1.183 ?".1!5 ?".953 ?".38

    ?"."2" ?1.753 ?".777 1.27 ?".958 ?".1!3

    "."" "."" "."" "."" "."" ".""

    1."" 1."" 1."" 1."" 1."" 1.""

    &'on()ite &(* ;,@ pop pop+)ouse income ;,@ H*$ot

    ".5 ?".29 "."9 ".37 ?".28 ".13

    ".! ".21 ".32 ?".33 ".2" ".23

    "." ?"."1 "."! ".2 ?".19 ?".!1

    ?".12 "."1 ?"."2 ?".1! ".13 ".18

    ".3" ?".11 ?".28 ".2" ?".3 ?".!8

    ?".21 ".!9 ".27 ?".39 ".51 ".18?"."1 ".25 ".21 ?".17 "."" ".2

    1."" ?"." ".22 ".35 ?".1" ".15

    ?"." 1."" ".28 ?".35 ".37 ".1

    ".22 ".28 1."" ?".2 ".!1 ".!8

    ".35 ?".35 ?".2 1."" ?".3" ?".22

    ?".1" ".37 ".!1 ?".3" 1."" ".29

    ".15 ".1 ".!8 ?".22 ".29 1.""

    ".21 ".11 ".5" ?".12 ".25 ".9!

    "."5 ?"."7 ".25 "."1 ?".1" ".1

    %NonWhite %WC LOG pop pop/house income LOG HCPot

    ".!2

    ".21

    ".3

  • 7/25/2019 Module 250 Xls 1 Sol

    30/64

    ".23

    ".2! ".2

    ".23

    ".23

    ".25 ".88

    ".37

  • 7/25/2019 Module 250 Xls 1 Sol

    31/64

    ;,@ ',-$ot ;,@ "2$ot

    ".31" ".57"

    ?"."31 ".28!

    ?".!1 ".19

    ?".219 ?"."51

    1."93 1.!32

    ".9!8 ".7"7

    ".9!8 "."!

    ?".8"2 ?1.28

    ".122 ".2!8

    ?".331 ?".17

    ?".219 "."31

    1.518 1.39

    ".773 1.195

    ".593 ".2

    ?".12" ?".375

    ?1.99 ?2.2!2

    ?".8"2 ?".33"

    ?".219 "."5

    1."23 1."82

    ?".8"2 ?".589

    ?1."!! ?".5!

    ?1."!! ?1.132

    ?1."!! ?".5!

    ?".1! ?2.2!2

    ?".331 ".19

    ?".8"2 ?1.28

    ?".331 ".1!8

    2.883 1.115

    1."7" 1.387

    ".!! ".19"

    ?1.99 ?2.2!2

    ".7" 1."88

    "."!9 ".""5

    ".252 ".72

    ?1."!! ?".8"8

    ".!1 ?2.2!2

    ".773 ".987

    ".9!8 1.22

    1.!3 1."1

    ".593 ".37

    ?".8"2 ?".2!9

    "."!9 ".853

    ?".12" ".!27

  • 7/25/2019 Module 250 Xls 1 Sol

    32/64

    ?".8"2 ?".2!9

    ".31" ".8

    1.557 ?".17

    2.358 ".83"

    ".9!8 ?1.!85

    ?".331 ?".17

    ?1.99 ?".17

    ?".1! ?"."22

    ?".331 ?"."22

    ?1.38 ?".589

    ".83 ".9!7

    ?1.38 ?2.2!2

    "."!9 ".335

    ?1."!! ?".8"8

    ?".219 ".!!2

    ".19" ".28!

    "."" ".""

    1."" 1.""

    ;,@ ',-$ot ;,@ "2$ot

    ".28 ".39

    ".18 ?".31

    ?".3" ?".31

    ".1" ?".11

    ?".39 ?".13

    "."3 ?".25".3! ".!5

    ".21 "."5

    ".11 ?"."7

    ".5" ".25

    ?".12 "."1

    ".25 ?".1"

    ".9! ".1

    1."" ".7"

    ".7" 1.""

    LOG NOxP LOG S02Pot

  • 7/25/2019 Module 250 Xls 1 Sol

    33/64

    ".21

    ".25

    ".88 ".37

    ".!8

    ".!8

  • 7/25/2019 Module 250 Xls 1 Sol

    34/64

    Pratique des biostatistiques www.fundp.ac.be/biostats Eric Depiereux -

    Mortality JanTemp JulyTemp RelHum Rain #ducation $op%ensit &'on()it

    Mortality ?".17 ".! "."2 ?".1" "."8 ?".2! ?".1 ".2!

    JanTemp "."9 "." ".53 ?".17 ".3" ".38 ".12 ?".2

    JulyTemp ?".3" ".13 ".!3 ".1! ?".18 "."7 "."1 ".""RelHum ".1! ?".11 ?"."8 ?".!5 "." ?".!" ?"."8 "."3

    Rain ?".35 ".11 ".13 ".18 ".39 ?".21 ?".15 ".18

    #ducation ".3" ?".29 ".18 ?"."5 ?".2" ?".2! ".19 ".!1

    $op%ensit ".1" ".27 ?"."8 ".58 ".23 ?".13 ?".1" ?".33

    &'on()it ?".13 ".3 ".39 ?".25 ?"."7 ?".15 ".18 "."!

    &(* ".23 ?"."9 ".27 ".!1 "." ?".! ".!9 ?"."2

    ;,@ pop ".29 ".2" ".27 "."5 ?".18 "."2 ?".!2 ".!3

    pop+)ouse ?".28 ".15 ?".12 ?".27 ?".!3 ?".!3 ".1! ?".3!

    income ".31 ?".11 ".21 ?"."1 ?".19 ?".29 ?"." ?".!1

    ;,@ H*$o ".39 ".29 ?"."5 ?".17 "."2 ".1" ".21 ?".12

    ;,@ ',-$ ".3! ".38 ?"." ?".12 ?"."2 "."7 ".12 ?".13

    ;,@ "2$ ".17 ".!" ?".33 ".13 ?"." "."1 "." ".2!

    A propos d

    dentie cette matricecalcule par diaonalisation+loiciel R.Nomme la dans le tableur.

    Utilise la pour la suite del!anal#se.

    http://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdfhttp://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdfhttp://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdf
  • 7/25/2019 Module 250 Xls 1 Sol

    35/64

    niversit de Namur

    &(* ;,@ pop pop+)ouse income ;,@ H*$o ;,@ ',-$ ;,@ "2$ot

    ?".18 ".35 "."9 ?".55 ?".25 ?".2! ?".1

    ?"."1 ?".11 ?".23 ?".11 ".1! ?".5" ?".1"

    ".1 ".11 ".!! ".!9 ?".39 ?".1" ?".15".3! "."1 ".2! ".23 ?"."3 ?"."7 ?"."1

    ?".!" ?".37 ?".39 ".27 ?".13 ".1! "."1

    ?".13 ".!1 ?".!1 ".27 ?"."9 ?".23 ".""

    ".35 ".!" ?".29 ".12 "."9 ?"."1 "."1

    ?"."! ".22 "."! "."8 ".55 ".!" ".23

    ?"."2 ?".3" ".27 ?".29 ?"."1 "."" ?"."1

    ".!9 ?".3 ?".15 ?".12 "."1 "."9 ?"."1

    ".2! ?".2 ?".33 "."! ?"."! ?".23 ?".1"

    ?".!" "."1 ".15 "." ".1" ?"."! ?"."!

    ?".12 ?"."3 ?".11 ".11 ?".22 ".!1 ?".3

    ?".12 ?"."9 ?"."1 ".1" ?".!! ?"."2 ".8

    ?".19 ?".18 ".23 ".3! ".!1 ?".!5 ?".12

  • 7/25/2019 Module 250 Xls 1 Sol

    36/64

    Pratique des biostatistiques www.fundp.ac.be/biosta

    D *,M$ 1 *,M$ 2 *,M$ 3 *,M$ ! *,M$ 5AEron ,H AEr "."! ?".17 ?1.53 ?".7 ?".27

    Al0any?c)enectady?Troy 'D Al0 ".11 ?".2 ?1."8 1."7 ".1!

    AllentoFn Get)le)em $A?'J All ?1.57 ?"."8 ?1.!5 ".7 ".23

    Atlanta @A Atl ?".7 1.2" 2.21 ?".!7 ?".!3Galtimore M% Gal ?".!7 !.2" ?"."8 ".35 ?".1"

    Girmin6)am A; Gir ?1.98 3.!" 1.!5 ?1.23 ?"."9

    Goston MA Gos 1.7 ".18 "."8 ".98 ?".58

    Grid6eport?Milord *T Gri ?".73 ?2.21 "." ?".72 ?".75

    Gualo 'D Gu ?"."2 1."3 ?1.83 ".!3 ".8

    *anton ,H *an ?1."" ?".2 ?1.7" ?".35 ".12

    *)attanoo6a T'?@A *)a ?2.95 1." ".3" ?1.25 ".5!

    *)ica6o ; *)i 1.28 2.1 ?".99 ".39 ?"."2

    *incinnati ,H?ID?' *in "." 1.5 ?".28 ".22 ".13

    *le/eland ,H *le ".9! ".82 ?".55 ?1."2 ?".!!

    *olum0us ,H *ol ?".5 ?". ?".!5 "."8 ".37

    %allas T %al ?1.!1 ?3.27 3.8" ".2" ?1.!8%ayton?prin6ield ,H %ay ?1."" ?".8 ?".23 ?"."9 ?".!"

    %en/er *, %en 1.97 ?1.22 ".!" 2.3 ?3.2

    %etroit M %et 1.2" 2."! ?".3 ?".!7 ?1."2

    Klint M Kli ?1.57 ?".5! ?1.78 ?1.81 ?".7

    @rand Rapids M @ra ?".93 ?2."2 ?1.31 ?".3! ?".25

    @reens0oro?(inston?alem?Hi6) @re ?2.5 "."5 ".95 ?1.1 ?".7

    Hartord *T Har ?".1" ?2.13 ".13 "." ?".5"

    Houston T Hou ?1."1 ?".7! !."! ?1."" ?".32

    ndianapolis ' nd ?".18 ".19 ?"."3 ".1" ".1

    Iansas *ity M, Ian ?".71 ?1.57 1.33 ".57 ?".59

    ;ancaster $A ;an ?1.52 ?".78 ?1.!3 ".27 ?".13

    ;os An6eles ;on6 Geac) *A ;A .27 1.28 ".9" ".8! ?".75

    ;ouis/ille ID?' ;ou ".2! 2.1! ?1.5 ?".57 ?"."5

    Memp)is T'?AR?M Mem ?2.2 2.5" 1.55 ?1.39 "."7

    Miami?Hialea) K; Mia ?".9" ?2.! !.28 1.35 2.99

    MilFauEee ( Mil 1.5! ?"."! ?1.9 ?1."! ?".23

    Minneapolis?t. $aul M'?( Min 1.7" ?1.91 ?".9" ".11 ?1.92

    'as)/ille T' 'as ?1.!1 1.!" ".3 ?".!8 ?"."3

    'eF Ha/en?Meriden *T 'eFH ?1."" ?1.83 ?".17 ".19 ".!2

    'eF ,rleans ;A 'eF, ?2.2" 2.1 3."7 ?1.9" 1.!3

    'eF DorE 'D 'D 1.87 2.35 ".7 2."1 ".2

    $)iladelp)ia $A?'J $)i ".51 2.92 ".12 ".93 ?".51

    $itts0ur6) $A $it 1.12 1.89 ?1.18 ?".28 ?".$ortland ,R $or 3.3! ?1.! ?".!! ?".58 3.12

    $ro/idence R $ro ?1.5" ?".8! ?1.!7 ".1" ".!5

    Readin6 $A Rea ?1.2" ".!8 ?1.!! ".88 ".3

    Ric)mond?$eters0ur6 LA Ric ?1."8 1.!9 1.!2 "."9 ?".!8

    Roc)ester 'D Roc ".25 ?1.5 ?".85 ".5" ?".11

    t. ;ouis M,?; t; "."! 1.72 ".13 ".!7 ?".19

    an %ie6o *A an% 3.98 ?".8" ".7" ?1.25 ?"."1

    an Krancisco *A anK .21 ".17 ".31 ?1.75 1.!3

    A propos du

    http://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdfhttp://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdf
  • 7/25/2019 Module 250 Xls 1 Sol

    37/64

    an Jose *A anJ !."7 ?2." ".7 ?2.38 ".1

    eattle (A ea 2.9" ?2."5 "." ?".5 2."8

    prin6ield MA pr ?1.91 ?2.11 ?".87 ?".11 ?".11

    yracuse 'D yr ?".31 ?".8 ?1.17 ".7 ".3!

    Toledo ,H Tol ?"." ?".3! ?1.12 ?".!! ?"."2

    tica?Rome 'D ti ?1.85 ?2.15 ?1.! ?".37 ".!1

    (as)in6ton %*?M%?LA (as 2.38 1.7" 2.5! 1.55 ?1.25(ic)ita I (ic ?".8" ?3.!2 1.!2 ".9! ?1.2

    (ilmin6ton %#?'J?M% (il ?1.!2 ".5 ".2! "."8 ".28

    (orcester MA (or ?1.8" ?1.77 ?1.25 ".85 ".93

    DorE $A Dor ?1.15 1."5 ?".38 !.88 2.31

    Doun6stoFn?(arren ,H Dou ?1.27 ".!! ?1.71 ?1.23 ?".!"

    Laleurs propres 3.9" 3.13 2.23 1.37 1."

    & cumul4 2& !7& 2& 71& 78&

  • 7/25/2019 Module 250 Xls 1 Sol

    38/64

    s Eric Depiereux - Universit de Namur

    *,M$ *,M$ 7 *,M$ 8 *,M$ 9 *,M$ 1" *,M$ 11 *,M$ 12 *,M$ 13 *,M$ 1! *,M$ 15

    ".11 ".59 ".!5 ?"." "."! ?".! ".!3 ?"."2 ?".12 ".13

    ?".52 ".15 ".73 ?".11 ".3! ".58 ?1."2 ?".39 ?".31 ".2!

    1."7 ?1.1! ?".23 ?".22 ?"."8 "."7 ?".28 ?".2! ?".33 "."3

    ?".58 ".5! ".!! "."9 ?"." ?".23 ?".11 ".39 ?"."9 ?".25?".3" ?".5 ?".!5 ".!7 ".13 ?".11 ?".2! ".18 ?"."8 ?".15

    ".29 1."8 ".1 ?".58 ?".12 ?".25 ".37 ".!5 ".27 ".35

    ?".3 ?".55 ".72 ?".18 ?".38 ?".71 ".!9 ?".75 ?".!9 ".2

    ?".27 ?2.!5 ?1.2 ?1.83 ?".2! ".1! "." "."3 ".25 "."8

    ?".55 ?".7 ?".27 ".93 ".92 ?".5 ?".!! ?"."3 "." ?"."1

    ".32 ".3" ?".!! ".!1 ".37 ?".!" ".2 ?"."1 "."5 "."5

    ".89 ".82 "."3 ?".5" ?".38 ".23 ?".17 ?".1 "."5 ?".3!

    ?".!8 ?".1" ?".5 ?".7 1.38 ".5 ".7 ?".3! ?"."2 ?".18

    ".52 ?"."1 ".2 "."2 ?".!7 ". ".29 ?".15 ?".18 "."3

    ?".53 ?".1 "." ?".25 ?".1 "."8 ?".29 ".1" ".1! "."3

    ?".1 2."3 ?".!3 ?".9" 1.53 ?"."2 ".21 ?".!! ?"."7 ?".19

    "."8 ?".! ".18 ".5! ?".31 ".83 "."" ".2" ?".5" ".2?".21 "."9 ".!2 ".75 ".53 ?".37 "."9 ".2 ?".25 "."8

    ".93 ".!1 ?".!5 ?".7 ".1 ?".3 ?".85 ".!! ?"."9 ?"."9

    ?".!" ?". ".23 1.17 ?".39 ?".27 ".!" "."! ".2" ?"."8

    ?"."2 ?".8 ?". ".7" 1.1" ?".2 ".31 ".35 ".18 ?".17

    ?".21 ".3" ?"."9 1."" ?".1! ".1" ?"."2 ".28 "."9 ".17

    ".3 ".17 ?"."3 ".15 ?"."! ?".!! ?".5 ".3 ".3" ?".1

    ?".9! ?".11 ?"."2 ?".7 ?".!9 ?"."3 ?".2! ".32 ".2 ?"."3

    ?".33 ?1.1! ?".!! ".! ?".19 ?".2" "."3 ?".55 ?".35 ?"."2

    ?".58 "."7 ".7! ".37 "." "."1 ".13 ".2" "."! ?"."!

    ".2 ".5 ".9" ".32 ".9 ".!1 ".22 ?".1 ".32 "."7

    1.1 ".!2 ?1.2! ?".1! ?1.!1 ".13 ".!5 ".11 ".11 "."1

    3.!3 ".!7 ".39 ?".53 "."" ?".2 ?".39 ?".12 ".52 ".13

    ".7" ".3 ?".!! ".28 ?".2" "." ?".!3 ".27 ?".!" "."

    ?".28 ".87 ".12 ".3" ".11 "."! ".73 ".35 ".17 ".!2

    1.92 ?".82 "." ".33 ".!" ?".! ".58 ".3 ?"."9 ?"."9

    ?".53 ?".55 ".5 "."1 ?".!" ".!8 ".29 "."2 ".1" "."5

    ?".99 ".15 1."1 ".3! ?".73 ".5 ".28 ?".53 ".1 "."!

    ".2 ".85 ".2! ?".18 ?".7 ".72 ".!1 ".12 ?".1 "."1

    ?".2! ?".!! ".2! ?".5 ".3! ?".2! ?".2" ".32 "."7 ".32

    ?".!! ?".39 ?".3 "." ".25 "."7 ?1.!5 ?1."7 ".51 "."5

    ?".18 ?1.58 ".1 1."9 "."9 "."" ".17 ?".25 ".19 ?".25

    ?".18 ?".91 ".!2 ".7 ?".18 ?".!1 ?"."1 "." ?"."8 "."

    ".13 ?".2" ".58 ?".27 ?".89 ".13 ?".22 ?".!3 ?".37 "."8".22 ".28 1.!2 ?".3! ".17 ".3 ".32 ?"."5 ".29 "."!

    1.2! ?".85 ".18 ?"." "."1 ?"."8 ?".37 "."" "."1 "."!

    1.77 ?".73 ?".81 ?".7" ".!3 ".7 ".53 ?".2" ?".!5 ?"."2

    ?".1 ".3 ".19 ?".8 ".!8 ".25 ?".37 ".7 ?".21 "."

    ?".27 ?".52 ?".1! ".2 ".1" ".17 ".17 ".!7 ".13 ".12

    ".!2 ?". ?".59 ".7" ?".11 ".98 ".3! ".19 ".! ?".2

    1.5" 1.71 ?".!9 ".8" ?".32 ?".25 ?".19 ?".3! ?".!! ?"."9

    ?".73 ?".51 ?1.15 ?1.17 ".!7 ".31 "."" ".58 ?"."5 ".18

  • 7/25/2019 Module 250 Xls 1 Sol

    39/64

    ?".9 ".53 ?2."1 ".93 ?".9 ?".32 ".21 ?".!" ?".12 ?".23

    ?1.!" ?"."1 ".! ".2" ?".32 ?".19 ?".57 ".7! ?".3" ?"."

    ".7" ?"."9 1."! ?".!" ?".2! ?"."3 ".1! ".33 ?".17 ?".3

    ?1.25 ".59 ".2 ".1 ".29 ?".18 ?".28 ?".17 ?".!1 ?"."9

    ".18 "."8 ".3 ".12 ".5! ".59 ?".52 ?"."3 "."3 "."2

    ?"."2 ".78 ".!1 ?"."5 ?".72 ".5 ?".75 "."3 ".23 ?".12

    ?1.85 ".!! ".15 ?".91 ?".11 ?"."7 ".31 ".3 ".1 ?".27?".18 ".87 ?".88 ".5 ".8! ".2 ".! ?".!2 ".21 "."9

    ?1.11 "."8 ".!2 ?1.71 ?".5! ?".9 ".39 ?".3 ?".!3 ?".1

    ?".23 "."1 ".!8 ?".9" ?".5 ?1.!3 ".22 ?".3 ".59 "."3

    ?1." 1.28 ?1.99 ".55 ?".97 "."2 ?".15 ".11 ".1 ".17

    ".32 "."9 ?".11 ".13 ".23 ?".7 ".27 "."" ?".18 ".21

    ".79 "." ".5" ".!! ".33 ".22 ".19 ".1! "."8 "."3

    83& 87& 9"& 93& 9& 97& 98& 99& 1""& 1""&

  • 7/25/2019 Module 250 Xls 1 Sol

    40/64

  • 7/25/2019 Module 250 Xls 1 Sol

    41/64

    15.""

  • 7/25/2019 Module 250 Xls 1 Sol

    42/64

    Pratique des biostatistiques www.fundp.ac.be/biostats Eric Depiere

    K *,M$ 1 *,M$ 2 *,M$ 3 *,M$ ! *,M$ 5 *,M$ *,M$ 7 *,M$ 8 *,M$ 9Mortality ?".3! ".81 "."3 ?".11 "."9 ?".21 ?".12 ".17 ?".12

    JanTemp ".17 ".1" ".79 ?".2" ".31 ".3! ".1" ?".18 ?"."1

    JulyTemp ?".58 ".22 ".5 ".1 ?".18 "." "."" "."" ".11

    RelHum ".29 ?".2" ?".12 ?".53 ".1 ?".3 ?"."7 "."2 ".23Rain ?".7" ".19 ".19 ".21 ".!1 ?".19 ?".12 ".13 ?".27

    #ducation ".59 ?".51 ".27 ?"." ?".21 ?".21 ".15 ".29 ?"."9

    $op%ensity ".2" ".!8 ?".12 ".7 ".2! ?".11 ?"."7 ?".23 ".23

    &'on()ite ?".2 ".3 ".58 ?".3" ?"."7 ?".13 ".1! "."2 ?"."3

    &(* ".! ?".17 ".!" ".!8 "." ?".!1 ".38 ?"."2 ?"."1

    ;,@ pop ".57 ".35 ".!" "." ?".19 "."2 ?".32 ".3" ".33

    pop+)ouse ?".55 ".2 ?".18 ?".32 ?".!! ?".38 ".11 ?".2! ".1

    income ".1 ?".2" ".32 ?"."2 ?".2" ?".2 ?".!7 ?".29 ?".27

    ;,@ H*$ot ".77 ".52 ?"."7 ?".2" "."2 "."9 ".1 ?"."9 ?"."8

    ;,@ ',-$ot ".8 ". ?"."9 ?".15 ?"."2 "." "."9 ?"."9 ?"."8

    ;,@ "2$ot ".33 ".7" ?".!9 ".1 ?"." "."1 "."5 ".17 ?".12

    Laleurs propres 3.895!1 3.1231 2.22759 1.37313 1."17 ".7897 "."13! ".!9525 ".!!332

    R Mortality JanTemp JulyTem RelHum Rain #ducatio $op%ensi&'on( &(*Mortality 1."" ?"."2 ".32 ?".1" ".!3 ?".51 ".25 ".5 ?".29

    JanTemp ?"."2 1."" ".32 "."9 "." ".11 ?"."8 ".! ".21

    JulyTemp ".32 ".32 1."" ?".!! ".!7 ?".27 ?"."1 "." ?"."1

    RelHum ?".1" "."9 ?".!! 1."" ?".12 ".19 ?".15 ?".12 "."1

    Rain ".!3 "." ".!7 ?".12 1."" ?".!7 "."8 ".3" ?".11

    #ducation ?".51 ".11 ?".27 ".19 ?".!7 1."" ?".2! ?".21 ".!9

    $op%ensity ".25 ?"."8 ?"."1 ?".15 "."8 ?".2! 1."" ?"."1 ".25&'on()ite ".5 ".! "." ?".12 ".3" ?".21 ?"."1 1."" ?"."

    &(* ?".29 ".21 ?"."1 "."1 ?".11 ".!9 ".25 ?"." 1.""

    ;,@ pop "."9 ".32 "."5 ?"."2 ?".28 ".27 ".21 ".23 ".28

    pop+)ouse ".37 ?".33 ".2 ?".1! ".2" ?".39 ?".17 ".35 ?".35

    income ?".28 ".2" ?".19 ".13 ?".3 ".51 "."" ?".1" ".37

    ;,@ H*$ot ".13 ".23 ?".!1 ".19 ?".!9 ".18 ".2 ".15 ".1

    ;,@ ',-$ot ".28 ".18 ?".3" ".1" ?".39 "."3 ".3! ".21 ".11

    ;,@ "2$ot ".39 ?".31 ?".31 ?".11 ?".13 ?".25 ".!5 "."5 ?"."7

    A propos du

    http://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdfhttp://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdf
  • 7/25/2019 Module 250 Xls 1 Sol

    43/64

    x - Universit de Namur

    *,M$ 1" *,M$ 11 *,M$ 12 *,M$ 13 *,M$ 1! *,M$ 15

    ".2" "."! ?".2! ?"."9 ?"."7 ?"."3 1.""

    ?"." ?".11 ?"."5 "."5 ?".1! ?"."2 1.""

    "." ".2" ".21 ?".15 ?"."3 ?"."3 1.""

    "."1 ".11 ".1" ?"."1 ?"."2 "."" 1.""?".22 ?".18 ".12 ?"."5 "."! "."" 1.""

    ".2! ?".19 ".12 ?"."3 ?"." "."" 1.""

    ".23 ?".1! "."5 "."3 "."" "."" 1.""

    ".13 "."2 "."3 ".21 ".11 "."! 1.""

    ?".17 ".13 ?".13 ?"."1 "."" "."" 1.""

    ?".21 ?"."7 ?"."5 "."1 "."2 "."" 1.""

    ?".15 ?".15 "."2 ?"."2 ?"."7 ?"."2 1.""

    "."1 "."7 "."3 "."! ?"."1 ?"."1 1.""

    ?"."1 ?"."5 "."5 ?"."8 ".12 ?".11 1.""

    ?"."5 ?"."1 "."! ?".1 ?"."1 ".12 1.""

    ?".11 ".11 ".15 ".15 ?".13 ?"."2 1.""

    ".33213 ".2183!! ".188829 ".138211 "."787"! "."32718 15.""

    ;,@ pop pop+)ous income ;,@ H*$o;,@ ',- ;,@ "2$ot

    "."9 ".37 ?".28 ".13 ".28 ".39

    ".32 ?".33 ".2" ".23 ".18 ?".31

    "."5 ".2 ?".19 ?".!1 ?".3" ?".31

    ?"."2 ?".1! ".13 ".19 ".1" ?".11

    ?".28 ".2" ?".3 ?".!9 ?".39 ?".13

    ".27 ?".39 ".51 ".18 "."3 ?".25

    ".21 ?".17 "."" ".2 ".3! ".!5".23 ".35 ?".1" ".15 ".21 "."5

    ".28 ?".35 ".37 ".1 ".11 ?"."7

    1."" ?".2 ".!1 ".!8 ".5" ".25

    ?".2 1."" ?".3" ?".22 ?".12 "."1

    ".!1 ?".3" 1."" ".29 ".2! ?".1"

    ".!8 ?".22 ".29 1."" ".9! ".1

    ".5" ?".12 ".2! ".9! 1."" ".7"

    ".25 "."1 ?".1" ".1 ".7" 1.""

  • 7/25/2019 Module 250 Xls 1 Sol

    44/64

    Pratique des biostatistiques www.funA propos du

    ".81

    ".22".19

    ".3

    ".2

    Corrlati

    F

    2

    http://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdfhttp://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdf
  • 7/25/2019 Module 250 Xls 1 Sol

    45/64

    De auc'e F droite $ climat. 6roid et pluvieux0 famill" droite0 en bas $ plus 'umide0 moins ouvrier +?@," droite0 en 'aut $ plus de pollution" auc'e0 en maut $ population plus colore +? Non*ortalit est donc corrl positivement F populationblancs ?@,I0 revenus0 ducation&oiquement0 pollution est corrle positivement F d

    ?@,I0 revenus0 ducation

  • 7/25/2019 Module 250 Xls 1 Sol

    46/64

    p.ac.be/biostats Eric Depiereux - Universit de Namur

    ".1"

    ?".2"

    ?".51

    ".!8

    ?".17

    ".35

    ?".2"

    ".52

    ".".7"

    n des variables

  • 7/25/2019 Module 250 Xls 1 Sol

    47/64

    F1

    s G nombreuses +pop/'ouse -H c'aud 0 densit plus0 plus de revenus et d!ducation

    'ite et plus de mortalit.colore0 pollution0 rion froide et nativement corr

    ensit de population et nativement corrle F Icol b

  • 7/25/2019 Module 250 Xls 1 Sol

    48/64

  • 7/25/2019 Module 250 Xls 1 Sol

    49/64

    orte

    e F Icol

    lancs

  • 7/25/2019 Module 250 Xls 1 Sol

    50/64

    Pratique des biosA propos du

    ?"."8

    3.!"

    1."

    "."5

    2.5"

    1.!"

    2.1

    "".5

    1

    COMP2

    http://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdfhttp://webcampus.fundp.ac.be/BIOSTAT/document/docbiostats/Charte_copy.pdf
  • 7/25/2019 Module 250 Xls 1 Sol

    51/64

    ?3.2

    ?".5!?".78

    ?".

    ?2.11?2.15

    ?1.77

  • 7/25/2019 Module 250 Xls 1 Sol

    52/64

  • 7/25/2019 Module 250 Xls 1 Sol

    53/64

    atistiques www.fundp.ac.be/biostats Er

    ?".17

    1.2"

    !.2"

    ".18

    1."3

    2.1

    1.5

    ".82

    2."!

    ".19

    2.1!

    ?"."!

    2.35

    2.92

    1.89

    !8

    1.!9 1.72

    ."5

    ".!!

    Projectiondes villes

    Rec'erccommencorrlatiprincipal

  • 7/25/2019 Module 250 Xls 1 Sol

    54/64

    ?".2

    ?2.21

    ?".2?".

    ?".8

    ?1.22

    ?2."2 ?2.13

    ?".7!

    ?1.57

    ?2.!

    ?1.91?1.83

    8!

    ?1.5

    ?".8

    .

    ?3.!2

    COMP1

  • 7/25/2019 Module 250 Xls 1 Sol

    55/64

  • 7/25/2019 Module 250 Xls 1 Sol

    56/64

    ic Depiereux - Universit de Namur

    .7"

    e sur internet une carte dte la rpartition des villesns entre variables et com

    es

  • 7/25/2019 Module 250 Xls 1 Sol

    57/64

    ?1.!

    ?".8"

    ?2."

    ?2."5

  • 7/25/2019 Module 250 Xls 1 Sol

    58/64

  • 7/25/2019 Module 250 Xls 1 Sol

    59/64

    1.28

    ".17 Hart5ord3 *THouston3 T

    ndianapolis3 '

    Iansas *ity3 M,

    ;ancaster3 $A

    ;os An6eles3 ;on6

    AEron3 ,H

    Al0any?c)enectadAllentoFn3 Get)le)

    Atlanta3 @A

    Galtimore3 M%

    Girmin6)am3 A;

    Goston3 MA

    Grid6eport?Mil5ord3

    Gu55alo3 'D

    *anton3 ,H

    *)attanoo6a3 T'?@

    *)ica6o3 ;

    *incinnati3 ,H?ID?

    *le/eland3 ,H

    *olum0us3 ,H%allas3 T

    %ayton?prin65ield

    %en/er3 *,

    %etroit3 M

    Klint3 M

    @rand Rapids3 M@reens0oro?(insto

    es U%" eten fonction desosantes

  • 7/25/2019 Module 250 Xls 1 Sol

    60/64

    Hart5ord3 *T

    Houston3 T

    ndianapolis3 '

    Iansas *ity3 M,

    ;ancaster3 $A

    ;os An6eles3 ;on6

    ;ouis/ille3 ID?'Memp)is3 T'?AR?M

    Miami?Hialea)3 K;

    MilFauEee3 (

    Minneapolis?t. $a

    'as)/ille3 T'

    'eF Ha/en?Meride'eF ,rleans3 ;A

    'eF DorE3 'D

    $)iladelp)ia3 $A?'

    $itts0ur6)3 $A

    $ortland3 ,R

    $ro/idence3 R

    Readin63 $A

    Ric)mond?$eters0

    Roc)ester3 'D

    t. ;ouis3 M,?;

    an %ie6o3 *A

    an Krancisco3 *A

    an Jose3 *Aeattle3 (A

    prin65ield3 MA

    yracuse3 'D

    Toledo3 ,H

    tica?Rome3 'D

    (as)in6ton3 %*?M

    (ic)ita3 I

  • 7/25/2019 Module 250 Xls 1 Sol

    61/64

    pr n6 e 3

    yracuse3 'D

    Toledo3 ,H

    tica?Rome3 'D

    (as)in6ton3 %*?M

    (ic)ita3 I

    (ilmin6ton3 %#?'J(orcester3 MA

    DorE3 $A

    Doun6stoFn?(arre

  • 7/25/2019 Module 250 Xls 1 Sol

    62/64

    @re

    T Har

    Hou

    s3 ' nd

    3 M, Ian

    $A ;an

    s3 ;on6 Geac)3 *A ;A

    AEr

    enectady?Troy3 'D Al0Get)le)em3 $A?'J All

    Atl

    M% Gal

    m3 A; Gir

    Gos

    Mil5ord3 *T Gri

    Gu5

    *an

    a3 T'?@A *)a

    *)i

    ,H?ID?' *in

    ,H *le

    ,H *ol%al

    in65ield3 ,H %ay

    %en

    %et

    Kli

    ds3 M @ra?(inston?alem?Hi6) $oi

  • 7/25/2019 Module 250 Xls 1 Sol

    63/64

    T Har

    Hou

    s3 ' nd

    3 M, Ian

    $A ;an

    s3 ;on6 Geac)3 *A ;A

    ID?' ;ou'?AR?M Mem

    ea)3 K; Mia

    ( Mil

    s?t. $aul3 M'?( Min

    T' 'as

    ?Meriden3 *T 'eFHs3 ;A 'eF,

    'D 'D

    a3 $A?'J $)i

    $A $it

    R $or

    R $ro

    A Rea

    $eters0ur63 LA Ric

    'D Roc

    M,?; t;

    *A an%

    co3 *A anK

    A anJA ea

    MA pr

    'D yr

    Tol

    3 'D ti

    3 %*?M%?LA (as

    (ic

  • 7/25/2019 Module 250 Xls 1 Sol

    64/64

    pr

    'D yr

    Tol

    3 'D ti

    3 %*?M%?LA (as

    (ic

    3 %#?'J?M% (ilMA (or

    Dor

    n?(arren3 ,H Dou