Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 31
Default how to generate a polynomial regression graph with 90% CI?

How do I add a trend line with the 10th, 50th and 90th percentiles to a
scattergram graph?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 837
Default how to generate a polynomial regression graph with 90% CI?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i graph multiple linear regression? enortirol Excel Discussion (Misc queries) 0 February 21st 06 02:18 PM
how to get coefficients for Polynomial regression as for rgp() AZ Excel Worksheet Functions 1 January 26th 06 01:27 PM
Polynomial regression - how does Excel do it? (under "Trendline") JH Charts and Charting in Excel 2 January 5th 06 06:07 PM
creating a regression line in a graph sirsoto Charts and Charting in Excel 1 November 10th 05 03:20 AM
using linest to generate 3rd order polynomial coefficients Incoherent Excel Worksheet Functions 4 September 14th 05 03:57 PM


All times are GMT +1. The time now is 09:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"