I am trying to solve a statistical problem using excel, but I am barely even a novice.
I have collected 100 numbers ranging from 0 and above (0, 1, 1.04, 4.35, 237.86...), I know that the bigger the number is, the lower the chances of it appearing are. What I am trying to figure out is for which number is the product of the number itself and its chances of popping up the biggest, for instance: the chances of getting 2 could be 0.8 which works out as 2*0.8= 1.6, the chances of getting 2,000 could be 0.008, whose product is 16.
The numbers are not random, and there is some formula that produces them, but I know that the chances of getting a 2.00 are virtually the same as getting a 2.01 for instance, so a graph displaying the chances of getting a number as a function of the actual number would be continuous. Thing is, I really don't know how to use excel, and all I have is that table of numbers.
How could I create a continuous graph as described above, using my data and also get its approximate function?
Thanks a lot.
Bookmarks