Solved exercises🧮 Solve my exercise

Brevet (DNB) 2021 — Mathematics general stream, Métropole La Réunion Antilles-Guyane 28 juin 2021 — exercise 1 : Statistics and Spreadsheet (official exam paper)

MathematicsLevel : Middle schoolStatistics and Spreadsheet🌐 Lire en français
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 solution

Have a similar exercise? Get it solved step by step, for free.

🧮 Solve my exercise