---
title: "Formatting hints and tips"
slug: "formatting-hints-and-tips"
updated: 2022-01-19T13:25:46Z
published: 2022-01-19T13:25:46Z
canonical: "userguide.dataclassroom.com/formatting-hints-and-tips"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://userguide.dataclassroom.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Formatting hints and tips

It's worth thinking a bit about how you enter data as you collect it, before you get to trying to analyze it. Here's a pair of quick examples to help you think about the issues.

### Example 1 - an experiment measuring a numerical outcome

Let's say you are running an experiment to see how light affects plant growth. You will expose plants to either light or dark environments, and measure **their growth after a week**. You have three volunteers, Ali, Beth and Cy who will each manage a pair of plants. So six plants in all.

How would you suggest the results get entered in a spreadsheet?

#### Table of average growth vs treatment

![](https://lh3.googleusercontent.com/OVVl2hgYVnNdgJbw3YCNYfoVQT-Q66cQBrpiIRNkkKr2hShCMJw4934VsWvgvZGPf_BimtVKYKIRhkARFr-OFYVY-CP9LvJXGjOyaOAjj8BOfT8JiGdkR8U7YEXTBWCCqpFqX_Fj6nB9)

If this is your choice, [read more here](https://userguide.dataclassroom.com//v1/docs/average-growth-vs-treatment) for a discussion.

#### Table of experimenter vs treatment

![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/image-1636111188924.png)

If this is your choice, [read more here](https://userguide.dataclassroom.com//v1/docs/table-of-experimenter-vs-treatment) for a discussion.

#### Table with 1 row per plant ![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/image-1636111434698.png)

If this is your choice, [read more here](https://userguide.dataclassroom.com//v1/docs/one-sample-per-row-numerical-outcome) for a discussion.

### Example 2 - an experiment measuring a categorical outcome

Let's say you are running an experiment to see whether light affects whether plants live or die. This time, each experimenter has 10 plants they will divide up between light and dark environments, and they will register the outcome as either "Lived" or "Died" after four weeks.

#### Table of treatment vs result

![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/image-1636112547230.png)

If this is your choice, [read more here](https://userguide.dataclassroom.com//v1/docs/table-of-treatment-vs-result) for a discussion.

#### Table of experimenter vs treatment and result

![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/image-1636112601384.png)

If this is your choice, [read more here](https://userguide.dataclassroom.com//v1/docs/table-of-experimenter-vs-treatment-and-result) for a discussion.

#### Table with 1 row per plant

![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/image-1642597560142.png)

If this is your choice, [read more here](https://userguide.dataclassroom.com//v1/docs/one-sample-per-row-categorical) for a discussion.