!    O >0@- >-+@-_        _      *,"Arial-@T^x!@!@!@ !@!@!@!@#P@-#P#P`#P`#P#P>#P>-#PJ>#P># P>D# P >F# P>F# P ># P>2#P>#P>#P#P#P&>#P>22#P>F#P >#P>|#P`#P>|#P> #P>2#P>22#P>#P#P>#P> # P>$#!P>2#"P6##P >#$P>`#%P>#&P>`#'P@-#(P@-#)P>F#*P #+P4#,P2#-P>F `'P `(P*v o_Wv22?@  -                                                       G9 G: G; G< G? GF GG GH GI G[ DM0 DM1 DM2   DM3 DM4# 6general#6comp_nombres#6test_t_student#6corrlation#6an_var_2x2#6an_var_2x3#6an_var_2x5#6equation2#6equation3'Que voulez-vous faire ?'Mode d'emploi :'Analyse statistique ::'Comparaison de nombres d'observations, test du Khi-2A'Normalement, les cases fond rouge (ou rose, ou orang...)0'Comparaison de moyennes, test T de StudentN'sont des cases o vous ne devez rien crire (elles sont mme protges).+'Corrlation entre 2, 3 ou 4 variablesD'Ces cases contiennent en particulier les formules des calculs.''Analyse de variance, 2x2 facteurs''Analyse de variance, 2x3 facteursF'Les cases vertes, par contre, sont celles o vous pouvez frapper''Analyse de variance, 2x5 facteursC'les valeurs numriques (et parfois des chanes de caractres)) 'Mettez-y vos valeurs exprimentales6 'Les rsultats apparaissent dans les cases bleues6 'Rsoudre un systme de 2 quations 2 inconnues6 'Rsoudre un systme de 3 quations 3 inconnuesC 'Dans les cases jaunes de droite sont souvent les explications;'supplmentaires sur la feuille actuellement utilise. 'Feuilles de calcul ts_eq :%'Tests statistiques et quations'par Pierre DIEUMEGARD'Professeur de SVT'Lyce Thiers'F 13232 MARSEILLE6'Courriel : pierre.dieumegard@ac-aix-marseille.fr'Test de Khi2*'Test du khi2, par comparaison de la *' rpartition du nombre d'individus,&'1): on a les nombres d'individus-' rpartis dans les types 1, 2, 3, 4, 5 'nombres'proportions 'hyp nulle-' en fonction de traitements A, B, C, D'A'B'C'D 'total 'A'B 'C 'D  'trait 'A'B'C'D'observ 1%%@(G@P($I$I? (? (4  ;(4  ;( I$I$? P(! ~<@  (! 2@  (!  (!  ('Mettre les nombres d'individus en 'observ 2% %@(T@P(m۶m? (? (4  ;(4  ;( ܶm۶m? P(! @H@  (!~?@  (!  (!  ' B6..E10'observ 3(P( ( (4  ;(4  ;(  P(!   (!  (!  (!  ,'Les proportions des divers types pour  'observ4(P( ( (4  ;(4  ;(  P(!   (!  (!  (!  )' chaque traitement sont en H6..K10 'observ 5(   P(   (   (4     ;(4     ;(     P(!     (!    (!    (!    , 'Le nombre thorique d'individus en cas 'total obs( @S@ P( I@ P(  P(  P( _@  P( ? P( ? P(    P(    P(  @  P- ' d'hypothse nulle (pas de diffrence % % - ' entre les traitements) est en N6..Q10% % % % " 'le paramtre khi2 est en C13% % %%'matrice du khi2 : 'comptage des populations :/'la signification du test khi2 est en B15.(FK?  @ ;(Fp>@@;(F@;(F@;(0??;(0??;(0 ?;(0 ?;.'Sa valeur indique la probabilit que les(Fx߸?  @ ;(F~o?@;(F@;(F@;(0??;(0??;(0 ?;(0 ?;+' rpartitions soient dues au hasard (F  @ ;(F@;(F@;(F@;(0?;(0?;(0 ?;(0 ?;-' (donc que les traitements n'aient pas(F  @ ;(F@;(F@;(F@;(0?;(0?;(0 ?;(0 ?;' d'effet)(F     @  ;(F   @ ;(F   @ ;(F   @ ;(0?;(0?;(0 ?;(0 ?;,'par exemple, 0.05 est une probabilit .' de 5% qu'il n'y ait pas de diffrence. 'khi2 :(|`d@P'nb de ddl(<?P? P?'proba : (6gɤǍ?z@<<@123>>CHIDIST((<8U?{Gz?***;N.S.;* 'test T'Marseille'<=groupe=> 'France'titre gnral :+ 'Comparaison de moyennes par le test T%'<=nombre=>%'ecrit ina-ensa 2001, 'mettre en B2 le nombre d'observations 'variables ^moy 1^ctype 1 ^moy2^ctype 2^sd ^diff ^diff/sd^conclusion( ' du groupe 1 et en D2 le nombre  'bioa%A%Y%SP %^(A]B1s?@@#(`ʡ?(PC̩?(:@U!@!@***;;# ' d'observations du groupe 2 'biob%%R@%%V(A-,w?@@#(> ףp=(K3!(:HU!@!@***;;**3 'mettre en B5..B18 les moyennes d'observations 'mata%Һ%@%R%~(AZR!?@@#(Gz(D5h7(:PU!@!@***;;**6 ' du groupe 1, en C5..C18 les carts-types des  'matb%%H% %d(A ߚ?@@#(n(gj{(:XU!@!@***;;*! ' observations du groupe 1 'chim%%V%S %(AqK`?@@#(8v@(%|?@(:`U!@!@***;;**3 'mettre en D5..D18 les moyennes du groupe 2 et 'phys% % @%  % Q(A ¢xa? @ @#( P +?  ( C/?  (: hU !@ !@***;; 0  ' en E5..E18 les carts-types du groupe 2 'rtex% : % 1% S % Z(A  @H? @ @#( @^I ?  ( E n?  (: pU !@ !@***;;  'lv% % Ra%  % S-(A ]#? @ @#( -?  ( 7?  (: xU !@ !@***;; 6  'en F5..F18 s'affichent les paramtres de Student% % Ra%  % S-(A ]#? @ @#( -?  ( 7?  (: U !@ !@***;; % % H%  % d(A  ߚ? @ @#( n  ( gj{  (: U !@ !@***;; *1  'En G5..G18 la diffrence entre les moyennes%R%Y%SP %^(A]B1s?@@#(@x?(L?(:U!@!@***;;1 'En H5..H18 cette diffrence divise par le %%R@%%V(A-,w?@@#(> ףp=(K3!(:U!@!@***;;** ' paramtre de Student%Һ%@%R%~(AZR!?@@#(Gz(D5h7(:U!@!@***;;**%Һ%@%R%~(AZR!?@@#(Gz(D5h7(:U!@!@***;;**. 'et finalement en I5..I18 la conclusion :7 ' - rien si la diffrence n'est pas significative2 ' - *si la diffrence est significative 5%? ' - ** si la diffrence est significative 1% (ou mieux) 'srie X 'srie Y'srie Y2'srie Y3'X'Y'Y2'Y31 'Corrlation entre les sries X, Y, Y2 et Y3%@%%@%'X(8?ccz@<<@123>>CORREL( 'Remplir les colonnes X, Y%%%% 'Y(8?ccz@<<@123>>CORREL((8?ccz@<<@123>>CORREL() ' (et ventuellement Y2 et Y3)%%@%@% 'Y2(85?ccz@<<@123>>CORREL((85?ccz@<<@123>>CORREL((8?ccz@<<@123>>CORREL(%%%@% 'Y3(8i`?ccz@<<@123>>CORREL((8~i`?ccz@<<@123>>CORREL((8V6i?ccz@<<@123>>CORREL((8?ccz@<<@123>>CORREL(, 'les corrlations s'affichent en F1..I6%@%%%'X'Y'Y2'Y3! 'Les moyennes sont en F7..I7'moyennes(*\(@c( ףp= 1@c(B@c(33333F@c2 'Les carts-types (dviations standards) sont'cart-type(o7"@c(o7"@c(D{2@c(f\7 *@c ' en F8..I86 'L'quation de la droite de rgression Y=F(x) est 'pente(! ?(! 6&-@(! p.Y?6  ' en G10 et G11 : G10 est la pente, G11est f(0) 'ord_orig(! #@ (! 66x6@ (! ѩB@ (  'Y2=H11 + H10*X et Y3 = I11 + I10*X"Facteur A"Facteur B"Moyennes"cart type "Nombre "Total"SC intra('Analyse de variance 2x2 facteurs%@%@%R%3%(GzP@(/J=9@@?%@%%A%Q%(a@(/PT@@?''mettre les moyennes, carts-types%%@%ҩ%>%(p= G@(/zB@@?%' et nombre d'observations dans%%%R%3%( T@(/y)B@@?' les cases C2..E5 "Total(gffffA@P(C@P(t@P(ec]f@P-'La probabilit que la variation ne soit 'Source "SDC"DL"CM"F "Prob." rapporter"ta carr*' pas lie au 1e facteur est en F9, 'Facteur A(ς!D@P@P@@@@z@<<@123>>HARMEAN(%@(ς!D@(4tO-@ (:*ݻ{{? z@<<@123>>FDIST((.U ?p < 0,05n.s.; p < 0,05(#(<=? -'La probabilit que la variation ne soit 'Facteur B( b"@P@P@@@@z@<<@123>>HARMEAN(% @( b"@  ( Vrr?  (: _C{?   z@<<@123>>FDIST((. U ?p < 0,05n.s.; n.s.( Jl$?  ) ' pas lie au 2e facteur est en F10 'Interaction( @V?z@<<@123>>SUMSQ(z@<<@123>>HARMEAN( @@z@<<@123>>HARMEAN(% @( @V?  ( B?  (: vY;e?   z@<<@123>>FDIST((. U ?p < 0,05n.s.; n.s.( bB`?  . 'La probabilit que la variation ne soit  'Erreur( ec]f@(7 A@? ?( 2Svo@  . ' pas due l'interaction entre les deux 'Total( w $H5m@ P( B@?( |(`gL@ P ' facteurs est en F11.' 'La signification statistique est ' ' ' ' en G9..G11'(origine : Jean Bgin, #' dpartement de psychologie,(' universit du Qubec Montral)"Facteur A"Facteur B"Moyennes"cart type "Nombre "Total"SC intra('Analyse de variance 2x3 facteurs%@%@%(* gz&@W@\@Z@%(B@(/VUUUUo@@?%@%(<fffffY@@Y@]@X@X@@Z@(<3^];Px!@@Y@]@X@X@@Z@%@(0@(/33333s@@?*'mettre les moyennes, carts-types et%@%(3 [@@V@^@[@\@(3#{kA}@+@@V@^@[@\@%( {@(/h@@?-' nombre d'observations dans les cases %%@(3T@V@R@@P@V@(3Y)@V@R@@P@V@%@(y@(/UUUUU@@?' C2..E7%%(*S@@Y@Q@M@(*zE#6@@Y@Q@M@%(l@(/@@?%%(<S@S@V@K@P@@W@(<D6>$ /@S@V@K@P@@W@%@(w@(/@@? "Total(|@P(9@P(8@P(xwwww@P-'La probabilit que la variation ne soit*' pas lie au 1e facteur est en F9,  'Source "SDC "DL "CM "F "Prob. " rapporter "ta carr- 'La probabilit que la variation ne soit 'Facteur A( 6`F@P@P@@@@z@<<@123>>HARMEAN(% @( 6`F@  ( &r?  (: IN?   z@<<@123>>FDIST((. U ?p < 0,05n.s.; n.s.( 3f[? ) ' pas lie au 2e facteur est en F10 'Facteur B( B/B@P@P@P@@@@z@<<@123>>HARMEAN(% ( B/B@  ( +T;@  (: ))>   z@<<@123>>FDIST((. U  ?p < 0,05n.s.; p < 0,05( FIW`? . 'La probabilit que la variation ne soit  'Interaction( 9@z@<<@123>>SUMSQ(z@<<@123>>HARMEAN(  @@z@<<@123>>HARMEAN(% ( 9@  ( l~x{=@@  (:  ר>   z@<<@123>>FDIST((. U  ?p < 0,05n.s.; p < 0,05( J:? / ' pas lie l'interaction entre les deux 'Erreur( xwwww@(7 3@ ? ?( XrUh@   ' facteurs est en F11. 'Total(DS:@  P(8@?( cU@  P''La signification statistique est ' en G9..G11' ' ' ' '(origine : Jean Bgin, #' dpartement de psychologie,(' universit du Qubec Montral)"Facteur A"Facteur B"Moyennes"cart type "Nombre "Total"SC intra('Analyse de variance 2x5 facteurs%@%@%(iH=6?"@ @@ @$@@@@@@ %(^@(/>@@?%@%(i@@"@@@@&@@@ @@ (iJ @@"@@@@&@@@ @@ %(@Q@(/43333sD@@?*'mettre les moyennes, carts-types et%@%(i&@&@*@ @@,@&@*@*@$@&@ (iԚ @&@*@ @@,@&@*@*@$@&@ %([@(/K@@?-' nombre d'observations dans les cases %@%(i*@(@&@0@&@"@7@(@$@3@&@ (i Z@(@&@0@&@"@7@(@$@3@&@ %(`@(/f@@?' C2..E11%@%@(i(@$@3@,@@$@&@,@.@&@&@ (iI?h @$@3@,@@$@&@,@.@&@&@ %(^@(/_@@?%%@%(ihM? @@@@@@@@"@@ %(^@(/2@@?%%%(iPG?$@@ @$@@@$@@@@ %(Q@(/233333A@@?-'La probabilit que la variation ne soit%%%(ib~Ϯ @,@&@2@,@*@6@1@0@(@&@ %([@(/ffffff[@@?+' pas lie au 1e facteur est en F15, % % % @(i uV𦂹@4@0@0@.@2@0@4@6@,@3@ % ( @`@  (/ 333333N@ @ ?- 'La probabilit que la variation ne soit% % @% (i eu,Y@5@3@1@.@6@0@6@6@2@5@ % ( ^@  (/ fffffP@ @ ?) ' pas lie au 2e facteur est en F16 "Total( 33333[@ P( Y@ P( <@ P( fffff@ P. 'La probabilit que la variation ne soit / ' pas lie l'interaction entre les deux 'Source "SDC "DL "CM "F "Prob. " rapporter "ta carr ' facteurs est en F17.'Facteur A(p= ?P@ P@@ @$@ z@<<@123>>HARMEAN(%@(p= ?(~Yu?(: O?z@<<@123>>FDIST((.U?p < 0,05n.s.; n.s.("c?''La signification statistique est 'Facteur B(q( }@P@P@P@ P@ P@@ @$@ z@<<@123>>HARMEAN(%(q( ]@(炓2{,@(:(QA/>z@<<@123>>FDIST((.U ?p < 0,05n.s.; p < 0,05(C% ?' en G15..G17'Interaction(Q? z@<<@123>>SUMSQ( z@<<@123>>HARMEAN( @$@ z@<<@123>>HARMEAN(%(Q?(=P>?(:۲?z@<<@123>>FDIST((.U?p < 0,05n.s.; n.s.('$,D? 'Erreur(fffff@ (7V@ ??(7& @'(origine : Jean Bgin,  'Total(o= ף@P(X@ ?(._@P#' dpartement de psychologie,(' universit du Qubec Montral)' ' ' 'x'y'c% 'Rsolution d'un systme de deux(F@(@S@(V@" 'quations deux inconnues :(9@ (6@ (K@ & 'Entrez les coefficients dans les 'inverse  'cases' ¤xL' -I?" 'C9-C10(pour les coeff. en x)' F?' ŤxL# 'F9-F10 (pour les coeff. en y)'a'x'+'b'y'='c( 'I9-I10 (pour les coeff. constants)% 'x'+%@'y'=%, 'Cliquez sur "Rsoudre les 2 quations" 'solution% @ 'x '+%  'y '=%  $  'les solutions sont en F12-F13' ~u7@' ֡lͿ 'solution :  'x=( ~u7@  'y=( ֡lͿ 'x'y'z'c- 'Rsolution d'un systme de 3 quations (@ (P@ (@ ( @   ' 3 inconnues :(@S@ (? (F@ (@S@  . 'Mettre les coefficients en x en C12..C14(@ (@ ( @ (@  3 ' les coefficients en y en F12..F143 ' les coefficients en z en I12..I14' ԅb?' .\S?' h?d+ ' les constantes en L12..L14' X?' l[B=' ,~' !S' =UpW' +?, 'cliquez sur "Rsoudre les 3 quations"%  'les solutions sont en C17.. C19' 8z? "a 'x '+ "b 'y '+ "c  'z  '=  'd' S=2?% @ 'x '+%  'y '+% @  'z  '=%  '  ˣ% @ 'x '+% @ 'y '+%    'z  '=%  @%  'x '+% @ 'y '+%   'z  '=%  'solution "x=(8z? "y=(S=2? "z=( ˣ B@    BCD:A2..D:A8192 BCD:A1  BCD:B2..D:B8192  BCD:B1  BCD:C2..D:C8192  BCD:C1  BCD:D2..D:D8192 BCD:D1 BCD:A1..D:D8192 BCD:A2..D:A8192  66 P5 ``??P6 5P< 5P< 5P< 5P< 5P6 5P6 5      ef                                  P P*P+P"P,PPP PPP P P PPP PP P!PP PP P PP PPP P PPPP P PP PPP P PPPP P PPP PPPPPPP PPP PPPPP PPP-PPPP P PP  Pe P!PE P PPPE PP  PPE Pf P PP PPPPPPPPPPPPPPPP PPPPPPPPP PPPPPPPPP PPPPPPPPPPPPPPPP P P PPPPPPPPPPPPPPP PPPPPPPP PPP PPPPP PPPPPPPPP PP PPP P P P PPPPP PPPPPPPP  PPPPPPP  PPPPP PP PPP PPPP PPPP PP PPPP PP P PPPPP PPPPPPPPPPPP P#PP P)P#P PP PP P#PP#P PP PP#PP#P PP PP#PP#P P PP#P%P#P       A A A    H J      0 *   *    &  D B 0  H  B                   A @  A @  A @  A @  A @  A @  A @  A @  26!6 BBZA}.9'd ^ Seite #BLB B>(( ('++LotusScript Development Environment:2:5:(Options):0:66 Option Public '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub mouvement '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:mouvement:1:8 Sub mouvement [<<D:\actuel\statistiques\ts_eq.123>>Fentre 1].Activate [comp_nombres].TurnTo [comp_nombres:A2].Select End Sub                 ! ">zz #$Ne@ d %$&  #general_'&%,( )B@  ''*B@  ''"+"(&" +PCm??$D" +Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [comp_nombres].TurnTo [comp_nombres:A2].Select End Sub"wkhi2??$D0@P khi2" +Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [test_t_student].TurnTo [test_t_student:A2].Select End Sub"zstudent??0A<@P student" +Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [corrlation].TurnTo [corrlation:A2].Select End Sub"~ corrlation??<AH@P  corrlation" +Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [an_var_2x2].TurnTo [an_var_2x2:A2].Select End Sub"{ anvar2x2??IAU@P  anvar2x2" +Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [an_var_2x3].TurnTo [an_var_2x3:A2].Select End Sub"{ anvar2x3??TB`@P  anvar2x3" +Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [an_var_2x5].TurnTo [an_var_2x5:A2].Select End Sub"{ anvar2x5??>_Am@P  anvar2x5" +Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [equation2].TurnTo [equation2:A2].Select End Sub"| equation2??@>@P  equation2" +Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [equation3].TurnTo [equation3:A2].Select End Sub"| equation3??@@P  equation3" ,$-  # comp_nombres_.-,,/ 0B@  ..1B@  .."2"/-" 2PCm??@>" 2Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [general].TurnTo [general:A2].Select End Sub"zgeneral??@>@P gnral" 3$4  #test_t_student_543, 6 7B@  558B@    55"9"64" 9PAm??@" 9Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [general].TurnTo [general:A2].Select End Sub"{ Bouton 2??@@P gnral" :$;  # corrlation_;:,.cht Lotus Chart`*@--@- -@-_bb4 4 h h  SS}}_AAvD !2        _  b  b      4  4  h  h      S  S  }  }  _  _      A  A                   !  "  # v $ v % D & D '  (  ) 2 * 2(Arial-@ k1@@!P$-!P**qqq>@T@?srie Xsrie Ysrie Y2srie Y3 Axe des X Axe des Y  Titre *'.@'  t' 1@t' 2@~'@'  0*' 0*'      'o@@>@'o$@@T@'o???'<  d' 'srie X'<  $' 'srie Y'<  $' 'srie Y2'<   $' 'srie Y3'<    $' '<    $' '<  $' '<  $' '<  $' '<   $' '<   $' '<   $' '<   $$' '<   %$' '<  +$' '<   &$' '<    *$' '<    ,$' '<  $' '<  $' '<  $' '<  $' '<  $' '<  ,6' '<" ! 6' '<$ # 6' '<  6' '<& % 6' '< ( ' 6' '<!* !) 6' !<( 'P(-B(# Autres*&)**< =B@  >B@  "?"<;" ?PCm??FE" ?V@VA<V     y   z    {    |  Graphique 2V"@ GRAPHIQUE 1??FE@@A" ?Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [general].TurnTo [general:A2].Select End Sub"{ Bouton 4??@@@P gnral" B$C  # an_var_2x2_DCB,E FB@  DDGB@  DD"H"EC" HPCm??@L" HClick '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [general].TurnTo [general:A2].Select End Sub"{ Bouton 5??@L@P gnral" I$J  # an_var_2x3_KJI,L MB@  KKNB@  KK"O"LJ" OPCm??@:>>" OClick '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [general].TurnTo [general:A2].Select End Sub"{ Bouton 6??@:>>@P gnral" P$Q  # an_var_2x5_RQP, S TB@  RRUB@    RR"V"SQ" VPCm??/>@y>" VClick '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [general].TurnTo [general:A2].Select End Sub"{ Bouton 7??/>@y>@P gnral" W$X  # equation2_YXW,Z [B@  YY\B@  YY"]"ZX" ]PCm??C>" ]rClickr r'++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [].MatrixInvert [equation2:A2..equation2:b3],[equation2:A6] [].MatrixMultiply [equation2:A6..equation2:b7],[equation2:c2..equation2:c3],[equation2:A11] End Sub"{ Bouton 1??0@$P Rsoudre les 2quations"! ]Click '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [general].TurnTo [general:A2].Select End Sub"{ Bouton 8??@>C>@P gnral" ^$_  # equation3__^, ` aB@  bB@    "c"`_" cPCm??׮ER" crClickr r'++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [].MatrixInvert [equation3:A2..equation3:C4],[equation3:A6] [].MatrixMultiply [equation3:A6..equation3:C8],[equation3:D2..equation3:D4],[equation3:A11] End Sub"{ Bouton 3??׮E>/@&P rsoudre les 3 quations"" cClick '++LotusScript Development Environment:2:5:(Options):0:66 '++LotusScript Development Environment:2:5:(Forward):0:1 Declare Sub Click(Source As Buttoncontrol) '++LotusScript Development Environment:2:5:(Declarations):0:2 '++LotusScript Development Environment:2:2:BindEvents:1:129 Private Sub BindEvents(Byval Objectname_ As String) Static Source As BUTTONCONTROL Set Source = Bind(Objectname_) On Event Click From Source Call Click End Sub '++LotusScript Development Environment:2:2:Click:1:12 Sub Click(Source As Buttoncontrol) [general].TurnTo [general:A2].Select End Sub"{ Bouton 9??@AR@P gnral" $W4 %,3:BIPW^   dieumegard dieumegardtests statistiques usuels, sous forme de fichiers de tableur : test du khi2, test T de student, corrlation et rgression, analyse de variance. Rsolution de systmes d'quations 2 ou 3 inconnues tests statistiques usuels3123123 PropertyDoc Info AuthorDoc Info CommentsDoc Info Editing TimeDoc Info KeywordsDoc Info Last RevisorDoc Info ObjectDoc Info RevisionsDoc Info Revisions CountDoc Info SubjectDoc Info TitleGraphique 2WCHChart  hSdV R RW>PS \S RRoQ R  }Q S  Q S  R RQAS^R0S R{RCMHdrhS