From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:8:6d80::]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id /KMTKJjMYWB9fAAAgWs5BA (envelope-from ) for ; Mon, 29 Mar 2021 14:48:24 +0200 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id IM0KIZjMYWDlHgAAB5/wlQ (envelope-from ) for ; Mon, 29 Mar 2021 12:48:24 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 0277C2C377 for ; Mon, 29 Mar 2021 14:48:24 +0200 (CEST) Received: from localhost ([::1]:39674 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lQrJd-0001hz-1t for larch@yhetil.org; Mon, 29 Mar 2021 08:48:21 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:40206) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lQrIn-0001gg-Du for emacs-orgmode@gnu.org; Mon, 29 Mar 2021 08:47:29 -0400 Received: from ciao.gmane.io ([116.202.254.214]:32786) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lQrIl-0004zH-GO for emacs-orgmode@gnu.org; Mon, 29 Mar 2021 08:47:29 -0400 Received: from list by ciao.gmane.io with local (Exim 4.92) (envelope-from ) id 1lQrIi-0003xL-HP for emacs-orgmode@gnu.org; Mon, 29 Mar 2021 14:47:24 +0200 X-Injected-Via-Gmane: http://gmane.org/ Mail-Followup-To: emacs-orgmode@gnu.org To: emacs-orgmode@gnu.org From: Uwe Brauer Subject: spreadsheet, calc descriptive statistics, the mode?? Date: Mon, 29 Mar 2021 14:47:20 +0200 Message-ID: <871rbynn3b.fsf@mat.ucm.es> Mime-Version: 1.0 Content-Type: text/plain User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) Cancel-Lock: sha1:/8eLR2Xz5k5YmeNijj4R8abyi+c= Mail-Copies-To: never Received-SPF: pass client-ip=116.202.254.214; envelope-from=geo-emacs-orgmode@m.gmane-mx.org; helo=ciao.gmane.io X-Spam_score_int: -15 X-Spam_score: -1.6 X-Spam_bar: - X-Spam_report: (-1.6 / 5.0 requ) BAYES_00=-1.9, HEADER_FROM_DIFFERENT_DOMAINS=0.25, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1617022104; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:list-id:list-help:list-unsubscribe: list-subscribe:list-post; bh=rF1qS4qZg0+dFItL8GUiLYGzmpnrphmmY/CwQ5riSok=; b=Muv3soanWXnzLsRmAc11ewgJsYVImje5KNhzSLGsdn1JimwGpztm1a6x1WDxNbK+PZaHWj JngWqq1Yokrhp55Kzef01YRV3fyNDJ2BBD1CC+DaRiIzfLRmrmuSdpLypfaRyw8iAYBLkR zbAuWyT+rIGsK7TkhTrHqf2CB3JzoOjO9p8ct3tZD01P0AzuCLFYO530gwqZUWajs5VNdt f913JGTekfwotWM1ciPox5QDaCmFsokcjY1Cwe/JZOQBygPApTRJ19lMtdgHcVHgaZHBBW EqCgnt0dsq8fqgCTjA4aIsr7rneDwIYTOnIEU4YSj5yWdWKifArT7+FE5Mn9mg== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1617022104; a=rsa-sha256; cv=none; b=OpctnxsHNMygDRIhyZ7gDjTpp+4rfTpv0mRlDRUWpykZKoyVvntLV556GmTvkyaPrq0cA4 iyXVFg3inHxnwUvTGqhC78q89DChrTa0XH7FlK1PLIk8Wun6n/RtMbgkpikHLpJA5paoGj CRewlLQ7/5VX6KGmWtmYN9ApVMiJGUO6n/cI9fUnmK75BXOl5iBO3vnBibubJVB93T01AO FAbqAYMI4YVq69QXcEm4hBWR2YvA3SC63Xug9BeEdx9xs6S7bZZ9jwqbbJbV5EV+cQL6N2 5L02zRrE76KWL8ikYkLWZ3RAxzWjl+LWFPKhqR9SyRpdbCzV5dDmj8wftYjEsQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Spam-Score: -0.82 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=mat.ucm.es (policy=none); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: 0277C2C377 X-Spam-Score: -0.82 X-Migadu-Scanner: scn0.migadu.com X-TUID: WHqrsWmRt380 Hi As far as I can see #+begin_src | | Marks | | |---+-------+-----------------------| | | 1 | | | | 1 | | | | 4 | | | | 5 | | | | 6 | | |---+-------+-----------------------| | 4 | 3.4 | vmod([1, 1, 4, 5, 6]) | ,#+TBLFM: @7$1=vmedian(@I$2..@II$2)::@7$2=vmean(@I$2..@II$2)::@7$3=vmod(@I$2..@II$2) #+end_src The mode as in explained for example in https://en.wikipedia.org/wiki/Mode_(statistics) Is not included in calc. Am I correct. I tried to search in the info but cannot find anything Regards Uwe Brauer