cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
johnhart1
Level II

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

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

ResultExcelJMP
Intercept

-1.30885

-1.210003
Slope0.9260180.9250579
UCL (99.7%) at intercept3.11048410.0827...
R20.99733670.997364

for data the data below:

XY

0

0.942
00.152
00.918
2722.597
2723.464
2722.184
5547.329
5547.329
5549.018
137121.108
137129.013
137

129.189

1 ACCEPTED SOLUTION

Accepted Solutions
ron_horne
Super User (Alumni)

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

hi johnhart1​,

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

12045_Untitled111.png

best,

ron

View solution in original post

6 REPLIES 6
johnhart1
Level II

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

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

ron_horne
Super User (Alumni)

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

hi johnhart1​,

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

12045_Untitled111.png

best,

ron

Kevin_Anderson
Level VI

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

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.

mpb
mpb
Level VII

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

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

johnhart1
Level II

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

johnhart1
Level II

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!