Riffyn Functions Help

Macros

Use these by clicking their corresponding button on the AddIns tab of the Ribbon.

 


Stack 

Description

Reshapes matrix data (e.g., 96-well or 384-well plate data) into a standard table.

 


 

 

Functions

Use these functions like any other Excel function. Enter "=rif...(...)" in any cell.

 


rifFDR 

rifFDR(Pval, PvalDist, [Q], [FDRType])

Description

Calculates the false discovery rate for a P-value using a set of P-values calculated from the same null hypothesis.

Arguments

Pval:  the P-value for which the FDR will be calculated

PvalDist: Range of cells containing the set of all P-values calculated for the experiment. All P-values must be calculated using the same null hypothesis (e.g., the same control data). If you have data P-values that come from (or potentially come from) multiple underlying distributions, consider using this very impressive method (not available in Excel though).

Q: Optional. If TRUE, then return the q-value.  If FALSE return the unadjusted FDR.

FDRType: Optional. Selects the method used for calculating the FDR.

 


rifInterpolate

rifInterpolate(Xvalue, Xvalues, Yvalues)

Description

Returns and interpolated value of Y at a given value X, among an array of X and Y values of equal length.

Arguments

Xvalue:  the value of X at which to calculate the interpolated Y value.

Xvalues: an array of X values.

Yvalues: an array of Y values of equal length to the Xvalue array.

 


rifIncRnum

rifIncRnum(rnum)

Description

Increments the value of a Riffyn run number in the form R####.  E.g., =rifIncRnum("R0014") will return "R0015".

Arguments

rnum:  a string in the form C####, where C is any single character and # is any digit.

 


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request