Inside the T.Test function we don’t have any argument of choosing the level of significance.
Let’s think here we have 0.01 but lets say we have 0.05,0.10 etc. The answer should be different or not.
"Great question! The significance level (α) is crucial in hypothesis testing, as it determines the threshold for rejecting the null hypothesis. In Python’s scipy.stats.ttest_ind() function, the default α is 0.05, but it’s essential to specify your desired significance level when interpreting results. Adjusting α can influence the p-value threshold for significance, affecting your conclusions. Always ensure your chosen α aligns with the context and consequences of your analysis
1 Like
Hello @Anish_Das123,
The T.TEST function does not do the threshold check here because it is simply giving us the p-value, and since it does not do the check, there is no need to supply it with the alpha value. Once we get the p-value using T.TEST, we can compare the result with our alpha.
Cheers,
Raymond
1 Like
Thank you very much
Thank you very much. Is there any other function in spreadsheet which do that.
Do what?
to check the threshold value.
We may just use the comparison operator for that. For example, =G18 < F18 will tell you whether or not a cell’s value (here, cell F18) is larger than another cell’s (here, cell G18), so you may use it to compare the cells that contain the p-value and the alpha value.
1 Like
Thank you very much
1 Like
You are welcome, @Anish_Das123!