{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Début","Feuille 1","Feuille 2"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Début","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,0,6,6],[7,0,7,6],[8,0,8,6],[9,0,9,6],[10,0,10,6],[5,0,5,6],[4,0,4,5],[0,0,0,3],[1,1,1,2],[2,0,2,2],[2,3,2,6],[0,4,0,6],[1,4,1,6],[3,0,3,6]]}
["Nom  &  Prémon"]
["Groupe",null,null,"  Filière"]
[null,null,null," أكتب إسمك ، الشعبة و الفوج قبل أي شئ آخر.        تحقق منه."]
["                       Activez les macros"]
[null,null,null,null,null,null,"Si l'avertissement (voir à gauche) apparait, cliquer sur Options et                             activer le contenu"]
[]
["Des températures ont été mesurées pendant un mois (30 jours).         \nOn note   Xi la température en degrés Celsius  (°C)"]
["1) في الورقة رقم 1   إشرح دور الدوال لبرنامج إكسيل المذكورة بجانب جدول المعطيات أسفله  (وفق المثال NBVAL) "]
["2)  dans la feuille n° 1, Calculez à l'aide des fonctions disponibles (menu insertion/fonctions/statistiques) la valeur des statistiques listées  à droite du tableau des données. (à 10-2 près)"]
["3)  Complèter le tableau dans la feuille n° 2, qui permet le calcul des écarts à la moyenne et ses carrés."]
["     En déduire la variance et l'écart type de la série des températures.          \n"]

{"sheet":"Feuille 1","index":1,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,0,3,1],[0,0,0,3],[0,4,0,5],[1,1,1,2],[1,4,1,5],[2,0,2,5],[12,4,12,5],[13,4,13,5],[17,3,17,5],[4,0,4,1],[5,3,5,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5]]}
[{"$f":"Début!A1","v":"Nom  &  Prémon"},null,null,null,{"$f":"Début!E1","v":0},null,null,null,null,null,null,"MOYENNE(arguments)"]
[{"$f":"Début!A2","v":"Groupe"},{"$f":"Début!B2","v":0},null,{"$f":"Début!D2","v":"  Filière"},{"$f":"Début!E2","v":0},null,null,null,null,null,null,"MEDIANE(arguments)"]
[null,null,null,null,null,null,null,null,null,null,null,"QUARTILE(arguments)"]
["جدول المعطيات",null,null,null,null,null,null,null,null,null,null,"MAX(arguments)"]
["Tableau des données. ",null,null,null,null,null,null,null,null,null,null,"MOYENNE(arguments)"]
["i","Xi",null,"1) شرح دوال إكسيل.",null,null,null,null,null,null,null,"MEDIANE(arguments)"]
[1,null,null,"دالة إكسيل",null,"شرح نتيجة الدالة إكسيل و كذا المتغيرات داخل الأقواس",null,null,null,null,null,"QUARTILE(arguments)"]
[2,null,null,"formule Excel.",null,"Résultat de la fonction et explication des paramètres",null,null,null,null,null,"MIN(arguments)"]
[3,null,null,"NBVAL(arguments)","Calcul le nombre de valeurs comprises dans la liste des arguments.",null,null,null,null,null,null,"MAX(arguments)"]
[4,null,null,null,null,null,null,null,null,null,null,"MOYENNE(arguments)"]
[5,null,null,null,null,null,null,null,null,null,null,"MEDIANE(arguments)"]
[6,null,null,null,null,null,null,null,null,null,null,"QUARTILE(arguments)"]
[7,null,null,null,null,null,null,null,null,null,null,"MIN(arguments)"]
[8,null,null,null,null,null,null,null,null,null,null,"MAX(arguments)"]
[9,null,null,null,null,null,null,null,null,null,null,"MOYENNE(arguments)"]
[10,null,null,null,null,null,null,null,null,null,null,"MEDIANE(arguments)"]
[11,null,null,null,null,null,null,null,null,null,null,"QUARTILE(arguments)"]
[12,null,null,"2) Calcul des paramètres utilisant les fonctions Excel",null,null,null,null,null,null,null,"MIN(arguments)"]
[13,null,null,"المؤشر المطلوب حسابه","الرمز","حساب المؤشر بواسطة دالة إكسيل",null,null,null,null,null,"MAX(arguments)"]
[14,null,null,"Paramètre à calculer ","symbole","Calcul du Paramètre utilisant une formule Excel.",null,null,null,null,null,"MOYENNE(arguments)"]
[15,null,null,"nbre de températures prise","N =",{"$f":"COUNTA(B7:B36)","v":0},null,null,null,null,null,"MEDIANE(arguments)"]
[16,null,null,"Moyenne    ","m =",null,null,null,null,null,null,"QUARTILE(arguments)"]
[17,null,null,"Médiane","med =",null,null,null,null,null,null,"MAX(arguments)"]
[18,null,null,"1er quartile","Q1 =",null,null,null,null,null,null,"MOYENNE(arguments)"]
[19,null,null,"Minimum","min =",null,null,null,null,null,null,"MEDIANE(arguments)"]
[20,null,null,"Maximum","max =",null,null,null,null,null,null,"QUARTILE(arguments)"]
[21,null,null,"Etendu","E =",null,null,null,null,null,null,"MAX(arguments)"]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[null,"            "]

{"sheet":"Feuille 2","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,5],[1,3,1,5],[2,0,2,1],[34,0,34,2]]}
["Nom  &  Prémon",null,{"$f":"'Feuille 1'!E1","v":0}]
["Gr",{"$f":"'Feuille 1'!B2","v":0},"  Filière",{"$f":"'Feuille 1'!E2","v":0}]
[null,null,"écart à la moyenne","carré de l'écart à la moyenne"]
["1)  إشرح دور الدوال لبرنامج إكسيل المذكورة بجانب جدول المعطيات أسفله  (وفق المثال NBVAL) ","Xi","Xi - m","( Xi - m )^2"]
[1,{"$f":"'Feuille 1'!B7","v":0},null,null,null," Variance  Var = "]
[2,{"$f":"'Feuille 1'!B8","v":0}]
[3,{"$f":"'Feuille 1'!B9","v":0},null,null,null," écart type σ ="]
[4,{"$f":"'Feuille 1'!B10","v":0}]
[5,{"$f":"'Feuille 1'!B11","v":0}]
[6,{"$f":"'Feuille 1'!B12","v":0}]
[7,{"$f":"'Feuille 1'!B13","v":0}]
[8,{"$f":"'Feuille 1'!B14","v":0}]
[9,{"$f":"'Feuille 1'!B15","v":0}]
[10,{"$f":"'Feuille 1'!B16","v":0}]
[11,{"$f":"'Feuille 1'!B17","v":0}]
[12,{"$f":"'Feuille 1'!B18","v":0}]
[13,{"$f":"'Feuille 1'!B19","v":0}]
[14,{"$f":"'Feuille 1'!B20","v":0}]
[15,{"$f":"'Feuille 1'!B21","v":0}]
[16,{"$f":"'Feuille 1'!B22","v":0}]
[17,{"$f":"'Feuille 1'!B23","v":0}]
[18,{"$f":"'Feuille 1'!B24","v":0}]
[19,{"$f":"'Feuille 1'!B25","v":0}]
[20,{"$f":"'Feuille 1'!B26","v":0}]
[21,{"$f":"'Feuille 1'!B27","v":0}]
[22,{"$f":"'Feuille 1'!B28","v":0}]
[23,{"$f":"'Feuille 1'!B29","v":0}]
[24,{"$f":"'Feuille 1'!B30","v":0}]
[25,{"$f":"'Feuille 1'!B31","v":0}]
[26,{"$f":"'Feuille 1'!B32","v":0}]
[27,{"$f":"'Feuille 1'!B33","v":0}]
[28,{"$f":"'Feuille 1'!B34","v":0}]
[29,{"$f":"'Feuille 1'!B35","v":0}]
[30,{"$f":"'Feuille 1'!B36","v":0}]
["Total"]