What can be done here (also see the bottom of the page for detailed instructions)

Treatment Versus Control comparisons of

  1. Factorial experiments in CRD or RBD

  2. Single factor experiments in CRD or RBD

Prepare excel file by reading instruction below and then proceed to analysis

In this web application, you only just need to upload the Excel file in CSV format. To Prepare excel file follow the instructions below

  • Open a new blank excel file

  • Copy and paste observations into a new sheet (use only one sheet) of a new excel file

  • For comparing Treatments with control in factorial or single factor CRD , you need two columns first column is treatments and second column is observation. Control treatments should be in the last row. Treatments should be repeated as number of times as replication. See the example shown below

  • For comparing Treatments with control in factorial or single factor RBD , you need three columns first column is treatments, second column is block, third column is observation. Control treatments should be in the last row. See the example shown below

  • You can also add more than one response as columns

  • No space is allowed in the treatment name. If space is required use underscore ‘_’ or ‘.’ full stop; for example ‘Treatment name’ should be written as Treatment_name or Treatment.name

  • Don't type and delete anything on other cells without data. If so select those cells, right click and click clear contents

  • Give names to all column, Don't add any unnecessary columns that is not required for analysis

  • Data should be arranged towards upper left corner and row above the data should not be left blank.

  • Once all these are done, your file is ready. Now you have to save it as CSV file. It is very simple. Follow the instruction below.

How to save an excel file as CSV

  • File --> Save As --> (in the dialogue box appearing), select save as type: csv (comma delimited)

  • Now save your file in any name

  • After file preparation click on the analysis button above

  • Upload this file in to the application for analysis.


Your final file should look like this

CRD ExampleCarousel image

How to save your excel file as csv before proceeding for analysis?

click file --> save as

Carousel imageCarousel image