t-test in simple linear regression

[kourosh kalayehParticipant]

Hi,

I was wondering if there is any way to use built-in t-test functionality with linear regression.

Thanks

Kourosh

[dgteamModerator]

The built-in t-test is set up for using column of data as input, so would not work directly for the regression output; however, you can conduct a t-test using statistical functions ( e.g., tcdf) in an expression column or expression variable.

For example, an expression variable can be used for a two-sided hypothesis test for the  intercept from a regression, where the output is the p-value.

H0: Value = 0
H1: Value ≠ 0

In the screen shot, the values outlined in red are output from the regression and the values in blue are calculated.

t =  test statistic

df =  degrees of freedom

p = 2*(1-tcdf(abs(t),df))

 

[kourosh kalayehParticipant]

Great, thanks.

[Author]

Posts