{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Title","Mode","Median v1","Median v2","Range","Interquartile Range","Percentiles","Mode-A","Median v1-A","Median v2-A","Range-A","Interquartile Range-A","Percentiles-A"],"not_rendered":{"charts":0,"images":4,"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":"Title","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,"Calculation practice activities to accompany\nCHAPTER 3"]
[]
[null,null,"Social Statistics in Action: A Canadian Introduction"]
[null,null,"Andrea M. Noack"]
[]
[null,null,"Oxford University Press, 2018"]
[]
[null,null,"For more information, visit: "]
[null,null,"https://www.oupcanada.com/catalog/9780199015214.html"]

{"sheet":"Mode","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[14,4,14,5],[10,4,12,5],[2,1,2,5],[1,6,1,9],[0,1,0,5]]}
[null,"PRACTICE FINDING THE MODE(S)"]
[]
[null,"Find the mode(s) of the values in the yellow highlighted cells. \nTo check your answer, click on the 'Show Answer' button."]
[]
[]
[null,"Case #","Value on\nVariable X"]
[null,1,15,null,"Mode 1:","hidden"]
[null,2,20,null,"Mode 2:","hidden"]
[null,3,15,null,"Mode 3:","hidden"]
[null,4,4]
[null,5,6,null,"If there are more than three modes \nin the data, only the three smallest \nwill be shown. "]
[null,6,17]
[null,7,7]
[null,8,13]
[null,9,17,null,"Need some help?"]
[null,10,15]
[null,11,17]
[null,12,7]
[]
[null,"FINDING THE MODE"]
[null,"The most number of times that any value appears is 3 times."]
[null,"Which values appear 3 time(s)?"]

{"sheet":"Median v1","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,6,1,9],[2,1,2,5],[9,4,9,5],[27,2,27,4]]}
[null,"PRACTICE FINDING THE MEDIAN \n(ODD NUMBER OF CASES)"]
[]
[null,"Find the median of the values in the yellow highlighted cells. \nTo check your answer, click on the 'Show Answer' button."]
[]
[]
[null,"Case #","Value on \nVariable X"]
[null,1,5,null,"Median:","hidden"]
[null,2,9]
[null,3,12]
[null,4,1,null,"Need some help?"]
[null,5,17]
[null,6,8]
[null,7,13]
[null,8,15]
[null,9,20]
[null,10,8]
[null,11,5]
[null,12,15]
[null,13,9]
[]
[null,"FINDING THE MEDIAN"]
[null,"Here are the values listed from from lowest to highest:"]
[null,1]
[null,5]
[null,5]
[null,8]
[null,8]
[null,9]
[null,9]
[null,12]
[null,13]
[null,15]
[null,15]
[null,17]
[null,20]

{"sheet":"Median v2","index":3,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,6,1,9],[2,1,2,5],[9,4,9,5]]}
[null,"PRACTICE FINDING THE MEDIAN \n(EVEN NUMBER OF CASES)"]
[]
[null,"Find the median of the values in the yellow highlighted cells. \nTo check your answer, click on the 'Show Answer' button."]
[]
[]
[null,"Case #","Value on\nVariable X"]
[null,1,10,null,"Median:","hidden"]
[null,2,17]
[null,3,19]
[null,4,18,null,"Need some help?"]
[null,5,17]
[null,6,17]
[null,7,8]
[null,8,2]
[null,9,13]
[null,10,6]
[null,11,7]
[null,12,2]
[]
[null,"FINDING THE MEDIAN"]
[null,"Here are the values listed from from lowest to highest:"]
[null,2]
[null,2]
[null,6]
[null,7]
[null,8]
[null,10]
[null,13]
[null,17]
[null,17]
[null,17]
[null,18]
[null,19]

{"sheet":"Range","index":4,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,6,1,9],[2,1,2,5],[11,4,11,5],[20,1,21,1]]}
[null,"PRACTICE FINDING THE RANGE "]
[]
[null,"Find the range of the values in the yellow highlighted cells. \nTo check your answer, click on the 'Show Answer' button."]
[]
[]
[null,"Case #","Value on\nVariable X"]
[null,1,8,null,"Minimum value:","hidden"]
[null,2,28,null,"Maximum value:","hidden"]
[null,3,15]
[null,4,29,null,"Range:","hidden"]
[null,5,2]
[null,6,13,null,"Need some help?"]
[null,7,11]
[null,8,3]
[null,9,20]
[null,10,23]
[null,11,11]
[null,12,18]
[null,null,null,null," "]
[null,"CALCULATING THE RANGE"]
[null,"Minimum &\nMaximum","Here are the values listed from from lowest to highest:"]
[null,null,2]
[null,null,3]
[null,null,8]
[null,null,11]
[null,null,11]
[null,null,13]
[null,null,15]
[null,null,18]
[null,null,20]
[null,null,23]
[null,null,28]
[null,null,29]
[null,"Range"]
[null,null,"= 29 - 2"]
[null,null,"= ?"]

{"sheet":"Interquartile Range","index":5,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,1,35,2],[37,1,38,2],[41,1,41,2],[0,1,0,6],[1,6,1,9],[2,1,2,6],[12,4,12,5],[19,1,19,2],[31,1,32,2]]}
[null,"PRACTICE FINDING THE INTERQUARTILE RANGE"]
[]
[null,"Find the interquartile range of the values in the yellow highlighted cells. \nTo check your answer, click on the 'Show Answer' button."]
[]
[]
[null,"Case #","Value on \nVariable X"]
[null,1,4,null,"25th percentile:",null,"hidden"]
[null,2,3,null,"75th percentile:",null,"hidden"]
[null,3,20]
[null,4,26,null,"Interquartile range:",null,"hidden"]
[null,5,18]
[null,6,24]
[null,7,29,null,"Need some help?"]
[null,8,4]
[null,9,14]
[null,10,18]
[null,11,18]
[null,null,null,null," "]
[null,"CALCULATING THE INTERQUARTILE RANGE"]
[null,"Find the position of each case",null,"Position","     Values listed from lowest to highest:"]
[null,null,null,1,3]
[null,null,null,2,4]
[null,null,null,3,4]
[null,null,null,4,14]
[null,null,null,5,18]
[null,null,null,6,18]
[null,null,null,7,18]
[null,null,null,8,20]
[null,null,null,9,24]
[null,null,null,10,26]
[null,null,null,11,29]
[null,"Find the position of the case at the \n25th percentile"]
[null,null,null,null,"= (11 + 1) x 0.25"]
[null,null,null,null,"= ? x ?"]
[null,null,null,"Position","= ?"]
[null,"Find the value of the 25th percentile",null,"The 25th percentile is the value of the case located in position 3"]
[null,null,null,"Thus, the 25th percentile is ?"]
[null,"Find the position of the case at the \n75th percentile"]
[null,null,null,null,"= (11 + 1) x 0.75"]
[null,null,null,null,"= ? x ?"]
[null,null,null,"Position","= ?"]
[null,"Find the value of the 75th percentile",null,"The 75th percentile is the value of the case located in position 9"]
[null,null,null,"Thus, the 75th percentile is ?"]
[null,"Interquartile Range",null,"= 75th percentile - 25th percentile"]
[null,null,null,"= 24 - 4"]
[null,null,null,"= ?"]

{"sheet":"Percentiles","index":6,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[51,1,52,2],[2,1,2,6],[0,1,0,6],[1,6,1,9],[11,4,11,5],[27,1,27,2],[47,1,48,2]]}
[null,"PRACTICE FINDING PERCENTILES"]
[]
[null,"Find the percentile specified in the green highlighted cell, \nfor the values in the yellow highlighted cells.\nTo check your answer, click on the 'Show Answer' button."]
[]
[]
[null,"Case #","Value on \nVariable X"]
[null,1,28,null,"Find this percentile:",null,"20th"]
[null,2,24]
[null,3,26,null,"Answer:",null,"hidden"]
[null,4,18]
[null,5,3]
[null,6,30,null,"Need some help?"]
[null,7,27]
[null,8,1]
[null,9,14]
[null,10,19]
[null,11,24]
[null,12,15]
[null,13,25]
[null,14,18]
[null,15,30]
[null,16,24]
[null,17,20]
[null,18,22]
[null,19,13]
[null,null,null,null," "]
[null,"FINDING A PERCENTILE"]
[null,"Find the position of each case",null,"Position","     Values listed from lowest to highest:"]
[null,null,null,1,1]
[null,null,null,2,3]
[null,null,null,3,13]
[null,null,null,4,14]
[null,null,null,5,15]
[null,null,null,6,18]
[null,null,null,7,18]
[null,null,null,8,19]
[null,null,null,9,20]
[null,null,null,10,22]
[null,null,null,11,24]
[null,null,null,12,24]
[null,null,null,13,24]
[null,null,null,14,25]
[null,null,null,15,26]
[null,null,null,16,27]
[null,null,null,17,28]
[null,null,null,18,30]
[null,null,null,19,30]
[null,"Find the position of the case at the specified percentile",null,null,"= (N + 1) x 0.2"]
[null,null,null,null,"= (19 + 1) x 0.2"]
[null,null,null,null,"= ? x ?"]
[null,null,null,"Position","= ?"]
[null,"Find the value of the specified \npercentile",null,"The 20th percentile is the value of the case located in position 4"]
[null,null,null,"Thus, the 20th percentile is ?"]

{"sheet":"Mode-A","index":7,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":true,"merged":[[0,1,0,5],[1,11,1,16],[2,1,2,5],[10,4,12,5],[14,4,14,5]]}
[null,"PRACTICE FINDING THE MODE(S)"]
[]
[null,"Find the mode(s) of the numbers in the yellow highlighted cells. \nTo check your answers, click on the 'Show Answers' button."]
[]
[]
[null,"Case #","Value"]
[{"$f":"RANDBETWEEN(1,20)","v":1},1,15,null,"Mode 1:",{"$f":"M7","v":15},null,{"$f":"COUNTIF($C$7:$C$18,C7)","v":3},1,{"$f":"IF(H7=$H$19,C7,\"\")","v":15},{"$f":"RANK(J7,$J$7:$J$18,1)","v":1},{"$f":"IF($H$21>=I7,MATCH(1+((I7-1)*$H$19),$K$7:$K$18,0),\"\")","v":1},{"$f":"IF(ISNUMBER(L7),INDEX($J$7:$J$18,L7),\"\")","v":15}]
[{"$f":"RANDBETWEEN(1,20)","v":4},2,20,null,"Mode 2:",{"$f":"IF($H$21>=2,M8,\"none\")","v":17},null,{"$f":"COUNTIF($C$7:$C$18,C8)","v":1},2,"",{"$f":"RANK(J8,$J$7:$J$18,1)","v":{"$error":"#VALUE!"}},{"$f":"IF($H$21>=I8,MATCH(1+((I8-1)*$H$19),$K$7:$K$18,0),\"\")","v":6},{"$f":"IF(ISNUMBER(L8),INDEX($J$7:$J$18,L8),\"\")","v":17}]
[8,3,15,null,"Mode 3:",{"$f":"IF($H$21>=3,M9,\"none\")","v":"none"},null,3,3,15,1,"",""]
[14,4,4,null,null,null,null,1,4,"",{"$error":"#VALUE!"},"",""]
[19,5,6,null,"If there are more than three modes \nin the data, only the three smallest \nwill be shown. ",null,null,1,5,"",{"$error":"#VALUE!"},"",""]
[5,6,17,null,null,null,null,3,6,17,4,"",""]
[10,7,7,null,null,null,null,2,7,"",{"$error":"#VALUE!"},"",""]
[9,8,13,null,null,null,null,1,8,"",{"$error":"#VALUE!"},"",""]
[17,9,17,null,"Need some help?",null,null,3,9,17,4,"",""]
[13,10,15,null,null,null,null,3,10,15,1,"",""]
[2,11,17,null,null,null,null,3,11,17,4,"",""]
[19,12,7,null,null,null,null,2,12,"",{"$error":"#VALUE!"},"",""]
[null,null,null,null,null,null,null,{"$f":"MAX($H$7:$H$18)","v":3}]
[null,"IDENTIFYING THE MODE",null,null,null,null,null,{"$f":"COUNTIF(H7:H18,H19)","v":6}]
[null,{"$f":"IF($H$19=1,F21,IF($H$19>1,G21,\"\"))","v":"'The most number of times that any value appears is 3 times."},null,null,null,{"$f":"CONCATENATE(\"'The most number of times that any value appears is \",$H$19,\" time.\")","v":"'The most number of times that any value appears is 3 time."},{"$f":"CONCATENATE(\"'The most number of times that any value appears is \",$H$19,\" times.\")","v":"'The most number of times that any value appears is 3 times."},{"$f":"H20/H19","v":2}]
[null,{"$f":"IF($H$21=1,F22,IF($H$21>1,G22,\"\"))","v":"'The following values appear 3 time(s):"},null,null,null,{"$f":"CONCATENATE(\"'The following value appears \",$H$19,\" time(s):\")","v":"'The following value appears 3 time(s):"},{"$f":"CONCATENATE(\"'The following values appear \",$H$19,\" time(s):\")","v":"'The following values appear 3 time(s):"}]
[null,{"$f":"IF($H$21>=I7,M7,\"\")","v":15},{"$f":"IF($H$21>=I13,M13,\"\")","v":""},null,null,{"$f":"CONCATENATE(\"'Which value appears \",$H$19,\" time(s)?\")","v":"'Which value appears 3 time(s)?"},{"$f":"CONCATENATE(\"'Which values appear \",$H$19,\" time(s)?\")","v":"'Which values appear 3 time(s)?"}]
[null,{"$f":"IF($H$21>=I8,M8,\"\")","v":17},{"$f":"IF($H$21>=I14,M14,\"\")","v":""},null,null,{"$f":"IF($H$21=1,F23,IF($H$21>1,G23,\"\"))","v":"'Which values appear 3 time(s)?"}]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]

{"sheet":"Median v1-A","index":8,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":true,"merged":[[0,1,0,5],[1,6,1,9],[2,1,2,5],[9,4,9,5],[28,2,28,4]]}
[null,"PRACTICE FINDING THE MEDIAN \n(ODD NUMBER OF CASES)"]
[]
[null,"Find the mode(s) of the numbers in the yellow highlighted cells. \nTo check your answers, click on the 'Show Answers' button."]
[]
[]
[null,"Case #","Value"]
[{"$f":"RANDBETWEEN(1,20)","v":13},1,5,null,"Median:",{"$f":"$I$13","v":9},null,1,{"$f":"SMALL($C$7:$C$19,H7)","v":1}]
[{"$f":"RANDBETWEEN(1,20)","v":13},2,9,null,null,null,null,2,{"$f":"SMALL($C$7:$C$19,H8)","v":5}]
[5,3,12,null,null,null,null,3,5]
[1,4,1,null,"Need some help?",null,null,4,8]
[2,5,17,null,null,null,null,5,8]
[8,6,8,null,null,null,null,6,9]
[15,7,13,null,null,null,null,7,9]
[6,8,15,null,null,null,null,8,12]
[11,9,20,null,null,null,null,9,13]
[17,10,8,null,null,null,null,10,15]
[3,11,5,null,null,null,null,11,15]
[7,12,15,null,null,null,null,12,17]
[8,13,9,null,null,null,null,13,20]
[]
[null,"IDENTIFYING THE MEDIAN"]
[null,"Here are the values listed from from lowest to highest:"]
[null,{"$f":"I7","v":1}]
[null,{"$f":"I8","v":5}]
[null,5]
[null,8]
[null,8]
[null,9]
[null,9,{"$f":"CONCATENATE(\"'     <--   The median is \",$I$13)","v":"'     <--   The median is 9"}]
[null,12]
[null,13]
[null,15]
[null,15]
[null,17]
[null,20]

{"sheet":"Median v2-A","index":9,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,1,0,5],[1,6,1,9],[2,1,2,5],[9,4,9,5]]}
[null,"PRACTICE FINDING THE MEDIAN \n(ODD NUMBER OF CASES)"]
[]
[null,"Find the mode(s) of the numbers in the yellow highlighted cells. \nTo check your answers, click on the 'Show Answers' button."]
[]
[]
[null,"Case #","Value"]
[{"$f":"RANDBETWEEN(1,20)","v":3},1,10,null,"Median:",{"$f":"$J$12","v":11.5},null,1,{"$f":"SMALL($C$7:$C$18,H7)","v":2}]
[{"$f":"RANDBETWEEN(1,20)","v":13},2,17,null,null,null,null,2,2]
[1,3,19,null,null,null,null,3,6]
[16,4,18,null,"Need some help?",null,null,4,7]
[9,5,17,null,null,null,null,5,8]
[13,6,17,null,null,null,null,6,10,{"$f":"((I12+I13)/2)","v":11.5}]
[7,7,8,null,null,null,null,7,13]
[2,8,2,null,null,null,null,8,17]
[8,9,13,null,null,null,null,9,17]
[9,10,6,null,null,null,null,10,17]
[10,11,7,null,null,null,null,11,18]
[16,12,2,null,null,null,null,12,19]
[]
[null,"IDENTIFYING THE MEDIAN"]
[null,"Here are the values listed from from lowest to highest:"]
[null,{"$f":"I7","v":2}]
[null,2]
[null,6]
[null,7]
[null,8]
[null,10,{"$f":"CONCATENATE(\"'     <--        The median is halfway between \",$I$12,\" and \",I13)","v":"'     <--        The median is halfway between 10 and 13"}]
[null,13,{"$f":"CONCATENATE(\"'     <--        Since (\",I12,\" + \",I13,\") ÷ 2 = \",J12,\", the median is \",J12)","v":"'     <--        Since (10 + 13) ÷ 2 = 11.5, the median is 11.5"}]
[null,17]
[null,17]
[null,17]
[null,18]
[null,19]

{"sheet":"Range-A","index":10,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":true,"merged":[[32,4,32,6],[0,1,0,5],[1,6,1,9],[2,1,2,5],[11,4,11,5],[20,1,21,1],[21,4,21,6]]}
[null,"PRACTICE FINDING THE RANGE "]
[]
[null,"Find the median of the numbers in the yellow highlighted cells. \nTo check your answer, click on the 'Show Answer' button."]
[]
[]
[null,"Case #","Value"]
[{"$f":"RANDBETWEEN(1,30)","v":16},1,8,null,"Minimum:",{"$f":"J7","v":2},null,null,1,{"$f":"SMALL($C$7:$C$18,I7)","v":2}]
[{"$f":"RANDBETWEEN(1,30)","v":11},2,28,null,"Maximum:",{"$f":"J18","v":29},null,null,2,3]
[17,3,15,null,null,null,null,null,3,8]
[28,4,29,null,"Range:",{"$f":"J19","v":27},null,null,4,11]
[11,5,2,null,null,null,null,null,5,11]
[29,6,13,null,"Need some help?",null,null,null,6,13]
[17,7,11,null,null,null,null,null,7,15]
[26,8,3,null,null,null,null,null,8,18]
[5,9,20,null,null,null,null,null,9,20]
[6,10,23,null,null,null,null,null,10,23]
[21,11,11,null,null,null,null,null,11,28]
[16,12,18,null,null,null,null,null,12,29]
[null,null,null,null," ",null,null,null,null,{"$f":"J18-J7","v":27}]
[null,"CALCULATING THE RANGE"]
[null,"Minimum &\nMaximum","Here are the values listed from from lowest to highest:"]
[null,null,{"$f":"J7","v":2},null,{"$f":"CONCATENATE(\"'     <--   The minimum is \",$J$7)","v":"'     <--   The minimum is 2"}]
[null,null,{"$f":"J8","v":3}]
[null,null,8]
[null,null,11]
[null,null,11]
[null,null,13]
[null,null,15]
[null,null,18]
[null,null,20]
[null,null,23]
[null,null,28]
[null,null,29,null,{"$f":"CONCATENATE(\"'     <--   The maximum is \",$J$18)","v":"'     <--   The maximum is 29"}]
[null,"Range","= maximum - minimum"]
[null,null,{"$f":"CONCATENATE(\"'= \",J18,\" - \", J7)","v":"'= 29 - 2"}]
[null,null,{"$f":"CONCATENATE(\"'= \",J19)","v":"'= 27"}]

{"sheet":"Interquartile Range-A","index":11,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":true,"merged":[[35,1,35,2],[37,1,38,2],[41,1,41,2],[0,1,0,6],[1,6,1,9],[2,1,2,6],[12,4,12,5],[19,1,19,2],[31,1,32,2]]}
[null,"PRACTICE FINDING THE INTERQUARTILE RANGE"]
[]
[null,"Find the interquartile range of the numbers in the yellow highlighted cells. \nTo check your answer, click on the 'Show Answer' button."]
[]
[]
[null,"Case #","Value"]
[{"$f":"RANDBETWEEN(1,30)","v":24},1,4,null,"25th percentile:",null,{"$f":"$J$9","v":4},null,1,{"$f":"SMALL($C$7:$C$17,I7)","v":3}]
[{"$f":"RANDBETWEEN(1,30)","v":2},2,3,null,"75th percentile:",null,{"$f":"$J$15","v":24},null,2,{"$f":"SMALL($C$7:$C$17,I8)","v":4}]
[24,3,20,null,null,null,null,null,3,4]
[19,4,26,null,"Interquartile range:",null,{"$f":"$J$18","v":20},null,4,14]
[15,5,18,null,null,null,null,null,5,18]
[22,6,24,null,null,null,null,null,6,18]
[25,7,29,null,"Need some help?",null,null,null,7,18]
[14,8,4,null,null,null,null,null,8,20]
[3,9,14,null,null,null,null,null,9,24]
[29,10,18,null,null,null,null,null,10,26]
[10,11,18,null,null,null,null,null,11,29]
[null,null,null,null," ",null,null,null,null,{"$f":"$J$15-$J$9","v":20}]
[null,"CALCULATING THE INTERQUARTILE RANGE"]
[null,"Find the position of each case",null,"Position","     Values listed from lowest to highest:"]
[null,null,null,1,{"$f":"J7","v":3}]
[null,null,null,2,{"$f":"J8","v":4}]
[null,null,null,3,4]
[null,null,null,4,14]
[null,null,null,5,18]
[null,null,null,6,18]
[null,null,null,7,18]
[null,null,null,8,20]
[null,null,null,9,24]
[null,null,null,10,26]
[null,null,null,11,{"$f":"J17","v":29}]
[null,"Find the position of the case at the 25th percentile",null,null,"= (N + 1) x 0.25"]
[null,null,null,null,"= (11 + 1) x 0.25"]
[null,null,null,null,"'= 12 x 0.25"]
[null,null,null,"Position","'= 3"]
[null,"Find the value of the 25th percentile",null,"The 25th percentile is the value of the case located in position 3"]
[null,null,null,{"$f":"CONCATENATE(\"'Thus, the 25th percentile is \",$J$9)","v":"'Thus, the 25th percentile is 4"},null,null,null,"Thus, the 25th percentile is ?"]
[null,"Find the position of the case at the 75th percentile",null,null,"= (N + 1) x 0.75"]
[null,null,null,null,"= (11 + 1) x 0.75"]
[null,null,null,null,"'= 12 x 0.75"]
[null,null,null,"Position","'= 9"]
[null,"Find the value of the 75th percentile",null,"The 75th percentile is the value of the case located in position 9"]
[null,null,null,{"$f":"CONCATENATE(\"'Thus, the 75th percentile is \",$J$15)","v":"'Thus, the 75th percentile is 24"},null,null,null,"Thus, the 75th percentile is ?"]
[null,"Interquartile Range",null,"= 75th percentile - 25th percentile"]
[null,null,null,{"$f":"CONCATENATE(\"'= \",$J$15,\" - \",$J$9)","v":"'= 24 - 4"}]
[null,null,null,{"$f":"CONCATENATE(\"'= \",$J$18)","v":"'= 20"}]

{"sheet":"Percentiles-A","index":12,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":true,"merged":[[51,1,52,2],[0,1,0,6],[1,6,1,9],[2,1,2,6],[11,4,11,5],[27,1,27,2],[47,1,48,2]]}
[null,"PRACTICE FINDING PERCENTILES"]
[]
[]
[]
[]
[null,"Case #","Value",null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(1,19)","v":7}]
[{"$f":"RANDBETWEEN(1,30)","v":15},1,28,null,"Find this percentile:",null,{"$f":"M7","v":"20th"},null,0.05,"5th",4,{"$f":"INDEX(I7:I25,K7)","v":0.2},{"$f":"INDEX(J7:J25,K7)","v":"20th"},1,{"$f":"SMALL($C$7:$C$25,N7)","v":1}]
[{"$f":"RANDBETWEEN(1,30)","v":1},2,24,null,null,null,null,null,{"$f":"I7+0.05","v":0.1},"10th",null,null,null,2,{"$f":"SMALL($C$7:$C$25,N8)","v":3}]
[7,3,26,null,"Answer:",null,{"$f":"H53","v":14},null,{"$f":"I8+0.05","v":0.15000000000000002},"15th",null,null,null,3,13]
[28,4,18,null,null,null,null,null,0.2,"20th",null,null,null,4,14]
[20,5,3,null,null,null,null,null,0.25,"25th",null,null,null,5,15]
[17,6,30,null,"Need some help?",null,null,null,0.3,"30th",null,null,null,6,18]
[13,7,27,null,null,null,null,null,0.35,"35th",null,null,null,7,18]
[27,8,1,null,null,null,null,null,0.39999999999999997,"40th",null,null,null,8,19]
[3,9,14,null,null,null,null,null,0.44999999999999996,"45th",null,null,null,9,20]
[9,10,19,null,null,null,null,null,0.49999999999999994,"50th",null,null,null,10,22]
[4,11,24,null,null,null,null,null,0.54999999999999993,"55th",null,null,null,11,24]
[{"$f":"RANDBETWEEN(1,30)","v":5},12,15,null,null,null,null,null,0.6,"60th",null,null,null,12,24]
[21,13,25,null,null,null,null,null,0.65,"65th",null,null,null,13,24]
[6,14,18,null,null,null,null,null,0.70000000000000007,"70th",null,null,null,14,25]
[20,15,30,null,null,null,null,null,0.75000000000000011,"75th",null,null,null,15,26]
[16,16,24,null,null,null,null,null,0.80000000000000016,"80th",null,null,null,16,27]
[17,17,20,null,null,null,null,null,0.8500000000000002,"85th",null,null,null,17,28]
[14,18,22,null,null,null,null,null,0.90000000000000024,"90th",null,null,null,18,30]
[20,19,13,null,null,null,null,null,0.95000000000000029,"95th ",null,null,null,19,30]
[null,null,null,null," "]
[null,"FINDING A PERCENTILE"]
[null,"Find the position of each case",null,"Position","     Values listed from lowest to highest:"]
[null,null,null,1,{"$f":"O7","v":1}]
[null,null,null,2,{"$f":"O8","v":3}]
[null,null,null,3,13]
[null,null,null,4,14]
[null,null,null,5,15]
[null,null,null,6,18]
[null,null,null,7,18]
[null,null,null,8,19]
[null,null,null,9,20]
[null,null,null,10,22]
[null,null,null,11,24]
[null,null,null,12,24]
[null,null,null,13,24]
[null,null,null,14,25]
[null,null,null,15,26]
[null,null,null,16,27]
[null,null,null,17,28]
[null,null,null,18,30]
[null,null,null,19,30]
[null,"Find the position of the case at the specified percentile",null,null,{"$f":"CONCATENATE(\"'= (N + 1) x \",$L$7)","v":"'= (N + 1) x 0.2"}]
[null,null,null,null,{"$f":"CONCATENATE(\"'= (19 + 1) x \",$L$7)","v":"'= (19 + 1) x 0.2"}]
[null,null,null,null,{"$f":"CONCATENATE(\"'= 20 x \",$L$7)","v":"'= 20 x 0.2"}]
[null,null,null,"Position",{"$f":"CONCATENATE(\"'= \",H51)","v":"'= 4"},null,null,{"$f":"20*L7","v":4}]
[null,"Find the value of the specified \npercentile",null,{"$f":"CONCATENATE(\"The \",$M$7,\" percentile is the value of the case located in position \",$H$51)","v":"The 20th percentile is the value of the case located in position 4"},null,null,null,null,{"$f":"CONCATENATE(\"The \",$M$7,\" percentile is the value of the case located in position \",$H$51)","v":"The 20th percentile is the value of the case located in position 4"}]
[null,null,null,{"$f":"CONCATENATE(\"Thus, the \",$M$7,\" percentile is \",$H$53)","v":"Thus, the 20th percentile is 14"},null,null,null,{"$f":"INDEX(O7:O25,H51)","v":14},{"$f":"CONCATENATE(\"Thus, the \",$M$7,\" percentile is ?\")","v":"Thus, the 20th percentile is ?"}]