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
- :
- Why do I get difference betwen excel and jmp when doing least square regression?

- 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
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 22, 2016 1:12 AM
(8208 views)

Hi,

I'm doing what is basic least square regression on 12 points (4 points in triplicate) but I get different results between excel and JMP. Can anyone offer an explanation? Thanks

Result | Excel | JMP |
---|---|---|

Intercept | -1.30885 | -1.210003 |

Slope | 0.926018 | 0.9250579 |

UCL (99.7%) at intercept | 3.110484 | 10.0827... |

R2 | 0.9973367 | 0.997364 |

for data the data below:

X | Y |
---|---|

0 | 0.942 |

0 | 0.152 |

0 | 0.918 |

27 | 22.597 |

27 | 23.464 |

27 | 22.184 |

55 | 47.329 |

55 | 47.329 |

55 | 49.018 |

137 | 121.108 |

137 | 129.013 |

137 | 129.189 |

1 ACCEPTED SOLUTION

Accepted Solutions

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

hi johnhart1,

I would guess you made a typo or missed and observation. I get the same results.

best,

ron

6 REPLIES 6

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

Re: Why do I get difference betwen excel and jmp when doing least square regression?

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

hi johnhart1,

I would guess you made a typo or missed and observation. I get the same results.

best,

ron

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

Re: Why do I get difference betwen excel and jmp when doing least square regression?

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

Re: Why do I get difference betwen excel and jmp when doing least square regression?

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

Re: Why do I get difference betwen excel and jmp when doing least square regression?

Hi,

I checked that bit and changed all the data to be strictly the same amount of decimal places

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

Re: Why do I get difference betwen excel and jmp when doing least square regression?

mmmhhhhh I get the same answer as well now....... something strange is going on somewhere.

Anyway! Thanks for the help!