For a linear fit, you need to select either two horizontally adjacent cells
or a 2 by 5 block if you want detailed stats. The type the formula and then
use CTRL+SHIFT+ENTER
Let us know how it goes
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"mcduffcpa" wrote in message
...
I am trying to use the above function, but only the slope results are
shown.
I have been careful to CTL-Shift-Enter to make the function an array.
The
y-intercept does not show up. I am using Excel 2007. Any help would be
appreciated.