Since R is a programming language, you can write code that can handle any kind of arrangement.
However, ideally you would arrange your data with variables in columns and samples/cases/measurements in rows. This is the way the data.frame structure is organized which is used with many standard R functions.
You need to make your data "Tidy".
Read this:
Wickham, Hadley (2014), Tidy data, Journal of Statistical Software, vol. 59.
Link below.
To make your data tidy in Excel, you may need to create a "reverse pivot table". This is easy using the latest Excel (2016/ Office 365) but also not hard if you must use an older version. Check MS-Office blogs, link below, and some of the lessons on ExcelMaster, also linked below.
http://vita.had.co.nz/papers/tidy-data.html
https://blogs.office.com/2015/12/15/learn-how-to-unpivot-static-tables-in-excel-2016/
https://excelmaster.co/2013/11/11/reverse-pivot-magic/
Dear the data arrangement usually depends on the package you use in R.
Although in many cases the replicated data can be arranged as one replication below another by adding one extra column for replication as a factor variable having factors equal to your replications.
I have attached a file below for your reference.
hope this will be helpful
Dear Saurav,,
Thank you very much for valuable suggestion.
Devendra
Hi, Aliyi Robsa Shuro . To receive any kind of informative answer, you'll have to explain what you mean by unreplicated data, what kind of variables you have (nominal, ordinal, continuous, count ? ), your basic experimental design, and what it is you are trying to determine with your data.
It is a continuous and count-pairwise plot comparison for vegetation structure via growth forms and composition, including soil property data. A given variable can have multiple sub-variables. How can we arrange them in Excel?
- Badges
- Science topic