Solved exercises🧮 Solve my exercise

Brevet (DNB) 2022 — Mathematics general stream, Métropole Antilles-Guyane 12 septembre 2022 — exercise 4 : Spreadsheet and statistics (official exam paper)

MathematicsLevel : Middle schoolSpreadsheet and statistics🌐 Lire en français
Statement
Here is the number of vehicle crossings at the toll of the Île de Ré bridge during the year 2020, recorded in a spreadsheet: Table: column A “Month”, column B “Number of crossings”. Line 2: January, 210 320. Line 3: February, 218 464. Line 4: March, 138 395. Line 5: April, 62 930. Line 6: May, 179 699. Line 7: June, 295 333. Line 8: July, 389 250. Line 9: August, 376 551. Line 10: September, 313 552. Line 11: October, 267 864. Line 12: November, 142 152. Line 13: December, 206 662. Line 14: Total, 2 801 172. 1. What formula was entered in cell B14 to obtain the total number of crossings in 2020? 2. Calculate the average number of crossings per month. 3. Give the range of the data set. 4. In order to study the effects of the 2020 lockdown, we want to compare the number of vehicle crossings on the Île de Ré bridge in May 2020 with that in May 2021. In May 2021, 305 214 vehicles crossed the toll. Calculate the percentage increase in the number of vehicle crossings between May 2020 and May 2021. Round to the nearest whole number. 5. Knowing that the bridge is 3 000 meters long, what is the average speed, expressed in km/h, of a cyclist who crosses it in $10$ minutes?
⏳ 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