Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
How do I add a trend line with the 10th, 50th and 90th percentiles to a
scattergram graph? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i graph multiple linear regression? | Excel Discussion (Misc queries) | |||
how to get coefficients for Polynomial regression as for rgp() | Excel Worksheet Functions | |||
Polynomial regression - how does Excel do it? (under "Trendline") | Charts and Charting in Excel | |||
creating a regression line in a graph | Charts and Charting in Excel | |||
using linest to generate 3rd order polynomial coefficients | Excel Worksheet Functions |