Using an excel visual to illustrate univariate and bivariate variability. (29th March 2021)

• Record Type: Journal Article
• Authors: Lilly, Bryan; Miller, Andrew J.
• Is Part Of: Teaching statistics. Volume 43:Number 2(2021)
• Page Start: 79
• Page End: 84
• Publication Date: 2021-03-29
• Subjects: correlation -- dotplot -- regression -- scatterplot -- teaching -- teaching statistics; Statistics -- Study and teaching (Elementary) -- Periodicals; Statistics -- Study and teaching (Secondary) -- Periodicals; 373
• DOI: 10.1111/test.12256
• Languages: English
• ISSNs: 0141-982X

Abstract

Abstract: This paper presents a dynamic Excel visual. The visual has three graphs that are all driven by the same data, so students can see how changes (via Slider controls) in data appear on a univariate graph, a bivariate graph, and a graph that shows a ratio of two variables on one axis. The visual has macros that let a statistics teacher reveal parts of the visual separately. The paper discusses how the visual helps students learn about five conceptual issues. Concluding comments are provided to help teachers who might wish to use the visual.