{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Overview","Unimodal","Multimodal","Frequent word","VBA"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Overview","index":0,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[9,8,10,8],[9,9,10,9],[0,0,0,9],[4,1,4,6],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6]]}
["Excel Mode Function"]
[null," returns the most frequently occurring, or repetitive, value in an array or range of data. "]
[null,"=MODE (number1, [number2], …)"]
[]
[null,"Range of Data",null,null,null,null,null,"Mode","Formula"]
[null,1,10,15,12,15,8,{"$f":"MODE(C6,D6,E6,F6,G6)","v":15},{"$f":"_xlfn.FORMULATEXT(H6)","v":"=MODE(C6,D6,E6,F6,G6)"}]
[null,2,12,13,13,14,15,{"$f":"MODE(C7:G7)","v":13},{"$f":"_xlfn.FORMULATEXT(H7)","v":"=MODE(C7:G7)"}]
[null,3,11,13,13,11,11,{"$f":"_xlfn.MODE.SNGL(C8:G8)","v":11},"=MODE.SNGL(C8:G8)"]
[null,4,10,null,6,null,10,{"$f":"MODE(C9:G9)","v":10},"=MODE(C9:G9)","  //Empty cells ignored"]
[null,5,10,10,12,12,9,{"$f":"_xlfn.MODE.MULT(C10:G11)","v":10},"=MODE.MULT(C10:G11)","  //Multimodal data"]
[null,null,null,null,null,null,null,12]
[null,6,8,12,10,9,7,{"$f":"MODE(C12:G12)","v":{"$error":"#N/A"}},"=MODE(C12:G12)","  // No mode"]
[null,7,"a","b","c","d","d",{"$f":"MODE(C13:G13)","v":{"$error":"#N/A"}},"=MODE(C13:G13)","  // Text data"]
[null,8,true,true,false,false,true,{"$f":"MODE(C14:G14)","v":{"$error":"#N/A"}},"=MODE(C14:G14)","  // logicals ignored"]

{"sheet":"Unimodal","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Excel Mode Function"]
[]
[]
[null,"Subject","Number of Students"]
[null,"Physics",38]
[null,"Mathematics",45,null,"Mode"]
[null,"Chemistry",36,null,{"$f":"MODE(C5:C13)","v":38}]
[null,"Biology",32]
[null,"Statistics",40]
[null,"Literature",33]
[null,"Accounting",35]
[null,"Finance",38]
[null,"Management",41]

{"sheet":"Multimodal","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Excel Mode Function"]
[]
[]
[null,"Subject","Number of Students"]
[null,"Physics",38]
[null,"Mathematics",45,null,"Mode"]
[null,"Chemistry",36,null,{"$f":"_xlfn.MODE.MULT(C5:C13)","v":38}]
[null,"Biology",40,null,40]
[null,"Statistics",40]
[null,"Literature",33]
[null,"Accounting",35]
[null,"Finance",38]
[null,"Management",41]

{"sheet":"Frequent word","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Excel Mode Function"]
[]
[]
[null,"Roll No.","Subject"]
[null,1312001,"Physics"]
[null,1312002,"Mathematics",null,"Most Chosen Subject"]
[null,1312003,"Accounting",null,{"$f":"INDEX(C5:C13,MODE(MATCH(C5:C13,C5:C13,0)))","v":"Physics"}]
[null,1312004,"Biology"]
[null,1312005,"Physics"]
[null,1312006,"Biology"]
[null,1312007,"Physics"]
[null,1312008,"Chemistry"]
[null,1312009,"Finance"]

{"sheet":"VBA","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Excel Mode Function"]
[]
[]
[null,"Subject","Number of Students"]
[null,"Physics",38]
[null,"Mathematics",45,null,"Mode"]
[null,"Chemistry",36,null,38]
[null,"Biology",32]
[null,"Statistics",40]
[null,"Literature",33]
[null,"Accounting",35]
[null,"Finance",38]
[null,"Management",41]