Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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.