From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:bcc0::]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id MNMxEUTVYWDzjgAAgWs5BA (envelope-from ) for ; Mon, 29 Mar 2021 15:25:24 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id GGMVC0TVYWChCgAA1q6Kng (envelope-from ) for ; Mon, 29 Mar 2021 13:25: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 5AC4F22FE3 for ; Mon, 29 Mar 2021 15:25:23 +0200 (CEST) Received: from localhost ([::1]:34858 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lQrtR-000554-3N for larch@yhetil.org; Mon, 29 Mar 2021 09:25:21 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:48794) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lQrsp-00054p-PJ for emacs-orgmode@gnu.org; Mon, 29 Mar 2021 09:24:43 -0400 Received: from mailbackend.panix.com ([166.84.1.89]:43433) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lQrso-0001Y2-8D for emacs-orgmode@gnu.org; Mon, 29 Mar 2021 09:24:43 -0400 Received: from panix1.panix.com (panix1.panix.com [166.84.1.1]) by mailbackend.panix.com (Postfix) with ESMTP id 4F8Cwn024xzRnH; Mon, 29 Mar 2021 09:24:40 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=panix.com; s=panix; t=1617024281; bh=/W6qInYM3h5EjqIuNglD6dMmNsrdW/Jljza5Kpb7lSc=; h=Date:From:To:cc:Subject:In-Reply-To:References; b=UUVTUNXQTICLzGNwqZAfcipcGgqzPf7ejDe3r3exe0lDfZFVg37Dx0veYH3KIaM3e XWIHAEY6EdbDa2ZozcDK2JRdnbSCUn633m17mvJv98yNK1qqzRZAr0p2Te28BAMKRG kF9zRJspouApruNOzz6PHBvNwMhXcWf+yA0tiCrg= Received: by panix1.panix.com (Postfix, from userid 20712) id 4F8Cwm6GCqzcbc; Mon, 29 Mar 2021 09:24:40 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by panix1.panix.com (Postfix) with ESMTP id 4F8Cwm5pNRzcbV; Mon, 29 Mar 2021 09:24:40 -0400 (EDT) Date: Mon, 29 Mar 2021 09:24:40 -0400 From: Jude DaShiell To: Uwe Brauer Subject: Re: spreadsheet, calc descriptive statistics, the mode?? In-Reply-To: <871rbynn3b.fsf@mat.ucm.es> Message-ID: References: <871rbynn3b.fsf@mat.ucm.es> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed Received-SPF: pass client-ip=166.84.1.89; envelope-from=jdashiel@panix.com; helo=mailbackend.panix.com X-Spam_score_int: -43 X-Spam_score: -4.4 X-Spam_bar: ---- X-Spam_report: (-4.4 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_MED=-2.3, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham 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: , Cc: emacs-orgmode@gnu.org 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=1617024324; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=+Io+2GJCKsNNh6qWDY4ARzWYCj3+8DUE0JN1y4u16UQ=; b=Ovxp5Klpp4AjbDgxoviAErCSF8U7lQr6SUo0fBFGMKsPOH6+XaK5yoJFjt/KUitI68MOnK DZB6Mj0C0fBooEgrH8MvHipS9mM6yhIsu6iGjRHnPf9tf1JzclTjWW9JekwCeqg6o72CBj WusWwRU3VYqW2EywnR2BsozRPV1SUrLmliexhY/fnM09wprjLD07V5Q//9iTi9gQBMjHrZ XWtCR8IlQVFIHxLU8n450YWq/jvbtJoHt+qezYryWQVPRzi41zwlrDO//QfK3vgFOgn77h CJExaRPOrwGWuVJU3LHb4anezrcir3HAH2bAQMMbHJVDE8X1BlUVsl1tZ8ghFA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1617024324; a=rsa-sha256; cv=none; b=EUC9q/XkNTiJOx2uIb2cbYkBXdJZpBml0cwTKkYWTAdDQbQwVykifQem1kNPHSr2cIRaXi xUnHqDqbmnI2voA5c2HQfN1IUaz6vSY5E+evTczTwDovHoraHt9bXIIieTGLlNzH7H2ewM P3LAu7V4XLlizwDB/Qp0baCczlXFfUi+l2Lsa5Wbtg8ljEzOKEvsHibU45hSeJJGlOyCyF RuLeGdRBgdRhQmBkRO90UJGwroxOJUxU9/6wnOq8zlSYRAXVvh/k9SDsD2w7ErtW0otzDu tLWGPq+TKby3jifW82Kx4807viRYAHqpmehn82kSMzXJcE9o1azplvhf01/yNQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=panix.com header.s=panix header.b=UUVTUNXQ; dmarc=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.98 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=panix.com header.s=panix header.b=UUVTUNXQ; dmarc=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: 5AC4F22FE3 X-Spam-Score: -0.98 X-Migadu-Scanner: scn0.migadu.com X-TUID: hkSmhu5ru2pM Many years ago I found it curious mean and median were available but mode hadn't been done. On Mon, 29 Mar 2021, Uwe Brauer wrote: > 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 > > >