Polynomial Array formula

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

NightRider

Thread Starter
Joined
Nov 29, 2000
Messages
38
Does anybody know of an Excel formula for a 4th order polynomial trend? I've been able to write one for a linear trendline but all attemps at a non-linear trendline have failed. I need the formula, not just the graphical representation which I can get in a chart, so that I can analyze the data.
Thanks.
 
Joined
Jul 29, 2001
Messages
21,334
Look on some search engines. Don't the examples in Excel point in the right direction?
 

NightRider

Thread Starter
Joined
Nov 29, 2000
Messages
38
I've been reading the results from various combos of 'Excel polynomial trendlines formula' searches via Google for the past 4 days and I'm only getting more confused. Excel help does have some formula info, but it is not very specific. Any help would be GREATLY appreciated.
 
Joined
Jul 29, 2001
Messages
21,334
Don't ask me!! I have problems with monosyllabic speech much less polymorphic polynomial formulas.....LOL. I'll see if I can find aything else.
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Polynomial Array formula

Obviously, you didn't read the part in the agreement about using foul language!

:D

I'm looking too.
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Don't laugh at me if this doesn't help. I found it in "my files".

starting in Row 1, insert the desired polynomial in this format:
=a*(1)^m+b*(1)^(m-1)+…j(1) + C
where m is the greatest desired power of x, a,b,…j are the corresponding coefficients, and C is the constant in the expression, if any. (1) is a placeholder for the next step, replace (1) with:
(Row()-n)
where n is the value of 1 more than the absolute value biggest negative value in the desired domain (x-values). Copy the formula down n+p rows, where p is the value of the greatest value in your domain and then graph the results.

???
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top