{"id":180,"date":"2009-12-09T09:41:00","date_gmt":"2009-12-09T09:41:00","guid":{"rendered":"https:\/\/www.root42.de\/blog\/?p=180"},"modified":"2009-12-09T09:41:00","modified_gmt":"2009-12-09T09:41:00","slug":"computing-the-standard-deviation-of-timings-in-openoffice","status":"publish","type":"post","link":"https:\/\/www.root42.de\/blog\/?p=180","title":{"rendered":"Computing the standard deviation of timings in OpenOffice"},"content":{"rendered":"<p>I took some timings during a user study, and tried to use NeoOffice (aka OpenOffice for OS X) to evaluate the results. I needed to compute the standard deviation of the timings. The data itself was in a format MM:SS. What does work is computing the sum, like this:<\/p>\n<div><\/div>\n<div><span  style=\"font-family:'courier new';\"> =SUMME(A1:A20)<\/span><\/div>\n<div><\/div>\n<div>Note that I am using the german function names. I don&#8217;t know all the english function names, so you have to check that yourself. Now I tried to compute the standard deviation as follows:<\/div>\n<div><\/div>\n<div><span  style=\"font-family:'courier new';\"> =STABW(A1:A20)<\/span><\/div>\n<div><\/div>\n<div>But all I got was 00:00 as the answer. I couldn&#8217;t get an answer why that is the case, not even by the helpful people in #openoffice.org on Freenode. What I did find out is that you can do the computation when converting the timings to another format, namely just seconds. You can do this in the following way:<\/div>\n<div><\/div>\n<div><span  style=\"font-family:'courier new';\"> =MINUTE(A1)*60+SEKUNDE(A1)<\/span><\/div>\n<div><\/div>\n<div>So you basically need another column, filled with the above formula, say column B, and then you can compute the standard deviation:<\/div>\n<div><\/div>\n<div><span  style=\"font-family:'courier new';\"> =STABW(B1:B20)<\/span><\/div>\n<div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I took some timings during a user study, and tried to use NeoOffice (aka OpenOffice for OS X) to evaluate the results. I needed to compute the standard deviation of the timings. The data itself was in a format MM:SS. What does work is computing the sum, like this: =SUMME(A1:A20) Note that I am using &hellip; <a href=\"https:\/\/www.root42.de\/blog\/?p=180\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Computing the standard deviation of timings in OpenOffice&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[107,105,106],"tags":[],"_links":{"self":[{"href":"https:\/\/www.root42.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/180"}],"collection":[{"href":"https:\/\/www.root42.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.root42.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.root42.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.root42.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=180"}],"version-history":[{"count":0,"href":"https:\/\/www.root42.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/180\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.root42.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.root42.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.root42.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}