Scatter Diagrams Explained and Demonstrated with Excel
Excel Demonstration is at timecode 3:43.
The Scatter Diagram is explained and demonstrated using an example of students grades on an exam and the number of hours studied. The X and Y coordinates are plotted, and a positive relationship appears to exist. The terms Independent Variable and Dependent Variable are also explained, and we look at situations where there is a negative relationship between X and Y, and when there is no relationship. The Scatter diagram is demonstrated using the Chart Tool in Excel.