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

Showing results for

- JMP User Community
- :
- Discussions
- :
- Re: Line fit in graph builder

- 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

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

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

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

Jun 28, 2013 10:36 AM
(3660 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
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 28, 2013 10:36 AM
(3661 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
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 28, 2013 11:23 AM
(1830 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.