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

Skip to content
# Category: Excel

## Excel function ranking

## When reading Excel date by SAS

## Excel string functions

## How to filter Excel data

## Excel function that produces "True" or "False"

## SAS PROC EXPORT

## Excel function to replicate t-test off SAS PROCs (e.g., GLIMMIX)

## Excel function for statistical significance

## Basic Excel functions

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

DOB=DOB-21916;

=CONCATENATE("Q",K12,"",C12)

=LEFT(L12,32)

Put the whole data into TABLE:

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())

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.

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