This mini Project covers the concepts of scatterplots and linear regression lines using data analysis in Excel. The project introduces the concepts of scatterplots and lines of best fit, has students work through a basic analysis of a data set using Excel, then has students complete a more complex analysis of a baseball data set. I created this for my standard 8th grade math class to cover CCSSM.8.SP.1, CCSSM.8.SP.3, MP.4, and MP.5 in an engaging and practical way. I had students working in pairs, but this could be used for individual work as well. For students who are more advanced and need a little more of a challenge, I have included extension questions and a data file to accompany them.
~Powerpoint to introduce project to class (.ppt)
~Excel data file for project (.xls)
~Optional project extension (.docx)
~Excel data file for optional extension (.xls)