{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["STDEV-IF","STDEV-IF AN ","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":"STDEV-IF","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["CarType","Sales"]
["Ford",25072]
["Toyota",23311]
["Honda",29557]
["Toyota",15922]
["Toyota",22794]
["Honda",16150]
["Ford",22880]
["Ford",21989]
["Honda",16582]
["Honda",25465]
["Toyota",20482]
["Toyota",19866]
["Toyota",21114]
["Ford",26504]

{"sheet":"STDEV-IF AN ","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["CarType","Sales","Z-score",null,"CarType","Mean","StandardDeviation","Mode","Median"]
["Ford",25072,{"$f":"(B2-VLOOKUP(A2,$E$2:$G$4,2,0))/VLOOKUP(A2,$E$2:$G$4,3,0)","v":0.46753412159355634},null,"Ford",{"$f":"AVERAGEIF($A$2:$A$15,E2,$B$2:$B$15)","v":24111.25},{"$f":"_xlfn.STDEV.S(IF($A$2:$A$15=E2,$B$2:$B$15))","v":2054.9302299591586},{"$f":"_xlfn.MODE.SNGL(IF($A$2:$A$15=E2,$B$2:$B$15))","v":{"$error":"#N/A"}},{"$f":"MEDIAN(IF($A$2:$A$15=E2,$B$2:$B$15))","v":23976}]
["Toyota",23311,{"$f":"(B3-VLOOKUP(A3,$E$2:$G$4,2,0))/VLOOKUP(A3,$E$2:$G$4,3,0)","v":1.0336988842900916},null,"Toyota",{"$f":"AVERAGEIF($A$2:$A$15,E3,$B$2:$B$15)","v":20581.5},{"$f":"_xlfn.STDEV.S(IF($A$2:$A$15=E3,$B$2:$B$15))","v":2640.517506096106},{"$f":"_xlfn.MODE.SNGL(IF($A$2:$A$15=E3,$B$2:$B$15))","v":{"$error":"#N/A"}},{"$f":"MEDIAN(IF($A$2:$A$15=E3,$B$2:$B$15))","v":20798}]
["Honda",29557,1.1455999424563983,null,"Honda",21938.5,{"$f":"_xlfn.STDEV.S(IF($A$2:$A$15=E4,$B$2:$B$15))","v":6650.2272893488389},{"$f":"_xlfn.MODE.SNGL(IF($A$2:$A$15=E4,$B$2:$B$15))","v":{"$error":"#N/A"}},{"$f":"MEDIAN(IF($A$2:$A$15=E4,$B$2:$B$15))","v":21023.5}]
["Toyota",15922,-1.7646162122548752]
["Toyota",22794,0.83790393166947341,null,"Row Labels","Mean","s"]
["Honda",16150,-0.87042137781831885,null,"Ford",24111.25,2054.9302299591586]
["Ford",22880,-0.59916876108463835,null,"Honda",21938.5,6650.2272893488389]
["Ford",21989,-1.0327601244360396,null,"Toyota",20581.5,2640.517506096106]
["Honda",16582,-0.80546119206769018,null,"Grand Total",21977.714285714286,4020.3040724757129]
["Honda",25465,0.53028262742961063]
["Toyota",20482,-3.7682007322536772E-2]
["Toyota",19866,-0.27096961044497547,{"$f":"(B13-F3)/G3","v":-0.27096961044497547}]
["Toyota",21114,0.20166501406282242]
["Ford",26504,1.1643947639271215]

{"sheet":"Sheet2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}