{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Contingency table"],"not_rendered":{"charts":4,"images":5,"macros":1,"external_links":0,"defined_names":5,"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":"Data","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["CLIENT","AGE","CITY","GENDER"]
["cl01","25-34","Lyon","F"]
["cl02","35-44","Paris","F"]
["cl03","45-54","Marseille","M"]
["cl04","55-64","Nantes","M"]
["cl05",">65","Paris","M"]
["cl06","25-34","Marseille","M"]
["cl07","35-44","Paris","M"]
["cl08","45-54","Paris","F"]
["cl09","35-44","Lyon","F"]
["cl10","45-54","Marseille","M"]
["cl11","25-34","Marseille","F"]
["cl12","45-54","Nantes","F"]
["cl13","35-44","Lyon","M"]
["cl14","45-54","Nantes","M"]
["cl15","45-54","Marseille","M"]
["cl16",">65","Nantes","M"]
["cl17",">65","Lyon","M"]
["cl18","25-34","Nantes","F"]
["cl19","35-44","Paris","F"]
["cl20","45-54","Paris","M"]

{"sheet":"Contingency table","index":1,"n_rows":143,"n_cols":7,"rows_kept":143,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2023.1.3.1409 - Create a contingency table - Start time: 30/05/2023 at 15:33:45 / End time: 30/05/2023 at 15:33:47 / Microsoft Excel 16.016327"]
[null,"Row variable(s): Workbook = DemoContingency_0.xlsm / Sheet = Data / Range = 'Data'!$B:$B / 20 rows and 1 column"]
[null,"Column variable(s): Workbook = DemoContingency_0.xlsm / Sheet = Data / Range = 'Data'!$C:$C / 20 rows and 1 column"]
[]
[]
[]
[]
[null,"Results for the variables AGE and CITY:"]
[]
[null,"Contingency table (AGE \\ CITY):"]
[]
[null,"AGE \\ CITY","Lyon","Marseille","Nantes","Paris"]
[null,"25-34",1,2,1,0]
[null,"35-44",2,0,0,3]
[null,"45-54",0,3,2,2]
[null,"55-64",0,0,1,0]
[null,">65",1,0,1,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]
[]
[]
[null,"3D view of the contingency table:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]
[]
[]
[null,"Observed frequencies (AGE \\ CITY):"]
[]
[null,"AGE \\ CITY","Lyon","Marseille","Nantes","Paris","Total"]
[null,"25-34",1,2,1,0,4]
[null,"35-44",2,0,0,3,5]
[null,"45-54",0,3,2,2,7]
[null,"55-64",0,0,1,0,1]
[null,">65",1,0,1,1,3]
[null,"Total",4,5,5,6,20]
[]
[]
[null,"Theoretical frequencies (AGE \\ CITY):"]
[]
[null,"AGE \\ CITY","Lyon","Marseille","Nantes","Paris","Total"]
[null,"25-34",0.8,1,1,1.2,4]
[null,"35-44",1,1.25,1.25,1.5,5]
[null,"45-54",1.4,1.75,1.75,2.1,7]
[null,"55-64",0.2,0.25,0.25,0.3,1]
[null,">65",0.6,0.75,0.75,0.9,3]
[null,"Total",4,5,5,6,20]
[]
[]
[null,"Proportions / Row (AGE \\ CITY):"]
[]
[null,"AGE \\ CITY","Lyon","Marseille","Nantes","Paris","Total"]
[null,"25-34",0.25,0.5,0.25,0,1]
[null,"35-44",0.4,0,0,0.6,1]
[null,"45-54",0,0.42857142857142855,0.2857142857142857,0.2857142857142857,1]
[null,"55-64",0,0,1,0,1]
[null,">65",0.33333333333333331,0,0.33333333333333331,0.33333333333333331,1]
[null,"Total",0.2,0.25,0.25,0.3,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]
[]
[]
[null,"Proportions / Column (AGE \\ CITY):"]
[]
[null,"AGE \\ CITY","Lyon","Marseille","Nantes","Paris","Total"]
[null,"25-34",0.25,0.4,0.2,0,0.2]
[null,"35-44",0.5,0,0,0.5,0.25]
[null,"45-54",0,0.6,0.4,0.33333333333333331,0.35]
[null,"55-64",0,0,0.2,0,0.05]
[null,">65",0.25,0,0.2,0.16666666666666666,0.15]
[null,"Total",1,1,1,1,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]