Augmented RCBD analysis
Genetic Variability Analysis
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
Observations should be pasted as columns.
Minimum three columns are required -: Block, Treatment and Yield
Preferably checks may be named with some separate names to identify from treatments (eg: C1, C2 etc)
Rest of the column should be characters of interest
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
You can use any names for your columns. No space is allowed in the Column name. If space is required use underscore ‘_’ or ‘.’ full stop; for example ‘Variable name’ should be written as Variable_name or Variable.name
Data should be arranged towards upper left corner and row above the data should not be left blank.
Only one sheet is allowed in the uploading excel file
Once all these are done, your file is ready (Will look like the example given below). 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
Final file would look like this!!
in this example check is denoted as C1, C2, C3 and C4
Treatments denoted as T1, T2,..., T8
How to save your excel file as csv before proceeding for analysis?
click file --> save as