Looking for some help here. I've tried to solve this, but I just
can't. What I need to know is what formula to use in an excel
calculation to complete the following calculation. It's in two parts.
If first finds a natural logarithm, then converts it to a percentile.
Even if I had to do it in two steps on the spreadsheet, I can't
determine the calculations.
*************** *************** *************** ******
Logarithm System
The "natural logarithm" [player] rankings system gives no advantage to
simply playing more often -- but, it gives more weight to [especially]
good results, and [it is more 'forgiving' of especially] bad results,
such that one exceptionally bad result does not 'kill' your ranking [],
and one exceptionally good result will not give you a safe enough lead
that you can then just 'sit on'...
Calculation details:
Where "X" is [a player's] finishing place out of "N" players, each []
individual tournament result is valued at:
*** Log ( (N + 1) / X )
....averaged over his number of plays...for example, with 300-player
tournaments, a player finishing 1st, 300th, 300th would rate 1.9046,
just slightly better than a player finishing 45th every time, 1.9004...
And then these 'natural logarithms' are converted back into
"percentiles".. .
*** Log = "natural" base for logarithms -- a universal number known as
"e" = 2.718282... (second in 'fame' only to "pi" = 3.141593...) -- and
"natural logarithms" are logarithms "to the base e" -- that is, numbers
expressed as powers of "e"... The base "e" is key in many mathematical
applications.
Converting logarithms back to percentiles
To convert the natural log score back to percentile, you need to use
this formula:
(1 - exp (-L) ) * 100
The variable L is the average of all the natural log score. The 'exp'
means the inverse of natural log.
For example, these are log scores from 3 different tournaments: 1.5,
2.0, and 1.0, so the average is 1.5.
Then plug that number into the above formula:
= (1 - exp ( -1.5 ) )* 100
= (1 - 0.22313016 ) * 100
= 77.686984 2 13189
cowboyboborton wrote: Looking for some help here. I've tried to solve this, but I just can't. What I need to know is what formula to use in an excel calculation to complete the following calculation. It's in two
parts. If first finds a natural logarithm, then converts it to a percentile. Even if I had to do it in two steps on the spreadsheet, I can't determine the calculations. *************** *************** *************** ****** Logarithm System The "natural logarithm" [player] rankings system gives no advantage
to simply playing more often -- but, it gives more weight to
[especially] good results, and [it is more 'forgiving' of especially] bad results, such that one exceptionally bad result does not 'kill' your ranking
[], and one exceptionally good result will not give you a safe enough
lead that you can then just 'sit on'...
Calculation details:
Where "X" is [a player's] finishing place out of "N" players, each [] individual tournament result is valued at:
*** Log ( (N + 1) / X )
...averaged over his number of plays...for example, with 300-player tournaments, a player finishing 1st, 300th, 300th would rate 1.9046, just slightly better than a player finishing 45th every time,
1.9004...
And then these 'natural logarithms' are converted back into "percentiles".. .
*** Log = "natural" base for logarithms -- a universal number known
as "e" = 2.718282... (second in 'fame' only to "pi" = 3.141593...) --
and "natural logarithms" are logarithms "to the base e" -- that is,
numbers expressed as powers of "e"... The base "e" is key in many
mathematical applications.
Converting logarithms back to percentiles
To convert the natural log score back to percentile, you need to use this formula:
(1 - exp (-L) ) * 100
The variable L is the average of all the natural log score. The 'exp' means the inverse of natural log.
For example, these are log scores from 3 different tournaments: 1.5, 2.0, and 1.0, so the average is 1.5.
Then plug that number into the above formula:
= (1 - exp ( -1.5 ) )* 100 = (1 - 0.22313016 ) * 100 = 77.686984
Excel has both LOG and PERCENTILE functions. Have a look at the help
for syntax and usage.
The Excel functions you need are LN, AVERAGE, and EXP. (LOG is used
for base-10 logarithms in Excel)
For example, if column B has a player's finishing place, and column C
has the number of players in that tournament.
For cell C2 to have the natural log ranking based on the contents of A2
and B2, you would have the following formulat in C2:
=LN((B2+1)/A2)
Mark This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Dan |
last post by:
Hello,
I am trying to read and write to an Excel file via my Java applet. I
have done so successfully on several simple Excel files that simply
had data cells without many complicated equations or any other Excel
extras. However, now is the time to get the complicated ones to work.
I didn't think that there would be a difference, but there is. At
first, I was beginning to think that it was a file size problem, but
now I am unsure. ...
|
by: Julie Miles |
last post by:
I need to pull several tables of data from Excel into a web page, but
when I use Excel's "Save as web page" function, I get an enormous file
containing a massive amount of css formatting. I'd like to strip out
this css so that I can apply my own style sheet; does anyone know
whether there is a way to do this, other than manually? Either a way to
export the data from Excel that doesn't include the css formatting, or
a utility that will...
|
by: Seth |
last post by:
I am in need of source code for the Aho Corasick algorithm. I have
tried searching the web but can't seem to find any code.
Is there a good site for c code I can search?
Thanks in advance.
|
by: Carlos Magalhaes |
last post by:
Hey All,
I am doing some excel automation using the excel COM. I can do most of
the functions and its working well until I come across a formula.
I can run a formula and insert the formula value into a cell. BUT this
is where it comes "complex".
|
by: Rich Wallace |
last post by:
Hi all,
I have a VB app that runs and manages individual XLS files within a single
COM object. Upon processing the final fie, I attempt to close out the EXCEL
object and release it using
System.Runtime.InteropServices.Marshal.ReleaseComObject.
I have a Try...Catch in my routine as seen below and when I receive the
error, my Catch is never called so my app sees the release as successful,
but when I look in Task Manager, the EXCEL.EXE...
| |
by: vj |
last post by:
Hi!
I have a piece of code (shown below) involving complex numbers. The
code is not running and giving error ("Invalid floating point
operation" and "SQRT:Domain error"). I would be very thankful
if someone can tell me where is the problem. I am aware that my code is
far from being efficient and organized, and also there are many extra
#include statements not really required for the code. I am a novice
programmer, as you can see ! At...
|
by: toffee |
last post by:
Hi all,
I got a pre-formatted spreadsheet. would it be possible using js to copy the
data from a table on the current webpage, open the spreadsheet and paste the
content ?
if so, anyone got any links or pointers?
i've already tried google - but all i get is ActiveX methods which work in a
very few cases.
|
by: Widge |
last post by:
I have made a spreadsheet that will calculate the distance from a set of addresses to a specified postcode in Excel. I'm looking to move this to Access so I can start thinking about hooking it up to a webpage. The main problem is the fact that I don't have a CLUE how to perform the lookup in Access. Basically we have 3 sheets. 1) where you enter your postcode and radius to search by, 2) a list of suppliers, their addresses and postcodes ... with...
|
by: Bobh |
last post by:
I am trying to figure out some code for a report issue;
I have an employee who has a incentive scheme.
I have a report showing various income amounts and in the report footer I vae totals for these feilds =sum() these work fine.
I also have in the detail feild Overall text boxes for the three feilds concerned
I then have in the report footer =++ which give me a grand total for the report also works fine.
I now need to have a more...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |