Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is there a way to obtain a polynomial trendline of order higher th
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is there a way to obtain a polynomial trendline of order higher th
Do you have a physical basis for a poly fit of such high order? Or do you
want the line just to look nice? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Vikram" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is there a way to obtain a polynomial trendline of order highe
Thank you for the reply.
There is no physical basis as such but I am looking at data that has to undergo several sets of such curve fitting combined with inter- and extrapolation. So in order for the final output to be free of any gross errors I need to make sure that the error induced by considering these approximations is avoided. I understand that there is a possibility of opposing actions of errors (thereby self-compensating), but I would like to avoid such errors in the first place. Because I couldn't find a higher order polynomial function , I had divided the domain into a few groups and am using different functions for different regions. This one works better for me. Thank you, Vikram "Jon Peltier" wrote: Do you have a physical basis for a poly fit of such high order? Or do you want the line just to look nice? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Vikram" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is there a way to obtain a polynomial trendline of order highe
Which leaves one wondering what the purpose of the fit is for?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Vikram" wrote in message ... Thank you for the reply. There is no physical basis as such but I am looking at data that has to undergo several sets of such curve fitting combined with inter- and extrapolation. So in order for the final output to be free of any gross errors I need to make sure that the error induced by considering these approximations is avoided. I understand that there is a possibility of opposing actions of errors (thereby self-compensating), but I would like to avoid such errors in the first place. Because I couldn't find a higher order polynomial function , I had divided the domain into a few groups and am using different functions for different regions. This one works better for me. Thank you, Vikram "Jon Peltier" wrote: Do you have a physical basis for a poly fit of such high order? Or do you want the line just to look nice? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Vikram" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is there a way to obtain a polynomial trendline of order highe
Bernard -
I think they want it to "look good" as a reassurance that any extrapolations also "look good". Vikram - Poly fits aren't bad if you need to interpolate values, even if there is no basis for selecting such a fit. However, you must check that the fit does what you want, without dips and bumps everywhere. If you need to extrapolate, you'd be unwise to depend on a polynomial relationship. Breaking up a set of data is probably not a bad idea, but you should still take care with the data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bernard Liengme" wrote in message ... Which leaves one wondering what the purpose of the fit is for? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Vikram" wrote in message ... Thank you for the reply. There is no physical basis as such but I am looking at data that has to undergo several sets of such curve fitting combined with inter- and extrapolation. So in order for the final output to be free of any gross errors I need to make sure that the error induced by considering these approximations is avoided. I understand that there is a possibility of opposing actions of errors (thereby self-compensating), but I would like to avoid such errors in the first place. Because I couldn't find a higher order polynomial function , I had divided the domain into a few groups and am using different functions for different regions. This one works better for me. Thank you, Vikram "Jon Peltier" wrote: Do you have a physical basis for a poly fit of such high order? Or do you want the line just to look nice? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Vikram" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is there a way to obtain a polynomial trendline of order highe
Thanks to everyone for answering my question. I am only looking to
interpolate between points. So I guess dividing the domain and then trying to fit different functions to these disparate regions would actually give better predictions within that division. Thanks again, Vikram |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating Polynomial Order Selection in Linest | Excel Worksheet Functions | |||
Increaseing Precision in polynomial trendline equations | Charts and Charting in Excel | |||
6th order polynomial equ yields unexpected results | Charts and Charting in Excel | |||
using linest to generate 3rd order polynomial coefficients | Excel Worksheet Functions | |||
higher order polynomial fit line x-coefficients | Excel Discussion (Misc queries) |