﻿<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>Millisecond Forums » Millisecond Forums » Inquisit 5  » Summary data output</title><generator>InstantForum 2017-1 Final</generator><description>Millisecond Forums</description><link>https://forums.millisecond.com/</link><webMaster>Millisecond Forums</webMaster><lastBuildDate>Sat, 04 Jul 2026 15:49:10 GMT</lastBuildDate><ttl>20</ttl><item><title>Summary data output</title><link>https://forums.millisecond.com/Topic25183.aspx</link><description>Hello,&lt;br/&gt;We have an experiment where each participant's individual responses per item are saving on different rows of a spreadsheet in the output file. We are looking for recommendations about how to efficiently save this as mean scores with one line per participant in the spreadsheet instead.&lt;br/&gt;&lt;br/&gt;So far my best idea is to save as a .dat file, then open in SPSS and take averages from there.&lt;br/&gt;&lt;br/&gt;Thanks very much!</description><pubDate>Fri, 29 Jun 2018 12:36:45 GMT</pubDate><dc:creator>inquisituser22</dc:creator></item><item><title>RE: Summary data output</title><link>https://forums.millisecond.com/Topic25184.aspx</link><description>&lt;div data-id="25183" class="if-quote-wrapper" unselectable="on" data-guid="1530300113316"&gt;&lt;a class="quote-para" unselectable="on" style="display: none;" href="#" data-id="25183" title="Move Cursor Below" contenteditable="false"&gt;&lt;span unselectable="on"&gt;+&lt;/span&gt;&lt;/a&gt;&lt;a class="quote-delete" unselectable="on" style="display: none;" href="#" data-id="25183" title="Delete Quote" contenteditable="false"&gt;&lt;span unselectable="on"&gt;x&lt;/span&gt;&lt;/a&gt;&lt;span unselectable="on" class="quote-markup"&gt;[quote]&lt;/span&gt;&lt;div unselectable="on" class="if-quote-header" contenteditable="false"&gt;&lt;div unselectable="on" class="if-quote-toggle-wrapper"&gt;&lt;a class="if-quote-toggle quote-link" href="#" data-id="25183" title=" "&gt;&lt;/a&gt;&lt;/div&gt;&lt;span unselectable="on" class="quote-markup"&gt;[b]&lt;/span&gt;inquisituser22 - Friday, June 29, 2018&lt;span unselectable="on" class="quote-markup"&gt;[/b]&lt;/span&gt;&lt;/div&gt;&lt;div class="if-quote-message if-quote-message-25183"&gt;&lt;div class="if-quote-message-margin"&gt;Hello,&lt;br/&gt;We have an experiment where each participant's individual responses per item are saving on different rows of a spreadsheet in the output file. We are looking for recommendations about how to efficiently save this as mean scores with one line per participant in the spreadsheet instead.&lt;br/&gt;&lt;br/&gt;So far my best idea is to save as a .dat file, then open in SPSS and take averages from there.&lt;br/&gt;&lt;br/&gt;Thanks very much!&lt;a class="if-quote-goto quote-link" href="#" data-id="25183"&gt;&lt;span class="goto"&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;span class="quote-markup"&gt;[/quote]&lt;/span&gt;&lt;/div&gt;&lt;br/&gt;&amp;gt; So far my best idea is to save as a .dat file, then open in SPSS and take averages from there.&lt;br/&gt;&lt;br/&gt;That's definitely something you can do, it's the traditional way of processing and preparing reaction time data for further analysis.&lt;br/&gt;&lt;br/&gt;Beyond that, you can have Inquisit create an additional single-line data file containing summary statistics per the &amp;lt;summarydata&amp;gt; element. The functionality to actually calculate the summary statistics of interest (here: some means) you would have to build into your script. As a simple example, consider a script where you have two types of trials A and B. You want to calculate the mean reaction time for each trial type -- mean_rt_a and mean_rt_b -- only considering correct responses, and log that as summary information. The code to do that would look like this:&lt;br/&gt;&lt;br/&gt;&amp;lt;block example&amp;gt;&lt;br/&gt;/ trials = [1-10 = noreplace(a_trial, b_trial)]&lt;br/&gt;&amp;lt;/block&amp;gt;&lt;br/&gt;&lt;br/&gt;// counts of correct responses for trial A and B&lt;br/&gt;&amp;lt;values&amp;gt;&lt;br/&gt;/ n_correct_a = 0&lt;br/&gt;/ n_correct_b = 0&lt;br/&gt;&amp;lt;/values&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial a_trial&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; if (trial.a_trial.correct) {&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; list.correct_rts_a.appenditem(trial.a_trial.latency);&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; values.n_correct_a += 1;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br/&gt;]&lt;br/&gt;/ stimulusframes = [1=a_stim]&lt;br/&gt;/ validresponse = ("a", "b")&lt;br/&gt;/ correctresponse = ("a")&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;trial b_trial&amp;gt;&lt;br/&gt;/ ontrialend = [&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; if (trial.b_trial.correct) {&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; list.correct_rts_b.appenditem(trial.b_trial.latency);&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; values.n_correct_b += 1;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br/&gt;]&lt;br/&gt;/ stimulusframes = [1=b_stim]&lt;br/&gt;/ validresponse = ("a", "b")&lt;br/&gt;/ correctresponse = ("b")&lt;br/&gt;&amp;lt;/trial&amp;gt;&lt;br/&gt;&lt;br/&gt;//will store the RTs of correct responses to trial A&lt;br/&gt;&amp;lt;list correct_rts_a&amp;gt;&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;//will store the RTs of correct responses to trial B&lt;br/&gt;&amp;lt;list correct_rts_b&amp;gt;&lt;br/&gt;&amp;lt;/list&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;text a_stim&amp;gt;&lt;br/&gt;/ items = a_items&lt;br/&gt;&amp;lt;/text&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;text b_stim&amp;gt;&lt;br/&gt;/ items = b_items&lt;br/&gt;&amp;lt;/text&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;item a_items&amp;gt;&lt;br/&gt;/ 1 = "A_1"&lt;br/&gt;/ 2 = "A_2"&lt;br/&gt;/ 3 = "A_3"&lt;br/&gt;/ 4 = "A_4"&lt;br/&gt;/ 5 = "A_5"&lt;br/&gt;&amp;lt;/item&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;item b_items&amp;gt;&lt;br/&gt;/ 1 = "B_1"&lt;br/&gt;/ 2 = "B_2"&lt;br/&gt;/ 3 = "B_3"&lt;br/&gt;/ 4 = "B_4"&lt;br/&gt;/ 5 = "B_5"&lt;br/&gt;&amp;lt;/item&amp;gt;&lt;br/&gt;&lt;br/&gt;&amp;lt;summarydata&amp;gt;&lt;br/&gt;/ columns = (script.startdate script.starttime script.subjectid script.groupid script.elapsedtime&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; values.n_correct_a list.correct_rts_a.mean values.n_correct_b list.correct_rts_b.mean)&lt;br/&gt;/ separatefiles = true&lt;br/&gt;&amp;lt;/summarydata&amp;gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;</description><pubDate>Fri, 29 Jun 2018 12:36:45 GMT</pubDate><dc:creator>Dave</dc:creator></item></channel></rss>