Use these by clicking their corresponding button on the AddIns tab of the Ribbon.
Reshapes matrix data (e.g., 96-well or 384-well plate data) into a standard table.
Use these functions like any other Excel function. Enter "=rif...(...)" in any cell.
rifFDR(Pval, PvalDist, [Q], [FDRType])
Calculates the false discovery rate for a P-value using a set of P-values calculated from the same null hypothesis.
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(Xvalue, Xvalues, Yvalues)
Returns and interpolated value of Y at a given value X, among an array of X and Y values of equal length.
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.
Increments the value of a Riffyn run number in the form R####. E.g., =rifIncRnum("R0014") will return "R0015".
rnum: a string in the form C####, where C is any single character and # is any digit.