Brevet (DNB) 2023 — Mathematics general stream, Métropole Antilles-Guyane 26 juin 2023 — exercise 1 : Statistics and spreadsheet (official exam paper)
Statement
An optician sells different models of sunglasses.
He records in the spreadsheet below information about five models sold during the year 2022.
Spreadsheet: columns A to G, rows 1 to 3. Row 1: A1 « Sunglasses », B1 « Model 1 », C1 « Model 2 », D1 « Model 3 », E1 « Model 4 », F1 « Model 5 », G1 « Total ». Row 2: A2 « Number of pairs of sunglasses sold », B2: 1 200, C2: 950, D2: 875, E2: 250, F2: 300, G2 blank. Row 3: A3 « Unit price in euros », B3: 75, C3: 100, D3: 110, E3: 140, F3: 160, G3 blank.
1. Show that the range of the prices of these pairs of sunglasses is 85 euros.
2. a. What formula should be entered in cell G2 to calculate the total number of pairs of sunglasses sold in 2022?
2. b. Calculate the total number of pairs of sunglasses sold in 2022.
3. a. Calculate the total amount, in euros, of sales of pairs of sunglasses in 2022.
3. b. Calculate the average price of a pair of sunglasses sold in 2022, rounded to the nearest cent.
⏳ 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