{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["sbSWV"],"not_rendered":{"charts":0,"images":0,"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":"sbSWV","index":0,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Values A","Values B","Weights","AVERAGE A",{"$f":"sbSWV(\"AVERAGE\",$A$2:$A$10,$C$2:$C$10)","v":35.92},{"$f":"AVERAGE($G$1:INDEX(G:G,LOOKUP(2,1/(G:G<>\"\"),ROW(G:G))))","v":35.92},32,31]
[32,31,1,"AVERAGE B",{"$f":"sbSWV(\"AVERAGE\",$B$2:$B$10,$C$2:$C$10)","v":37.36},{"$f":"AVERAGE($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":37.36},33,34]
[33,34,4,"MODE A",{"$f":"sbSWV(\"MODE\",$A$2:$A$10,$C$2:$C$10)","v":33},{"$f":"MODE($G$1:INDEX(G:G,LOOKUP(2,1/(G:G<>\"\"),ROW(G:G))))","v":33},33,34]
[34,35,4,"MEDIAN A",{"$f":"sbSWV(\"MEDIAN\",$A$2:$A$10,$C$2:$C$10)","v":36},{"$f":"MEDIAN($G$1:INDEX(G:G,LOOKUP(2,1/(G:G<>\"\"),ROW(G:G))))","v":36},33,34]
[35,36,3,"STDEV A",{"$f":"sbSWV(\"STDEV\",$A$2:$A$10,$C$2:$C$10)","v":2.5152865973217975},{"$f":"STDEV($G$1:INDEX(G:G,LOOKUP(2,1/(G:G<>\"\"),ROW(G:G))))","v":2.5152865973217975},33,34]
[36,38,3,"VARIANCE A",{"$f":"sbSWV(\"VAR\",$A$2:$A$10,$C$2:$C$10)","v":6.3266666666666653},{"$f":"VAR($G$1:INDEX(G:G,LOOKUP(2,1/(G:G<>\"\"),ROW(G:G))))","v":6.3266666666666653},34,35]
[37,39,4,"VARIANCE B",{"$f":"sbSWV(\"VAR\",$B$2:$B$10,$C$2:$C$10)","v":9.6566666666666681},{"$f":"VAR($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":9.6566666666666663},34,35]
[38,40,1,"COVAR",{"$f":"sbSWV(\"COVAR\",$A$2:$A$10,$B$2:$B$10,$C$2:$C$10)","v":7.428799999999999},{"$f":"COVAR($G$1:INDEX(G:G,LOOKUP(2,1/(G:G<>\"\"),ROW(G:G))),$H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":7.4287999999999963},34,35]
[39,41,1,"CORREL",{"$f":"sbSWV(\"CORREL\",$A$2:$A$10,$B$2:$B$10,$C$2:$C$10)","v":0.99002539862122463},{"$f":"CORREL($G$1:INDEX(G:G,LOOKUP(2,1/(G:G<>\"\"),ROW(G:G))),$H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":0.99002539862122441},34,35]
[40,42,4,null,null,null,35,36]
[null,null,null,null,"ABS Difference Total",{"$f":"SUM(ABS(E1:E9-F1:F9))","v":4.6629367034256575E-15},35,36]
[null,null,null,null,null,null,35,36]
[null,null,null,null,null,null,36,38]
[null,null,null,null,null,null,36,38]
[null,null,null,null,null,null,36,38]
[null,null,null,null,null,null,37,39]
[null,null,null,null,null,null,37,39]
[null,null,null,null,null,null,37,39]
[null,null,null,null,null,null,37,39]
[null,null,null,null,null,null,38,40]
[null,null,null,null,null,null,39,41]
[null,null,null,null,null,null,40,42]
[null,null,null,null,null,null,40,42]
[null,null,null,null,null,null,40,42]
[null,null,null,null,null,null,40,42]