{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["index","5 positives","Find the 5","4 positives","Find the 4","5 integers","Find the 5 integers","4 integers","Find the 4 integers","freq table","pie chart","2 way","large 2 way"],"not_rendered":{"charts":1,"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":"index","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"AVERAGES, PIE CHARTS AND TWO-WAY TABLES"]
[1,"5 positives -  find the mean, mode, median and range  "]
[2,"Find the 5 numbers - given the averages and range"]
[3,"4 positives -  find the mean, mode, median and range - watch that median!"]
[4,"Find the 4 numbers - given the averages and range"]
[5,"5 integers -  find the mean, mode, median and range  "]
[6,"Find the 5 integers - given the averages and range"]
[7,"4 integers -  find the mean, mode, median and range - watch that median!"]
[8,"Find the 4 integers - given the averages and range"]
[9,"Frequency table - find the mean"]
[10,"Pie chart - calculate the angles"]
[11,"2 way tables - find the missing numbers"]
[12,"Larger 2 way tables - find the missing numbers"]
[null,"© Copyright 2004 S.A.Lomax, M.J.Nixon.  All Rights Reserved."]

{"sheet":"5 positives","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,8,10,9],[11,8,11,9]]}
[]
[null,null,null,null,null,"Find the mean, median, mode and range of these numbers"]
[]
[null,null,null,{"$f":"1+INT(20*RAND())","v":13},{"$f":"1+INT(20*RAND())","v":6},{"$f":"1+INT(20*RAND())","v":16},{"$f":"1+INT(20*RAND())","v":19},{"$f":"1+INT(20*RAND())","v":1}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Mean:",{"$f":"AVERAGE(D4:H4)","v":11},{"$f":"IF(AVERAGE(D4:H4)=INT(AVERAGE(D4:H4)),\"\",\"(1dp)\")","v":""},null,"Mode:",{"$f":"MODE(D4:H4)","v":{"$error":"#N/A"}}]
[null,null,null,"Median:",{"$f":"MEDIAN(D4:H4)","v":13},null,null,"Range:",{"$f":"MAX(D4:H4)-MIN(D4:H4)","v":18}]

{"sheet":"Find the 5","index":2,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Find five numbers with mean, median, mode and range"]
[null,null,null,null,null,null,null,"as shown below"]
[]
[null,null,null,"Mean:",null,{"$f":"AVERAGE(D12,F12,H12,J12,L12)","v":11.8},{"$f":"IF(AVERAGE(D12,F12,H12,J12,L12)=INT(AVERAGE(D12,F12,H12,J12,L12)),\"\",\"(1dp)\")","v":"(1dp)"},null,null,"Mode:",null,{"$f":"MODE(D12,F12,H12,J12,L12)","v":15}]
[null,null,null,"Median:",null,{"$f":"MEDIAN(D12,F12,H12,J12,L12)","v":13},null,null,null,"Range:",null,{"$f":"MAX(D12,F12,H12,J12,L12)-MIN(D12,F12,H12,J12,L12)","v":9}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"1+INT(20*RAND())","v":10},",",15,",",15,",",13,",",6]

{"sheet":"4 positives","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,7,10,9],[11,7,11,9]]}
[]
[null,null,null,null,null,"Find the mean, median, mode and range of these numbers"]
[]
[null,null,null,{"$f":"1+INT(20*RAND())","v":3},{"$f":"1+INT(20*RAND())","v":16},{"$f":"1+INT(20*RAND())","v":16},{"$f":"1+INT(20*RAND())","v":17}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Mean:",{"$f":"AVERAGE(D4:G4)","v":13},{"$f":"IF(AVERAGE(D4:G4)=INT(AVERAGE(D4:G4)),\"\",\"(1dp)\")","v":""},"Mode:",{"$f":"MODE(D4:G4)","v":16}]
[null,null,null,"Median:",{"$f":"MEDIAN(D4:G4)","v":16},null,"Range:",{"$f":"MAX(D4:G4)-MIN(D4:G4)","v":14}]

{"sheet":"Find the 4","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Find five numbers with mean, median, mode and range"]
[null,null,null,null,null,null,null,"as shown below"]
[]
[null,null,null,"Mean:",null,{"$f":"AVERAGE(D12,F12,H12,J12)","v":10.25},{"$f":"IF(AVERAGE(D12,F12,H12,J12)=INT(AVERAGE(D12,F12,H12,J12)),\"\",\"(1dp)\")","v":"(1dp)"},null,null,"Mode:",null,{"$f":"MODE(D12,F12,H12,J12)","v":{"$error":"#N/A"}}]
[null,null,null,"Median:",null,{"$f":"MEDIAN(D12,F12,H12,J12)","v":9.5},null,null,null,"Range:",null,{"$f":"MAX(D12,F12,H12,J12)-MIN(D12,F12,H12,J12)","v":14}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"1+INT(20*RAND())","v":4},",",{"$f":"1+INT(20*RAND())","v":9},",",{"$f":"1+INT(20*RAND())","v":18},",",{"$f":"1+INT(20*RAND())","v":10}]

{"sheet":"5 integers","index":5,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,8,10,9],[11,8,11,9]]}
[]
[null,null,null,null,null,"Find the mean, median, mode and range of these numbers"]
[]
[null,null,null,{"$f":"1+INT(20*RAND())","v":11},{"$f":"-10+INT(20*RAND())","v":6},{"$f":"1+INT(20*RAND())","v":2},{"$f":"1+INT(20*RAND())","v":14},{"$f":"-20+INT(20*RAND())","v":-19}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Mean:",{"$f":"AVERAGE(D4:H4)","v":2.8},{"$f":"IF(AVERAGE(D4:H4)=INT(AVERAGE(D4:H4)),\"\",\"(1dp)\")","v":"(1dp)"},null,"Mode:",{"$f":"MODE(D4:H4)","v":{"$error":"#N/A"}}]
[null,null,null,"Median:",{"$f":"MEDIAN(D4:H4)","v":6},null,null,"Range:",{"$f":"MAX(D4:H4)-MIN(D4:H4)","v":33}]

{"sheet":"Find the 5 integers","index":6,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Find five numbers with mean, median, mode and range"]
[null,null,null,null,null,null,null,"as shown below"]
[]
[null,null,null,"Mean:",null,{"$f":"AVERAGE(D12,F12,H12,J12,L12)","v":6.4},{"$f":"IF(AVERAGE(D12,F12,H12,J12,L12)=INT(AVERAGE(D12,F12,H12,J12,L12)),\"\",\"(1dp)\")","v":"(1dp)"},null,null,"Mode:",null,{"$f":"MODE(D12,F12,H12,J12,L12)","v":{"$error":"#N/A"}}]
[null,null,null,"Median:",null,{"$f":"MEDIAN(D12,F12,H12,J12,L12)","v":4},null,null,null,"Range:",null,{"$f":"MAX(D12,F12,H12,J12,L12)-MIN(D12,F12,H12,J12,L12)","v":23}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"1+INT(20*RAND())","v":16},",",{"$f":"-10+INT(20*RAND())","v":-5},",",{"$f":"1+INT(20*RAND())","v":18},",",{"$f":"-20+INT(20*RAND())","v":-1},",",{"$f":"1+INT(20*RAND())","v":4}]

{"sheet":"4 integers","index":7,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,7,10,9],[11,7,11,9]]}
[]
[null,null,null,null,null,"Find the mean, median, mode and range of these numbers"]
[]
[null,null,null,{"$f":"1+INT(20*RAND())","v":7},{"$f":"-10+INT(20*RAND())","v":-2},{"$f":"1+INT(20*RAND())","v":15},{"$f":"-20+INT(20*RAND())","v":-18}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Mean:",{"$f":"AVERAGE(D4:G4)","v":0.5},{"$f":"IF(AVERAGE(D4:G4)=INT(AVERAGE(D4:G4)),\"\",\"(1dp)\")","v":"(1dp)"},"Mode:",{"$f":"MODE(D4:G4)","v":{"$error":"#N/A"}}]
[null,null,null,"Median:",{"$f":"MEDIAN(D4:G4)","v":2.5},null,"Range:",{"$f":"MAX(D4:G4)-MIN(D4:G4)","v":33}]

{"sheet":"Find the 4 integers","index":8,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Find five numbers with mean, median, mode and range"]
[null,null,null,null,null,null,null,"as shown below"]
[]
[null,null,null,"Mean:",null,{"$f":"AVERAGE(D12,F12,H12,J12)","v":1.5},{"$f":"IF(AVERAGE(D12,F12,H12,J12)=INT(AVERAGE(D12,F12,H12,J12)),\"\",\"(1dp)\")","v":"(1dp)"},null,null,"Mode:",null,{"$f":"MODE(D12,F12,H12,J12)","v":{"$error":"#N/A"}}]
[null,null,null,"Median:",null,{"$f":"MEDIAN(D12,F12,H12,J12)","v":1.5},null,null,null,"Range:",null,{"$f":"MAX(D12,F12,H12,J12)-MIN(D12,F12,H12,J12)","v":19}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"1+INT(20*RAND())","v":3},",",{"$f":"-10+INT(20*RAND())","v":0},",",{"$f":"1+INT(20*RAND())","v":11},",",{"$f":"-20+INT(20*RAND())","v":-8}]

{"sheet":"freq table","index":9,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,7,10,9],[11,7,11,9]]}
[]
[null,"Find the mean of the data in the frequency table"]
[null,null,"x",{"$f":"1+INT(20*RAND())","v":14},{"$f":"D3+1","v":15},{"$f":"E3+1","v":16},{"$f":"F3+1","v":17}]
[null,null,"f",{"$f":"1+INT(10*RAND())","v":4},{"$f":"1+INT(10*RAND())","v":10},{"$f":"1+INT(10*RAND())","v":5},{"$f":"1+INT(10*RAND())","v":8}]
[]
[]
[]
[]
[]
[]
[null,null,"Mean:",{"$f":"SUM(D3*D4,E3*E4,F3*F4,G3*G4)/SUM(D4:G4)","v":15.62962962962963},"(2dp)"]

{"sheet":"pie chart","index":10,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,7,10,9],[11,7,11,9]]}
[]
[null,"Calculate the angles needed to construct a pie chart"]
[null,null,"x",{"$f":"1+INT(20*RAND())","v":5},{"$f":"D3+1","v":6},{"$f":"E3+1","v":7},{"$f":"F3+1","v":8}]
[null,null,"f",{"$f":"1+INT(10*RAND())","v":10},{"$f":"1+INT(10*RAND())","v":10},{"$f":"1+INT(10*RAND())","v":9},{"$f":"1+INT(10*RAND())","v":10}]
[]
[]
[]
[]
[]
[]
[null,null,"Angle:",{"$f":"(D4/SUM($D4:$G4))*360","v":92.307692307692292},{"$f":"(E4/SUM($D4:$G4))*360","v":92.307692307692292},{"$f":"(F4/SUM($D4:$G4))*360","v":83.07692307692308},{"$f":"(G4/SUM($D4:$G4))*360","v":92.307692307692292}]

{"sheet":"2 way","index":11,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,5]]}
[null,null,"Find the missing values in the two-way table"]
[null,null,null,"Left-handed","Right-handed"]
[null,null,"Male",{"$f":"1+INT(10*RAND())","v":7}]
[null,null,"Female",null,null,{"$f":"36+INT(20*RAND())","v":49}]
[null,null,null,{"$f":"20-D3","v":13},{"$f":"6*D5","v":78}]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"E5-E12","v":35},{"$f":"D3+E11","v":42}]
[null,null,null,{"$f":"D5-D3","v":6},{"$f":"F4-D12","v":43}]

{"sheet":"large 2 way","index":12,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,6]]}
[null,null,"Find the missing values in the two-way table"]
[null,null,null,"Yes","No","Don't Know"]
[null,null,"Male",{"$f":"1+INT(10*RAND())","v":5},null,null,{"$f":"D5+E5+F5-G4","v":80}]
[null,null,"Female",null,null,{"$f":"16+INT(20*RAND())","v":33},{"$f":"70+INT(20*RAND())","v":81}]
[null,null,null,{"$f":"30-D3","v":25},{"$f":"35+D5","v":60},{"$f":"70+INT(20*RAND())","v":76}]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"G3-F11-D3","v":32},{"$f":"F5-F4","v":43}]
[null,null,null,{"$f":"D5-D3","v":20},{"$f":"E5-E11","v":28}]