R is incredibly powerful and new users should take a look at these resources to get a more in depth view of how to get started
You'll also need this toy ODK data set in CSV format.
data.csv (570.1 KB)
What people want to do with their ODK data is pretty varied, but in the first instance most people will want some summaries and a couple of bar charts.
Here I provide a basic example of how to do this in R.
There are two scripts that you need to download in this zip file
R_Analysis_Scripts.zip (2.1 KB)
The easiest way to work these is to open RStudio, then click the
file menu and select
New Project. Save the project in a new folder, then open that folder. Paste the data set and the scripts. you downloaded above in to this folder, then click the .Rproj file to open the project.
In the Rstudio
File menu you can then use
open file to load the scripts.
To run them you simply press the
For most people, the
Basic.Data.Summaries.in.R file provides a useful start point. This script will
- Open the data set
- Select some useful variables
- Save a summary table to the R project folder
- Save another summary, split by a user defined variable
- Save a barchart
Armed with a bit of basic knowledge from the training resources above and you'll be up and running with your own analysis pretty quickly.
Many users want to share a summary report to their stakeholders. R Markdown is a nice way to make reports in html or pdf format. You can also put these online as a form of basic dashboard.
Basic.Data.Summaries.in.Rmd script does the same things as the basic analysis script, but makes a PDF report. You'll see that the key difference here is that you can window dress the documentation with text, show the code that was used to create the tables and charts and other things.
Simply open the .Rmd file in Rstudio and click
Knit to create the PDF in your R project folder.
R Markdown is very versatile and can export a whole bunch of different formats.
There's a lot of ways to make interactive dashboards in R. Some are very sophisticated, but are also a bit harder to use. Perhaps the simplest way is to use R Markdown to create an html page or site.
Basic.Data.Summaries.in.Rmd file and change line 3
Hopefully this post will provide a start point for people who have so far used excel for their analysis. Using a professional package for statistical analysis can seem daunting and does come with a pretty steep learning curve, but is worth it in the long run.
Example output files
Example_Outputs.zip (1.0 MB)