Regression Output without Analyst Tool Pack

[dinesh_ltjd]

Hi All,

I am trying to get a regression output in excel for a particular data set however I don't want to use Analyst Tool Pack addinn.

Please suggest if there is a way to do this.

Thanks
DInesh

[Kaper]

select range of cells 2 columns by 5 rows, and write formula like:

Please Login or Register  to view this content.

(of course instead of A2:A15,B2:B15 ranges with your X and Ys)

and !!! commit it as array formula (don't press Enter but Ctrl+Shift+Enter) !!!

[dinesh_ltjd]

Thanks Kaper

But I also want t-Value, p-value to get calculated

Thanks
Dinesh

[MrShorty]

The LINEST() function can output additional statistics, including r^2, though it doesn't appear that t is among them: http://office.microsoft.com/en-us/ex...010069838.aspx

Excel has a long list of statistical functions, including several related to the t statistic http://office.microsoft.com/en-us/ex...920.aspx?CTT=1 Assuming you already understand how to use each statistic, these functions should be useful for calculating the desired statistics.

If you are not certain of how to use the desired statistics, I might suggest this website, which explains both the statistical concepts and the Excel functions being used http://www.real-statistics.com/regression-models/