Note for GraphPad Prism users
BioRender's data tables are structured differently from GraphPad Prism. GraphPad Prism requires your data to be in a wide format. BioRender requires your data to be in a long format, similar to R, Origin, and SPSS.
The examples below explain how to format data for BioRender.
Learn more about long and wide data here.
t-tests and one-way ANOVAs
The spreadsheet for t-tests and one-way ANOVAs will have two columns: (A) your independent variable and (B) your dependent variable.
All of your group labels for your data points will go in column A and your results will go in column B.
Note: This is different from how GraphPad Prism’s spreadsheet requires your data to be formatted, but the same as how R, Origin, and SPSS typically accept data.
Example: You’re comparing the weight of wild-type vs. knockout mice.
Two-way ANOVAs
The spreadsheet for regressions has three columns:
(A) the independent variable which will be displayed on the x-axis
(B) the dependent variable
(C) the (optional) second independent variable which will be displayed in the legend
Note: This is different from how GraphPad Prism’s spreadsheet requires your data to be formatted, but the same as how R, Origin, and SPSS typically accepts data.
Example: you’re comparing the effect of different drug types (independent variable) on the resting heart rate (dependent variable) of male and female (independent variable) mice.
Regressions (linear and non-linear)
The spreadsheet for regressions has three columns:
(A) the independent variable which will be displayed on the x-axis
(B) the dependent variable
(C) the (optional) second independent variable which will be displayed in the legend
Because the data will be used to run a regression analysis, column A must be numeric.
Example: you’re comparing the effect of different drug concentrations (independent variable) on the resting heart rate (dependent variable) of male and female (independent variable) mice.
Have any questions or concerns?
Open our chat messenger (bottom-right of any BioRender webpage).