Prev: Change category width...
Next: How do I do cluster analysis in Excel 2003?
From: Ruben on 18 Mar 2007 10:57
How do I add a trend line with the 10th, 50th and 90th percentiles to a
scattergram graph?
From: Jerry W. Lewis on 19 Mar 2007 10:28
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

"Ruben" wrote:

> How do I add a trend line with the 10th, 50th and 90th percentiles to a
> scattergram graph?
 | 
Pages: 1
Prev: Change category width...
Next: How do I do cluster analysis in Excel 2003?