Survey data

**whitmja** · 10-01-2014, 02:59 AM

Hi there,
I have over 20 submissions from a survey that have been parsed to a spreadsheet.

I have been trying to research whether it is possible to use excel to highlight relationships between the answers that were submitted - by the different individuals.

Even the possibility of a graph would be awesome, but a dendogram would be ideal.

Kind regards.
Mark

**Kaper** · 10-01-2014, 03:50 AM

Hi Mark,
Have a look here: http://excelgraphs.blogspot.com/2013...-analysis.html would go up to "avesome level" :-).
You will need RExcel, but for home use it's free http://rcom.univie.ac.at/download.html

**whitmja** · 10-01-2014, 07:57 AM

Thanks so much Kaper. This is exactly what I am looking for. Unfortunately I cant get the program to work, by following the wiki page and installation notes.

The issue I have is trying to set an R server. Do you know if I need this to perform analysis of table data?

Ps I downloaded the other setup option,statconnDCOM, from the section at the bottom of the wiki called (D)COM server but this has also failed to help me.

Thank you for your help
Mark

**Kaper** · 10-02-2014, 02:43 AM

Hi,
Have you also set up rscproxy ( see http://cran.r-project.org/web/packag...oxy/index.html for ready binaries ) and R itself http://www.r-project.org/ ?
Sorry, I'm not aware of all details, because one of my ex MSc students used this set of tools for his thesis.