{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Scatter Plot Template Template","Histogram (2)","Interpreting a Scatter Plot"],"not_rendered":{"charts":2,"images":7,"macros":1,"external_links":0,"defined_names":3,"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":"Scatter Plot Template Template","index":0,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[[51,9,51,10],[49,12,50,12],[49,13,50,13],[48,12,48,13],[14,6,14,8],[15,6,15,8],[16,6,16,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Oberservation","X-axis\n(independent variable)","Y-axis\n(dependant variable)"]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,"",null,null,null,null,null,null,"Strength"]
[null,null,null,null,null,"",null,null,null,"Pearson's r",{"$f":"IF(AND(COUNT(G21:G63)>0, COUNT(H21:H63)>0), PEARSON(G21:G63, H21:H63), \"\")","v":""},null,"Size of Correlation of Pearsons r","Interpretation "]
[null,null,null,null,null,""]
[null,null,null,null,null,"",null,null,null,"Interpretation of Data",null,null,".9 to 1","Very Strong"]
[null,null,null,null,null,"",null,null,null,"Trend:  ","Positive/Negative",null,".7 to .9","Strong"]
[null,null,null,null,null,"",null,null,null,"Shape:  ","Linier/Non-linear",null,".5 to .7","Moderate"]
[null,null,null,null,null,"",null,null,null,"Strength:  ","Strong/Moderate/Weak ",null,".3 to .5","Weak "]
[null,null,null,null,null,"",null,null,null,null,null,null,"0 to .3","No relationship"]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]

{"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 Scatter Plot","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}