M
MNi
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Why do I get one RSQ-value in LINEST and another value in the xy-chart when doing a simple linear regression forcing the y-intercept to equal 0?
Is this also a consequence of the lack of VBA (whatever that is) in Excel 2008?
Using {=LINEST(G13:L13;G10:L10;0;TRUE)} with
G10:L10 being x-values:
0
60
120
180
240
300
and G13:L13 being y-values:
0
920,04
1756,44
2551,02
3387,42
4140,18
returns a slope of 14,041381818 and an RSQ of 0,999559520.
However a slope of 14,041381818 but an RSQ of 0,998559162
is returned when plotting the same data into an xy-chart, forcing the
y-intercept of the added trendline to equal 0.
What am I missing?
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Why do I get one RSQ-value in LINEST and another value in the xy-chart when doing a simple linear regression forcing the y-intercept to equal 0?
Is this also a consequence of the lack of VBA (whatever that is) in Excel 2008?
Using {=LINEST(G13:L13;G10:L10;0;TRUE)} with
G10:L10 being x-values:
0
60
120
180
240
300
and G13:L13 being y-values:
0
920,04
1756,44
2551,02
3387,42
4140,18
returns a slope of 14,041381818 and an RSQ of 0,999559520.
However a slope of 14,041381818 but an RSQ of 0,998559162
is returned when plotting the same data into an xy-chart, forcing the
y-intercept of the added trendline to equal 0.
What am I missing?