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
- :
- Discussions
- :
- Re: Line fit in graph builder

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
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 28, 2013 9:21 AM
(3306 views)

I am wanting to fit a straight line in graph builder, but only for a specified range of data. I want my chart to show the whole spectrum of data and the smoother line (as shown below), but also a fit line only using the range of the data between the black lines. I would also like to get the equation of the line and show it on the graph if possible.

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 28, 2013 10:36 AM
(6148 views)

Solution

Three possibilities come to mind for the main part (lacking the line equation).

1) Add a weighting column to your data table, set to 1 in the middle area and 0 elsewhere. Then use GB and assign the new variable to the Freq role.

2) Split your Y column into two columns, Y1 and Y2, with Y1 missing in the middle area and Y2 missing elsewhere. Now put both Y1 and Y2 into the Y role in GB. Add a Line of Fit, Right-click in graph > Line Of Fit > Y > Y1 to turn off Y1 for the Line of Fit.

3) Mark the rows for the outer points as excluded (but not hidden) and use Fit Y by X. Use Group By to get the overlay effect there.

Only the third option readily gives you an equation for the fit, though Graph Builder will show it in the graph for JMP 11 due out in September.

2 REPLIES

Highlighted
Solution

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 28, 2013 10:36 AM
(6149 views)

Three possibilities come to mind for the main part (lacking the line equation).

1) Add a weighting column to your data table, set to 1 in the middle area and 0 elsewhere. Then use GB and assign the new variable to the Freq role.

2) Split your Y column into two columns, Y1 and Y2, with Y1 missing in the middle area and Y2 missing elsewhere. Now put both Y1 and Y2 into the Y role in GB. Add a Line of Fit, Right-click in graph > Line Of Fit > Y > Y1 to turn off Y1 for the Line of Fit.

3) Mark the rows for the outer points as excluded (but not hidden) and use Fit Y by X. Use Group By to get the overlay effect there.

Only the third option readily gives you an equation for the fit, though Graph Builder will show it in the graph for JMP 11 due out in September.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 28, 2013 11:23 AM
(3167 views)

Great. Thank you very much. I think I am going with option 2 with a slight modification.

I couldn't get option 1 to show both sets of data on the same Y axis at the same time in GB. With option 3, I couldn't find a way to get a smoother line in the Fit Y by X (and if I could it didn't seem like it would include the excluded data, which I wanted for the smoother line). I ended up going with option 2, except instead of adding 2 additional columns I only added 1 that only had the data I wanted to fit the line to. Then I put my original Y and my new Y into GB and fit a line only to the new Y as you described. If I did 2 new columns the smoother line was not correct for the middle section.

I look forward to JMP 11 when I can get my equation on the graph.