{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Ex-1","Ex-2","Ex-3","Ex-4","Ex-4 (2)"],"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":"Dataset","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Values",null,"Quartile"]
[null,10,null,{"$f":"QUARTILE(B5:B10,1)","v":10.5},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=QUARTILE(B5:B10,1)"}]
[null,4.7,null,{"$f":"QUARTILE(B5:B10,2)","v":12.99},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=QUARTILE(B5:B10,2)"}]
[null,13.98,null,{"$f":"QUARTILE(B5:B10,3)","v":15.495000000000001},"=QUARTILE(B5:B10,3)"]
[null,12]
[null,23.9]
[null,16]

{"sheet":"Ex-1","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Find 2nd Quartile of Salaries"]
[]
[null,"Name","Salary",null,"2nd Quartile"]
[null,"John",2000,null,{"$f":"QUARTILE(C5:C10,2)","v":2150},{"$f":"_xlfn.FORMULATEXT(E5)","v":"=QUARTILE(C5:C10,2)"}]
[null,"Max",2300]
[null,"Stacy",3400]
[null,"Julia",2000]
[null,"Peter",1900]
[null,"Alfred",4000]

{"sheet":"Ex-2","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Find 3rd Quartile of Marks"]
[]
[null,"Name","Marks",null,"3rd Quartile"]
[null,"Nick",50,null,{"$f":"QUARTILE(C5:C10,3)","v":73.25},{"$f":"_xlfn.FORMULATEXT(E5)","v":"=QUARTILE(C5:C10,3)"}]
[null,"Aron",76]
[null,"Mark",49]
[null,"Henry",32]
[null,"Elizabeth",88]
[null,"Tom",65]

{"sheet":"Ex-3","index":3,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Finding All The quart Values"]
[]
[null,"Name","Marks",null,"quart Values","Meaning","Result"]
[null,"Nick",50,null,0,"Minumum Value",{"$f":"QUARTILE($C$5:$C$10,E5)","v":32}]
[null,"Aron",76,null,1,"1st Quartile",{"$f":"QUARTILE($C$5:$C$10,E6)","v":49.25}]
[null,"Mark",49,null,2,"2nd Quartile",57.5]
[null,"Henry",32,null,3,"3rd Quartile",73.25]
[null,"Elizabeth",88,null,4,"Maximum Value",88]
[null,"Tom",65]

{"sheet":"Ex-4","index":4,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using the QUARTILE.INC Function"]
[]
[null,"Name","Marks",null,"quart Values","Meaning","Result"]
[null,"Nick",50,null,0,"Minumum Value",{"$f":"_xlfn.QUARTILE.INC($C$5:$C$10,E5)","v":32}]
[null,"Aron",76,null,1,"1st Quartile",{"$f":"_xlfn.QUARTILE.INC($C$5:$C$10,E6)","v":49.25}]
[null,"Mark",49,null,2,"2nd Quartile",57.5]
[null,"Henry",32,null,3,"3rd Quartile",73.25]
[null,"Elizabeth",88,null,4,"Maximum Value",{"$f":"_xlfn.QUARTILE.INC($C$5:$C$10,E9)","v":88}]
[null,"Tom",65]

{"sheet":"Ex-4 (2)","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using the QUARTILE.EXC Function"]
[]
[null,"Name","Marks",null,"quart Values","Meaning","Result"]
[null,"Nick",50,null,0,"Minumum Value",{"$f":"_xlfn.QUARTILE.EXC($C$5:$C$10,E5)","v":{"$error":"#NUM!"}}]
[null,"Aron",76,null,1,"1st Quartile",{"$f":"_xlfn.QUARTILE.EXC($C$5:$C$10,E6)","v":44.75}]
[null,"Mark",49,null,2,"2nd Quartile",57.5]
[null,"Henry",32,null,3,"3rd Quartile",79]
[null,"Elizabeth",88,null,4,"Maximum Value",{"$error":"#NUM!"}]
[null,"Tom",65]