{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Titre","Md","Moyenne","Ecartype ","CV","Formules","ScoresZ","CN-Ord","CN-Prop","CN-surf(1)","CN-surf(2)","CN-surf(3)","CN-Prob","CN-Table"],"not_rendered":{"charts":7,"images":3,"macros":1,"external_links":4,"defined_names":48,"comments":13,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Titre","index":0,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,6,2,10],[4,6,9,10]]}
[]
[]
[null,null,null,null,null,null,"Objectif du labo Excel 3"]
[]
[null,null,null,null,null,null,"Utiliser Excel pour décrire les données d'une variable à l'aide des mesures de tendance centrale et de variation de façon à apprécier la représentativité et la variabilité d'un phénomène."]

{"sheet":"Md","index":1,"n_rows":87,"n_cols":21,"rows_kept":87,"cut":false,"hidden":false,"merged":[[38,9,38,15],[40,9,41,15],[79,1,79,15],[1,1,1,15],[3,1,3,15],[5,1,5,7],[5,9,5,15],[28,13,28,15],[43,1,43,15],[45,1,45,7],[45,9,45,15],[62,4,63,4],[62,12,63,12],[68,13,68,15],[40,1,41,7],[38,1,38,7]]}
[]
[null,"Calcul de la médiane pour des scores bruts- n impair (Démonstration & exercice)"]
[]
[null,"Quelle est la note typique médiane chez les étudiants du SOL1020-E13? Pour y répondre, on s'appuie sur les scores bruts…"]
[]
[null,"Notes à l'examen intra des 29 premiers étudiants du SOL1020-E13 en ordre alphabétique (n impair)",null,null,null,null,null,null,null,"Notes à l'examen final des 29 premiers étudiants du SOL1020-E13 en ordre alphabétique (n impair)"]
[]
[null,"Notes (X)",null,"Rang","n=29",null,null,null,null,"Notes (X)",null,"Rang","n=29"]
[null,42,null,1,null,null,null,null,null,40]
[null,50,null,2,null,null,null,null,null,41]
[null,54,null,3,null,null,null,null,null,41]
[null,55,null,4,null,null,null,null,null,42]
[null,58,null,5,null,null,null,null,null,44]
[null,59,null,6,null,null,null,null,null,49]
[null,59,null,7,null,null,null,null,null,49]
[null,61,null,8,null,null,null,null,null,50]
[null,61,null,9,null,null,null,null,null,65]
[null,69,null,10,null,null,null,null,null,66]
[null,74,null,11,null,null,null,null,null,66]
[null,75,null,12,null,null,null,null,null,68]
[null,76,null,13,null,null,null,null,null,68]
[null,78,null,14,null,null,null,null,null,69]
[null,78,null,15,"n+1/2=15",null,null,null,null,74,null,null,"n+1/2=15"]
[null,80,null,16,null,null,null,null,null,75]
[null,81,null,17,null,null,null,null,null,75]
[null,81,null,18,null,null,null,null,null,76]
[null,82,null,19,null,null,null,null,null,76]
[null,84,null,20,null,null,null,null,null,81]
[null,84,null,21,null,null,null,null,null,85]
[null,85,null,22,null,null,null,null,null,86]
[null,86,null,23,null,null,null,null,null,88]
[null,88,null,24,null,null,null,null,null,89]
[null,88,null,25,null,null,null,null,null,89]
[null,91,null,26,null,null,null,null,null,89]
[null,92,null,27,null,null,null,null,null,90]
[null,94,null,28,null,null,null,null,null,95]
[null,94,null,29,null,null,null,null,null,98]
[]
[null,"Interprétation statistique "]
[]
[null,"La médiane est de 78. Ce qui signifie qu'au moins 50% des étudiants ont obtenu une note de 78% ou moins à l'examen intra du SOL1020-E13."]
[]
[]
[null,"Calcul de la médiane pour des scores bruts- n pair (Démonstration & exercice)"]
[]
[null,"Notes à l'examen intra des 30 premiers étudiants du SOL1020-E13 en ordre alphabétique (n pair)",null,null,null,null,null,null,null,"Notes à l'examen final des 30 premiers étudiants du SOL1020-E13 en ordre alphabétique (n pair)"]
[]
[null,"Notes (X)",null,"Rang","n=30",null,null,null,null,"Notes (X)",null,"Rang","n=30"]
[null,42,null,1,null,null,null,null,null,40]
[null,50,null,2,null,null,null,null,null,41]
[null,54,null,3,null,null,null,null,null,41]
[null,55,null,4,null,null,null,null,null,42]
[null,58,null,5,null,null,null,null,null,44]
[null,59,null,6,null,null,null,null,null,49]
[null,59,null,7,null,null,null,null,null,49]
[null,61,null,8,null,null,null,null,null,50]
[null,61,null,9,null,null,null,null,null,65]
[null,69,null,10,null,null,null,null,null,66]
[null,74,null,11,null,null,null,null,null,66]
[null,75,null,12,null,null,null,null,null,68]
[null,76,null,13,null,null,null,null,null,68]
[null,78,null,14,null,null,null,null,null,69]
[null,78,null,15,"n+1/2=15,5",null,null,null,null,74,null,null,"n+1/2=15,5"]
[null,80,null,16,null,null,null,null,null,75]
[null,81,null,17,null,null,null,null,null,75]
[null,81,null,18,null,null,null,null,null,76]
[null,82,null,19,null,null,null,null,null,76]
[null,84,null,20,null,null,null,null,null,81]
[null,84,null,21,null,null,null,null,null,85]
[null,85,null,22,null,null,null,null,null,86]
[null,86,null,23,null,null,null,null,null,88]
[null,88,null,24,null,null,null,null,null,89]
[null,88,null,25,null,null,null,null,null,89]
[null,91,null,26,null,null,null,null,null,89]
[null,92,null,27,null,null,null,null,null,90]
[null,94,null,28,null,null,null,null,null,95]
[null,94,null,29,null,null,null,null,null,98]
[null,98,null,30,null,null,null,null,null,100]
[]
[null,"Représentation graphique de la médiane à l'aide du diagramme en boîtes et à moustaches (n=30)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Examen intra","Examen final","Quart"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                  ",null,"min",42,{"$f":"QUARTILE(J49:J78,0)","v":40},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",{"$f":"QUARTILE(B49:B78,1)","v":61},{"$f":"QUARTILE(J49:J78,1)","v":53.8},1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Md",79,{"$f":"QUARTILE(J49:J78,2)","v":74.5},2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2",{"$f":"QUARTILE(B49:B78,3)","v":85.8},{"$f":"QUARTILE(J49:J78,3)","v":87.5},3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"max",98,100,4]

{"sheet":"Moyenne","index":2,"n_rows":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,14,38,15],[21,1,22,10],[21,12,22,18],[24,1,24,18],[26,1,26,10],[26,12,26,18],[28,1,28,10],[28,12,28,18],[1,1,1,18],[3,1,3,18],[5,1,5,10],[5,12,5,18],[19,1,19,10],[19,12,19,18]]}
[]
[null,"Moyenne dans le cas d'une distribution avec des données brutes"]
[]
[null,"Quel est le revenu horaire typique moyen (en dollars) d'une micro-entreprise? (n=5)"]
[]
[null,"Démonstration: calcul de la moyenne",null,null,null,null,null,null,null,null,null,null,"Exercice: trouver la moyenne "]
[]
[null,null,"Cas",null,"Scores Xi",null,null,null,null,null,null,null,null,"Cas",null,"Scores Xi"]
[null,null,1,null,10,null,null,null,null,null,null,null,null,1,null,20]
[null,null,2,null,30,null,null,null,null,null,null,null,null,2,null,30]
[null,null,3,null,20,null,null,null,null,null,null,null,null,3,null,40]
[null,null,4,null,50,null,null,null,null,null,null,null,null,4,null,60]
[null,null,5,null,40,null,null,null,null,null,null,null,null,5,null,20]
[null,null,null,"SXi",{"$f":"SUM(E9:E13)","v":150},null,null,null,null,null,null,null,null,null,"SXi"]
[]
[null,null,"X =","SXi/n",{"$f":"E14/5","v":30},null,null,null,null,null,null,null,null,"X =","SXi/n"]
[]
[]
[]
[null,"Interprétation statistique "]
[]
[null,"La moyenne est égale à 30. Autrement dit, les cinq travailleurs de la micro-entreprise gagnent en moyenne 30 dollars par heure, soit le revenu typique."]
[]
[]
[null,"Moyenne dans le cas d'une distribution avec des fréquences simples  "]
[]
[null,"Revenu horaire de 15 travailleurs d'une micro-entreprise (en dollars)",null,null,null,null,null,null,null,null,null,null,"Revenu horaire de 22 travailleurs d'une micro-entreprise (en dollars)"]
[]
[null,"Démonstration: calcul de la moyenne pondérée",null,null,null,null,null,null,null,null,null,null,"Exercice: trouver la moyenne pondérée des scores ci-dessous"]
[]
[null,null,"Scores Xi",null,"Fréq. fi",null,null,null,"Xi  fi",null,null,null,null,"Scores Xi",null,"Fréq. fi",null,null,"Xi fi"]
[null,null,10,null,3,null,null,null,{"$f":"C32*E32","v":30},null,null,null,null,20,null,4]
[null,null,30,null,2,null,null,null,{"$f":"C33*E33","v":60},null,null,null,null,30,null,6]
[null,null,20,null,5,null,null,null,{"$f":"C34*E34","v":100},null,null,null,null,40,null,3]
[null,null,50,null,4,null,null,null,{"$f":"C35*E35","v":200},null,null,null,null,60,null,7]
[null,null,40,null,1,null,null,null,{"$f":"C36*E36","v":40},null,null,null,null,20,null,2]
[null,"SXi",{"$f":"SUM(C32:C36)","v":150},"S fi",{"$f":"SUM(E32:E36)","v":15},null,null,"S Xifi",{"$f":"SUM(I32:I36)","v":430},null,null,null,"SXi",{"$f":"SUM(N32:N36)","v":170},"S fi",{"$f":"SUM(P32:P36)","v":22},null,"SXifi"]
[]
[null,"X =","SXifi / n",{"$f":"I37/E37","v":28.7},null,null,null,null,null,null,null,null,"X =","SXifi / n"]

{"sheet":"Ecartype ","index":3,"n_rows":89,"n_cols":7,"rows_kept":89,"cut":false,"hidden":false,"merged":[[56,5,56,6],[71,5,71,6],[88,1,88,6],[70,3,70,4],[85,3,85,4],[90,1,94,6],[85,5,85,6],[86,5,86,6],[1,1,1,6],[39,1,39,6],[19,5,19,6],[20,5,20,6],[55,5,55,6],[19,4,22,4],[21,5,21,6],[22,5,22,6],[41,1,41,6],[24,1,26,6],[3,1,3,6],[55,3,55,4],[70,5,70,6]]}
[]
[null,"Calcul de la variance et de l'écart-type- Démonstration & exercice"]
[]
[null,"Quelle est la variation du nombre d'heures passées sur Internet par jour ? (n=9)"]
[]
[null,"Cas (i)","Scores Xi","Déviation Di","Di2"]
[null,1,2,{"$f":"(C7-$C$19)","v":-8},{"$f":"D7^2","v":64},"= D12","= (X1 - X)2"]
[null,2,4,-6,36,"= D22","= (X2 - X)2"]
[null,3,6,-4,16,"= D32","= (X3 - X)2"]
[null,4,8,-2,4,"= D42","= (X4 - X)2"]
[null,5,10,0,0,"= D52","= (X5 - X)2"]
[null,6,12,2,4,"= D62","= (X6 - X)2"]
[null,7,14,4,16,"= D72","= (X7 - X)2"]
[null,8,16,6,36,"= D82","= (X8 - X)2"]
[null,9,18,8,64,"= D92","= (X9 - X)2"]
[null,"S",{"$f":"SUM(C7:C15)","v":90},{"$f":"SUM(D7:D15)","v":0},{"$f":"SUM(E7:E15)","v":240}]
[null,null,null,null,"SDi² = S(Xi - X)²"]
[null,"n",9]
[null,"Moyenne X",{"$f":"C16/C18","v":10}]
[null,null,null,null,"Formules"," s2 = (SDi2)/N"]
[null,"Variance Échan.",{"$f":"(E16/8)","v":30},"=240/9-1",null," s2 = (SDi2)/n-1"]
[null,null,null,null,null," s =  Ö s2"]
[null,"Écart-type Échan.",{"$f":"C21^0.5","v":5.5},"=30^0,5",null," s =  Ö s2"]
[]
[null,"Interprétation statistique et représentation graphique: L'écart-type de l'échantillon est de 5,5. Autrement dit, environ deux tiers des répondants (68%) passent sur Internet ± 5,5 heures de la moyenne, soit entre 4,5 et 15,5 heures (10-5,5 et 10+5,5). Encore, si l'on prenait au hasard un cas, il y a 68% de chances que son score se trouve à ± 5,5 heures de la moyenne, soit entre 4,5 et 15,5 h."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Exercice: calculer la variance et l'écart-type des scores ci-dessous"]
[]
[null,"Quelle est la variation de la performance (notes en %) chez les étudiants ? (n=7 par groupe)"]
[]
[null,"Groupe A","Scores Xi","Déviation Di","Di2"]
[null,1,64,null,null,"= D12","= (X1 - X)2"]
[null,2,66,null,null,"= D22","= (X2 - X)2"]
[null,3,68,null,null,"= D32","= (X3 - X)2"]
[null,4,69,null,null,"= D42","= (X4 - X)2"]
[null,5,70,null,null,"= D52","= (X5 - X)2"]
[null,6,71,null,null,"= D62","= (X6 - X)2"]
[null,7,82,null,null,"= D72","= (X7 - X)2"]
[null,"S",{"$f":"SUM(C45:C51)","v":490}]
[null,null,null,null,"SDi² = S(Xi - X)²"]
[null,"n",7]
[null,"Moyenne X",{"$f":"C52/C54","v":70}]
[null,"Variance échan.",null,"                  X ± s ",null," s2 = (SDi2)/n-1"]
[null,"Écart-type échan.",null,"    70 ±  ",{"$f":"\"\"&C57","v":""}," s =  Ö s2"]
[]
[null,"Groupe B","Scores Xi","Déviation Di","Di2"]
[null,1,44,{"$f":"C60-70","v":-26},{"$f":"D60*D60","v":676},"= D12","= (X1 - X)2"]
[null,2,56,{"$f":"C61-70","v":-14},{"$f":"D61*D61","v":196},"= D22","= (X2 - X)2"]
[null,3,63,-7,49,"= D32","= (X3 - X)2"]
[null,4,74,4,16,"= D42","= (X4 - X)2"]
[null,5,80,10,100,"= D52","= (X5 - X)2"]
[null,6,82,12,144,"= D62","= (X6 - X)2"]
[null,7,91,21,441,"= D72","= (X7 - X)2"]
[null,"S",{"$f":"SUM(C60:C66)","v":490},{"$f":"SUM(D60:D66)","v":0},{"$f":"SUM(E60:E66)","v":1622}]
[null,null,null,null,"SDi² = S(Xi - X)²"]
[null,"n",7]
[null,"Moyenne X",{"$f":"C67/C69","v":70}]
[null,"Variance échan.",{"$f":"E67/6","v":270.3},"                  X ± s ",null," s2 = (SDi2)/n-1"]
[null,"Écart-type échan.",{"$f":"SQRT(C71)","v":16.399999999999999},"    70 ±  ",{"$f":"\"\"&C72","v":"16,4"}," s =  Ö s2"]
[]
[null,"Groupe C","Scores Xi","Déviation Di","Di2"]
[null,1,34,{"$f":"C75-70","v":-36},{"$f":"D75*D75","v":1296},"= D12","= (X1 - X)2"]
[null,2,46,{"$f":"C76-70","v":-24},{"$f":"D76*D76","v":576},"= D22","= (X2 - X)2"]
[null,3,58,-12,144,"= D32","= (X3 - X)2"]
[null,4,79,9,81,"= D42","= (X4 - X)2"]
[null,5,82,12,144,"= D52","= (X5 - X)2"]
[null,6,90,20,400,"= D62","= (X6 - X)2"]
[null,7,101,31,961,"= D72","= (X7 - X)2"]
[null,"S",{"$f":"SUM(C75:C81)","v":490},{"$f":"SUM(D75:D81)","v":0},{"$f":"SUM(E75:E81)","v":3602}]
[null,null,null,null,"SDi² = S(Xi - X)²"]
[null,"n",7]
[null,"Moyenne X",{"$f":"C82/C84","v":70}]
[null,"Variance échan.",{"$f":"E82/6","v":600.29999999999995},"                  X ± s ",null," s2 = (SDi2)/n-1"]
[null,"Écart-type échan.",{"$f":"SQRT(C86)","v":24.5},"    70 ±  ",{"$f":"\"\"&C87","v":"24,5"}," s =  Ö s2"]
[]
[null,"En vous basant sur l'écart-type, laquelle des trois distributions semble plus dispersée: A, B ou C? Interprétez statistiquement l'écart-type de cette distribution."]

{"sheet":"CV","index":4,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,3,8],[13,4,14,8],[35,1,35,8],[37,1,38,8],[5,4,5,5],[16,1,16,8],[18,1,18,8]]}
[]
[null,"Démonstration: Calcul du coefficient de variation"]
[]
[null,"Quelle est la variation du nombre d'heures passées sur Internet par jour ? (n=9)"]
[]
[null,"Cas (i)","Scores-Xi",null,"CV = (s / X) * 100"]
[null,1,2]
[null,2,4,null,"Moyenne",{"$f":"AVERAGE(C7:C15)","v":10}]
[null,3,6]
[null,4,8,null,"Ecart-type",{"$f":"STDEV(C7:C15)","v":5.48}]
[null,5,10]
[null,6,12,null,"CV",{"$f":"(F10/F8)*100","v":54.8}]
[null,7,14]
[null,8,16,null,"Interprétation statistique: Le CV (54,8%) étant de loin supérieur à 15%, la distribution est donc très hétérogène."]
[null,9,18]
[]
[null,"Exercice: Calculer le coefficient de variation"]
[]
[null,"Quelle est la variation de la performance (notes en %) chez les étudiants ? (n=7 par groupe)"]
[]
[null,"Groupe A","Xi",null,"Groupe B","Xi",null,"Groupe C","Xi"]
[null,1,64,null,1,44,null,1,34]
[null,2,66,null,2,56,null,2,46]
[null,3,68,null,3,63,null,3,58]
[null,4,69,null,4,74,null,4,79]
[null,5,70,null,5,80,null,5,82]
[null,6,71,null,6,82,null,6,90]
[null,7,82,null,7,91,null,7,101]
[]
[null,"Moyenne",null,null,"Moyenne",{"$f":"AVERAGE(F22:F28)","v":70},null,"Moyenne",{"$f":"AVERAGE(I22:I28)","v":70}]
[]
[null,"Ecart-type",null,null,"Ecart-type",{"$f":"STDEV(F22:F28)","v":16.399999999999999},null,"Ecart-type",{"$f":"STDEV(I22:I28)","v":24.5}]
[]
[null,"CV",null,null,"CV",{"$f":"F32/F30","v":0.23},null,"CV",{"$f":"I32/I30","v":0.35}]
[]
[null,"En vous basant sur le coefficient de variation, laquelle des trois distributions semble plus dispersée: A, B ou C? Interprétez statistiquement le CV de cette distribution."]

{"sheet":"Formules","index":5,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,3,8]]}
[]
[null,"Utilisation des formules statistiques intégrées- Démonstration & exercice"]
[]
[null,"Quelle est la tendance centrale et la variation de la performance (notes sur 20) chez les étudiants de trois groupes ? (n=8)"]
[]
[null,"Groupe 1","Scores Xi",null,"Groupe 2","Scores Xi ",null,"Groupe 3","Scores Xi"]
[null,1,10,null,1,8,null,1,12]
[null,2,12,null,2,20,null,2,11]
[null,3,10,null,3,15,null,3,11]
[null,4,11,null,4,12,null,4,9]
[null,5,17,null,5,12,null,5,13]
[null,6,13,null,6,11,null,6,8]
[null,7,14,null,7,13,null,7,13]
[null,8,9,null,8,10,null,8,10]
[]
[null,"Démonstration: Calcul de statistiques descriptives ",null,null,"Exercice: Calculer les statistiques descriptives ci-dessous!"]
[]
[null,"Mode",{"$f":"MODE(C7:C14)","v":10},null,"Mode",null,null,"Mode"]
[null,"Médiane",{"$f":"MEDIAN(C7:C14)","v":11.5},null,"Médiane",null,null,"Médiane"]
[null,"Moyenne",{"$f":"AVERAGE(C7:C14)","v":12},null,"Moyenne",null,null,"Moyenne"]
[null,"Minimum",{"$f":"MIN(C7:C14)","v":9},null,"Minimum",null,null,"Minimum"]
[null,"Maximum",{"$f":"MAX(C7:C14)","v":17},null,"Maximum",null,null,"Maximum"]
[null,"Étendue",{"$f":"C22-C21","v":8},null,"Étendue",null,null,"Étendue"]
[null,"Quartile 1",{"$f":"QUARTILE(C7:C14,1)","v":10},null,"Quartile 1",null,null,"Quartile 1"]
[null,"Quartile 3",{"$f":"QUARTILE(C7:C14,3)","v":13.25},null,"Quartile 3",null,null,"Quartile 3"]
[null,"Écart interquartile",{"$f":"C25-C24","v":3.25},null,"Écart interquartile",null,null,"Écart interquartile"]
[null,"Écart-type",{"$f":"STDEV(C7:C14)","v":2.62},null,"Écart-type",null,null,"Écart-type"]
[null,"Coef. de variation",{"$f":"C27/C20*100","v":21.83},null,"Coef. de variation",null,null,"Coef. de variation"]

{"sheet":"ScoresZ","index":6,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,1,1,11],[23,1,23,11],[3,1,3,11],[27,1,27,11],[5,1,5,10],[25,1,25,11]]}
[]
[null,"Démonstration: calcul des scores zi"]
[]
[null,"Comment se situent les étudiants par rapport à la moyenne de leur groupe d'appartenance? (N=10)"]
[]
[null,"Notes finales des 10 premiers étudiants en ordre alphabétique du SOL1020-H13 (en %: scores-X)"]
[]
[null,"m =",77.8]
[null,"s =",11.6]
[]
[null,null,"Ind (i)",null,"Scores Xi",null,"zi=(Xi-m)/s",null,"Formule",null,"Calcul"]
[null,null,1,null,72,null,{"$f":"(E12-$C$8)/$C$9","v":-0.5},null,"z1=(x1-m)/s",null,{"$f":"\"= (\"&E12&\" - \"&$C$8&\") / \"&$C$9&\" = \"&G12","v":"= (72 - 77,8) / 11,6 = -0,5"}]
[null,null,2,null,66,null,{"$f":"(E13-$C$8)/$C$9","v":-1},null,"z2=(x2-m)/s",null,{"$f":"\"= (\"&E13&\" - \"&$C$8&\") / \"&$C$9&\" = \"&G13","v":"= (66 - 77,8) / 11,6 = -1"}]
[null,null,3,null,66,null,-1,null,"z3=(x3-m)/s",null,"= (66 - 77,8) / 11,6 = -1"]
[null,null,4,null,92,null,1.2,null,"z4=(x4-m)/s",null,"= (92 - 77,8) / 11,6 = 1,2"]
[null,null,5,null,66,null,-1,null,"z5=(x5-m)/s",null,"= (66 - 77,8) / 11,6 = -1"]
[null,null,6,null,79,null,0.1,null,"z6=(x6-m)/s",null,"= (79 - 77,8) / 11,6 = 0,1"]
[null,null,7,null,69,null,-0.8,null,"z7=(x7-m)/s",null,"= (69 - 77,8) / 11,6 = -0,8"]
[null,null,8,null,95,null,1.5,null,"z8=(x8-m)/s",null,"= (95 - 77,8) / 11,6 = 1,5"]
[null,null,9,null,91,null,1.1000000000000001,null,"z9=(x9-m)/s",null,"= (91 - 77,8) / 11,6 = 1,1"]
[null,null,10,null,82,null,0.4,null,"z10=(x10-m)/s",null,"= (82 - 77,8) / 11,6 = 0,4"]
[]
[]
[null,"Exercice: calculer les scores zi"]
[]
[null,"Comment se situent les étudiants par rapport à la moyenne de leur groupe d'appartenance? (N=10)"]
[]
[null,"Notes finales des 10 premiers étudiants en ordre alphabétique du SOL1020-A12 (en %: scores-X)"]
[]
[null,"m =",79.400000000000006]
[null,"s =",10.6]
[]
[]
[null,null,"Ind (i)",null,"Scores Xi",null,"zi=(Xi-m)/s",null,"Formule",null,"Calcul"]
[null,null,1,null,89,null,null,null,"z1=(x1-m)/s",null,{"$f":"\"= (\"&E35&\" - \"&$C$30&\") / \"&$C$31&\" = \"&G35","v":"= (89 - 79,4) / 10,6 = "}]
[null,null,2,null,76,null,null,null,"z2=(x2-m)/s",null,{"$f":"\"= (\"&E36&\" - \"&$C$30&\") / \"&$C$31&\" = \"&G36","v":"= (76 - 79,4) / 10,6 = "}]
[null,null,3,null,75,null,null,null,"z3=(x3-m)/s",null,"= (75 - 79,4) / 10,6 = "]
[null,null,4,null,86,null,null,null,"z4=(x4-m)/s",null,"= (86 - 79,4) / 10,6 = "]
[null,null,5,null,72,null,null,null,"z5=(x5-m)/s",null,"= (72 - 79,4) / 10,6 = "]
[null,null,6,null,71,null,null,null,"z6=(x6-m)/s",null,"= (71 - 79,4) / 10,6 = "]
[null,null,7,null,100,null,null,null,"z7=(x7-m)/s",null,"= (100 - 79,4) / 10,6 = "]
[null,null,8,null,84,null,null,null,"z8=(x8-m)/s",null,"= (84 - 79,4) / 10,6 = "]
[null,null,9,null,78,null,null,null,"z9=(x9-m)/s",null,"= (78 - 79,4) / 10,6 = "]
[null,null,10,null,63,null,null,null,"z10=(x10-m)/s",null,"= (63 - 79,4) / 10,6 = "]
[]
[null,null,null,null,"m"]
[]
[null,null,null,null,"s"]

{"sheet":"CN-Ord","index":7,"n_rows":69,"n_cols":12,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,1,1,12],[3,1,5,12],[9,5,33,12],[36,7,36,8],[36,11,36,12],[42,7,42,8],[42,11,42,12],[37,7,37,8],[37,11,37,12],[35,7,35,8],[35,11,35,12],[41,7,41,8],[41,11,41,12],[38,7,38,8],[38,11,38,12],[39,7,39,8],[39,11,39,12],[40,7,40,8],[40,11,40,12]]}
[]
[null,"La courbe normale standardisée (ordonnées ou fréquences f)"]
[]
[null,"Connaisant le score-z, il est possible de déterminer son ordonnée ou fréquence f en se basant sur la table de la loi normale et ainsi on peut tracer la courbe normale à l'aide d'Excel."]
[]
[]
[]
[null,"z","f","P ≤ 0",null,null,null,null,"m","s"]
[null,"-3",{"$f":"NORMDIST(B9,0,1,FALSE)","v":4.4000000000000003E-3},{"$f":"IF(B9<=$I$9,C9,\"\")","v":""},null,null,null,null,0,1]
[null,"-2,9",{"$f":"NORMDIST(B10,0,1,FALSE)","v":6.0000000000000001E-3},{"$f":"IF(B10<=$I$9,C10,\"\")","v":""}]
[null,"-2,8",7.9000000000000008E-3,""]
[null,"-2,7",1.04E-2,""]
[null,"-2,6",1.3599999999999999E-2,""]
[null,"-2,5",1.7500000000000002E-2,""]
[null,"-2,4",2.24E-2,""]
[null,"-2,3",2.8299999999999999E-2,""]
[null,"-2,2",3.5499999999999997E-2,""]
[null,"-2,1",4.3999999999999997E-2,""]
[null,"-2",5.3999999999999999E-2,""]
[null,"-1,9",6.5600000000000006E-2,""]
[null,"-1,8",7.9000000000000001E-2,""]
[null,"-1,7",9.4E-2,""]
[null,"-1,6",0.1109,""]
[null,"-1,5",0.1295,""]
[null,"-1,4",0.1497,""]
[null,"-1,3",0.1714,""]
[null,"-1,2",0.19420000000000001,""]
[null,"-1,1",0.21790000000000001,""]
[null,"-1",0.24199999999999999,""]
[null,"-0,9",0.2661,""]
[null,"-0,8",0.28970000000000001,""]
[null,"-0,7",0.31230000000000002,""]
[null,"-0,6",0.3332,""]
[null,"-0,5",0.35210000000000002,""]
[null,"-0,4",0.36830000000000002,""]
[null,"-0,3",0.38140000000000002,"",null,null,"z","f ou ordonnées",null,null,"z","f ou ordonnées"]
[null,"-0,2",0.39100000000000001,"",null,null,-3,null,null,null,3]
[null,"-0,1",0.39700000000000002,"",null,null,-2.5,null,null,null,2.5]
[null,"0",0.39889999999999998,"",null,null,-2,null,null,null,2]
[null,"0,1",0.39700000000000002,"",null,null,-1.5,null,null,null,1.5]
[null,"0,2",0.39100000000000001,"",null,null,-1,null,null,null,1]
[null,"0,3",0.38140000000000002,"",null,null,-0.5,null,null,null,0.5]
[null,"0,4",0.36830000000000002,"",null,null,0,null,null,null,0]
[null,"0,5",0.35210000000000002,""]
[null,"0,6",0.3332,""]
[null,"0,7",0.31230000000000002,""]
[null,"0,8",0.28970000000000001,""]
[null,"0,9",0.2661,""]
[null,"1",0.24199999999999999,""]
[null,"1,1",0.21790000000000001,""]
[null,"1,2",0.19420000000000001,""]
[null,"1,3",0.1714,""]
[null,"1,4",0.1497,""]
[null,"1,5",0.1295,""]
[null,"1,6",0.1109,""]
[null,"1,7",9.4E-2,""]
[null,"1,8",7.9000000000000001E-2,{"$f":"IF(B57<=$I$9,C57,\"\")","v":""}]
[null,"1,9",6.5600000000000006E-2,""]
[null,"2",5.3999999999999999E-2,""]
[null,"2,1",4.3999999999999997E-2,""]
[null,"2,2",3.5499999999999997E-2,""]
[null,"2,3",2.8299999999999999E-2,""]
[null,"2,4",2.24E-2,""]
[null,"2,5",1.7500000000000002E-2,""]
[null,"2,6",1.3599999999999999E-2,""]
[null,"2,7",1.04E-2,""]
[null,"2,8",7.9000000000000008E-3,""]
[null,"2,90000000000001",6.0000000000000001E-3,""]
[null,"3",4.4000000000000003E-3,""]

{"sheet":"CN-Prop","index":8,"n_rows":72,"n_cols":14,"rows_kept":72,"cut":false,"hidden":false,"merged":[[43,8,43,9],[43,12,43,13],[46,7,48,14],[3,2,3,12],[42,8,42,9],[42,12,42,13],[38,10,38,11],[1,2,1,12],[40,8,40,9],[40,12,40,13],[41,8,41,9],[41,12,41,13],[38,12,38,13],[39,12,39,13]]}
[]
[null,null,"La courbe normale standardisée (scores bruts et scores z): Propriétés"]
[]
[null,null,"Connaissant m et s, on peut décrire complètement la distribution des scores bruts (X) et standardisés (z) et les représenter à l'aide de la courbe normale afin de déterminer une proportion donnée.\n"]
[]
[null,null,"m","s",null,null,"- 3 s","- 2 s","- 1 s","m","1 s","2 s","3 s"]
[null,null,100,10,null,null,{"$f":"H7-10","v":70},80,{"$f":"J7-10","v":90},100,{"$f":"J7+10","v":110},{"$f":"K7+10","v":120},130]
[null,null,70,5]
[]
[null,null,null,null,null,null,null,null,"m","s"]
[null,"z","X","f","P < X","X1 < P < X2",null,null,100,10]
[null,-3,{"$f":"$I$11+($J$11*B12)","v":70},{"$f":"NORMDIST(B12,0,1,FALSE)","v":4.4000000000000003E-3},{"$f":"IF(C12<=$I$40,D12,\"\")","v":""},{"$f":"IF(AND(C12>=$K$40,C12<=$L$40),D12,\"\")","v":""}]
[null,-2.9,{"$f":"$I$11+($J$11*B13)","v":71},{"$f":"NORMDIST(B13,0,1,FALSE)","v":6.0000000000000001E-3},{"$f":"IF(C13<=$I$40,D13,\"\")","v":""},{"$f":"IF(AND(C13>=$K$40,C13<=$L$40),D13,\"\")","v":""}]
[null,-2.8,72,7.9000000000000008E-3,"",""]
[null,-2.7,73,1.04E-2,"",""]
[null,-2.6,74,1.3599999999999999E-2,"",""]
[null,-2.5,75,1.7500000000000002E-2,"",""]
[null,-2.4,76,2.24E-2,"",""]
[null,-2.2999999999999998,77,2.8299999999999999E-2,"",""]
[null,-2.2000000000000002,78,3.5499999999999997E-2,"",""]
[null,-2.1,79,4.3999999999999997E-2,"",""]
[null,-2,80,5.3999999999999999E-2,"",""]
[null,-1.9,81,6.5600000000000006E-2,"",""]
[null,-1.8,82,7.9000000000000001E-2,"",""]
[null,-1.7,83,9.4E-2,"",""]
[null,-1.6,84,0.1109,"",""]
[null,-1.5,85,0.1295,"",""]
[null,-1.4,86,0.1497,"",""]
[null,-1.3,87,0.1714,"",""]
[null,-1.2,88,0.19420000000000001,"",""]
[null,-1.1000000000000001,89,0.21790000000000001,"",""]
[null,-1,90,0.24199999999999999,"",""]
[null,-0.9,91,0.2661,"",""]
[null,-0.8,{"$f":"$I$11+($J$11*B34)","v":92},0.28970000000000001,"",{"$f":"IF(AND(C34>=$K$40,C34<=$L$40),D34,\"\")","v":""}]
[null,-0.7,93,0.31230000000000002,"","",null,null,null,null,null,null,null,"Scores X"]
[null,-0.6,94,0.3332,"",""]
[null,-0.5,95,0.35210000000000002,"","","       -3","         -2","           -1                           0","             0","            1","                 2","                    3","Scores Z"]
[null,-0.4,96,0.36830000000000002,"",""]
[null,-0.3,97,0.38140000000000002,"","",null,null,"P < X",null,"X1 < P < X2"]
[null,-0.2,98,0.39100000000000001,"",""]
[null,-0.1,99,0.39700000000000002,"",""]
[null,0,100,{"$f":"NORMDIST(B42,0,1,FALSE)","v":0.39889999999999998},"",""]
[null,0.1,101,0.39700000000000002,{"$f":"IF(C43<=$I$40,D43,\"\")","v":""},""]
[null,0.2,102,0.39100000000000001,"",""]
[null,0.3,103,0.38140000000000002,"",""]
[null,0.4,104,0.36830000000000002,"",""]
[null,0.5,105,0.35210000000000002,"",""]
[null,0.6,106,0.3332,"",""]
[null,0.7,107,0.31230000000000002,"",""]
[null,0.8,108,0.28970000000000001,"",""]
[null,0.9,109,0.2661,"",""]
[null,1,110,0.24199999999999999,"",{"$f":"IF(AND(C52>=$K$40,C52<=$L$40),D52,\"\")","v":""}]
[null,1.1000000000000001,111,0.21790000000000001,"",""]
[null,1.2,112,0.19420000000000001,{"$f":"IF(C54<=$I$40,D54,\"\")","v":""},""]
[null,1.3,113,0.1714,"",""]
[null,1.4,114,0.1497,"",""]
[null,1.5,115,0.1295,"",""]
[null,1.6,116,0.1109,"",""]
[null,1.7,117,{"$f":"NORMDIST(B59,0,1,FALSE)","v":9.4E-2},"",""]
[null,1.8,118,7.9000000000000001E-2,"",""]
[null,1.9,119,6.5600000000000006E-2,"",""]
[null,2,120,5.3999999999999999E-2,"",""]
[null,2.1,121,4.3999999999999997E-2,"",""]
[null,2.2000000000000002,122,3.5499999999999997E-2,"",""]
[null,2.2999999999999998,123,2.8299999999999999E-2,"",""]
[null,2.4,124,2.24E-2,"",""]
[null,2.5,125,1.7500000000000002E-2,"",""]
[null,2.6,126,1.3599999999999999E-2,"",""]
[null,2.7,127,1.04E-2,"",""]
[null,2.8,128,7.9000000000000008E-3,"",""]
[null,2.9000000000000101,129,6.0000000000000001E-3,""]
[null,3,130,4.4000000000000003E-3,""]

{"sheet":"CN-surf(1)","index":9,"n_rows":90,"n_cols":23,"rows_kept":90,"cut":false,"hidden":false,"merged":[[1,1,1,10],[8,1,9,10],[3,1,5,10],[6,0,6,16383],[7,0,7,16383]]}
[]
[null,"La courbe normale standardisée (surface sous la courbe)"]
[]
[null,"On peut trouver la proportion ou le pourcentage de données inférieur à un score-z en se basant sur la courbe normale centrée réduite\n"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Score Z",null,"P <  Z Below (gauche)",null,"P > Z Above (droite)",null,"Score Z",null,"P <  Z Below (gauche)",null,"P > Z Above (droite)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"NORMSDIST(M11)","v":0.5},null,{"$f":"1-O11","v":0.5},null,0.8,null,{"$f":"NORMSDIST(S11)","v":0.78800000000000003},null,{"$f":"1-U11","v":0.21199999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,0.01,null,{"$f":"NORMSDIST(M12)","v":0.504},null,{"$f":"1-O12","v":0.496},null,0.81,null,{"$f":"NORMSDIST(S12)","v":0.79100000000000004},null,0.20899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,0.02,null,{"$f":"NORMSDIST(M13)","v":0.50800000000000001},null,0.49199999999999999,null,0.82,null,0.79400000000000004,null,0.20599999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,0.03,null,0.51200000000000001,null,0.48799999999999999,null,0.83,null,0.79700000000000004,null,0.20300000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,0.04,null,0.51600000000000001,null,0.48399999999999999,null,0.84,null,0.8,null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.05,null,0.52,null,0.48,null,0.85,null,0.80200000000000005,null,0.19800000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,0.06,null,0.52400000000000002,null,0.47599999999999998,null,0.86,null,0.80500000000000005,null,0.19500000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,null,0.52800000000000002,null,0.47199999999999998,null,0.87,null,0.80800000000000005,null,0.192]
[null,null,null,null,null,null,null,null,null,null,null,null,0.08,null,0.53200000000000003,null,0.46800000000000003,null,0.88,null,0.81100000000000005,null,0.189]
[null,null,null,null,null,null,null,null,null,null,null,null,0.09,null,0.53600000000000003,null,0.46400000000000002,null,0.89,null,0.81299999999999994,null,0.187]
[null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,0.54,null,0.46,null,0.9,null,0.81599999999999995,null,0.184]
[null,null,null,null,null,null,null,null,null,null,null,null,0.11,null,0.54400000000000004,null,0.45600000000000002,null,0.91,null,0.81899999999999995,null,0.18099999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,0.12,null,0.54800000000000004,null,0.45200000000000001,null,0.92,null,0.82099999999999995,null,0.17899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,0.13,null,0.55200000000000005,null,0.44800000000000001,null,0.93,null,0.82399999999999995,null,0.17599999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001,null,0.55600000000000005,null,0.44400000000000001,null,0.94,null,0.82599999999999996,null,0.17399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,0.15,null,0.56000000000000005,null,0.44,null,0.95,null,0.82899999999999996,null,0.17100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,0.16,null,0.56399999999999995,null,0.436,null,0.96,null,0.83099999999999996,null,0.16900000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,0.17,null,0.56699999999999995,null,0.433,null,0.97,null,0.83399999999999996,null,0.16600000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,0.18,null,0.57099999999999995,null,0.42899999999999999,null,0.98,null,0.83599999999999997,null,0.16400000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,0.19,null,0.57499999999999996,null,0.42499999999999999,null,0.99,null,0.83899999999999997,null,0.161]
[null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,0.57899999999999996,null,0.42099999999999999,null,1,null,0.84099999999999997,null,0.159]
[null,null,null,null,null,null,null,null,null,null,null,null,0.21,null,0.58299999999999996,null,0.41699999999999998,null,1.01,null,0.84399999999999997,null,0.156]
[null,null,null,null,null,null,null,null,null,null,null,null,0.22,null,0.58699999999999997,null,0.41299999999999998,null,1.02,null,0.84599999999999997,null,0.154]
[null,null,null,null,null,null,null,null,null,null,null,null,0.23,null,0.59099999999999997,null,0.40899999999999997,null,1.03,null,0.84799999999999998,null,0.152]
[null,null,null,null,null,null,null,null,null,null,null,null,0.24,null,0.59499999999999997,null,0.40500000000000003,null,1.04,null,0.85099999999999998,null,0.14899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,0.25,null,0.59899999999999998,null,0.40100000000000002,null,1.05,null,0.85299999999999998,null,0.14699999999999999]
["Valeur de z",null,null,null,null,null,null,null,null,null,"Proportion",null,0.26,null,0.60299999999999998,null,0.39700000000000002,null,1.06,null,0.85499999999999998,null,0.14499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,0.27,null,0.60599999999999998,null,0.39400000000000002,null,1.07,null,0.85799999999999998,null,0.14199999999999999]
["de - ¥ à + ¥",null,null,null,null,null,null,null,null,null,1,"P(-∞ < z <+∞)",0.28000000000000003,null,0.61,null,0.39,null,1.08,null,0.86,null,0.14000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,0.28999999999999998,null,0.61399999999999999,null,0.38600000000000001,null,1.0900000000000001,null,0.86199999999999999,null,0.13800000000000001]
["de - ¥ à + 3",null,null,null,null,null,null,null,null,0.99870000000000003,"P(z < 3)",null,0.3,null,0.61799999999999999,null,0.38200000000000001,null,1.1000000000000001,null,0.86399999999999999,null,0.13600000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,0.31,null,0.622,null,0.378,null,1.1100000000000001,null,0.86699999999999999,null,0.13300000000000001]
["de - ¥ à + 2",null,null,null,null,null,null,null,0.97719999999999996,"P(z < 2)",null,null,0.32,null,0.626,null,0.374,null,1.1200000000000001,null,0.86899999999999999,null,0.13100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,0.33,null,0.629,null,0.371,null,1.1299999999999999,null,0.871,null,0.129]
["de - ¥ à + 1",null,null,null,null,null,null,0.84130000000000005,"P(z < 1)",null,null,null,0.34,null,0.63300000000000001,null,0.36699999999999999,null,1.1399999999999999,null,0.873,null,0.127]
[null,null,null,null,null,null,null,null,null,null,null,null,0.35,null,0.63700000000000001,null,0.36299999999999999,null,1.1499999999999999,null,0.875,null,0.125]
["de - ¥ à + 0",null,null,null,null,null,0.5,"P(z < 0)",null,null,null,null,0.36,null,0.64100000000000001,null,0.35899999999999999,null,1.1599999999999999,null,0.877,null,0.123]
[null,null,null,null,null,null,null,null,null,null,null,null,0.37,null,0.64400000000000002,null,0.35599999999999998,null,1.17,null,0.879,null,0.121]
["de - ¥ à -1",null,null,null,null,0.15870000000000001,"P(z < -1)",null,null,null,null,null,0.38,null,0.64800000000000002,null,0.35199999999999998,null,1.18,null,0.88100000000000001,null,0.11899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,0.39,null,0.65200000000000002,null,0.34799999999999998,null,1.19,null,0.88300000000000001,null,0.11700000000000001]
["de - ¥ à -2",null,null,null,2.2800000000000001E-2,"P(z < -2)",null,null,null,null,null,null,0.4,null,{"$f":"NORMSDIST(M51)","v":0.65500000000000003},null,{"$f":"1-O51","v":0.34499999999999997},null,1.2,null,0.88500000000000001,null,0.115]
[null,null,null,null,null,null,null,null,null,null,null,null,0.41,null,{"$f":"NORMSDIST(M52)","v":0.65900000000000003},null,{"$f":"1-O52","v":0.34100000000000003},null,1.21,null,0.88700000000000001,null,0.113]
["de - ¥ à -3",null,null,1.2999999999999999E-3,"P(z < -3)",null,null,null,null,null,null,null,0.42,null,0.66300000000000003,null,0.33700000000000002,null,1.22,null,0.88900000000000001,null,0.111]
[null,null,null,null,null,null,null,null,null,null,null,null,0.43,null,0.66600000000000004,null,0.33400000000000002,null,1.23,null,0.89100000000000001,null,0.109]
[null,null,null,null,null,null,null,null,null,null,null,null,0.44,null,0.67,null,0.33,null,1.24,null,0.89300000000000002,null,0.107]
[null,null,null,null,null,null,null,null,null,null,null,null,0.45,null,0.67400000000000004,null,0.32600000000000001,null,1.25,null,0.89400000000000002,null,0.106]
[null,null,null,null,null,null,null,null,null,null,null,null,0.46,null,0.67700000000000005,null,0.32300000000000001,null,1.26,null,0.89600000000000002,null,0.104]
[null,null,null,null,null,null,null,null,null,null,null,null,0.47,null,0.68100000000000005,null,0.31900000000000001,null,1.27,null,0.89800000000000002,null,0.10199999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,0.48,null,0.68400000000000005,null,0.316,null,1.28,null,0.9,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,0.49,null,0.68799999999999994,null,0.312,null,1.29,null,0.90100000000000002,null,9.9000000000000005E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,0.69099999999999995,null,0.309,null,1.3,null,0.90300000000000002,null,9.7000000000000003E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.50999999999999901,null,0.69499999999999995,null,0.30499999999999999,null,1.31,null,0.90500000000000003,null,9.5000000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.51999999999999902,null,0.69799999999999995,null,0.30199999999999999,null,1.32,null,0.90700000000000003,null,9.2999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.52999999999999903,null,0.70199999999999996,null,0.29799999999999999,null,1.33,null,0.90800000000000003,null,9.1999999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.53999999999999904,null,0.70499999999999996,null,0.29499999999999998,null,1.34,null,0.91,null,0.09]
[null,null,null,null,null,null,null,null,null,null,null,null,0.54999999999999905,null,0.70899999999999996,null,0.29099999999999998,null,1.35,null,0.91100000000000003,null,8.8999999999999996E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.55999999999999905,null,0.71199999999999997,null,0.28799999999999998,null,1.36,null,0.91300000000000003,null,8.6999999999999994E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.56999999999999895,null,0.71599999999999997,null,0.28399999999999997,null,1.37,null,0.91500000000000004,null,8.5000000000000006E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.57999999999999896,null,0.71899999999999997,null,0.28100000000000003,null,1.38,null,0.91600000000000004,null,8.4000000000000005E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.58999999999999897,null,0.72199999999999998,null,0.27800000000000002,null,1.39,null,0.91800000000000004,null,8.2000000000000003E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.59999999999999898,null,0.72599999999999998,null,0.27400000000000002,null,1.4,null,0.91900000000000004,null,8.1000000000000003E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.60999999999999899,null,0.72899999999999998,null,0.27100000000000002,null,1.41,null,0.92100000000000004,null,7.9000000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.619999999999999,null,0.73199999999999998,null,0.26800000000000002,null,1.42,null,0.92200000000000004,null,7.8E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.62999999999999901,null,0.73599999999999999,null,0.26400000000000001,null,1.43,null,0.92400000000000004,null,7.5999999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.63999999999999901,null,0.73899999999999999,null,0.26100000000000001,null,1.44,null,0.92500000000000004,null,{"$f":"1-U75","v":7.4999999999999997E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,0.64999999999999902,null,0.74199999999999999,null,0.25800000000000001,null,1.45,null,{"$f":"NORMSDIST(S76)","v":0.92600000000000005},null,7.3999999999999996E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.65999999999999903,null,0.745,null,0.255,null,1.46,null,0.92800000000000005,null,7.1999999999999995E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.66999999999999904,null,0.749,null,0.251,null,1.47,null,0.92900000000000005,null,7.0999999999999994E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.67999999999999905,null,0.752,null,0.248,null,1.48,null,0.93100000000000005,null,6.9000000000000006E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.68999999999999895,null,0.755,null,0.245,null,1.49,null,0.93200000000000005,null,6.8000000000000005E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.69999999999999896,null,0.75800000000000001,null,0.24199999999999999,null,1.5,null,0.93300000000000005,null,6.7000000000000004E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.70999999999999897,null,0.76100000000000001,null,0.23899999999999999,null,1.51,null,0.93400000000000005,null,6.6000000000000003E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.71999999999999897,null,0.76400000000000001,null,0.23599999999999999,null,1.52,null,0.93600000000000005,null,6.4000000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.72999999999999798,null,0.76700000000000002,null,0.23300000000000001,null,1.53,null,0.93700000000000006,null,6.3E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.73999999999999799,null,0.77,null,0.23,null,1.54,null,0.93799999999999994,null,6.2E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.749999999999998,null,0.77300000000000002,null,0.22700000000000001,null,1.55,null,0.93899999999999995,null,6.0999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.75999999999999801,null,0.77600000000000002,null,0.224,null,1.56,null,0.94099999999999995,null,5.8999999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.76999999999999802,null,0.77900000000000003,null,0.221,null,1.57,null,0.94199999999999995,null,5.8000000000000003E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.77999999999999803,null,0.78200000000000003,null,0.218,null,1.58,null,0.94299999999999995,null,5.7000000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.78999999999999804,null,0.78500000000000003,null,0.215,null,1.59,null,0.94399999999999995,null,5.6000000000000001E-2]

{"sheet":"CN-surf(2)","index":10,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,1,1,10],[6,1,31,10],[3,1,3,10]]}
[]
[null,"La courbe normale standardisée (surface sous la courbe)"]
[]
[null,"On peut trouver la proportion ou le pourcentage de données compris entre deux écarts-types ou scores-z en se basant sur la courbe normale centrée réduite\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Valeur de z",null,null,null,null,null,null,null,null,null,"Proportion"]
[]
["de 0 à + ¥",null,null,null,null,null,null,null,null,null,0.5,"P(z > 0)"]
[]
["de 0 à + 3",null,null,null,null,null,null,null,null,0.49864999999999998,"P(0 < z < 3)"]
[]
["de 0 à + 2",null,null,null,null,null,null,null,0.47720000000000001,"P(0< z <2)"]
[]
["de 0 à + 1",null,null,null,null,null,null,0.34129999999999999,"P(0 < z < 1)"]
[]
["de 0 à -1",null,null,null,null,null,0.34129999999999999,"P(-1 < z <0)"]
[]
["de 0 à -2",null,null,null,null,null,0.47720000000000001,"P(-2 < z < 0)"]
[]
["de 0 à -3",null,null,null,null,null,0.49869999999999998,"P(-3 < z < 0)"]
[]
["de 0 à - ¥",null,null,null,null,null,0.5,"P(z < 0)"]

{"sheet":"CN-surf(3)","index":11,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,1,1,10],[8,1,33,10],[3,1,5,10]]}
[]
[null,"La courbe normale standardisée (surface sous la courbe)"]
[]
[null,"On peut trouver la proportion ou le pourcentage de données compris entre deux écarts-types ou scores-z en se basant sur la courbe normale\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Valeur de z",null,null,null,null,null,null,null,null,null,"Proportion"]
[]
["de - ¥ à + ¥",null,null,null,null,null,null,null,null,null,1,"P(-∞ < z <+∞)"]
[]
["de -3 à + 3",null,null,null,null,null,null,null,null,0.996,"P(-3 < z < -3)"]
[]
["de -2 à + 2",null,null,null,null,null,null,null,0.95440000000000003,"P(-2 < z < 2)"]
[]
["de -1 à + 1",null,null,null,null,null,null,0.68259999999999998,"P(-1 < z < 1)"]
[]
["de 0 à 0"]

{"sheet":"CN-Prob","index":12,"n_rows":76,"n_cols":16,"rows_kept":76,"cut":false,"hidden":false,"merged":[[1,14,1,23],[3,14,4,23],[8,14,8,23],[13,14,13,23],[70,6,70,8],[58,6,58,12],[62,6,62,12],[68,5,68,12],[69,6,69,7],[69,10,69,11],[46,6,46,12],[15,14,15,20],[17,14,17,15],[24,14,24,23],[26,14,26,20],[28,14,28,15],[35,14,35,23],[38,14,38,15],[44,14,44,23],[37,14,37,17],[50,6,50,12],[56,5,56,12],[57,6,57,7],[57,10,57,11],[1,1,1,12],[3,1,4,10],[8,1,8,12],[43,10,43,11],[45,6,45,7],[45,10,45,11],[55,6,55,7],[55,10,55,11],[38,10,38,11],[13,11,13,12],[42,5,42,12],[44,5,44,12]]}
[]
[null,"Courbe normale standardisée et problème pratique",null,null,null,null,null,null,null,null,null,null,null,null,"Courbe normale standardisée et problème pratique (exercice)"]
[]
[null,"Les résultats à un test d'intelligence, dans une université, donne les résultats suivants en termes de moyenne et d'écart-type :                                                   ",null,null,null,null,null,null,null,null,null,null,null,null,"Les résultats à un examen de statistiques sociales, dans une classe, donne les résultats suivants en termes de moyenne et d'écart-type (sur 20):                                                   "]
[]
[null,"m =",100,null,null,null,null,null,null,null,null,null,null,null,"m =",10]
[null,"s =",20,null,null,null,null,null,null,null,null,null,null,null,"s =",4]
[]
[null,"En vous servant de la courbe normale et sachant que les résultats suivent une distribution normale, calculer le pourcentage de la population qui obtient un QI correspondant aux caractéristiques:",null,null,null,null,null,null,null,null,null,null,null,null,"En vous servant de la courbe normale et sachant que les résultats suivent une distribution normale, calculer le pourcentage d'étudiants qui obtient une note correspondant aux caractéristiques:"]
[null,null,"●Inférieur à 80",null,null,null,null,null,null,null,null,null,null,null,null,"●Inférieure à 14"]
[null,null,"●Inférieur à 130",null,null,null,null,null,null,null,null,null,null,null,null,"●Inférieure à 6"]
[null,null,"●Compris entre 80 et 130",null,null,null,null,null,null,null,null,null,null,null,null,"●Comprise entre 6 et 14"]
[]
[null,null,null,null,null,null,"m","s",null,"P <  X",null,"X1 < P < X2",null,null,"1. Calculez le pourcentage d'étudiants dont la note est inférieure à 14 (illustrez sur la courbe à gauche)"]
["z",null,"X","P < X","X1 < P < X2"]
[-3,{"$f":"$G$15+($H$15*A16)","v":0},{"$f":"NORMDIST(A16,0,1,FALSE)","v":4.4000000000000003E-3},{"$f":"IF(B16<=$J$15,C16,\"\")","v":4.4000000000000003E-3},{"$f":"IF(AND(B16>=$L$15,B16<=$M$15),C16,\"\")","v":4.4000000000000003E-3},null,null,null,null,null,null,null,null,null,"1.1. Calculez d'abord le score-Z correspondant au score X 14"]
[-2.9,{"$f":"$G$15+($H$15*A17)","v":0},{"$f":"NORMDIST(A17,0,1,FALSE)","v":6.0000000000000001E-3},{"$f":"IF(B17<=$J$15,C17,\"\")","v":6.0000000000000001E-3},{"$f":"IF(AND(B17>=$L$15,B17<=$M$15),C17,\"\")","v":6.0000000000000001E-3}]
[-2.8,0,7.9000000000000008E-3,7.9000000000000008E-3,7.9000000000000008E-3,null,null,null,null,null,null,null,null,null,"zi=(Xi-m)/s"]
[-2.7,0,1.04E-2,1.04E-2,1.04E-2]
[-2.6,0,1.3599999999999999E-2,1.3599999999999999E-2,1.3599999999999999E-2,null,null,null,null,null,null,null,null,null,"1.2. Sur la table, quelle est la proportion de cas inférieure au score-z calculé?"]
[-2.5,0,1.7500000000000002E-2,1.7500000000000002E-2,1.7500000000000002E-2]
[-2.4,0,2.24E-2,2.24E-2,2.24E-2]
[-2.2999999999999998,0,2.8299999999999999E-2,2.8299999999999999E-2,2.8299999999999999E-2]
[-2.2000000000000002,0,3.5499999999999997E-2,3.5499999999999997E-2,3.5499999999999997E-2]
[-2.1,0,4.3999999999999997E-2,4.3999999999999997E-2,4.3999999999999997E-2,null,null,null,null,null,null,null,null,null,"2. Calculez le pourcentage d'étudiants dont la note est inférieure à 6 (illustrez sur la courbe à gauche)"]
[-2,0,5.3999999999999999E-2,5.3999999999999999E-2,5.3999999999999999E-2]
[-1.9,0,6.5600000000000006E-2,6.5600000000000006E-2,6.5600000000000006E-2,null,null,null,null,null,null,null,null,null,"2.1. Calculez d'abord le score-Z correspondant au score X 6"]
[-1.8,0,7.9000000000000001E-2,7.9000000000000001E-2,7.9000000000000001E-2]
[-1.7,0,9.4E-2,9.4E-2,9.4E-2,null,null,null,null,null,null,null,null,null,"zi=(Xi-m)/s"]
[-1.6,0,0.1109,0.1109,0.1109]
[-1.5,0,0.1295,0.1295,0.1295,null,null,null,null,null,null,null,null,null,"2.2. Sur la table, quelle est la proportion de cas inférieure au score-z calculé?"]
[-1.4,0,0.1497,0.1497,0.1497]
[-1.3,0,0.1714,0.1714,0.1714]
[-1.2,0,0.19420000000000001,0.19420000000000001,0.19420000000000001]
[-1.1000000000000001,0,0.21790000000000001,0.21790000000000001,0.21790000000000001]
[-1,0,0.24199999999999999,0.24199999999999999,0.24199999999999999,null,null,null,null,null,null,null,null,null,"3. Calculez le % d'étudiants dont la note est comprise entre 6 et 14 (illustrez sur la courbe à gauche)"]
[-0.9,0,0.2661,0.2661,0.2661]
[-0.8,0,0.28970000000000001,0.28970000000000001,0.28970000000000001,null,null,null,null,null,null,null,null,null,"P(6 < X < 14) =P(X < 6) - P(X < 14)"]
[-0.7,0,0.31230000000000002,0.31230000000000002,0.31230000000000002,null,null,null,null,null,"Scores X",null,null,"Scores X"]
[-0.6,0,0.3332,0.3332,0.3332]
[-0.5,0,0.35210000000000002,0.35210000000000002,0.35210000000000002,"          -3","        -2","         -1","           0","                          1",null,"   2","             3","Scores Z"]
[-0.4,0,0.36830000000000002,0.36830000000000002,0.36830000000000002]
[-0.3,0,0.38140000000000002,0.38140000000000002,0.38140000000000002,"1. Décrire les scores-X en inscrivant la moyenne et l'écart-type sur la courbe normale"]
[-0.2,0,0.39100000000000001,{"$f":"IF(B44<=$J$15,C44,\"\")","v":0.39100000000000001},0.39100000000000001,null,null,null,null,"  "]
[-0.1,0,0.39700000000000002,0.39700000000000002,0.39700000000000002,"2. Calculez le pourcentage d'étudiants dont le QI est inférieur à 80 (illustrez la surface)"]
[0,0,0.39889999999999998,0.39889999999999998,0.39889999999999998]
[0.1,0,0.39700000000000002,0.39700000000000002,0.39700000000000002,null,"2.1. Calculez d'abord le score-Z correspondant au score X 80"]
[0.2,{"$f":"$G$15+($H$15*A48)","v":0},0.39100000000000001,0.39100000000000001,0.39100000000000001]
[0.3,0,0.38140000000000002,0.38140000000000002,0.38140000000000002,null,"zi=(Xi-m)/s"]
[0.4,0,0.36830000000000002,0.36830000000000002,0.36830000000000002]
[0.5,0,{"$f":"NORMDIST(A51,0,1,FALSE)","v":0.35210000000000002},0.35210000000000002,0.35210000000000002,null,"2.2. Dans la table, quelle est la proportion de cas inférieure au score-z calculé?"]
[0.6,0,0.3332,0.3332,0.3332]
[0.7,0,0.31230000000000002,0.31230000000000002,0.31230000000000002]
[0.8,0,0.28970000000000001,0.28970000000000001,0.28970000000000001]
[0.9,0,0.2661,0.2661,0.2661,"Le pourcentage d'étudiants ayant un QI inférieur à 80 est donc de:"]
[1,0,0.24199999999999999,0.24199999999999999,0.24199999999999999]
[1.1000000000000001,0,0.21790000000000001,0.21790000000000001,0.21790000000000001,"3. Calculez le pourcentage d'étudiants dont le QI est inférieur à 130 (illustrez la surface)"]
[1.2,0,0.19420000000000001,0.19420000000000001,0.19420000000000001]
[1.3,0,0.1714,0.1714,0.1714,null,"2.1. Calculez d'abord le score-Z correspondant au score X 130"]
[1.4,0,{"$f":"NORMDIST(A60,0,1,FALSE)","v":0.1497},{"$f":"IF(B60<=$J$15,C60,\"\")","v":0.1497},0.1497]
[1.5,0,0.1295,0.1295,0.1295,null,"zi=(Xi-m)/s"]
[1.6,0,0.1109,0.1109,0.1109]
[1.7,0,9.4E-2,9.4E-2,9.4E-2,null,"2.2. Dans la table, quelle est la proportion de cas inférieure au score-z calculé?"]
[1.8,0,7.9000000000000001E-2,7.9000000000000001E-2,7.9000000000000001E-2]
[1.9,{"$f":"$G$15+($H$15*A65)","v":0},6.5600000000000006E-2,6.5600000000000006E-2,6.5600000000000006E-2]
[2,0,5.3999999999999999E-2,5.3999999999999999E-2,5.3999999999999999E-2]
[2.1,0,4.3999999999999997E-2,4.3999999999999997E-2,4.3999999999999997E-2,"Le pourcentage d'étudiants ayant un QI inférieur à 130 est donc de:"]
[2.2000000000000002,0,3.5499999999999997E-2,3.5499999999999997E-2,3.5499999999999997E-2]
[2.2999999999999998,0,2.8299999999999999E-2,2.8299999999999999E-2,2.8299999999999999E-2,"4. Calculez le pourcentage d'étudiants dont le QI est compris entre 80 et 130 (illustrez la surface)"]
[2.4,0,2.24E-2,2.24E-2,2.24E-2]
[2.5,0,1.7500000000000002E-2,1.7500000000000002E-2,1.7500000000000002E-2,null,"P(80 < X < 130) =P(X < 130) - P(X < 80)"]
[2.6,0,1.3599999999999999E-2,1.3599999999999999E-2,1.3599999999999999E-2]
[2.7,0,1.04E-2,1.04E-2,1.04E-2,"Le pourcentage d'étudiants ayant un QI compris entre 80 et 130 est donc de:"]
[2.8,0,7.9000000000000008E-3,7.9000000000000008E-3,7.9000000000000008E-3]
[2.9000000000000101,0,6.0000000000000001E-3,6.0000000000000001E-3,6.0000000000000001E-3]
[3,0,4.4000000000000003E-3,4.4000000000000003E-3,4.4000000000000003E-3]

{"sheet":"CN-Table","index":13,"n_rows":100,"n_cols":26,"rows_kept":100,"cut":false,"hidden":false,"merged":[[1,1,1,23]]}
[]
[null,"TaTable de la loi normale"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Z","=",1.1299999999999999]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P <  Z","=",{"$f":"NORMSDIST(T8)","v":0.87080000000000002}]
[]
[]
[]
[]
[null,"Score Z",null,"P <  Z Below (gauche)",null,"P > Z Above (droite)",null,"Score Z",null,"P <  Z Below (gauche)",null,"P > Z Above (droite)",null,"Score Z",null,"P <  Z Below (gauche)",null,"P > Z Above (droite)",null,"Score Z",null,"P <  Z Below (gauche)",null,"P > Z Above (droite)"]
[]
[null,0,null,{"$f":"NORMSDIST(B17)","v":0.5},null,{"$f":"1-D17","v":0.5},null,0.4,null,{"$f":"NORMSDIST(H17)","v":0.65539999999999998},null,{"$f":"1-J17","v":0.34460000000000002},null,0.8,null,{"$f":"NORMSDIST(N17)","v":0.78810000000000002},null,{"$f":"1-P17","v":0.21190000000000001},null,1.2,null,{"$f":"NORMSDIST(T17)","v":0.88490000000000002},null,{"$f":"1-V17","v":0.11509999999999999}]
[null,0.01,null,{"$f":"NORMSDIST(B18)","v":0.504},null,{"$f":"1-D18","v":0.496},null,0.41,null,{"$f":"NORMSDIST(H18)","v":0.65910000000000002},null,{"$f":"1-J18","v":0.34089999999999998},null,0.81,null,{"$f":"NORMSDIST(N18)","v":0.79100000000000004},null,0.20899999999999999,null,1.21,null,0.88690000000000002,null,0.11310000000000001]
[null,0.02,null,{"$f":"NORMSDIST(B19)","v":0.50800000000000001},null,0.49199999999999999,null,0.42,null,0.66279999999999994,null,0.3372,null,0.82,null,0.79390000000000005,null,0.20610000000000001,null,1.22,null,0.88880000000000003,null,0.11119999999999999]
[null,0.03,null,0.51200000000000001,null,0.48799999999999999,null,0.43,null,0.66639999999999999,null,0.33360000000000001,null,0.83,null,0.79669999999999996,null,0.20330000000000001,null,1.23,null,0.89070000000000005,null,0.10929999999999999]
[null,0.04,null,0.51600000000000001,null,0.48399999999999999,null,0.44,null,0.67,null,0.33,null,0.84,null,0.79949999999999999,null,0.20050000000000001,null,1.24,null,0.89249999999999996,null,0.1075,null,"!"]
[null,0.05,null,0.51990000000000003,null,0.48010000000000003,null,0.45,null,0.67359999999999998,null,0.32640000000000002,null,0.85,null,0.80230000000000001,null,0.19769999999999999,null,1.25,null,0.89439999999999997,null,0.1056]
[null,0.06,null,0.52390000000000003,null,0.47610000000000002,null,0.46,null,0.67720000000000002,null,0.32279999999999998,null,0.86,null,0.80510000000000004,null,0.19489999999999999,null,1.26,null,0.8962,null,0.1038]
[null,7.0000000000000007E-2,null,0.52790000000000004,null,0.47210000000000002,null,0.47,null,0.68079999999999996,null,0.31919999999999998,null,0.87,null,0.80779999999999996,null,0.19220000000000001,null,1.27,null,0.89800000000000002,null,0.10199999999999999]
[null,0.08,null,0.53190000000000004,null,0.46810000000000002,null,0.48,null,0.68440000000000001,null,0.31559999999999999,null,0.88,null,0.81059999999999999,null,0.18940000000000001,null,1.28,null,0.89970000000000006,null,0.1003]
[null,0.09,null,0.53590000000000004,null,0.46410000000000001,null,0.49,null,0.68789999999999996,null,0.31209999999999999,null,0.89,null,0.81330000000000002,null,0.1867,null,1.29,null,0.90149999999999997,null,9.8500000000000004E-2]
[null,0.1,null,0.53979999999999995,null,0.4602,null,0.5,null,0.6915,null,0.3085,null,0.9,null,0.81589999999999996,null,0.18410000000000001,null,1.3,null,0.9032,null,9.6799999999999997E-2]
[null,0.11,null,0.54379999999999995,null,0.45619999999999999,null,0.50999999999999901,null,0.69499999999999995,null,0.30499999999999999,null,0.91,null,0.81859999999999999,null,0.18140000000000001,null,1.31,null,0.90490000000000004,null,9.5100000000000004E-2]
[null,0.12,null,0.54779999999999995,null,0.45219999999999999,null,0.51999999999999902,null,0.69850000000000001,null,0.30149999999999999,null,0.92,null,0.82120000000000004,null,0.17879999999999999,null,1.32,null,0.90659999999999996,null,9.3399999999999997E-2]
[null,0.13,null,0.55169999999999997,null,0.44829999999999998,null,0.52999999999999903,null,0.70189999999999997,null,0.29809999999999998,null,0.93,null,0.82379999999999998,null,0.1762,null,1.33,null,0.90820000000000001,null,9.1800000000000007E-2]
[null,0.14000000000000001,null,0.55569999999999997,null,0.44429999999999997,null,0.53999999999999904,null,0.70540000000000003,null,0.29459999999999997,null,0.94,null,0.82640000000000002,null,0.1736,null,1.34,null,0.90990000000000004,null,9.01E-2]
[null,0.15,null,0.55959999999999999,null,0.44040000000000001,null,0.54999999999999905,null,0.70879999999999999,null,0.29120000000000001,null,0.95,null,0.82889999999999997,null,0.1711,null,1.35,null,0.91149999999999998,null,8.8499999999999995E-2]
[null,0.16,null,0.56359999999999999,null,0.43640000000000001,null,0.55999999999999905,null,0.71230000000000004,null,0.28770000000000001,null,0.96,null,0.83150000000000002,null,0.16850000000000001,null,1.36,null,0.91310000000000002,null,8.6900000000000005E-2]
[null,0.17,null,0.5675,null,0.4325,null,0.56999999999999895,null,0.7157,null,0.2843,null,0.97,null,0.83399999999999996,null,0.16600000000000001,null,1.37,null,0.91469999999999996,null,8.5300000000000001E-2]
[null,0.18,null,0.57140000000000002,null,0.42859999999999998,null,0.57999999999999896,null,0.71899999999999997,null,0.28100000000000003,null,0.98,null,0.83650000000000002,null,0.16350000000000001,null,1.38,null,0.91620000000000001,null,8.3799999999999999E-2]
[null,0.19,null,0.57530000000000003,null,0.42470000000000002,null,0.58999999999999897,null,0.72240000000000004,null,0.27760000000000001,null,0.99,null,0.83889999999999998,null,0.16109999999999999,null,1.39,null,0.91769999999999996,null,8.2299999999999998E-2]
[null,0.2,null,0.57930000000000004,null,0.42070000000000002,null,0.59999999999999898,null,0.72570000000000001,null,0.27429999999999999,null,1,null,0.84130000000000005,null,0.15870000000000001,null,1.4,null,0.91920000000000002,null,8.0799999999999997E-2]
[null,0.21,null,0.58320000000000005,null,0.4168,null,0.60999999999999899,null,0.72909999999999997,null,0.27089999999999997,null,1.01,null,0.84379999999999999,null,0.15620000000000001,null,1.41,null,0.92069999999999996,null,7.9299999999999995E-2]
[null,0.22,null,0.58709999999999996,null,0.41289999999999999,null,0.619999999999999,null,0.73240000000000005,null,0.2676,null,1.02,null,0.84609999999999996,null,0.15390000000000001,null,1.42,null,0.92220000000000002,null,7.7799999999999994E-2]
[null,0.23,null,0.59099999999999997,null,0.40899999999999997,null,0.62999999999999901,null,0.73570000000000002,null,0.26429999999999998,null,1.03,null,0.84850000000000003,null,0.1515,null,1.43,null,0.92359999999999998,null,7.6399999999999996E-2]
[null,0.24,null,0.5948,null,0.4052,null,0.63999999999999901,null,0.7389,null,0.2611,null,1.04,null,0.8508,null,0.1492,null,1.44,null,0.92510000000000003,null,7.4899999999999994E-2]
[null,0.25,null,0.59870000000000001,null,0.40129999999999999,null,0.64999999999999902,null,0.74219999999999997,null,0.25779999999999997,null,1.05,null,0.85309999999999997,null,0.1469,null,1.45,null,0.92649999999999999,null,7.3499999999999996E-2]
[null,0.26,null,0.60260000000000002,null,0.39739999999999998,null,0.65999999999999903,null,0.74539999999999995,null,0.25459999999999999,null,1.06,null,0.85540000000000005,null,0.14460000000000001,null,1.46,null,0.92789999999999995,null,7.2099999999999997E-2]
[null,0.27,null,0.60640000000000005,null,0.39360000000000001,null,0.66999999999999904,null,0.74860000000000004,null,0.25140000000000001,null,1.07,null,0.85770000000000002,null,0.14230000000000001,null,1.47,null,0.92920000000000003,null,7.0800000000000002E-2]
[null,0.28000000000000003,null,0.61029999999999995,null,0.38969999999999999,null,0.67999999999999905,null,0.75170000000000003,null,0.24829999999999999,null,1.08,null,0.8599,null,0.1401,null,1.48,null,0.93059999999999998,null,6.9400000000000003E-2]
[null,0.28999999999999998,null,0.61409999999999998,null,0.38590000000000002,null,0.68999999999999895,null,0.75490000000000002,null,0.24510000000000001,null,1.0900000000000001,null,0.86209999999999998,null,0.13789999999999999,null,1.49,null,0.93189999999999995,null,6.8099999999999994E-2]
[null,0.3,null,0.6179,null,0.3821,null,0.69999999999999896,null,0.75800000000000001,null,0.24199999999999999,null,1.1000000000000001,null,0.86429999999999996,null,0.13569999999999999,null,1.5,null,0.93320000000000003,null,6.6799999999999998E-2]
[null,0.31,null,0.62170000000000003,null,0.37830000000000003,null,0.70999999999999897,null,0.7611,null,0.2389,null,1.1100000000000001,null,0.86650000000000005,null,0.13350000000000001,null,1.51,null,0.9345,null,6.5500000000000003E-2]
[null,0.32,null,0.62549999999999994,null,0.3745,null,0.71999999999999897,null,0.76419999999999999,null,0.23580000000000001,null,1.1200000000000001,null,0.86860000000000004,null,0.13139999999999999,null,1.52,null,0.93569999999999998,null,6.4299999999999996E-2]
[null,0.33,null,0.62929999999999997,null,0.37069999999999997,null,0.72999999999999798,null,0.76729999999999998,null,0.23269999999999999,null,1.1299999999999999,null,0.87080000000000002,null,0.12920000000000001,null,1.53,null,0.93700000000000006,null,6.3E-2]
[null,0.34,null,0.6331,null,0.3669,null,0.73999999999999799,null,0.77039999999999997,null,0.2296,null,1.1399999999999999,null,0.87290000000000001,null,0.12709999999999999,null,1.54,null,0.93820000000000003,null,6.1800000000000001E-2]
[null,0.35,null,0.63680000000000003,null,0.36320000000000002,null,0.749999999999998,null,0.77339999999999998,null,0.2266,null,1.1499999999999999,null,0.87490000000000001,null,0.12509999999999999,null,1.55,null,0.93940000000000001,null,6.0600000000000001E-2]
[null,0.36,null,0.64059999999999995,null,0.3594,null,0.75999999999999801,null,0.77639999999999998,null,0.22359999999999999,null,1.1599999999999999,null,0.877,null,0.123,null,1.56,null,0.94059999999999999,null,5.9400000000000001E-2]
[null,0.37,null,0.64429999999999998,null,0.35570000000000002,null,0.76999999999999802,null,0.77939999999999998,null,0.22059999999999999,null,1.17,null,0.879,null,0.121,null,1.57,null,0.94179999999999997,null,5.8200000000000002E-2]
[null,0.38,null,0.64800000000000002,null,0.35199999999999998,null,0.77999999999999803,null,0.7823,null,0.2177,null,1.18,null,0.88100000000000001,null,0.11899999999999999,null,1.58,null,0.94289999999999996,null,5.7099999999999998E-2]
[null,0.39,null,0.65169999999999995,null,0.3483,null,0.78999999999999804,null,0.78520000000000001,null,0.21479999999999999,null,1.19,null,0.88300000000000001,null,0.11700000000000001,null,1.59,null,0.94410000000000005,null,5.5899999999999998E-2]
[]
[]
[null,"Score Z",null,"P <  Z Below (gauche)",null,"P > Z Above (droite)",null,"Score Z",null,"P <  Z Below (gauche)",null,"P > Z Above (droite)",null,"Score Z",null,"P <  Z Below (gauche)",null,"P > Z Above (droite)",null,"Score Z",null,"P <  Z Below (gauche)",null,"P > Z Above (droite)"]
[]
[null,1.6,null,{"$f":"NORMSDIST(B61)","v":0.94520000000000004},null,{"$f":"1-D61","v":5.4800000000000001E-2},null,2,null,{"$f":"NORMSDIST(H61)","v":0.97719999999999996},null,{"$f":"1-J61","v":2.2800000000000001E-2},null,2.4,null,{"$f":"NORMSDIST(N61)","v":0.99180000000000001},null,{"$f":"1-P61","v":8.2000000000000007E-3},null,2.8,null,{"$f":"NORMSDIST(T61)","v":0.99739999999999995},null,{"$f":"1-V61","v":2.5999999999999999E-3}]
[null,1.61,null,{"$f":"NORMSDIST(B62)","v":0.94630000000000003},null,{"$f":"1-D62","v":5.3699999999999998E-2},null,2.0099999999999998,null,{"$f":"NORMSDIST(H62)","v":0.9778},null,{"$f":"1-J62","v":2.2200000000000001E-2},null,2.41,null,{"$f":"NORMSDIST(N62)","v":0.99199999999999999},null,{"$f":"1-P62","v":8.0000000000000002E-3},null,2.81,null,{"$f":"NORMSDIST(T62)","v":0.99750000000000005},null,{"$f":"1-V62","v":2.5000000000000001E-3}]
[null,1.62,null,0.94740000000000002,null,5.2600000000000001E-2,null,2.02,null,0.97829999999999995,null,2.1700000000000001E-2,null,2.42,null,0.99219999999999997,null,7.7999999999999996E-3,null,2.82,null,0.99760000000000004,null,2.3999999999999998E-3]
[null,1.63,null,0.94840000000000002,null,5.16E-2,null,2.0299999999999998,null,0.9788,null,2.12E-2,null,2.4300000000000002,null,0.99250000000000005,null,7.4999999999999997E-3,null,2.83,null,0.99770000000000003,null,2.3E-3]
[null,1.64,null,0.94950000000000001,null,5.0500000000000003E-2,null,2.04,null,0.97929999999999995,null,2.07E-2,null,2.44,null,0.99270000000000003,null,7.3000000000000001E-3,null,2.84,null,0.99770000000000003,null,2.3E-3]
[null,1.65,null,0.95050000000000001,null,4.9500000000000002E-2,null,2.0499999999999998,null,0.9798,null,2.0199999999999999E-2,null,2.4500000000000002,null,0.9929,null,7.1000000000000004E-3,null,2.85,null,0.99780000000000002,null,2.2000000000000001E-3]
[null,1.66,null,0.95150000000000001,null,4.8500000000000001E-2,null,2.06,null,0.98029999999999995,null,1.9699999999999999E-2,null,2.46,null,0.99309999999999998,null,6.8999999999999999E-3,null,2.86,null,0.99790000000000001,null,2.0999999999999999E-3]
[null,1.67,null,0.95250000000000001,null,4.7500000000000001E-2,null,2.0699999999999998,null,0.98080000000000001,null,1.9199999999999998E-2,null,2.4700000000000002,null,0.99319999999999997,null,6.7999999999999996E-3,null,2.87,null,0.99790000000000001,null,2.0999999999999999E-3]
[null,1.68,null,0.95350000000000001,null,4.65E-2,null,2.08,null,0.98119999999999996,null,1.8800000000000001E-2,null,2.48,null,0.99339999999999995,null,6.6E-3,null,2.88,null,0.998,null,2E-3]
[null,1.69,null,0.95450000000000002,null,4.5499999999999999E-2,null,2.09,null,0.98170000000000002,null,1.83E-2,null,2.4900000000000002,null,0.99360000000000004,null,6.4000000000000003E-3,null,2.89,null,0.99809999999999999,null,1.9E-3]
[null,1.7,null,0.95540000000000003,null,4.4600000000000001E-2,null,2.1,null,0.98209999999999997,null,1.7899999999999999E-2,null,2.5,null,0.99380000000000002,null,6.1999999999999998E-3,null,2.9,null,0.99809999999999999,null,1.9E-3]
[null,1.71,null,0.95640000000000003,null,4.36E-2,null,2.11,null,0.98260000000000003,null,1.7399999999999999E-2,null,2.5099999999999998,null,0.99399999999999999,null,6.0000000000000001E-3,null,2.91,null,0.99819999999999998,null,1.8E-3]
[null,1.72,null,0.95730000000000004,null,4.2700000000000002E-2,null,2.12,null,0.98299999999999998,null,1.7000000000000001E-2,null,2.52,null,0.99409999999999998,null,5.8999999999999999E-3,null,2.92,null,0.99819999999999998,null,1.8E-3]
[null,1.73,null,0.95820000000000005,null,4.1799999999999997E-2,null,2.13,null,0.98340000000000005,null,1.66E-2,null,2.5299999999999998,null,0.99429999999999996,null,5.7000000000000002E-3,null,2.93,null,0.99829999999999997,null,1.6999999999999999E-3]
[null,1.74,null,0.95909999999999995,null,4.0899999999999999E-2,null,2.14,null,0.98380000000000001,null,1.6199999999999999E-2,null,2.54,null,0.99450000000000005,null,5.4999999999999997E-3,null,2.94,null,0.99839999999999995,null,1.6000000000000001E-3]
[null,1.75,null,0.95989999999999998,null,4.0099999999999997E-2,null,2.15,null,0.98419999999999996,null,1.5800000000000002E-2,null,2.5499999999999998,null,0.99460000000000004,null,5.4000000000000003E-3,null,2.95,null,0.99839999999999995,null,1.6000000000000001E-3]
[null,1.76,null,0.96079999999999999,null,3.9199999999999999E-2,null,2.16,null,0.98460000000000003,null,1.54E-2,null,2.56,null,0.99480000000000002,null,5.1999999999999998E-3,null,2.96,null,0.99850000000000005,null,1.5E-3]
[null,1.77,null,0.96160000000000001,null,3.8399999999999997E-2,null,2.17,null,0.98499999999999999,null,1.4999999999999999E-2,null,2.57,null,0.99490000000000001,null,5.1000000000000004E-3,null,2.97,null,0.99850000000000005,null,1.5E-3]
[null,1.78,null,0.96250000000000002,null,3.7499999999999999E-2,null,2.1800000000000002,null,0.98540000000000005,null,1.46E-2,null,2.58,null,0.99509999999999998,null,4.8999999999999998E-3,null,2.98,null,0.99860000000000004,null,1.4E-3]
[null,1.79,null,0.96330000000000005,null,3.6700000000000003E-2,null,2.19,null,0.98570000000000002,null,1.43E-2,null,2.59,null,0.99519999999999997,null,4.7999999999999996E-3,null,2.99,null,0.99860000000000004,null,1.4E-3]
[null,1.8,null,0.96409999999999996,null,3.5900000000000001E-2,null,2.2000000000000002,null,0.98609999999999998,null,1.3899999999999999E-2,null,2.6,null,0.99529999999999996,null,4.7000000000000002E-3,null,3,null,0.99870000000000003,null,1.2999999999999999E-3]
[null,1.81,null,0.96489999999999998,null,3.5099999999999999E-2,null,2.21,null,0.98640000000000005,null,1.3599999999999999E-2,null,2.61,null,0.99550000000000005,null,4.4999999999999997E-3,null,3.01,null,0.99870000000000003,null,1.2999999999999999E-3]
[null,1.82,null,0.96560000000000001,null,3.44E-2,null,2.21999999999999,null,0.98680000000000001,null,1.32E-2,null,2.62,null,0.99560000000000004,null,4.4000000000000003E-3,null,3.02,null,0.99870000000000003,null,1.2999999999999999E-3]
[null,1.83,null,0.96640000000000004,null,3.3599999999999998E-2,null,2.23,null,0.98709999999999998,null,1.29E-2,null,2.63,null,0.99570000000000003,null,4.3E-3,null,3.03,null,0.99880000000000002,null,1.1999999999999999E-3]
[null,1.84,null,0.96709999999999996,null,3.2899999999999999E-2,null,2.23999999999999,null,0.98750000000000004,null,1.2500000000000001E-2,null,2.6400000000000099,null,0.99590000000000001,null,4.1000000000000003E-3,null,3.0400000000000098,null,0.99880000000000002,null,1.1999999999999999E-3]
[null,1.85,null,0.96779999999999999,null,3.2199999999999999E-2,null,2.25,null,0.98780000000000001,null,1.2200000000000001E-2,null,2.6500000000000101,null,0.996,null,4.0000000000000001E-3,null,3.05000000000001,null,0.99890000000000001,null,1.1000000000000001E-3]
[null,1.86,null,0.96860000000000002,null,3.1399999999999997E-2,null,2.25999999999999,null,0.98809999999999998,null,1.1900000000000001E-2,null,2.6600000000000099,null,0.99609999999999999,null,3.8999999999999998E-3,null,3.0600000000000098,null,0.99890000000000001,null,1.1000000000000001E-3]
[null,1.87,null,0.96930000000000005,null,3.0700000000000002E-2,null,2.2699999999999898,null,0.98839999999999995,null,1.1599999999999999E-2,null,2.6700000000000101,null,0.99619999999999997,null,3.8E-3,null,3.0700000000000101,null,0.99890000000000001,null,1.1000000000000001E-3]
[null,1.88,null,0.96989999999999998,null,3.0099999999999998E-2,null,2.27999999999999,null,0.98870000000000002,null,1.1299999999999999E-2,null,2.6800000000000099,null,0.99629999999999996,null,3.7000000000000002E-3,null,3.0800000000000098,null,0.999,null,1E-3]
[null,1.89,null,0.97060000000000002,null,2.9399999999999999E-2,null,2.2899999999999898,null,0.98899999999999999,null,1.0999999999999999E-2,null,2.6900000000000102,null,0.99639999999999995,null,3.5999999999999999E-3,null,3.0900000000000101,null,0.999,null,1E-3]
[null,1.9,null,0.97130000000000005,null,2.87E-2,null,2.2999999999999901,null,0.98929999999999996,null,1.0699999999999999E-2,null,2.7000000000000099,null,0.99650000000000005,null,3.5000000000000001E-3,null,3.1000000000000099,null,0.999,null,1E-3]
[null,1.91,null,0.97189999999999999,null,2.81E-2,null,2.3099999999999898,null,0.98960000000000004,null,1.04E-2,null,2.7100000000000102,null,0.99660000000000004,null,3.3999999999999998E-3,null,3.1100000000000101,null,0.99909999999999999,null,8.9999999999999998E-4]
[null,1.92,null,0.97260000000000002,null,2.7400000000000001E-2,null,2.3199999999999901,null,0.98980000000000001,null,1.0200000000000001E-2,null,2.72000000000001,null,0.99670000000000003,null,3.3E-3,null,3.1200000000000099,null,0.99909999999999999,null,8.9999999999999998E-4]
[null,1.93,null,0.97319999999999995,null,2.6800000000000001E-2,null,2.3299999999999899,null,0.99009999999999998,null,9.9000000000000008E-3,null,2.7300000000000102,null,0.99680000000000002,null,3.2000000000000002E-3,null,3.1300000000000101,null,0.99909999999999999,null,8.9999999999999998E-4]
[null,1.94,null,0.9738,null,2.6200000000000001E-2,null,2.3399999999999901,null,0.99039999999999995,null,9.5999999999999992E-3,null,2.74000000000001,null,0.99690000000000001,null,3.0999999999999999E-3,null,3.1400000000000099,null,0.99919999999999998,null,8.0000000000000004E-4]
[null,1.95,null,0.97440000000000004,null,2.5600000000000001E-2,null,2.3499999999999899,null,0.99060000000000004,null,9.4000000000000004E-3,null,2.7500000000000102,null,0.997,null,3.0000000000000001E-3,null,3.1500000000000101,null,0.99919999999999998,null,8.0000000000000004E-4]
[null,1.96,null,0.97499999999999998,null,2.5000000000000001E-2,null,2.3599999999999901,null,{"$f":"NORMSDIST(H97)","v":0.9909},null,{"$f":"1-J97","v":9.1000000000000004E-3},null,2.76000000000001,null,{"$f":"NORMSDIST(N97)","v":0.99709999999999999},null,{"$f":"1-P97","v":2.8999999999999998E-3},null,3.1600000000000099,null,{"$f":"NORMSDIST(T97)","v":0.99919999999999998},null,{"$f":"1-V97","v":8.0000000000000004E-4}]
[null,1.97,null,0.97560000000000002,null,2.4400000000000002E-2,null,2.3699999999999899,null,{"$f":"NORMSDIST(H98)","v":0.99109999999999998},null,{"$f":"1-J98","v":8.8999999999999999E-3},null,2.7700000000000098,null,{"$f":"NORMSDIST(N98)","v":0.99719999999999998},null,{"$f":"1-P98","v":2.8E-3},null,3.1700000000000101,null,{"$f":"NORMSDIST(T98)","v":0.99919999999999998},null,{"$f":"1-V98","v":8.0000000000000004E-4}]
[null,1.98,null,0.97609999999999997,null,2.3900000000000001E-2,null,2.3799999999999901,null,{"$f":"NORMSDIST(H99)","v":0.99129999999999996},null,{"$f":"1-J99","v":8.6999999999999994E-3},null,2.78000000000001,null,{"$f":"NORMSDIST(N99)","v":0.99729999999999996},null,{"$f":"1-P99","v":2.7000000000000001E-3},null,3.1800000000000099,null,{"$f":"NORMSDIST(T99)","v":0.99929999999999997},null,{"$f":"1-V99","v":6.9999999999999999E-4}]
[null,1.99,null,0.97670000000000001,null,2.3300000000000001E-2,null,2.3899999999999899,null,{"$f":"NORMSDIST(H100)","v":0.99160000000000004},null,{"$f":"1-J100","v":8.3999999999999995E-3},null,2.7900000000000098,null,{"$f":"NORMSDIST(N100)","v":0.99739999999999995},null,{"$f":"1-P100","v":2.5999999999999999E-3},null,3.19,null,{"$f":"NORMSDIST(T100)","v":0.99929999999999997},null,{"$f":"1-V100","v":6.9999999999999999E-4}]