https://www.ablebits.com/office-addins-blog/2017/09/06/excel-rank-functions/
=rank.eq(x1, x1-x5)
x1 refers to the value you want to evaluate
x1-x5 specifies the range
When reading Excel date by SAS
DOB=DOB-21916;
Excel string functions
=CONCATENATE("Q",K12,"",C12)
=LEFT(L12,32)
How to filter Excel data
Put the whole data into TABLE:
Excel function that produces "True" or "False"
https://exceljet.net/excel-functions/excel-true-function
I tried this myself and it worked. If column C2 and D2 contain the identical values, this will return "TRUE."
=IF(C2=D2,TRUE())
SAS PROC EXPORT
Excel function to replicate t-test off SAS PROCs (e.g., GLIMMIX)
Phil of SAS helped me identify this function. Thank you.
T-test conducted in PROC GLIMMIX (or most likely other regression procedures) is expressed in Excel function as:
=2*(1-T.DIST( T_VALUE , DEG_OF_FREEDOM ,TRUE))
where T_value must be an absolute value of the original t-value (e.g., if -2 then 2).
This expresses CDF (cumulative distribution function), not PDF (probability density function). I will explicitly discuss what these are in the near future.
I wanted to know how much of statistical results (off PROC GLIMMIX in this case) comes from SAS's internal computation (i.e., I can't replicate results outside SAS) and how much of it can be done in Excel given what I get from SAS output.
Excel function for statistical significance
=IF(ABS($G3)<0.001,"***",IF(ABS($G3)<0.01,"**",IF(ABS($G3)<0.05,"*",IF(ABS($G3)<0.1,"",IF(ABS($G3)>=0.1,"")))))