Gr. 12 Data Managment Do NOT solve #5 I already did it.

at. Google SheetstJtcel Question. For this question we'll practice creating a simple simulation. Watch the following video on creating a simulation with a spreadsheet: Making Simulations with Google Sheets Then create a simulation for the following situation. l students are writing a test. The test has 5 multiple choice questions with 4 options each, and then it also has 5 true and false questions. Students are guessing each of the answers. a} Create the simulation to determine the score of each of the students. In} Determine the mean, median, mode and range of marks. [5 marks} 100 students are writing a test. The test has 5 multiple choice questions with 4 options each, and then it also has 5 true and false questions. Students are guessing each of the answers. 3) Create the simulation to determine the score of each of the students. b) Determine the mean, median, mode and range of marks. (6 marks) 5. An average is taken of three students' marks but some of the data is lost! You remember the mean is 82.1, and 2 of the marks were 90 and 75. What was the third mark? Show your work. (3 marks) 6. A set of data has an outlier at 155 and Q, = 110? What's the smallest possible value for Q1? Explain how you know. (3 marks)100 students are writing a test. The test has 5 multiple choice questions with 4 options each, and then it also has 5 true and false questions. Students are guessing each of the answers. a) Create the simulation to determine the score of each of the students. b) Determine the mean, median, mode and range of marks. (6 marks)