Norm,
You are correct the 3rd order equation was much closer. It is only about 0.5% off at 131". That is much better. Actually it is much better through out the curve. I just figured that the higher the order the better the curve. Thanks Norm!!
Lance,
Thanks for the info on how to look at the curve much better. I figured there would be some errors especially at the ends of the curve. I just couldn't see it until you told me about it.
A 3rd order equation looks like it will do the job within the accuracy I need. A big thanks to Tom for showing us all how to use this feature in Excel. It is very powerful!! And a big thanks to you Lance for doing a lot of leg work on this.
You are correct the 3rd order equation was much closer. It is only about 0.5% off at 131". That is much better. Actually it is much better through out the curve. I just figured that the higher the order the better the curve. Thanks Norm!!
Lance,
Thanks for the info on how to look at the curve much better. I figured there would be some errors especially at the ends of the curve. I just couldn't see it until you told me about it.
A 3rd order equation looks like it will do the job within the accuracy I need. A big thanks to Tom for showing us all how to use this feature in Excel. It is very powerful!! And a big thanks to you Lance for doing a lot of leg work on this.