{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Probability"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Probability","index":0,"n_rows":68,"n_cols":63,"rows_kept":68,"cut":false,"hidden":false,"merged":[[13,4,13,6],[35,31,35,33],[39,31,39,33],[50,15,50,16],[1,1,5,42],[11,10,11,12],[13,10,13,12],[11,15,11,28],[23,7,23,8],[24,7,24,8],[50,10,50,13],[46,10,46,16],[47,15,47,16],[47,10,47,13],[48,10,48,13],[48,15,48,16],[66,31,66,33],[62,31,62,33],[57,7,57,8],[49,10,49,13],[27,7,27,8],[56,33,56,35],[49,15,49,16],[54,21,54,23],[15,12,15,13],[29,23,29,25],[22,7,22,8],[25,7,25,8],[26,7,26,8]]}
[]
[null,"Level 3/4 Maths - Probability                                                                                                                                                                   Created by Mr.Lafferty@mathsrevision.com"]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q1.  There are 52 cards in standard pack of playing cards.\"","v":"Q1.  There are 52 cards in standard pack of playing cards."},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,{"$f":"ROUND(AVERAGE(H13:I17),1)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"\"What is the probability that if you pick a card at random\"","v":"What is the probability that if you pick a card at random"}]
[null,null,{"$f":"\"that is will be\"","v":"that is will be"},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,{"$f":"AI10-AJ10","v":0},null,{"$f":"MAX(H13:I17)","v":0},{"$f":"MIN(H13:I17)","v":0}]
[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,{"$f":"ROUND(RAND()*(3-0)+0,0)","v":3}]
[null,null,{"$f":"\" (a)   \"&BB12&\" of \"&BC12&\" .\"","v":" (a)   2 of spades ."},null,null,null,null,null,null,null,null,null,null,null,null,"General Information for Question",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,1.9230769230769232E-2,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":2},{"$f":"IF(BC11=3,\"spades\",IF(BC11=2,\"clubs\",IF(BC11=1,\"diamonds\",\"hearts\")))","v":"spades"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 suites spade,diamond,clubs and hearts"]
[null,null,"(b)",null,{"$f":"BC15","v":"Black"},null,null,null,null,null,null,null,null,null,null,"2 red and 2 black suites",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,{"$f":"BC16","v":0.5},null,null,{"$f":"ROUND(RAND()*(3-0)+0,0)","v":0},null,null,null,{"$f":"ROUND(RAND()*(3-0)+0,0)","v":2},{"$f":"ROUND(RAND()*(10-2)+2,0)","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 face cards in each suite and have a value on 10",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,{"$f":"IF(BC14=3,\"Even\",IF(BC14=2,\"Odd\",IF(BC14=1,\"Red\",\"Black\")))","v":"Black"},null,null,null,{"$f":"IF(BG14=3,\"Greater than\",IF(BG14=2,\"Less than\",IF(BG14=1,\"Greater than or equal to\",\"Less than or equal to\")))","v":"Less than"}]
[null,null,{"$f":"\"(c)  \"&BG15&\" \"&BH14","v":"(c)  Less than 8"},null,null,null,null,null,null,null,null,null,null,null,null,"Aces count as 1",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,{"$f":"BG16","v":0.53846153846153844},null,null,{"$f":"IF(BC14=3,32/52,IF(BC14=2,20/52,IF(BC14=1,0.5,0.5)))","v":0.5},null,null,null,{"$f":"IF(BG14=3,(13-BH14)*4/52,IF(BG14=2,(BH14-1)*4/52,IF(BG14=1,(13-BH14+1)*4/52,(BH14*4/52))))","v":0.53846153846153844}]
[]
[]
[]
[null,{"$f":"\"Q2.   The number of planes arriving at Glasgow airport from different countries is given below.\"","v":"Q2.   The number of planes arriving at Glasgow airport from different countries is given below."}]
[]
[null,null,"Country",null,null,null,null,"Frequency",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,"Number","Country"]
[null,null,"France",null,null,null,null,{"$f":"ROUND(RAND()*(20-9)+9,0)","v":13},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,{"$f":"ROUND(RAND()*(6-1)+1,0)","v":5},1,{"$f":"C23","v":"France"},{"$f":"H23","v":13}]
[null,null,"Spain",null,null,null,null,10,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,2,"Spain",10]
[null,null,"Germany",null,null,null,null,15,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,3,"Germany",15]
[null,null,"Turkey",null,null,null,null,16,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,4,"Turkey",16]
[null,null,"Holland",null,null,null,null,19,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,5,"Holland",19]
[null,null,"Portugal",null,null,null,null,13,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,6,"Portugal",13]
[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,{"$f":"SUM(AN23:AN28)","v":86}]
[null,null,"What is the probability that a plane chosen at random",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,{"$f":"AN30/AN29","v":0.22093023255813954},null,null,null,null,null,null,{"$f":"LOOKUP(AK23,AL23:AL28,AN23:AN28)","v":19}]
[null,null,{"$f":"\"came from \"&AI31&\" . \"","v":"came from Holland . "},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,{"$f":"LOOKUP(AK23,AL23:AL28,AM23:AM28)","v":"Holland"}]
[]
[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,{"$f":"ROUND(AVERAGE(H38:I40),2)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"\"Q3.   Danielle's bag of sweets contain \"&BG35&\" yellow \"&BH35&\" purple,\"&BI35&\" red and \"&BJ35&\" pink sweets.\"","v":"Q3.   Danielle's bag of sweets contain 2 yellow 6 purple,3 red and 5 pink sweets."},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,{"$f":"IF($BG$38=3,BG35-1,BG35)","v":1},{"$f":"IF($BG$38=2,BH35-1,BH35)","v":6},{"$f":"IF($BG$38=1,BI35-1,BI35)","v":3},{"$f":"IF($BG$38=0,BJ35-1,BJ35)","v":5},{"$f":"SUM(BG34:BJ34)","v":15}]
[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,{"$f":"AI35-AJ35","v":0},null,{"$f":"MAX(H38:I40)","v":0},{"$f":"MIN(H38:I40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(10-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(10-1)+1,0)","v":6},{"$f":"ROUND(RAND()*(10-1)+1,0)","v":3},{"$f":"ROUND(RAND()*(10-1)+1,0)","v":5},{"$f":"SUM(BG35:BJ35)","v":16}]
[null,null,{"$f":"\"The corner of the bag is torn and a sweet falls out. What is the probability it will be \"&BG37&\".\"","v":"The corner of the bag is torn and a sweet falls out. What is the probability it will be purple."},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,{"$f":"BH37/BK35","v":0.375},null,null,null,null,null,null,{"$f":"ROUND(RAND()*(3-0)+0,0)","v":2}]
[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,{"$f":"IF(BG36=3,\"yellow\",IF(BG36=2,\"purple\",IF(BG36=1,\"red\",\"pink\")))","v":"purple"},{"$f":"IF(BG36=3,BG35,IF(BG36=2,BH35,IF(BG36=1,BI35,BJ35)))","v":6}]
[null,null,{"$f":"\"The sweet that fell out was \"&BG39&\" and it was put in the bin.\"","v":"The sweet that fell out was yellow and it was put in the bin."},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,{"$f":"ROUND(RAND()*(3-0)+0,0)","v":3}]
[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,{"$f":"IF(BG38=3,\"yellow\",IF(BG38=2,\"purple\",IF(BG38=1,\"red\",\"pink\")))","v":"yellow"},{"$f":"IF(BG38=3,BG34,IF(BG38=2,BH34,IF(BG38=1,BI34,BJ34)))","v":1}]
[null,null,{"$f":"\"What is the probability that the next sweet to fall out will be \"&BG39&\" .\"","v":"What is the probability that the next sweet to fall out will be yellow ."},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,{"$f":"BH39/BK34","v":6.6666666666666666E-2}]
[]
[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,{"$f":"ROUND(AVERAGE(H47:I58),2)","v":{"$error":"#DIV/0!"}}]
[null,"Q4. Sandra works in the school office."]
[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,{"$f":"AI44-AJ44","v":0},null,{"$f":"MAX(H47:I58)","v":0},{"$f":"MIN(H47:I58)","v":0}]
[null,null,{"$f":"\"Shown below is her order for \"&BK54&\" boxes of folders. \"","v":"Shown below is her order for 16 boxes of folders. "}]
[]
[null,null,null,null,null,null,null,null,null,null,"Office Supplies"]
[null,null,null,null,null,null,null,null,null,null,"Yellow folders",null,null,null,{"$f":"BG54","v":2},"boxes"]
[null,null,null,null,null,null,null,null,null,null,"Purple folders",null,null,null,{"$f":"BH54","v":2},"boxes"]
[null,null,null,null,null,null,null,null,null,null,"Red folders",null,null,null,{"$f":"BI54","v":3},"boxes"]
[null,null,null,null,null,null,null,null,null,null,"Pink folders",null,null,null,{"$f":"BJ54","v":9},"boxes"]
[]
[null,null,"Her order arrived in identical boxes but unlabelled.",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,{"$f":"IF(BG57=3,BG54-1,BG54)","v":1},{"$f":"IF(BG57=2,BH54-1,BH54)","v":2},{"$f":"IF(BG57=1,BI54-1,BI54)","v":3},{"$f":"IF(BG57=0,BJ54-1,BJ54)","v":9},{"$f":"SUM(BG53:BJ53)","v":15}]
[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,{"$f":"ROUND(RAND()*(10-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(10-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(10-1)+1,0)","v":3},{"$f":"ROUND(RAND()*(10-1)+1,0)","v":9},{"$f":"SUM(BG54:BJ54)","v":16}]
[null,null,{"$f":"\"(a) What is the probability that the first box Sandra opens is \"&BG56&\" .\"","v":"(a) What is the probability that the first box Sandra opens is red ."},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,{"$f":"BH56/BK54","v":0.1875},null,null,null,null,null,null,{"$f":"ROUND(RAND()*(3-0)+0,0)","v":1}]
[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,{"$f":"IF(BG55=3,\"yellow\",IF(BG55=2,\"purple\",IF(BG55=1,\"red\",\"pink\")))","v":"red"},{"$f":"IF(BG55=3,BG54,IF(BG55=2,BH54,IF(BG55=1,BI54,BJ54)))","v":3}]
[null,null,{"$f":"\"(b) The first box that Sandra opened contained \"&BG58&\" . What is the probability that the next box opened is \"&BG58&\" .\"","v":"(b) The first box that Sandra opened contained yellow . What is the probability that the next box opened is yellow ."},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,{"$f":"ROUND(RAND()*(3-0)+0,0)","v":3}]
[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,{"$f":"IF(BG57=3,\"yellow\",IF(BG57=2,\"purple\",IF(BG57=1,\"red\",\"pink\")))","v":"yellow"},{"$f":"IF(BG57=3,BG53,IF(BG57=2,BH53,IF(BG57=1,BI53,BJ53)))","v":1}]
[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,{"$f":"BH58/BK53","v":6.6666666666666666E-2}]
[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,{"$f":"ROUND(AVERAGE(H65:I69),2)","v":{"$error":"#DIV/0!"}},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,{"$f":"BG62-BG67","v":5},{"$f":"BH62-BH67","v":8},{"$f":"BI62-BI67","v":5},{"$f":"BJ62-BJ67","v":3},{"$f":"SUM(BG60:BJ60)","v":21}]
[null,{"$f":"\"Q5.  A box contains \"&BK62&\" colour balls, \"&BG62&\" yellow , \"&BH62&\" purple, \"&BI62&\" red and \"&BJ62&\" pink balls.\"","v":"Q5.  A box contains 28 colour balls, 6 yellow , 10 purple, 7 red and 5 pink balls."},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,"yellow","PU","R","PI"]
[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,{"$f":"AI62-AJ62","v":0},null,{"$f":"MAX(H65:I67)","v":0},{"$f":"MIN(H65:I69)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(10-5)+5,0)","v":6},{"$f":"ROUND(RAND()*(10-5)+5,0)","v":10},{"$f":"ROUND(RAND()*(10-5)+5,0)","v":7},{"$f":"ROUND(RAND()*(10-5)+5,0)","v":5},{"$f":"SUM(BG62:BJ62)","v":28}]
[null,null,{"$f":"\"(a) Adam takes a ball out of the box. What is the probability it will be \"&BG64&\" .\"","v":"(a) Adam takes a ball out of the box. What is the probability it will be purple ."},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,{"$f":"BH64/BK62","v":0.35714285714285715},null,null,null,null,null,null,{"$f":"ROUND(RAND()*(3-0)+0,0)","v":2}]
[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,{"$f":"IF(BG63=3,\"yellow\",IF(BG63=2,\"purple\",IF(BG63=1,\"red\",\"pink\")))","v":"purple"},{"$f":"IF(BG63=3,BG62,IF(BG63=2,BH62,IF(BG63=1,BI62,BJ62)))","v":10}]
[null,null,{"$f":"\"The ball is put back in and \"&BG67&\" yellow, \"&BH67&\" purple, \"&BI67&\" red and \"&BJ67&\" pink are removed.\"","v":"The ball is put back in and 1 yellow, 2 purple, 2 red and 2 pink are removed."},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,{"$f":"ROUND(RAND()*(3-0)+0,0)","v":1}]
[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,{"$f":"IF(BG65=3,\"yellow\",IF(BG65=2,\"purple\",IF(BG65=1,\"red\",\"pink\")))","v":"red"},{"$f":"IF(BG65=3,BG62,IF(BG65=2,BH62,IF(BG65=1,BI62,BJ62)))","v":7}]
[null,null,{"$f":"\"What is the probability that the next ball removed will be \"&BG66&\" .\"","v":"What is the probability that the next ball removed will be red ."},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,{"$f":"BC68/BC67","v":0.23809523809523808},null,null,{"$f":"BK62-SUM(BG67:BJ67)","v":21},null,null,null,{"$f":"ROUND(RAND()*(3-1)+1,0)","v":1},{"$f":"ROUND(RAND()*(3-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(3-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(3-1)+1,0)","v":2}]
[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,{"$f":"BH66-BH68","v":5},null,null,null,null,{"$f":"IF(BG65=3,BG67,IF(BG65=2,BH67,IF(BG65=1,BI67,BJ67)))","v":2}]