Forums » Using AMC (english) »
calculate the frequency of choices
Added by red sea over 12 years ago
please How do I calculate (by AMC) the frequency of choices in the referendum to uesed in Master's and doctoral and Knowledge of statistics and Sociology ?
Replies (8)
RE: calculate the frequency of choices - Added by Alexis Bienvenüe over 12 years ago
This is not currently possible to get statistics for indicative questions in AMC. Consider for example the following question:
\begin{question}{icecream}\QuestionIndicative\scoring{auto=1} Did you like this ice-cream? \begin{choices} \wrongchoice{not at all} \wrongchoice{a little} \wrongchoice{very much} \end{choices} \end{question}
After data analysis, you can read in the exported marks file the score (1 for not at all, 2 for a little, 3 for very much) of each student, and the average score for this question, that represents how much students like this ice-cream on average.
But you can't read in the file the number of students that answered for example not at all. Some solutions:
- use the
FREQUENCY
function in the LibreOffice exported file to get these values. - export to a CSV file with the Ticked boxes options set, and use any statistics software to get these values. As an example, use R with the following code:
n<-read.csv("~/MC-Projects/project-name/exports/project-code.csv") summary(n$"TICKED.question-code")
- use SQL requests on the SQLite database that contains the data capture results (data/capture.sqlite). See the comments and standard SQL requests in the source:AMC-perl/AMC/DataModule/capture.pm file for some help.
- a basic statistics tab for indicative questions in the ODS exported file
- a new export format to get only the ticked-or-not status of each box in a SQLite database
RE: calculate the frequency of choices - Added by red sea over 12 years ago
Thank you very much
I will wait to add these features to AMC.
best regards
RE: calculate the frequency of choices - Added by red sea over 12 years ago
RE: calculate the frequency of choices - Added by Alexis Bienvenüe over 12 years ago
a new export format to get only the ticked-or-not status of each box in a SQLite database
You can use the attached plugin rawsqlite.tgz for that (with AMC version>=1.0.975, using the menu item Tools->Plugins->Add). I don't know if it's better to let it live as a plugin or to integrate it in AMC...
rawsqlite.tgz - AMC plugin to export raw data (are boxes ticked or not) as a SQLite database (1.6 kB)
RE: calculate the frequency of choices - Added by Alexis Bienvenüe over 12 years ago
Since revision r977, questions basic statistics can be shown in tables that can be included in the ODS export.
RE: calculate the frequency of choices - Added by Tak Huen Chau over 12 years ago
Help! I can't add a plugin!
RE: calculate the frequency of choices - Added by Tak Huen Chau over 12 years ago
Version=1.0.3 (svn:704)
RE: calculate the frequency of choices - Added by Alexis Bienvenüe over 12 years ago
Tak Huen Chau wrote:
Help! I can't add a plugin!
Version=1.0.3 (svn:704)
Yes: you need a more recent version of AMC (on Ubuntu, use the test AMC PPA).
(1-8/8)