[Latingp] Corrected median in Underlining Analysis

[Mats Dufberg]

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
https://internetstiftelsen.se/


From: Bill Jouris <bill.jouris at insidethestack.com>
Reply-To: Bill Jouris <bill.jouris at insidethestack.com>
Date: Thursday, 20 June 2019 at 16:42
To: ICANN Latin GP <Latingp at icann.org>, Mats Dufberg <mats.dufberg at 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 at insidethestack.com
831-659-8360
925-855-9512 (direct)


On Thursday, June 20, 2019, 4:43:53 AM PDT, Mats Dufberg <mats.dufberg at 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.





https://docs.google.com/spreadsheets/d/19FZmntXOan_7LF0ckzKZNLrla0L8eC_GxWEfAmmOMkU/edit#gid=1543789122







Mats



---

Mats Dufberg

DNS Specialist

Internetstiftelsen (The Swedish Internet Foundation)

Mobile: +46 73 065 3899

https://internetstiftelsen.se/


_______________________________________________
Latingp mailing list
Latingp at icann.org<mailto:Latingp at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mm.icann.org/pipermail/latingp/attachments/20190620/53c8628e/attachment-0001.html>