Now, go back to the Class dataset tab and repeat the process for the arm span column in column E. We click on the letter D at the top of the height column and hold down Control C.Ĭlick on the Height and Arm Span tab, click in cell A1 and hold down Control V to paste. So, click on the Class dataset tab and select the height column, using the mouse. We need to copy and paste the two columns of data that we need for this graph from the class dataset worksheet to this worksheet. Open the Excel spreadsheet containing the class dataset, and insert a new worksheet. It is very easy to create scatter plots using the Chart command in Excel. We can use Excel to help us create the graphs to test this theory. This lesson is based on Leonardo da Vinci’s theory that in the perfect human, the height measurement and the arm span measurement will be the same.
One lesson on the Census at School website that is excellent for discovering trends in numeric data is the lesson The Vitruvian theory – does it apply to you? In the Learning activities section, you can find a version of this lesson for both the Grades 4 to 8 students or the Grades 9 to 12. Scatter plots allow us to plot two numeric variables against each other to see if there is some relationship or correlation between the data. Scatter plots are for graphing numeric variables, like the height or foot length data from the Census at School survey. This episode will cover creating scatter plots using Excel. To access the Rich-Text Format (RTF) version, use the document conversion features available in most word processing software, or use a file viewer capable of reading RTF. This episode will cover creating scatter plots in Microsoft Excel. Most of the information is still relevant.
NOTE: These videos were prepared when the Census at School Project was managed by Statistics Canada.