Grade 9 / statistics 17 exercises (100% corrected)

a
123456789101112131415161718ABCDEAnnéesdesjeuxdupaci∏queNombredemédaillesd’orNombredemédaillesd’argentNombredemédaillesdebronzeTotal16937911271966393030991969362021771971333227921975373134102197933432610219832420196319878248381681991292927851995825743182199973554417220039373742032007906968227Total:6585164621636Moyennes:514036126 1234567891011121314ABCDEFGHIJL.M.Mer.J.V.S.D.TotalMoyenneSemaine11571451421591901561611110159Semaine21471581561411411521551050150Semaine31531481621491601461631081154Semaine41681561621571661581611128161Semaine51631691701621671691621162166Semaine61561671711731651651621159166Semaine71731721681731611621671176168Semaine81681661701731681761651186169Semaine91761751751711721781731220174Semaine101891761721801851711711240177Semaine111781811831721781721731237177Semaine121711831711841721761731230176Moyennesurtroismois166 123ABCDEFGHIJKLMNOPQRClasseMoy.Méd.A00000571215151618213467B01121117181820321214NombredeSMSenvoyésparélèvedansleweek-end 1. Calculation sheet E.5043 The number of medals won by New Caledonian athletes during the Pacific Games was recorded. Here are the results grouped in a ta-ble : 1 To get the number 27 in cell E2 , we wrote the following formula : =SUM(B2:D2) . What formula was written in B16 to get 658? 2 What formula was written in B18 to calculate the average gold medals earned over those 13 years. E.5495 Starting 2 January 2012 , an airline is testing a new flight between Nantes and Toulouse. This flight is made daily on an aircraft that can carry a max-imum of 190 passengers. Starting in February, it is decided to study the ridership of this bowl for twelve weeks. The company uses a spreadsheet showing the number of passengers per day. This spreadsheet is given below : 1 What formula was entered in cell I2 to obtain the total number of passengers during the week 1 ? 2 What formula was entered in cell J2 to obtain the average number of passengers per day over the week 1 ? 2. Mean and median E.7972 Fifteen students in a A class and ten students in a B class are asked to count the number of text messages they send over a weekend. On Monday, we retrieve the results in a spreadsheet. 1 Calculate the average and median number of text mes-sages sent over the weekend by these students in class A . 2 What formulas could have been written in cells Q3 and R3 of the spreadsheet? 3 Calculate the average number of text messages sent over the weekend by these 25 students in grades A and B . 4 Calculate the median number of text messages sent over the weekend by these 25 students in grades A and B . https://chingmath.fr chapExoCorrec/5043 sacados/5043 fichierPlus/5043/ 123456789101112131415161718ABCDEAnnéesdesjeuxdupaci∏queNombredemédaillesd’orNombredemédaillesd’argentNombredemédaillesdebronzeTotal16937911271966393030991969362021771971333227921975373134102197933432610219832420196319878248381681991292927851995825743182199973554417220039373742032007906968227Total:6585164621636Moyennes:514036126 chapExoCorrec/5495 sacados/5495 fichierPlus/5495/ 1234567891011121314ABCDEFGHIJL.M.Mer.J.V.S.D.TotalMoyenneSemaine11571451421591901561611110159Semaine21471581561411411521551050150Semaine31531481621491601461631081154Semaine41681561621571661581611128161Semaine51631691701621671691621162166Semaine61561671711731651651621159166Semaine71731721681731611621671176168Semaine81681661701731681761651186169Semaine91761751751711721781731220174Semaine101891761721801851711711240177Semaine111781811831721781721731237177Semaine121711831711841721761731230176Moyennesurtroismois166 chapExoCorrec/7972 sacados/7972 123ABCDEFGHIJKLMNOPQRClasseMoy.Méd.A00000571215151618213467B01121117181820321214NombredeSMSenvoyésparélèvedansleweek-end
1234567891011ABCDEFRangPaysOrArgentBronzeTotal1Etats-Unis4637381212Grande-Bretagne272317673Chine261826704Russie191819565Allemage171015426Japon12821417France101814428CoréeduSud939219Italie81282810Australie8111029 E.7626 On a spreadsheet, the rank-ing of the top ten countries, by number of medals, at the Rio Olympics in 2016 was plotted. 1 Which of the three suggested formulas was entered into cell F2 of this worksheet before it was stretched down? Formula A Formula B Formula C =46+37+38 =SUM(C2:E2) C2+D2+E2 2 We look at the series of gold medal numbers for these ten countries. a What is the range of this series? b What is the mean of this series? 3 What is the percentage of gold medals won by France out of its total number of medals? Round the percentage re-sult to the nearest tenth. 4 The ranking at the Olympic Games is based on the num-ber of gold medals won, not the total number of medals. For this reason, France with 42 medals is behind Japan, which has only 41 . Looking at Italy and Australia, es-tablish the ranking rule in case of a tie on the number of gold medals. 5 A sports journalist proposes a new procedure for rank-ing countries : each gold medal earns 3 points, each sil-ver medal earns 2 points, and each bronze medal earns 1 points. Under these conditions, would France surpass Japan? E.5698 Here, for the year’s produc-tion 2009 , is a record of the lengths of vanilla beans from a grower on Tahaa : Longueur en cm 12 15 17 22 23 Effectif 600 800 1800 1200 600 The Chamber of Agriculture gives an award (a ˇlabel of qual-ityı) to farmers if : the average pod length of their production is greater than or equal to 16.5 cm ; and more than half of the pods in their production are larger than 17.5 cm . Will this grower be able to receive this ˇ quality label ı? Hint: for this question, any trace of research, even if in-complete, will be considered in the evaluation 3. Scope E.3743 During a track and field com-petition, the 7 competitors ran the 200 m with the following times (in seconds) : 20.25 ; 20.12 ; 20.48 ; 20.09 ; 20.69 ; 20.19 ; 20.38 1 What is the range of this series? 2 What is the mean of this series (rounded to the hun-dredth) . 3 What is the median of this series? 4 What is the average speed of the top-ranked athlete, in meters per second ( m = s ) , (rounded to the thousandth) ? E.3765 Here are the employee head-counts and salaries for a Small and Medium Enterprise (SME) . Catégorie Ouvrier simple Ouvrier qualifié Cadre moyen Cadre supérieur Dirigeant Effectif 50 25 15 10 2 Salaire en euros 950 1300 1700 3500 8000 1 What is the size of this PME ? 2 Calculate the average wage rounded to the nearest unit. 3 Determine the range of wages. 4 Managers decide on an increase of 8 % in the amount of a single worker’s wage. Calculate the new wage for this worker. https://chingmath.fr chapExoCorrec/7626 sacados/7626 1234567891011ABCDEFRangPaysOrArgentBronzeTotal1Etats-Unis4637381212Grande-Bretagne272317673Chine261826704Russie191819565Allemage171015426Japon12821417France101814428CoréeduSud939219Italie81282810Australie8111029 chapExoCorrec/5698 sacados/5698 chapExoCorrec/3743 sacados/3743 chapExoCorrec/3765 sacados/3765 Antilles-Guyane Septembre 2008
x0123456789101112y2468101214161820 8910111213141501234567NotesE∑ectifs Un concert100500700900110013001500G E.4337 On the graph below, we have plotted Mathieu’s math scores throughout the school year. 1 On which homework assignment did Mathieu get his best grade? 2 Calculate Mathieu’s average grade over the entire year. 3 Determine the range of Mathieu’s grade series. 4 a How many grades did Mathieu get strictly below 10 on 20 ? b Express this result as a percentage of the total number of assignments. E.908 The bar chart below shows the distribution of marks obtained in a math test by students in a class of 3 e . 1 How many students are there in this class? 2 What is the average grade for the class on this test? 3 What is the median grade? 4 What is the range of this series of scores? E.990 Two middle school classes an-swered the following question : ˇ How many books have you borrowed in the last 12 months? ı The two classes communicated the answers in two different ways : Class n o 1 : 1 ; 2 ; 2 ; 2 ; 2 ; 2 ; 3 ; 3 ; 3 ; 3 ; 3 ; 3 ; 3 ; 3 ; 6 6 ; 6 ; 6 ; 6 ; 7 ; 7 ; 7 Class n o 2 : Total number: 25 Average: 4 Extent : 8 Médiane : 5 1 Compare the average numbers of books borrowed in each class. 2 A ˇ great lecteur ı is a student who has borrowed 5 books or more. Which class has the most ˇ great readers ı? 3 In which class is the student who borrowed the most books? 4. Histogram E.9227 In one city, a concert hall has pro-grammed 41 concerts during the 2004/2005 season. The results in number of spectators expected are indicated by https://chingmath.fr chapExoCorrec/4337 sacados/4337 x0123456789101112y2468101214161820 chapExoCorrec/908 sacados/908 Groupe Est Juin 200 points 8910111213141501234567NotesE∑ectifs chapExoCorrec/990 sacados/990 chapExoCorrec/9227 sacados/9227 Un concert100500700900110013001500G
0123456780246810Nombred’adolescentsNombredeséancesdecinema Football32%Volley-Ball12%Tennis22%Judo16%Danse10%Autre8% Vollye-BallFootballTennisJudoDanseAutre050100150200250300 the histogram above. For example, the manager thinks that 6 concerts will attract between 500 and 700 spectators during the 2004/2005 season. 1 Complete the following table : Classe [100;500[ [500;700[ [700;900[ [900;1100[ [1100;1300[ [1300;1500[ Centre classe Membership 2 Determine, to the nearest number of spectators, the av-erage number of spectators per concert for this perfor-mance venue. E.1913 Teenagers aged between 14 and 18 were asked how many times they went to the cinema each month. The bar chart below shows their answers 1 How many movies, on average, does a teenager see per month? 2 Construct, the histogram, corresponding with the classes 0 ; 2 , 2 ; 4 , 4 ; 6 et 6 ; 8 5. Statistics and probability E.5922 The following information con-cerns the salaries of men and women in the same company: Women’s wages: 1 200 e ; 1 230 e ; 1 250 e ; 1 310 e ; 1 376 e 1 400 e ; 1 440 e ; 1 500 e ; 1 700 e ; 2 100 e Men’s wages: Total workforce: 20 Moyenne : 1 769 e Etendue : 2 400 e Médiane : 2 000 e Men’s salaries are all different. 1 Compare the average salary of men and women. 2 One person in the company is drawn at random. What is the probability that it will be a woman? 3 The lowest salary in the company is 1 000 e . Which salary is the highest? 4 In this company how many people earn more than 2 000 e ? 6. Unclassified exercises E.226 In one school, a study was carried out into the preferred sport of 14 and 16 year olds. The results are summarized in the diagram below : 1 This study involved a population with a total strength of 879 individuals. Complete the headcount table, to the nearest unit : Sport Volley ball Football Tennis Judo Danse Autre Effectif 2 Complete the graph below to obtain the bar chart asso-ciated with this statistical series. https://chingmath.fr chapExoCorrec/1913 sacados/1913 0123456780246810Nombred’adolescentsNombredeséancesdecinema chapExoCorrec/5922 sacados/5922 chapExoCorrec/226 sacados/226 Football32%Volley-Ball12%Tennis22%Judo16%Danse10%Autre8% Vollye-BallFootballTennisJudoDanseAutre050100150200250300
1400150016001700180022001 bloc=20 employéssource: E.9239 The leader of the largest multi-sport club in the region found that as of 1 er January 2017 , membership was 1 260 members. Here is the breakdown of 2017 members by their sport of choice. Effectif en 2017 Angles en degrés correspondant (pour construire le diagramme circulaire) Fréquence en % Planche à voile 392 Beach Volley 224 Surf 644 Total 1260 360 o 100 % 1 Complete the column entitled ˇ Angle in degrees corre-spondant ı. (To explain your approach, you will include the corre-sponding calculations on your copy.) 2 To represent the situation, construct a pie chart of radius 4 cm . 3 Complete the column above ˇ Frequency in % ı. (To ex-plain your approach, you will include the correspond-ing calculations on your copy. You will give the result rounded to the nearest hundredth) E.7621 For his 32 th birthday, Denis bought an exercise bike so he could work out during the win-ter. Heart rate ( HR ) is the number of pulses (or beats) of the heart per minute. 1 Denis wants to estimate his heart rate: in fifteen seconds, he has counted 18 beats. What heart rate, expressed in beats per minute, does this correspond to? 2 His bike is equipped with a heart rate monitor that al-lows him to optimize his effort by recording, in this heart rate monitor, all the pulses of his heart. At one point, the heart rate monitor measured an interval of 0.8 second between two pulses. Calculate the heart rate that will be displayed by the heart rate monitor. 3 After a workout, the heart rate monitor gave him the following information : Number de pulsations enregistrées Fréquence minimale enregistrée Fréquence moyenne Fréquence maximale enregistrée 3640 65 pulsations = minute 130 pulsations = minute 182 pulsations = minute a What is the range of recorded heart rates? b Denis did not time the duration of his workout. What was that duration? E.7970 Tell whether the statement below is true or false, carefully justifying the answer. The histogram below represents the distribution of wages in a company: Statement: More than 40 % of employees have a salary of at least 1 700 e https://chingmath.fr chapExoCorrec/9239 sacados/9239 chapExoCorrec/7621 sacados/7621 chapExoCorrec/7970 sacados/7970 1400150016001700180022001 bloc=20 employéssource: