{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Histogram Template","Histogram (2)","Interpreting a Histogram","Example"],"not_rendered":{"charts":3,"images":11,"macros":1,"external_links":0,"defined_names":4,"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":"Histogram Template","index":0,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,2,53,3],[11,2,40,3],[43,2,44,3],[42,2,42,3],[14,6,14,7],[15,6,15,7],[16,6,16,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Instructions\n\nStep 1:  Download this spreadsheet template onto your computer and re-name the file. Click on ENABLE EDITING.\n\nStep 2:  Enter the data categories into the table (X-axis). The intervals need to be of equal range size and mutually exclusive so that cases can only fall into one interval/bin.   \n\nStep 3:  Count the number of values in each bin and enter those values into the count column \n\nStep 4:  Label the chart by entering the Title, X-axis and Y-axis label cells \n\nStep 5: Interpret the data based on the distribution of the columns (See Interpreting a Histogram worksheet for more information) \n\nStep 6: To reset the template press the Clear data button\n\nTo Change the X-Axis range: \n1. Right click on the graph and select 'Select Data'\n2. Under 'Horizontal (Category) Axis Labels', deselect any bin options you do not wish to include in the graph. "]
[]
[]
[null,null,null,null,null,"Chart Title"]
[null,null,null,null,null,"Y-axis label"]
[null,null,null,null,null,"X-axis label"]
[]
[]
[null,null,null,null,null,"Data Categories","Count"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total",{"$f":"SUM(G21:G41)","v":0}]
[null,null,"Number of Intervals in a Histogram "]
[null,null,"There is no rule for deciding the number of intervals, however the table below gives a rough guide. "]
[]
[null,null,"Number of observations ","Number of intervals (bins) recommended"]
[]
[null,null,"Less than 50 ","From 5 to 7 bins"]
[null,null,"Between 50 and 100","From 6 to 10 bins"]
[null,null,"Between 100 and 250","From 7 to 12 bins"]
[null,null,"More than 250","From 10 to 20 bins"]
[null,null,"Reference: Neviene Torki, \"Statistical Techniques - Process Improvement - The Link\", Published 1992. "]

{"sheet":"Histogram (2)","index":1,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":true,"merged":[[51,2,52,3],[45,3,46,3],[45,2,46,2],[14,6,14,7],[15,6,15,7],[16,6,16,7],[43,2,44,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Chart Title"]
[null,null,null,null,null,"Y Axis lable"]
[null,null,null,null,null,"X Axis Lable"]
[]
[]
[null,null,null,null,null,"Raw Data",null,"Bin Label / Range","Count"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I21:I41)","v":0}]
[null,null,"Number of Intervals in a Histogram "]
[null,null,"There is no rule for deciding the number of intervals, however the table below gives a rough guide. "]
[]
[null,null,"Number of observations ","Number of intervals (bins) recommended"]
[]
[null,null,"Less than 50 ","From 5 to 7 bins"]
[null,null,"Between 50 and 100","From 6 to 10 bins"]
[null,null,"Between 100 and 250","From 7 to 12 bins"]
[null,null,"More than 250","From 10 to 20 bins"]
[null,null,"Reference: Neviene Torki, \"Statistical Techniques - Process Improvement - The Link\", Published 1992. "]

{"sheet":"Interpreting a Histogram","index":2,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The shape of the histogram provides insights into how the data is distributed."]

{"sheet":"Example","index":3,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[40,2,41,3],[13,2,28,3],[14,6,14,7],[15,6,15,7],[16,6,16,7],[32,2,33,3],[34,2,35,2],[34,3,35,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This example displays the number of falls that occurred over a 12-month period on an aged care ward by the age range of the patients. \n\nThis example demonstrates a negative/right skew indicating that the older patients on the aged care ward have have the greatest number of falls, particularly for those aged between 85 and 89 years.\n\n"]
[null,null,null,null,null,"Chart Title","Age of patients who fell on aged care ward"]
[null,null,null,null,null,"Y Axis lable","Number of falls"]
[null,null,null,null,null,"X Axis Lable","Age categories "]
[]
[]
[null,null,null,null,null,"Bin Label / Range","Count"]
[null,null,null,null,null,"60 to 64 years",2]
[null,null,null,null,null,"65 to 69 years",1]
[null,null,null,null,null,"70 to 74 years",2]
[null,null,null,null,null,"75 to 79 years",6]
[null,null,null,null,null,"80 to 84 years",11]
[null,null,null,null,null,"85 to 89 years",13]
[null,null,null,null,null,"90 to 94 years",6]
[null,null,null,null,null,"95 to 99 years",0]
[null,null,null,null,null,"100 years and above",0]
[]
[]
[null,null,"Number of intervals in a histogram "]
[null,null,"There is no rule for deciding the number of categories, however the table below gives a rough guide. "]
[]
[null,null,"Number of observations ","Number of categories (bins) recommended"]
[]
[null,null,"Less than 50 ","From 5 to 7 bins"]
[null,null,"Between 50 and 100","From 6 to 10 bins"]
[null,null,"Between 100 and 250","From 7 to 12 bins"]
[null,null,"More than 250","From 10 to 20 bins"]
[null,null,"Reference: Neviene Torki, \"Statistical Techniques - Process Improvement - The Link\", Published 1992. "]
[null,null,null,null,null,"Total",{"$f":"SUM(G21:G41)","v":41}]