Frequency trees

I’ve been using Excel for 20 years now and it is amazing what you can create in it. As with all of my files, content and presentation are always exceptional. This is a file to deliver the topic of frequency trees. You access the questions using the tabs at the bottom of the screen. There are three different trees to fill in and the answers are revealed by clicking on the ticks buttons. Each one ends with a probability question relating to the tree. There is a further tab which contains 4 questions in which students need to create and complete their own tree before answering a probability question relating to the tree. As before, all answers can be revealed at a click of the button. I would use this to teach the topic from scratch or as part of intervention when getting the students ready for their mocks or real GCSEs. I have produced over 30 of these files so if you find this useful, please have a look at others in the series.

Save for later
  • Frequency-trees.xlsm

About this resource


Created: Oct 21, 2018

xlsm, 1 MB


Report a problem

Tes Paid Licence

How can I re-use this?