Brevet (DNB) 2021 — Mathematics general stream, Métropole La Réunion Antilles-Guyane 28 juin 2021 — exercise 1 : Statistics and Spreadsheet (official exam paper)
Statement
This spreadsheet shows the average monthly temperatures in Tours in 2019.
Table: line 1, the months are indicated from January to December by the letters J, F, M, A, M, J, J, A, S, O, N, D in columns B to M; column N is titled "Average for the year". Line 2, "Temperature in °C": January 4,4; February 7,8; March 9,6; April 11,2; May 13,4; June 19,4; July 22,6; August 20,5; September 17,9; October 14,4; November 8,2; December 7,8; cell N2 is empty.
1. From the table above, what was the average temperature in Tours in November 2019?
2. Determine the range of this data set.
3. What formula should be entered in cell N2 to calculate the annual average temperature?
4. Verify that the annual average temperature is $13,1~°\text{C}$.
5. The annual average temperature in Tours in 2009 was $11,9~°\text{C}$.
Is the percentage increase between 2009 and 2019, rounded to the nearest unit, 7 %; 10 % or 13 %? Justify your answer.
⏳ 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