Or even integer value. I think at least one case change from 2 to 3. It is confusing when some cells in a spread sheet hold numbers that are text and other hold numbers that are -- numbers.
Mats
---
Mats Dufberg
DNS Specialist
Internetstiftelsen (The Swedish Internet Foundation)
Mobile: +46 73 065 3899
From: Bill Jouris <bill.jouris@insidethestack.com>
Reply-To: Bill Jouris <bill.jouris@insidethestack.com>
Date: Thursday, 20 June 2019 at 16:42
To: ICANN Latin GP <Latingp@icann.org>, Mats Dufberg <mats.dufberg@internetstiftelsen.se>
Subject: Re: [Latingp] Corrected median in Underlining Analysis
Hi Mats.
Thanks for working that out. I had wondered why (how?) the median function was getting a non-integer result. But couldn't it figure out. So I tried to just count the 2s and 3s, but obviously the manual method is more subject to error. (That's why I used the function, after all.) Sigh
In the case of N with circumflex below, I'm assuming that was one of the cases with the non-integer result initially.
Bill Jouris
Inside Products
bill.jouris@insidethestack.com
831-659-8360
925-855-9512 (direct)
On Thursday, June 20, 2019, 4:43:53 AM PDT, Mats Dufberg <mats.dufberg@internetstiftelsen.se> wrote:
I noticed that the median calculation was wrong in some instances. Finally I found out how to fix it. I selected all cells G5:M73 and selected Format->Number and ticked "automatic". Some of the cells were "text" so that is why they were not included in the medians.
Now all of medians are correct, and Bill should re-review them. I think Latin Small Letter N vs. Latin Small Letter N with Circumflex Below should probably go from "Variant" to "Not a Variant". I think there are other cases.
Mats
---
Mats Dufberg
DNS Specialist
Internetstiftelsen (The Swedish Internet Foundation)
Mobile: +46 73 065 3899
https://internetstiftelsen.se/
_______________________________________________
Latingp mailing list
Latingp@icann.org
https://mm.icann.org/mailman/listinfo/latingp
_______________________________________________
By submitting your personal data, you consent to the processing of your personal data for purposes of subscribing to this mailing list accordance with the ICANN Privacy Policy (https://www.icann.org/privacy/policy)
and the website Terms of Service (https://www.icann.org/privacy/tos). You can visit the Mailman link above to change your membership status or configuration, including unsubscribing, setting digest-style
delivery or disabling delivery altogether (e.g., for a vacation), and so on.