May 2013 Member Webinar: 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 webinar is an exclusive benefit for members of the Statistically Speaking Membership Program.

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 late to join the hottest stats club around.

Just head over to our enrollment page to sign up for Statistically Speaking.

You’ll get exclusive access to this month’s webinar, plus live Q&A sessions, a private stats forum, 50+ video recordings of past webinars (including this one), and more.

{ 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: