turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- use a polynomial fit equation to predict new data

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 14, 2010 7:37 AM
(1906 views)

I have 97 different sites with monthly average temperature data. Therefor 97 different figures with a satisfactory line drawn through the 12 data points. Here is an example of one site's equation:

T_AVE = 2.127629 + 0.0769089*DOY - 0.0015991*(DOY-183.083)^2 - 2.3911e-6*(DOY-183.083)^3 + 2.1454e-8*(DOY-183.083)^4

I want to create a new column that will predict the X variable "DOY" when the Y variable "T_AVE" equals 5. There should be two solutions (~120, ~320).

Do I need to copy (by hand) the equation for each of the 97 sites and paste it into a new column?

Any suggestions will be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 15, 2010 1:22 PM
(2647 views)

Solution

If the polynomial is degree 1 or 2 then solve manually for X and use the resulting formula. If your polynomial is of degree 3 or higher solving directly is either impossible or extremely messy.

Solving numerically automatically for all real roots is not straight forward. If you are willing to be involved in the solution, then, assuming the formula has been saved in a column with a couple of rows and a provisional min and max value for X, you can call up the Profiler and specify that column. Then you will see a graph of the polynomial. Specify that you want a desirability function. It will default to "maximize". Change the desirability function to "target" and adjust the curve so that it is centered at 5 and is fairly wide to start.

Adjust the horizontal axis as necessary to see where your function heads off to infinity at either end. Then use the desirability function plot to locate the current value at one of the high desirability values and click on "maximize desirability". You may need to repeat to get convergence. Repeat for each of the indicated solutions.

Message was edited by: mpb

If you do a Google search for "Solving Quartics and Cubics for Graphics" the first hit is a paper on the topic which will give you a feel for the difficulty of automatic solution.

Solving numerically automatically for all real roots is not straight forward. If you are willing to be involved in the solution, then, assuming the formula has been saved in a column with a couple of rows and a provisional min and max value for X, you can call up the Profiler and specify that column. Then you will see a graph of the polynomial. Specify that you want a desirability function. It will default to "maximize". Change the desirability function to "target" and adjust the curve so that it is centered at 5 and is fairly wide to start.

Adjust the horizontal axis as necessary to see where your function heads off to infinity at either end. Then use the desirability function plot to locate the current value at one of the high desirability values and click on "maximize desirability". You may need to repeat to get convergence. Repeat for each of the indicated solutions.

Message was edited by: mpb

If you do a Google search for "Solving Quartics and Cubics for Graphics" the first hit is a paper on the topic which will give you a feel for the difficulty of automatic solution.

4 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 15, 2010 3:19 AM
(1662 views)

I've then fitted a cubic polynomial in height to the weight data: originally I did this interactively, but I've copied the resulting script below (to do that, click on the red triangle at the top of the window and select Script | Save Script to Script Window), so if you run this you should see the resulting output from that model fit:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 15, 2010 7:26 AM
(1662 views)

Does anyone know if JMP can solve for essentially what is the X term in a polynomial. In the above equation, it means solving for the DOY term which appears on the right side of the equation?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 15, 2010 1:22 PM
(2648 views)

Solving numerically automatically for all real roots is not straight forward. If you are willing to be involved in the solution, then, assuming the formula has been saved in a column with a couple of rows and a provisional min and max value for X, you can call up the Profiler and specify that column. Then you will see a graph of the polynomial. Specify that you want a desirability function. It will default to "maximize". Change the desirability function to "target" and adjust the curve so that it is centered at 5 and is fairly wide to start.

Adjust the horizontal axis as necessary to see where your function heads off to infinity at either end. Then use the desirability function plot to locate the current value at one of the high desirability values and click on "maximize desirability". You may need to repeat to get convergence. Repeat for each of the indicated solutions.

Message was edited by: mpb

If you do a Google search for "Solving Quartics and Cubics for Graphics" the first hit is a paper on the topic which will give you a feel for the difficulty of automatic solution.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 15, 2010 12:22 PM
(1662 views)