## calculate the frequency of choices

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üeabout 10 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 seaabout 10 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 seaabout 10 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üeabout 10 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...

#### RE: calculate the frequency of choices - Added by Alexis Bienvenüeabout 10 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 Chauabout 10 years ago

Help! I can't add a plugin!

#### RE: calculate the frequency of choices - Added by Tak Huen Chauabout 10 years ago

Version=1.0.3 (svn:704)

#### RE: calculate the frequency of choices - Added by Alexis Bienvenüeabout 10 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)