In excel how do you figure out based on a t-test, are betas statistically signif
ID: 3180407 • Letter: I
Question
In excel how do you figure out based on a t-test, are betas statistically significant at 1% level of significance? Why? How about 5% level of significance and 10% level of significance and why? In excel how do you figure out based on a t-test, are betas statistically significant at 1% level of significance? Why? How about 5% level of significance and 10% level of significance and why? In excel how do you figure out based on a t-test, are betas statistically significant at 1% level of significance? Why? How about 5% level of significance and 10% level of significance and why? In excel how do you figure out based on a t-test, are betas statistically significant at 1% level of significance? Why? How about 5% level of significance and 10% level of significance and why?Explanation / Answer
we can use excel tdsit function to get p value of the test. If p value is less then significance level the test is significant.
Otherwise it is not significant.