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
- :
- Why do I get difference betwen excel and jmp when ...

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

Jul 22, 2016 1:12 AM
(3613 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 |

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

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

Jul 22, 2016 4:32 PM
(6317 views)

hi johnhart1,

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

best,

ron

6 REPLIES

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

Jul 22, 2016 1:38 AM
(3427 views)

Quick addendum: I get the same result as excel when using the JMP excel pluggin but different when putting the numbers directly into JMP!

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

Jul 22, 2016 4:32 PM
(6318 views)

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

Jul 23, 2016 8:36 AM
(3427 views)

Friends don't let friends use Excel for statistics! There are many scholarly articles available about the statistical problems with Excel. Microsoft knows about them, yet won't fix them. Let the consumer beware.

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

Jul 23, 2016 9:19 AM
(3427 views)

In this case, my guess is that the data in Excel has greater precision then the 3 decimal places shown in the original post.

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

Jul 25, 2016 2:41 AM
(3427 views)

Hi,

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

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

Jul 25, 2016 2:55 AM
(3427 views)

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

Anyway! Thanks for the help!