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.
Some features that could be added to AMC to help the user:
  • 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

if any one want to know how we can used "FREQUENCY function", this 2 example:
first
2nd

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

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)