// Numbas version: finer_feedback_settings
{"name": "EXCEL - Basketball players", "extensions": ["stats", "random_person", "download-text-file"], "custom_part_types": [], "resources": [], "navigation": {"allowregen": true, "showfrontpage": false, "preventleave": false, "typeendtoleave": false}, "question_groups": [{"pickingStrategy": "all-ordered", "questions": [{"name": "EXCEL - Basketball players", "tags": [], "metadata": {"description": "<p>Find the number of people with heights greater then mean plus two times the standard deviation.</p>", "licence": "Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International"}, "statement": "<p>A basketball talent scout is looking for tall people to be new players, analyse the data in the file linked below to find the potential candidates.</p>\n<p>How many people on the list are taller than the mean height plus two standard deviations?</p>\n<p>There are {n} people in the list.</p>\n<p>{download_link(\"student_heights.csv\",csv)}</p>\n<p><strong>WARNING</strong> The data supplied for this question changes each time. If you retry this question you will need to redownload the csv.</p>\n<details>\n<summary><span style=\"text-decoration: underline;\">Help I don't know where to start!</span></summary>\nYou'll need to use the <code>AVERAGE</code>, <code>STDEV</code> and <code>COUNTIF</code> functions.</details>", "advice": "<p>First find the mean with <code>=AVERAGE(B1:B{n})</code> in cell <code>C1</code></p>\n<p>Now the standard deviation with <code>=STDEV(B1:B{n})</code> in cell <code>C2</code>. Note this calculates the sample standard deviation and gives the same answer as <code>=STDEV.S(B1:B{n})</code></p>\n<p>Now find the critical height that we want to find people above. In cell <code>C3</code> write <code>=C1+2*C2</code>.</p>\n<p>To count all the people taller than this we can use the following formula <code>=COUNTIF(B1:B{n},\"&gt;\"&amp;C3)</code> to give {ans_2}</p>", "rulesets": {}, "extensions": ["download-text-file", "random_person", "stats"], "builtin_constants": {"e": true, "pi,\u03c0": true, "i": true}, "constants": [], "variables": {"people": {"name": "people", "group": "Ungrouped variables", "definition": "map([x['name'],trunc(normalsample(mu, sigma))],x,random_people(n))", "description": "", "templateType": "anything", "can_override": false}, "n": {"name": "n", "group": "Ungrouped variables", "definition": "random(800..1010)", "description": "", "templateType": "anything", "can_override": false}, "mu": {"name": "mu", "group": "Ungrouped variables", "definition": "random(160..180)", "description": "", "templateType": "anything", "can_override": false}, "sigma": {"name": "sigma", "group": "Ungrouped variables", "definition": "random(5..15)", "description": "", "templateType": "anything", "can_override": false}, "ans": {"name": "ans", "group": "Ungrouped variables", "definition": "sum(map(if(x[1] > (mu+2*sigma),1,0),x,people))", "description": "<p>This is the answer not based on the sample data - ignore this one</p>", "templateType": "anything", "can_override": false}, "csv": {"name": "csv", "group": "Ungrouped variables", "definition": "csv(people)", "description": "", "templateType": "anything", "can_override": false}, "x_bar": {"name": "x_bar", "group": "Ungrouped variables", "definition": "mean(map(x[1],x,people))", "description": "", "templateType": "anything", "can_override": false}, "sd": {"name": "sd", "group": "Ungrouped variables", "definition": "stdev(map(x[1],x,people),true)", "description": "", "templateType": "anything", "can_override": false}, "ans_2": {"name": "ans_2", "group": "Ungrouped variables", "definition": "sum(map(if(x[1] > (x_bar+2*sd),1,0),x,people))", "description": "", "templateType": "anything", "can_override": false}}, "variablesTest": {"condition": "", "maxRuns": 100}, "ungrouped_variables": ["people", "n", "mu", "sigma", "csv", "x_bar", "sd", "ans_2", "ans"], "variable_groups": [], "functions": {}, "preamble": {"js": "", "css": ""}, "parts": [{"type": "numberentry", "useCustomName": false, "customName": "", "marks": 1, "scripts": {}, "customMarkingAlgorithm": "", "extendBaseMarkingAlgorithm": true, "unitTests": [], "showCorrectAnswer": true, "showFeedbackIcon": true, "variableReplacements": [], "variableReplacementStrategy": "originalfirst", "nextParts": [], "suggestGoingBack": false, "adaptiveMarkingPenalty": 0, "exploreObjective": null, "minValue": "{ans_2}", "maxValue": "{ans_2}", "correctAnswerFraction": false, "allowFractions": false, "mustBeReduced": false, "mustBeReducedPC": 0, "displayAnswer": "", "showFractionHint": true, "notationStyles": ["plain", "en", "si-en"], "correctAnswerStyle": "plain"}], "partsMode": "all", "maxMarks": 0, "objectives": [], "penalties": [], "objectiveVisibility": "always", "penaltyVisibility": "always", "type": "question", "contributors": [{"name": "Ed Southwood", "profile_url": "https://numbas.mathcentre.ac.uk/accounts/profile/2415/"}, {"name": "Ben McGovern", "profile_url": "https://numbas.mathcentre.ac.uk/accounts/profile/4872/"}]}]}], "contributors": [{"name": "Ed Southwood", "profile_url": "https://numbas.mathcentre.ac.uk/accounts/profile/2415/"}, {"name": "Ben McGovern", "profile_url": "https://numbas.mathcentre.ac.uk/accounts/profile/4872/"}]}