I am using Excel 2007. I am calculating significance level and I would like to use a formula to calculate it automatically.
I have got the coefficient and the standard error in cell b7 and c7, so i use the following function:
=CONCATENATE(B7,SI(B7/C7>+-1.65," ",SI(B7/C7>+-1.96,"*",SI(B7/C7>+-2.58,"**","***"))))
The formula returns only the assigned symbols for positive number, but not for negative ones. Could you help me?
Thank you a lot.
Can you give a couple of examples of values in B7 and C7 that are wrong, and what they should be?
BTW, is your Excel a French Excel (I think it needs an extra function, and I want to supply the correct name)?
Bookmarks