how to generate a polynomial regression graph with 90% CI?

R

Ruben

How do I add a trend line with the 10th, 50th and 90th percentiles to a
scattergram graph?
 
J

Jerry W. Lewis

Excel has no graphics option nor any worksheet function that will do this.

LINEST will give the standard errors of regression coefficients, but not
their covariances (which are needed to get the standard error of a fitted
value). Your options are to either write your own polynomial regression
function, or use a different package. R is a freely available
http://www.r-project.org
full-featured and widely used statistical package that is an open-source
implementation of the S languaguage, that can easily do what you want.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top