// Numbas version: exam_results_page_options
{"name": "EXCEL - Index of Multiple deprivation", "extensions": ["stats", "download-text-file"], "custom_part_types": [], "resources": [], "navigation": {"allowregen": true, "showfrontpage": false, "preventleave": false, "typeendtoleave": false}, "question_groups": [{"pickingStrategy": "all-ordered", "questions": [{"name": "EXCEL - Index of Multiple deprivation", "tags": [], "metadata": {"description": "<p>Find and compare means and standard deviation using EXCEL (downloadable randomised dataset)</p>", "licence": "Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International"}, "statement": "<p>The following (fictional) data shows the Index of Multiple Deprivation (IMD) score, rank and decile of a random sample of {n} areas in England.</p>\n<p>{download_link(\"IMD.csv\",csv)}</p>\n<p><span class=\"ui-provider cbm cbn c d e f g h i j k l m n o p q r s t cbo cbp w x y z ab ac ae af ag ah ai aj ak\" dir=\"ltr\"><strong>WARNING</strong> The data supplied for this question changes each time. If you retry this question you will need to redownload the csv.</span></p>", "advice": "<p>a) This is a large dataset, and looking for the area code manually might be time-consuming. Therefore, we can use <code>MATCH</code> and <code>INDEX</code> to find values in question.</p>\n<p>For example, to find the IMD score for {Area[areachoice1]} we can add <code>=INDEX(B2:B{n+1},MATCH(\"{Area[areachoice1]}\",A2:A{n+1},0))</code> in an empty cell.</p>\n<p>The table summarises the commands we can use:</p>\n<table border=\"1\">\n<tbody>\n<tr style=\"height: 18px;\">\n<td style=\"width: 96px; height: 18px;\"></td>\n<td style=\"width: 166.66px; height: 18px;\"><strong>{Area[areachoice1]}</strong></td>\n<td style=\"width: 166.66px; height: 18px;\"><strong>{Area[areachoice2]}</strong></td>\n</tr>\n<tr style=\"height: 22px;\">\n<td style=\"width: 96px; height: 22px;\"><strong>IMD score:</strong></td>\n<td style=\"width: 166.66px; height: 22px;\"><code>=INDEX(B2:B{n+1},MATCH(\"{Area[areachoice1]}\",A2:A{n+1},0))</code></td>\n<td style=\"width: 166.66px; height: 22px;\"><code>=INDEX(B2:B{n+1},MATCH(\"{Area[areachoice2]}\",A2:A{n+1},0))</code></td>\n</tr>\n<tr style=\"height: 18px;\">\n<td style=\"width: 96px; height: 18px;\"><strong>IMD rank:</strong></td>\n<td style=\"width: 166.66px; height: 18px;\"><code>=INDEX(C2:C{n+1},MATCH(\"{Area[areachoice1]}\",A2:A{n+1},0))</code></td>\n<td style=\"width: 166.66px; height: 18px;\"><code>=INDEX(C2:C{n+1},MATCH(\"{Area[areachoice2]}\",A2:A{n+1},0))</code></td>\n</tr>\n<tr style=\"height: 18px;\">\n<td style=\"width: 96px; height: 18px;\"><strong>IMD decile:</strong></td>\n<td style=\"width: 166.66px; height: 18px;\"><code>=INDEX(D2:D{n+1},MATCH(\"{Area[areachoice1]}\",A2:A{n+1},0))</code></td>\n<td style=\"width: 166.66px; height: 18px;\"><code>=INDEX(D2:D{n+1},MATCH(\"{Area[areachoice1]}\",A2:A{n+1},0))</code></td>\n</tr>\n</tbody>\n</table>\n<p>Alternatively, we can search for the row with the corresponding Area Codes manually, the results will be the same.</p>\n<p></p>\n<p>b) To choose the correct answers, we need to compare the results calculated in part a.&nbsp;</p>\n<p>We need to keep in mind that <strong>IMD scores record good performance negatively</strong>. Also, the areas are ranked starting from most deprived as 1. Similarly, the first dicile correspondes to the 10% most deprived areas.</p>", "rulesets": {}, "extensions": ["download-text-file", "stats"], "builtin_constants": {"e": true, "pi,\u03c0": true, "i": true, "j": false}, "constants": [], "variables": {"n": {"name": "n", "group": "Ungrouped variables", "definition": "random(100..300)", "description": "", "templateType": "anything", "can_override": false}, "Area": {"name": "Area", "group": "Ungrouped variables", "definition": "repeat(\"E010\"+random(1..32844),n)", "description": "", "templateType": "anything", "can_override": false}, "Rank": {"name": "Rank", "group": "Ungrouped variables", "definition": "shuffle(repeat(random(1..32844),n))", "description": "", "templateType": "anything", "can_override": false}, "Decile": {"name": "Decile", "group": "Ungrouped variables", "definition": "map(if(i< 3284 , 1, if(i<6586,2,if(i<9853,3,if(i<13137,4,if(i<16422,5,if(i<19706,6,if(i<22990,7,if(i<26275,8,if(i<29559,9,10)))))))) ),i,Rank)", "description": "", "templateType": "anything", "can_override": false}, "IMD": {"name": "IMD", "group": "Ungrouped variables", "definition": "map(precround((i+random*(i+1))100/32844,3), i, rank)", "description": "", "templateType": "anything", "can_override": false}, "random": {"name": "random", "group": "Ungrouped variables", "definition": "random(0.01..0.08 # 0.01)", "description": "", "templateType": "anything", "can_override": false}, "csv": {"name": "csv", "group": "Ungrouped variables", "definition": "csv(zip(Area,IMD, Rank, Decile),[\"Area Code\", \"Index of Multiple Deprivation (IMD) Score\",\"IMD Rank (Where 1 is most deprived)\", \"IMD Decile (where 1 is most deprived 10%)\"])", "description": "", "templateType": "anything", "can_override": false}, "areachoice1": {"name": "areachoice1", "group": "Ungrouped variables", "definition": "random(0..n)", "description": "", "templateType": "anything", "can_override": false}, "areachoice2": {"name": "areachoice2", "group": "Ungrouped variables", "definition": "random(0..n)", "description": "", "templateType": "anything", "can_override": false}, "choices": {"name": "choices", "group": "Ungrouped variables", "definition": "[\"{Area[areachoice1]} has a higher IMD score than {Area[areachoice2]}.\", \n\"{Area[areachoice1]} is more deprived than {Area[areachoice2]}.\", \n\"{Area[areachoice1]} is less deprived than {Area[areachoice2]}.\", \n\nif(d2<5, \"{Area[areachoice2]} is in the {d2*10}% least deprived areas in England.\", \"{Area[areachoice2]} is in the {(11-d2)*10}% most deprived areas in England.\"),\nif(d1<5, \"{Area[areachoice1]} is in the {d1*10}% most deprived areas in England.\", \"{Area[areachoice1]} is in the {(11-d1)*10}% least deprived areas in England.\"),\nif(d1<5, \"{Area[areachoice1]} and {Area[areachoice2]} are both within the most deprived {d1*10}% of areas in England.\", \"{Area[areachoice1]} and {Area[areachoice2]} are both in the least deprived {(11-d1)*10}% of areas in England.\")]", "description": "", "templateType": "anything", "can_override": false}, "points": {"name": "points", "group": "Ungrouped variables", "definition": "[if(s1>s2,1,0), if(r1<r2,1,0), if(r1>r2,1,0),0,1,if(d2<=d1,1,0)]", "description": "", "templateType": "anything", "can_override": false}, "s1": {"name": "s1", "group": "Ungrouped variables", "definition": "IMD[areachoice1]", "description": "", "templateType": "anything", "can_override": false}, "s2": {"name": "s2", "group": "Ungrouped variables", "definition": "IMD[areachoice2]", "description": "", "templateType": "anything", "can_override": false}, "r1": {"name": "r1", "group": "Ungrouped variables", "definition": "Rank[areachoice1]", "description": "", "templateType": "anything", "can_override": false}, "r2": {"name": "r2", "group": "Ungrouped variables", "definition": "Rank[areachoice2]", "description": "", "templateType": "anything", "can_override": false}, "d1": {"name": "d1", "group": "Ungrouped variables", "definition": "Decile[areachoice1]", "description": "", "templateType": "anything", "can_override": false}, "d2": {"name": "d2", "group": "Ungrouped variables", "definition": "Decile[areachoice2]", "description": "", "templateType": "anything", "can_override": false}}, "variablesTest": {"condition": "", "maxRuns": 100}, "ungrouped_variables": ["n", "Area", "Rank", "Decile", "IMD", "random", "csv", "areachoice1", "areachoice2", "choices", "points", "s1", "s2", "r1", "r2", "d1", "d2"], "variable_groups": [], "functions": {}, "preamble": {"js": "", "css": ""}, "parts": [{"type": "gapfill", "useCustomName": false, "customName": "", "marks": 0, "scripts": {}, "customMarkingAlgorithm": "", "extendBaseMarkingAlgorithm": true, "unitTests": [], "showCorrectAnswer": true, "showFeedbackIcon": true, "variableReplacements": [], "variableReplacementStrategy": "originalfirst", "nextParts": [], "suggestGoingBack": false, "adaptiveMarkingPenalty": 0, "exploreObjective": null, "prompt": "<p>For the areas {Area[areachoice1]} and {Area[areachoice2]} fill in the table with the appropriate statistic:&nbsp;</p>\n<table border=\"1\" style=\"height: 76px;\">\n<tbody>\n<tr style=\"height: 18px;\">\n<td style=\"width: 96px; height: 18px;\"></td>\n<td style=\"width: 166.66px; height: 18px;\"><strong>{Area[areachoice1]}</strong></td>\n<td style=\"width: 166.66px; height: 18px;\"><strong>{Area[areachoice2]}</strong></td>\n</tr>\n<tr style=\"height: 22px;\">\n<td style=\"width: 96px; height: 22px;\"><strong>IMD score:</strong></td>\n<td style=\"width: 166.66px; height: 22px;\">[[0]]</td>\n<td style=\"width: 166.66px; height: 22px;\">[[1]]</td>\n</tr>\n<tr style=\"height: 18px;\">\n<td style=\"width: 96px; height: 18px;\"><strong>IMD rank:</strong></td>\n<td style=\"width: 166.66px; height: 18px;\">[[2]]</td>\n<td style=\"width: 166.66px; height: 18px;\">[[3]]</td>\n</tr>\n<tr style=\"height: 18px;\">\n<td style=\"width: 96px; height: 18px;\"><strong>IMD decile:</strong></td>\n<td style=\"width: 166.66px; height: 18px;\">[[4]]</td>\n<td style=\"width: 166.66px; height: 18px;\">[[5]]</td>\n</tr>\n</tbody>\n</table>", "gaps": [{"type": "jme", "useCustomName": false, "customName": "", "marks": 1, "scripts": {}, "customMarkingAlgorithm": "", "extendBaseMarkingAlgorithm": true, "unitTests": [], "showCorrectAnswer": true, "showFeedbackIcon": true, "variableReplacements": [], "variableReplacementStrategy": "originalfirst", "nextParts": [], "suggestGoingBack": false, "adaptiveMarkingPenalty": 0, "exploreObjective": null, "answer": "{s1}", "showPreview": true, "checkingType": "absdiff", "checkingAccuracy": 0.001, "failureRate": 1, "vsetRangePoints": 5, "vsetRange": [0, 1], "checkVariableNames": false, "singleLetterVariables": false, "allowUnknownFunctions": true, "implicitFunctionComposition": false, "caseSensitive": false, "valuegenerators": []}, {"type": "jme", "useCustomName": false, "customName": "", "marks": 1, "scripts": {}, "customMarkingAlgorithm": "", "extendBaseMarkingAlgorithm": true, "unitTests": [], "showCorrectAnswer": true, "showFeedbackIcon": true, "variableReplacements": [], "variableReplacementStrategy": "originalfirst", "nextParts": [], "suggestGoingBack": false, "adaptiveMarkingPenalty": 0, "exploreObjective": null, "answer": "{s2}", "showPreview": true, "checkingType": "absdiff", "checkingAccuracy": 0.001, "failureRate": 1, "vsetRangePoints": 5, "vsetRange": [0, 1], "checkVariableNames": false, "singleLetterVariables": false, "allowUnknownFunctions": true, "implicitFunctionComposition": false, "caseSensitive": false, "valuegenerators": []}, {"type": "jme", "useCustomName": false, "customName": "", "marks": 1, "scripts": {}, "customMarkingAlgorithm": "", "extendBaseMarkingAlgorithm": true, "unitTests": [], "showCorrectAnswer": true, "showFeedbackIcon": true, "variableReplacements": [], "variableReplacementStrategy": "originalfirst", "nextParts": [], "suggestGoingBack": false, "adaptiveMarkingPenalty": 0, "exploreObjective": null, "answer": "{r1}", "showPreview": true, "checkingType": "absdiff", "checkingAccuracy": 0.001, "failureRate": 1, "vsetRangePoints": 5, "vsetRange": [0, 1], "checkVariableNames": false, "singleLetterVariables": false, "allowUnknownFunctions": true, "implicitFunctionComposition": false, "caseSensitive": false, "valuegenerators": []}, {"type": "jme", "useCustomName": false, "customName": "", "marks": 1, "scripts": {}, "customMarkingAlgorithm": "", "extendBaseMarkingAlgorithm": true, "unitTests": [], "showCorrectAnswer": true, "showFeedbackIcon": true, "variableReplacements": [], "variableReplacementStrategy": "originalfirst", "nextParts": [], "suggestGoingBack": false, "adaptiveMarkingPenalty": 0, "exploreObjective": null, "answer": "{r2}", "showPreview": true, "checkingType": "absdiff", "checkingAccuracy": 0.001, "failureRate": 1, "vsetRangePoints": 5, "vsetRange": [0, 1], "checkVariableNames": false, "singleLetterVariables": false, "allowUnknownFunctions": true, "implicitFunctionComposition": false, "caseSensitive": false, "valuegenerators": []}, {"type": "jme", "useCustomName": false, "customName": "", "marks": 1, "scripts": {}, "customMarkingAlgorithm": "", "extendBaseMarkingAlgorithm": true, "unitTests": [], "showCorrectAnswer": true, "showFeedbackIcon": true, "variableReplacements": [], "variableReplacementStrategy": "originalfirst", "nextParts": [], "suggestGoingBack": false, "adaptiveMarkingPenalty": 0, "exploreObjective": null, "answer": "{d1}", "showPreview": true, "checkingType": "absdiff", "checkingAccuracy": 0.001, "failureRate": 1, "vsetRangePoints": 5, "vsetRange": [0, 1], "checkVariableNames": false, "singleLetterVariables": false, "allowUnknownFunctions": true, "implicitFunctionComposition": false, "caseSensitive": false, "valuegenerators": []}, {"type": "jme", "useCustomName": false, "customName": "", "marks": 1, "scripts": {}, "customMarkingAlgorithm": "", "extendBaseMarkingAlgorithm": true, "unitTests": [], "showCorrectAnswer": true, "showFeedbackIcon": true, "variableReplacements": [], "variableReplacementStrategy": "originalfirst", "nextParts": [], "suggestGoingBack": false, "adaptiveMarkingPenalty": 0, "exploreObjective": null, "answer": "{d2}", "showPreview": true, "checkingType": "absdiff", "checkingAccuracy": 0.001, "failureRate": 1, "vsetRangePoints": 5, "vsetRange": [0, 1], "checkVariableNames": false, "singleLetterVariables": false, "allowUnknownFunctions": true, "implicitFunctionComposition": false, "caseSensitive": false, "valuegenerators": []}], "sortAnswers": false}, {"type": "gapfill", "useCustomName": false, "customName": "", "marks": 0, "scripts": {}, "customMarkingAlgorithm": "", "extendBaseMarkingAlgorithm": true, "unitTests": [], "showCorrectAnswer": true, "showFeedbackIcon": true, "variableReplacements": [], "variableReplacementStrategy": "originalfirst", "nextParts": [], "suggestGoingBack": false, "adaptiveMarkingPenalty": 0, "exploreObjective": null, "prompt": "<p>Compare the areas {Area[areachoice1]} and {Area[areachoice2]}. Select&nbsp;<span style=\"text-decoration: underline;\">all</span> the sentences that are true:</p>\n<p>[[0]]</p>", "gaps": [{"type": "m_n_2", "useCustomName": false, "customName": "", "marks": 0, "scripts": {}, "customMarkingAlgorithm": "", "extendBaseMarkingAlgorithm": true, "unitTests": [], "showCorrectAnswer": true, "showFeedbackIcon": true, "variableReplacements": [], "variableReplacementStrategy": "originalfirst", "nextParts": [], "suggestGoingBack": false, "adaptiveMarkingPenalty": 0, "exploreObjective": null, "minMarks": 0, "maxMarks": 0, "shuffleChoices": true, "displayType": "checkbox", "displayColumns": 0, "minAnswers": 0, "maxAnswers": 0, "warningType": "none", "showCellAnswerState": true, "markingMethod": "sum ticked cells", "choices": "{choices}", "matrix": "{points}"}], "sortAnswers": false}], "partsMode": "all", "maxMarks": 0, "objectives": [], "penalties": [], "objectiveVisibility": "always", "penaltyVisibility": "always", "contributors": [{"name": "Ben McGovern", "profile_url": "https://numbas.mathcentre.ac.uk/accounts/profile/4872/"}, {"name": "Evi Papadaki", "profile_url": "https://numbas.mathcentre.ac.uk/accounts/profile/18113/"}]}]}], "contributors": [{"name": "Ben McGovern", "profile_url": "https://numbas.mathcentre.ac.uk/accounts/profile/4872/"}, {"name": "Evi Papadaki", "profile_url": "https://numbas.mathcentre.ac.uk/accounts/profile/18113/"}]}