Share via

Regression Result Different From Windows Version

Anonymous
2019-01-25T10:24:23+00:00

Hello,

I'm using the MacOS version of Excel, and the regression result i get is different compared to the one done in Windows version. Any ideas?

These are the data.

X Range Y Range
100 0
200 -0.75
300 0.24
400 0.99
500 1.73
600 2.44
700 3.48
800 4.60

The result for MacOS version.

Result for Windows Version.

Other info.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2019-01-25T14:00:04+00:00

It appears that you selected the wrong range in Windows since the Observation = 7 not 8

But even with 8 my results do not agree exactly with your Mac results.

Can you post file to OneDrive or Dropbox and tell us the link?

best wishes

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful