View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default Is there a way to obtain a polynomial trendline of order higher th

Polynomials have a fundamentally different shape than s-shaped curves, since
polynomials are unbounded and s-shaped curves are not. If you are fitting a
broad enough range that you need a 6+ degree polynomial, you might do better
fitting a function that is actually s-shaped. Without knowing what kind of
data you have, the best I can suggest is that a 4- or 5-parameter logistic
(Google it) is used frequently in biochemistry. Any cumulative probability
distribution function is also s-shaped.

"Vikram" wrote:

Hi,

I have data which generates an s-shaped curve. The best trendlines that can
be obtained in Excel are of the order 6 and that isn't close to the accuracy
I am seeking.

Does anyone know if there is a way in Excel to get a trend line of order
higher than 6?

Thanks in advance,
Vikram