{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Corrélation bisérielle"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"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":"Data","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,"X","Q"]
[null,3.41,"a","=XLSTAT_Biserial(B2:B31;C2:C31)"]
[null,4.04,"a",{"$f":"[1]!XLSTAT_Biserial(B2:B31,C2:C31)","v":{"$error":"#NAME?"}}]
[null,1.23,"a"]
[null,2.46,"a","=INDEX(XLSTAT_Biserial(B2:B31;C2:C31;;TRUE);2;1)"]
[null,3.33,"a",{"$f":"INDEX([1]!XLSTAT_Biserial(B2:B31,C2:C31,,TRUE),2,1)","v":{"$error":"#NAME?"}}]
[null,3.85,"a"]
[null,2.92,"a"]
[null,2.6,"a"]
[null,2.89,"a"]
[null,1.28,"a"]
[null,3.62,"a"]
[null,3.5,"a"]
[null,3.14,"a"]
[null,2.58,"a"]
[null,4.67,"a"]
[null,2.8899999999999997,"b"]
[null,4.24,"b"]
[null,4.0199999999999996,"b"]
[null,4.28,"b"]
[null,4.4000000000000004,"b"]
[null,3.9699999999999998,"b"]
[null,3.7699999999999996,"b"]
[null,1.0899999999999999,"b"]
[null,4.63,"b"]
[null,3.66,"b"]
[null,4.05,"b"]
[null,3.2800000000000002,"b"]
[null,3.6799999999999997,"b"]
[null,1.94,"b"]
[null,1.38,"b"]

{"sheet":"Corrélation bisérielle","index":1,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,1,39,9]]}
[null,"XLSTAT 2023.2.1414.1415 - Corrélation bisérielle - Début : 12/11/2023 à 14:47:48 / Fin : 12/11/2023 à 14:47:50 / Microsoft Excel 16.017029"]
[null,"Variables quantitatives : Classeur = demo-biserial-correlations-fr.xlsm / Feuille = Data / Plage = 'Data'!$B:$B / 30 lignes et 1 colonne"]
[null,"Variable binaire : Classeur = demo-biserial-correlations-fr.xlsm / Feuille = Data / Plage = 'Data'!$C:$C / 30 lignes et 1 colonne"]
[null,"Niveau de signification (%) : 5"]
[null,"p-value : Méthode Monte Carlo"]
[null,"Modalité témoin : a"]
[null,"Nombre de simulations : 10000"]
[null,"Temps maximum (s) : 180"]
[null,"Graine (nombres aléatoires) : 123456789"]
[]
[]
[]
[]
[null,"Statistiques descriptives (Données quantitatives) :"]
[]
[null,"Variable","Observations","Obs. avec données manquantes","Obs. sans données manquantes","Minimum","Maximum","Moyenne","Ecart-type"]
[null,"X",30,0,30,1.0899999999999999,4.67,3.226666666666667,1.0267905582808563]
[]
[]
[null,"Statistiques descriptives (Données qualitatives) :"]
[]
[null,"Variable","Modalités","Comptages","Effectifs","%"]
[null,"Q","a",15,15,50]
[null,"","b",15,15,50]
[]
[]
[null,"Corrélation bisérielle (X / Q) / Test bilatéral :"]
[]
[null,"r",-0.19018707122682546]
[null,"p-value (bilatérale)",0.30747756729810566]
[null,"alpha",0.05]
[null,"La p-value a été calculée en utilisant 10000 simulations Monte Carlo. Temps passé : 0s."]
[null,"Intervalle de confiance à 99% autour de la p-value :"]
[null,0.29559143059662984,0.31936370399958147]
[]
[null,"Interprétation du test :"]
[null,"H0 : La variable quantitative X et la variable qualitative Q ne sont pas associées"]
[null,"Ha : La variable quantitative X et la variable qualitative Q sont associées."]
[null,"Etant donné que la p-value calculée est supérieure au niveau de signification seuil alpha=0,05, on ne peut pas rejeter l'hypothèse nulle H0."]