Brevet (DNB) 2021 — Mathematics general stream, Asie (secours) juin 2021 — exercise 4 : Statistics, percentages and spreadsheets (official exam paper)
Statement
A ski resort has $30$ runs. These ski runs are either green, blue, red, or black. The color of the run determines its difficulty level for skiing.
Each ski run can be either open or closed.
On the ski resort’s website, the following information could be found:
Monday 17 February 2020:
- Green runs: the 7 green runs are all open.
- Blue runs: number of blue runs: 8. The pie chart shows that three quarters of the blue runs are open and one quarter is closed.
- Red runs: among the 10 red runs, 8 red runs are open.
- Black runs: among the 5 black runs, 3 black runs are open.
Information: on the diagrams, the hatched areas represent the closed runs and the shaded areas represent the open runs.
1. Determine the number of closed red runs on Monday 17 February 2020.
2. Justify that there are six open blue runs on Monday 17 February 2020.
3. Among the black runs, what percentage of black runs were open on Monday 17 February 2020?
4. On Wednesday 19 February 2020, the new distribution shown on the website is as follows:
Table:
- Green runs: number of runs: 7 ; number of open runs: 5.
- Blue runs: number of runs: 8 ; number of open runs: 4.
- Red runs: number of runs: 10 ; number of open runs: 3.
- Black runs: number of runs: 5 ; number of open runs: 1.
On the resort website, it says: « Your day pass is refunded if more than 50 % of the resort’s runs are closed. »
A customer asks for a refund of her day pass for Wednesday 19 February 2020.
Must the ski resort issue this refund?
5. The maximum snow depths at the resort, expressed in centimeters, were measured for each month, from November 2018 to March 2019.
These measurements are entered in a spreadsheet, a copy of which is shown below:
Spreadsheet:
- Row 1: B1 = Nov. ; C1 = Dec. ; D1 = January ; E1 = February ; F1 = March ; G1 = Average.
- Row 2: A2 = 2018-2019 season ; B2 = 90 ; C2 = 120 ; D2 = 130 ; E2 = 120 ; F2 = 75 ; G2 = 107.
- Row 3: A3 = 2019-2020 season ; B3 = 105 ; C3 = 130 ; D3 = 115 ; E3 = 140 ; F3 = 60 ; G3 is blank.
a. What formula could have been entered in cell G2 before being dragged down to cell G3?
b. Is the average of the five maximum snow depths for the 2019-2020 season greater than that for the 2018-2019 season?
⏳ Solution not generated yet
Open this statement in Expert Maths AI: the step-by-step solution is computed on demand, checked by a second resolution, then published here for everyone.
📝 See the solutionHave a similar exercise? Get it solved step by step, for free.
🧮 Solve my exercise