In the board game, Monopoly, does a property’s distance from GO correlate to its rent when you land on it ?

Using Brian’s spread sheet (list of properties, distance from GO, rent and rent with properties) students create scatter plots. They graph points, draw lines of best fit, find average (X ,Y) values, judge outliers, and make predictions about new properties.

As the teacher, you can choose to assign this activity to be done by hand or to be completed with the tools and skills of manipulating Excel spreadsheets. (Question 8 on the Word document uses property names that are related to our room and our school in Newton. You can easily change the document to relate to your room and school.)

Activity as questions and separate Excel data:

monopoly-wo-excel.pdf + monopoly-data.xls

For member we have solutions and an editable Word doc:

monopoly2014.docx monopoly2014-solutions.pdf

CCSS: 5.G., 6.SP.3, 6.SP.5, 8.F.4, 8.SP, S-ID

I have never had such quick success with so little effort (on my part) with constructing & understanding line of best fit, correlation and using functions to make meaningful predictions. All seamlessly embedded into one rich lesson. And students are now intrigued by the power of Excel.

Great to hear Dawn. We are glad they liked the activity and that students are appreciating Excel. 🙂

This is quickly becoming one of my favorite websites. This project is outstandingly done and I really enjoyed reading about it. I would use this in my class in the future, hands down. Thanks for sharing your wonderful ideas!!

Thanks for the feedback Jenni. Hope you and your students find the activities interesting and useful! 🙂

This is my new favorite problem-based lesson for teaching scatter plots. Thanks for sharing!

Thanks Robert! And let us know if you have any great ideas to add to this activity!