How to filter Excel data

Put the whole data into TABLE:

https://support.office.com/en-us/article/Filter-data-in-an-Excel-table-7d8e9739-2898-4bfe-9d0f-c6204e6e5c8a

Excel function that produces "True" or "False"

https://exceljet.net/excel-functions/excel-true-function

SAS PROC EXPORT

 

http://blogs.sas.com/content/sasdummy/2012/01/25/export-to-excel-got-easier/

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 […]

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,"")))))

Basic Excel functions

http://www.excel-easy.com/functions/text-functions.html