I would not wish to seem over-pedantic but 2.2 is nearer the mark for the conversion (2.20462 is more acute). However perhaps as Tom Lehrer put it in his song ‘The New Math’, “… the idea is the important thing” 😊
Paul
From: email list for Radical Statistics <[log in to unmask]> On Behalf Of hedwyg
Sent: 01 September 2020 12:49
To: [log in to unmask]
Subject: Re: "I want my weight to be a prime number" + autism + scale-invariance + a problem in Excel
This is the first time I've "delurked" on the list, so hi! I'm in Virginia, USA, and just finished up my MS in math/stats in May.
What I usually do when I have something complex or fiddly to work out in Excel is to add columns that do one step at a time. Having just made a Prime column (manually populated) and a 2.3 multiplier column, I realize that what I would do is use VLOOKUP to see if each value in my multiplier column exists in my Prime column. This will give you an #N/A for each non-prime number, and will give you the number again if it is found in the column of primes. Then you can use this as the basis of your conditional formatting.
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
Good to see statisticians dipping their toes into number theory!
I've just been listening to Francesca Happe talking about autism in "A Life Scientific" and found it fascinating.
She mentioned somebody who wanted her weight "to be a prime number". This set me thinking - what weights are prime in both pounds AND kilograms?
So I set to work on Excel, with Primes in the first column and multiplying factors (e.g. 2.3) along the top. In each cell of the array I now have the rounded value ROUND(PRIME*2.3, 0) and I can see that some are prime.
Now I want to colour red all cells holding primes. How to do this? Are there any Excel experts out there please? (I have tried using the COUNTIF function with conditional formatting, but have not succeeded.)
Thanks for any comments or advice.
****************************************************** Please note that if you press the 'Reply' button your message will go only to the sender of this message. If you want to reply to the whole list, use your mailer's 'Reply-to-All' button to send your message automatically to [log in to unmask]. Disclaimer: The messages sent to this list are the views of the sender and cannot be assumed to be representative of the range of views held by subscribers to the Radical Statistics Group. To find out more about Radical Statistics and its aims and activities and read current and past issues of our newsletter you are invited to visit our web site www.radstats.org.uk. *******************************************************
****************************************************** Please note that if you press the 'Reply' button your message will go only to the sender of this message. If you want to reply to the whole list, use your mailer's 'Reply-to-All' button to send your message automatically to [log in to unmask]. Disclaimer: The messages sent to this list are the views of the sender and cannot be assumed to be representative of the range of views held by subscribers to the Radical Statistics Group. To find out more about Radical Statistics and its aims and activities and read current and past issues of our newsletter you are invited to visit our web site www.radstats.org.uk. *******************************************************