{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Raking survey"],"not_rendered":{"charts":0,"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":"Data","index":0,"n_rows":201,"n_cols":6,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["Sat","Gender","Age",null,"Gender","Age"]
[2,1,2,null,3800,2000]
[5,2,3,null,6200,5000]
[2,1,2,null,null,3000]
[3,1,1]
[4,2,2]
[3,1,2]
[3,1,2]
[3,2,2]
[4,1,3]
[2,2,2]
[2,1,2]
[3,1,1]
[2,2,2]
[3,1,2]
[4,1,2]
[3,1,2]
[3,1,2]
[2,2,2]
[3,2,2]
[3,1,2]
[4,2,2]
[3,1,2]
[3,1,2]
[3,2,3]
[2,1,2]
[3,2,3]
[3,1,3]
[3,1,3]
[2,2,1]
[1,2,2]
[4,1,2]
[4,1,3]
[3,2,2]
[3,1,2]
[2,2,2]
[3,2,1]
[4,1,3]
[2,1,2]
[3,1,2]
[3,1,2]
[3,2,2]
[5,1,2]
[3,1,2]
[1,1,3]
[4,1,2]
[3,1,2]
[3,1,2]
[4,1,2]
[4,2,2]
[2,1,1]
[3,1,3]
[3,1,3]
[3,1,2]
[5,1,3]
[4,2,2]
[4,1,2]
[5,1,2]
[3,2,2]
[4,2,2]
[4,2,2]
[5,2,2]
[3,2,3]
[3,2,2]
[4,2,2]
[3,2,1]
[3,2,2]
[3,1,2]
[3,1,2]
[2,1,1]
[4,1,2]
[4,2,2]
[3,1,3]
[3,2,2]
[4,1,2]
[3,2,1]
[2,1,2]
[4,1,2]
[4,2,1]
[3,1,2]
[4,1,2]
[4,2,1]
[4,1,2]
[5,1,2]
[3,1,2]
[3,1,2]
[4,1,2]
[4,1,2]
[4,2,2]
[3,1,3]
[2,1,2]
[2,2,2]
[4,2,1]
[3,2,3]
[4,2,2]
[3,1,2]
[4,1,2]
[4,2,3]
[3,2,2]
[3,1,2]
[3,2,2]
[3,1,3]
[4,1,1]
[4,2,2]
[4,1,1]
[4,2,2]
[3,1,2]
[3,2,1]
[3,2,2]
[3,1,2]
[2,1,2]
[3,1,2]
[3,2,2]
[2,1,2]
[2,1,1]
[5,1,2]
[4,2,2]
[5,1,3]
[2,1,1]
[4,2,2]
[4,1,2]
[4,2,2]
[3,2,2]
[4,2,2]
[4,1,2]
[2,1,2]
[4,2,2]
[4,2,3]
[3,1,1]
[4,1,1]
[3,1,2]
[4,2,1]
[2,1,2]
[3,2,2]
[3,1,2]
[2,2,2]
[4,2,2]
[3,1,2]
[4,1,2]
[4,1,2]
[3,2,1]
[5,2,3]
[2,1,2]
[4,2,2]
[4,2,2]
[3,2,1]
[4,2,2]
[5,1,1]
[3,2,1]
[3,2,2]
[3,1,1]
[3,2,2]
[2,1,1]
[3,2,1]
[4,1,2]
[4,1,2]
[4,2,2]
[2,2,2]
[4,1,2]
[4,1,2]
[2,1,2]
[3,2,2]
[5,2,3]
[2,1,2]
[2,2,1]
[3,2,2]
[3,2,1]
[3,1,1]
[3,2,2]
[3,2,3]
[4,1,3]
[4,1,1]
[3,1,3]
[3,2,3]
[4,2,2]
[4,2,2]
[4,1,2]
[4,2,2]
[4,1,2]
[4,2,2]
[4,2,2]
[4,2,2]
[3,2,2]
[2,1,3]
[3,1,2]
[3,2,3]
[3,1,3]
[3,1,2]
[4,1,2]
[4,2,2]
[4,1,3]
[3,1,1]
[3,2,2]
[4,2,1]
[3,1,2]
[4,1,3]
[4,1,2]
[4,1,2]
[3,2,2]
[3,1,3]
[2,1,2]

{"sheet":"Raking survey","index":1,"n_rows":243,"n_cols":7,"rows_kept":243,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2023.2.1413.1414 - Raking survey - Start time: 08/11/2023 at 12:11:53 / End time: 08/11/2023 at 12:11:53 / Microsoft Excel 16.016924"]
[null,"Data to be raked on: Workbook = demoRaking (1).xls / Sheet = Data / Range = 'Data'!$B:$C / 200 rows and 2 columns"]
[null,"Marginal control totals: Workbook = demoRaking (1).xls / Sheet = Data / Range = 'Data'!$E:$F / 3 rows and 2 columns"]
[null,"Estimation method: Raking ratio"]
[null,"Population size: 10000"]
[]
[]
[]
[]
[null,"Summary statistics (before raking):"]
[]
[null,"Variable","Categories","Frequencies","%","Marginal control totals","Marginal control totals (%)"]
[null,"Gender","1",112,56,3800,38]
[null,"","2",88,44,6200,62]
[null,"Age","1",32,16,2000,20]
[null,"","2",136,68,5000,50]
[null,"","3",32,16,3000,30]
[]
[]
[null,"Final weights:"]
[]
[null,"Observation","Gender","Age","Final weights","Weights ratio"]
[null,"Obs1","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs2","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs3","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs4","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs5","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs6","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs7","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs8","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs9","1","3",65.523953171171797,1.310479063423436]
[null,"Obs10","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs11","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs12","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs13","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs14","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs15","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs16","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs17","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs18","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs19","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs20","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs21","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs22","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs23","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs24","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs25","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs26","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs27","1","3",65.523953171171797,1.310479063423436]
[null,"Obs28","1","3",65.523953171171797,1.310479063423436]
[null,"Obs29","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs30","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs31","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs32","1","3",65.523953171171797,1.310479063423436]
[null,"Obs33","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs34","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs35","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs36","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs37","1","3",65.523953171171797,1.310479063423436]
[null,"Obs38","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs39","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs40","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs41","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs42","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs43","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs44","1","3",65.523953171171797,1.310479063423436]
[null,"Obs45","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs46","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs47","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs48","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs49","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs50","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs51","1","3",65.523953171171797,1.310479063423436]
[null,"Obs52","1","3",65.523953171171797,1.310479063423436]
[null,"Obs53","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs54","1","3",65.523953171171797,1.310479063423436]
[null,"Obs55","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs56","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs57","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs58","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs59","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs60","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs61","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs62","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs63","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs64","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs65","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs66","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs67","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs68","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs69","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs70","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs71","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs72","1","3",65.523953171171797,1.310479063423436]
[null,"Obs73","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs74","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs75","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs76","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs77","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs78","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs79","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs80","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs81","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs82","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs83","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs84","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs85","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs86","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs87","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs88","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs89","1","3",65.523953171171797,1.310479063423436]
[null,"Obs90","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs91","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs92","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs93","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs94","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs95","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs96","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs97","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs98","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs99","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs100","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs101","1","3",65.523953171171797,1.310479063423436]
[null,"Obs102","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs103","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs104","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs105","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs106","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs107","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs108","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs109","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs110","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs111","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs112","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs113","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs114","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs115","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs116","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs117","1","3",65.523953171171797,1.310479063423436]
[null,"Obs118","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs119","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs120","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs121","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs122","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs123","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs124","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs125","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs126","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs127","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs128","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs129","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs130","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs131","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs132","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs133","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs134","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs135","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs136","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs137","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs138","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs139","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs140","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs141","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs142","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs143","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs144","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs145","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs146","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs147","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs148","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs149","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs150","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs151","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs152","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs153","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs154","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs155","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs156","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs157","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs158","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs159","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs160","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs161","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs162","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs163","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs164","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs165","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs166","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs167","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs168","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs169","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs170","1","3",65.523953171171797,1.310479063423436]
[null,"Obs171","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs172","1","3",65.523953171171797,1.310479063423436]
[null,"Obs173","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs174","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs175","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs176","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs177","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs178","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs179","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs180","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs181","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs182","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs183","1","3",65.523953171171797,1.310479063423436]
[null,"Obs184","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs185","2","3",140.79354037270028,2.8158708074540058]
[null,"Obs186","1","3",65.523953171171797,1.310479063423436]
[null,"Obs187","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs188","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs189","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs190","1","3",65.523953171171797,1.310479063423436]
[null,"Obs191","1","1",39.698495780607082,0.7939699156121417]
[null,"Obs192","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs193","2","1",85.301504227334419,1.7060300845466885]
[null,"Obs194","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs195","1","3",65.523953171171797,1.310479063423436]
[null,"Obs196","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs197","1","2",24.399285347994795,0.4879857069598959]
[null,"Obs198","2","2",52.427571909982561,1.0485514381996512]
[null,"Obs199","1","3",65.523953171171797,1.310479063423436]
[null,"Obs200","1","2",24.399285347994795,0.4879857069598959]
[]
[]
[null,"Summary statistics (after raking):"]
[]
[null,"Variable","Categories","Frequencies","%","Marginal control totals","Marginal control totals (%)"]
[null,"Gender","1",3800.0006823607559,38.000000937143469,3800,38]
[null,"","2",6200.0008667087031,61.999999062856531,6200,62]
[null,"Age","1",2000.0000001270639,19.9999969031322,2000,20]
[null,"","2",5000.0000010465546,49.999992265119452,5000,50]
[null,"","3",3000.0015478958394,30.000010831748341,3000,30]
[]
[]
[null,"List of combines:"]
[]
[null,"Gender","Age","Frequencies","Weights ratio"]
[null,"1","2",76,0.4879857069598959]
[null,"1","1",16,0.7939699156121417]
[null,"2","2",60,1.0485514381996512]
[null,"1","3",20,1.310479063423436]
[null,"2","1",16,1.7060300845466885]
[null,"2","3",12,2.8158708074540058]