**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.

0
0

#### Was this article helpful?

0 out of 0 found this helpful