{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["STDEV Functions","STDEV.S function","STDEV.P function","VBA"],"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":"STDEV Functions","index":0,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"STDEV Functions",null,null,null,null,null,null,"For Practice"]
[]
[null," ID","Marks",null,null,null,null,null," ID","Marks"]
[null,1,78,null,"STDEV Result",{"$f":"STDEV(C5:C10)","v":15.958278938114447},null,null,1,78,null,"STDEV Result"]
[null,2,96,null,"STDEV.S Result",{"$f":"_xlfn.STDEV.S(C5:C10)","v":15.958278938114447},null,null,2,96,null,"STDEV.S Result"]
[null,3,82,null,"STDEV.P Result",{"$f":"_xlfn.STDEV.P(C5:C10)","v":14.567848922274772},null,null,3,82,null,"STDEV.P Result"]
[null,4,100,null,"STDEVP Result",{"$f":"STDEVP(C5:C10)","v":14.567848922274772},null,null,4,100,null,"STDEVP Result"]
[null,5,59,null,"STDEVA Result",{"$f":"STDEVA(C5:C10)","v":15.958278938114447},null,null,5,59,null,"STDEVA Result"]
[null,6,99,null,"STDEVPA Result",{"$f":"STDEVPA(C5:C10)","v":14.567848922274772},null,null,6,99,null,"STDEVPA Result"]

{"sheet":"STDEV.S function","index":1,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,3],[13,1,13,3]]}
[]
[null,"STDEV.S Function"]
[null,null,null,null,null,null,"Formula","Result"]
[null,"Serial No.","Name","Weight (Kg)",null,"Count",{"$f":"_xlfn.FORMULATEXT(H4)","v":"=B10"},{"$f":"B10","v":6}]
[null,1,"John",78,null,"Average",{"$f":"_xlfn.FORMULATEXT(H5)","v":"=AVERAGE(D5:D10)"},{"$f":"AVERAGE(D5:D10)","v":69.166666666666671}]
[null,2,"Moly",49,null,"Standard Deviation",{"$f":"_xlfn.FORMULATEXT(H6)","v":"=STDEV.S(D5:D10)"},{"$f":"_xlfn.STDEV.S(D5:D10)","v":18.734104373219083}]
[null,3,"Smith",60]
[null,4,"Ruby",67,null,null,null,null,null,null,null,null,"Where,"]
[null,5,"Sam",59,null,null,null,null,null,null,null,null,null,"Each Indivudual value in the dataset"]
[null,6,"Holk",102,null,null,null,null,null,null,null,null,null,"The arithmetic mean"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The number of data point in the set."]
[]
[]
[null,"For Practice"]
[null,null,null,null,null,null,"Formula","Result"]
[null,"Serial No.","Name","Weight (Kg)",null,"Count"]
[null,1,"John",78,null,"Average"]
[null,2,"Moly",49,null,"Standard Deviation"]
[null,3,"Smith",60]
[null,4,"Ruby",67]
[null,5,"Sam",59]
[null,6,"Holk",102]

{"sheet":"STDEV.P function","index":2,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,3],[13,1,13,3]]}
[]
[null,"STDEV.P Function"]
[null,null,null,null,null,null,"Formula","Result"]
[null,"Serial No.","Name","Weight (Kg)",null,"Count",{"$f":"_xlfn.FORMULATEXT(H4)","v":"=B10"},{"$f":"B10","v":6}]
[null,1,"John",78,null,"Average",{"$f":"_xlfn.FORMULATEXT(H5)","v":"=AVERAGE(D5:D10)"},{"$f":"AVERAGE(D5:D10)","v":69.166666666666671}]
[null,2,"Moly",49,null,"Standard Deviation",{"$f":"_xlfn.FORMULATEXT(H6)","v":"=STDEV.P(D5:D10)"},{"$f":"_xlfn.STDEV.P(D5:D10)","v":17.10181926644713}]
[null,3,"Smith",60]
[null,4,"Ruby",67,null,null,null,null,null,null,null,null,"Where,"]
[null,5,"Sam",59,null,null,null,null,null,null,null,null,null,"Each Indivudual value in the dataset"]
[null,6,"Holk",102,null,null,null,null,null,null,null,null,null,"The arithmetic mean"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The number of data point in the set."]
[]
[]
[null,"For Practice"]
[null,null,null,null,null,null,"Formula","Result"]
[null,"Serial No.","Name","Weight (Kg)",null,"Count"]
[null,1,"John",78,null,"Average"]
[null,2,"Moly",49,null,"Standard Deviation"]
[null,3,"Smith",60]
[null,4,"Ruby",67]
[null,5,"Sam",59]
[null,6,"Holk",102]

{"sheet":"VBA","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"STDEV Functions",null,null,null,null,null,null,"For Practice"]
[]
[null," ID","Marks",null,null,null,null,null," ID","Marks"]
[null,1,78,null,"STDEV Result",15.96,null,null,1,78,null,"STDEV Result"]
[null,2,96,null,"STDEV.P Result",14.57,null,null,2,96,null,"STDEV.P Result"]
[null,3,82,null,"STDEVP Result",14.57,null,null,3,82,null,"STDEVP Result"]
[null,4,100,null,"STDEV.S Result",15.96,null,null,4,100,null,"STDEV.S Result"]
[null,5,59,null,null,null,null,null,5,59]
[null,6,99,null,null,null,null,null,6,99]