Hello,

Is there an worksheet function that calculates t-stat of the regression line of 2 data series?

Say I have 2 columns of data (Y and X), I run a regression of Y on X, which gives me some slope coefficient this an be obtained by SLOPE(...) function. To estimate the significance of this slope coefficent I need t statistic. Is there a function to obtain it?

Note: I am aware that the result is obtainable from Tools - Data Analysis - Regression under the heading 't Stat'. But can I obtain it directly as a function?

Thanks!

Jiri

Is there an worksheet function that calculates t-stat of the regression line of 2 data series?

Say I have 2 columns of data (Y and X), I run a regression of Y on X, which gives me some slope coefficient this an be obtained by SLOPE(...) function. To estimate the significance of this slope coefficent I need t statistic. Is there a function to obtain it?

Note: I am aware that the result is obtainable from Tools - Data Analysis - Regression under the heading 't Stat'. But can I obtain it directly as a function?

Thanks!

Jiri

## Comment