hello,

i have such a data:

Y X1 X2 X3
0.77% -5.23% 13.40% 20.12%
3.55% 0.77% 6.57% 13.40%
1.47% 3.55% 0.74% 6.57%
1.81% 1.47% -2.15% 0.74%
1.07% 1.81% -2.30% -2.15%
5.47% 1.07% 0.06% -2.30%
-2.23% 5.47% 2.85% 0.06%
-1.77% -2.23% 0.31% 2.85%
0.27% -1.77% 2.85% 0.31%

i use formula =LINEST(range1;range2;0;1)

and i get R.squared value -9.61%, what is obviously mistake

r.sq is always 0 and < 1..

i use office xp

and as i'm reading now (http://support.microsoft.com/kb/828533/)

there are some differences between results in excel 2002 and excel 2003

so, can it cause this problem?