How to enter data into the spreadsheet

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.