Graphing Multilevel Models in Excel
Casey DeBuse, UMass Amherst Psychology Department
Visual representations of statistical models of data are often the most succinct way to present such information, especially when that information is fairly complex and difficult to describe in words. While HLM and other programs typically used for multilevel modeling have the capacity for generating graphs, they sometimes lack the flexibility needed for graphing more complex models that include trajectories, interactions, and dyadic effects. In the worst case, these models may be visually misrepresented. Moreover, even the simpler graphs these programs are capable of creating , once generated, can be cumbersome to format.
This workshop will help you to better understand how to accurately graph such models using common office productivity software such as Microsoft Excel, and provide you with the tools and knowledge to do so more quickly and easily. We encourage you to bring a laptop with data that you wish to plot to the workshop.
For more info: umass.edu/family/methodology
Free & open to the public