Transformations

Transformations provide methods to adjust or scale data. This isue ful when you want to reshape data or perform operations across multiple columns and groups. Sphinx offers multiple transformations, including:

• ∆Ct
• ∆∆Ct
• Pfaffl
• ELISA Curve Fitting
• 3PL Curve Fitting
• 4PL Curve Fitting
• Kinetic Curve Fitting
• 1-way ANOVA
• 2-way ANOVA
• Pearson Correlation
• Spearman Correlation
• Descriptive Statistics
• Linear Regression
• Weighted Linear Regression
• Mann Whitney Test
• Robust Outlier Detection
• Normalized Percent Inhibition (NPI)
• Signal Normalization
• T-test
• Paired T-test
• Normalization
• Fold Change
• Pivot Long
• Pivot Wide
• Split Column
• Z Factor

You can add these transformations to an Analysis using the “Analyze” option in the Analysis Toolbar.

AI Code Generation

If you need to perform a transformation that is not on the list above, you can use Metis to build it.

Just write what you need done to the data and our AI agent will write code and execute it to create a transformed Data Table. For example, if you had a column that contained IDs with multiple pieces of information such as “Sample-001 (rep 1)-Plate 1”, you could say: “Split my ID column into a Sample ID column, a replicate column, and a plate identifier column”.