{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Puissance(Moyenne)"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Puissance(Moyenne)","index":0,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[[20,1,20,8],[21,1,21,8],[22,1,23,8],[24,1,25,8]]}
[null,"XLSTAT 2021.5.1.12345 - Puissance / Comparer des moyennes - Début : 30/12/2021 à 17:41:54 / Fin : 30/12/2021 à 17:41:57 / Microsoft Excel 16.014701"]
[null,"Objectif : Trouver la taille de l'échantillon"]
[null,"Test : Test t pour deux échantillons indépendants"]
[null,"Hypothèse alternative : Moyenne 1 ≠ Moyenne 2"]
[]
[]
[]
[]
[null,"Résultats :"]
[]
[null,"Paramètres","Résultats"]
[null,"alpha",0.05]
[null,"Taille de l'effet",0.2]
[null,"Taille d'échantillon 1",526]
[null,"Taille d'échantillon 2",526]
[null,"Puissance (obtenu)",0.89981946139171676]
[]
[]
[null,"Interprétation :"]
[]
[null,"H0 : La différence entre les moyennes est égale à 0."]
[null,"Ha : La différence entre les moyennes est différente de 0."]
[null,"Le risque de ne pas rejeter l'hypothèse nulle H0 alors qu'elle est fausse est de 0.1."]
[]
[null,"Pour les paramètres saisis, pour un alpha de 0.05, la taille de l'échantillon nécessaire afin d'obtenir une puissance de 0.9 est de 526 observations."]
[]
[]
[]
[null,"Résultats (Graphique des simulations) :"]
[]
[null,"Puissance","Taille d'échantillon 1","Taille d'échantillon 2"]
[null,0.8,393,393]
[null,0.81,404,404]
[null,0.82000000000000006,414,414]
[null,0.83000000000000007,426,426]
[null,0.84000000000000008,437,437]
[null,0.85000000000000009,450,450]
[null,0.8600000000000001,463,463]
[null,0.87000000000000011,477,477]
[null,0.88000000000000012,492,492]
[null,0.89000000000000012,509,509]
[null,0.90000000000000013,526,526]
[null,0.91000000000000014,546,546]
[null,0.92000000000000015,567,567]
[null,0.93000000000000016,591,591]
[null,0.94000000000000017,619,619]
[null,0.95000000000000018,651,651]
[null,0.96000000000000019,689,689]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]