{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dataset","Marks Histogram","Formatted Output"],"not_rendered":{"charts":2,"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":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Creating Histogram Using VBA"]
[]
[null,"Subject","Marks"]
[null,"Physics",92]
[null,"Chemistry",75]
[null,"Matematics",84]
[null,"Sociaology",78]
[null,"History",57]
[null,"Civics",34]
[null,"Geography",55]
[null,"Literature",73]
[null,"Language",67]
[null,"Economics",85]

{"sheet":"Marks Histogram","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,11]]}
[]
[null,"Histogram Created with VBA Code"]
[]
[null,"Marks Scores","Bins","Counts","Ranges"]
[null,92,9,{"$f":"FREQUENCY(B5:B14,C5:C13)","v":0},"0-9"]
[null,75,19,0,"10-19"]
[null,84,29,0,"20-29"]
[null,78,39,1,"30-39"]
[null,57,49,0,"40-49"]
[null,34,59,2,"50-59"]
[null,55,69,1,"60-69"]
[null,73,79,3,"70-79"]
[null,67,89,2,"80-89"]
[null,85,null,1,"90-100"]
[]
[null,"Average",{"$f":"AVERAGE(B4:B14)","v":70}]
[null,"StdDev",{"$f":"STDEV(B4:B14)","v":17.326921891156037}]

{"sheet":"Formatted Output","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Final Histogram Output"]
[]
[null,"Marks Scores","Bins","Counts","Ranges"]
[null,92,9,{"$f":"FREQUENCY(B5:B14,C5:C13)","v":0},"0-9"]
[null,75,19,0,"10-19"]
[null,84,29,0,"20-29"]
[null,78,39,1,"30-39"]
[null,57,49,0,"40-49"]
[null,34,59,2,"50-59"]
[null,55,69,1,"60-69"]
[null,73,79,3,"70-79"]
[null,67,89,2,"80-89"]
[null,85,null,1,"90-100"]
[]
[null,"Average",{"$f":"AVERAGE(B4:B14)","v":70}]
[null,"StdDev",{"$f":"STDEV(B4:B14)","v":17.326921891156037}]