Member Training: Using Excel to Graph Predicted Values from Regression Models

by Karen Grace-Martin

Graphing predicted values from a regression model or means from an ANOVA makes interpretation of results much easier.

Every statistical software will graph predicted values for you. But the more complicated your model, the harder it can be to get the graph you want in the format you want.

Excel isn’t all that useful for estimating the statistics, but it has some very nice features that are useful for doing data analysis, one of which is graphing.

In this webinar, I will demonstrate how to calculate predicted means from a linear and a logistic regression model, then graph them. It will be particularly useful to you if you don’t have a very clear sense of where those predicted values come from.

Note: This training is an exclusive benefit to members of the Statistically Speaking Membership Program and part of the Stat’s Amore Trainings Series. Each Stat’s Amore Training is approximately 90 minutes long.

About the Instructor

Karen Grace-Martin helps statistics practitioners gain an intuitive understanding of how statistics is applied to real data in research studies.

She has guided and trained researchers through their statistical analysis for over 15 years as a statistical consultant at Cornell University and through The Analysis Factor. She has master’s degrees in both applied statistics and social psychology and is an expert in SPSS and SAS.

Not a Member Yet?

It’s never too early to set yourself up for successful analysis with support and training from expert statisticians. Just head over and sign up for Statistically Speaking. You'll get access to this training webinar and 85+ other stats trainings — plus the expert guidance you need to progress with live Q&A sessions and an ask-a-mentor forum.

{ 1 comment… read it below or add one }

mouddane abdelkader

plaise estimate uncertainty in excel


Leave a Comment

Please note that, due to the large number of comments submitted, any comments on problems related to a personal study/project will not be answered. We suggest joining Statistically Speaking, where you have access to a private forum and more resources 24/7.

Previous post:

Next post: