Talk:Drop rate/Gift of the Traveler

This page doesn't have the 10 Hunter's Ales (not aged) drop. I'd add it myself, but I have no idea how. --Totally Imbalanced 00:28, 27 April 2009 (UTC)
 * I believe it's not there because none of the people listing their drops have gotten it yet. Technically there should also be Vampiric Dragon Sword, etc. -Phazor 00:32, 27 April 2009 (UTC)
 * Well, I got the Ales, and someone will eventually get the VDS. The Mini Gwen Doll, Mini Professor, Mini Brown Rabbit, 5 Crates of Fireworks, Everlasting Cottontail, Traveler's Bo Staff, Ascalon Razor, and Icy Dragon Sword also need to be added.  Again, I'd do it but have no idea how. --Totally Imbalanced 00:36, 27 April 2009 (UTC)
 * I'll see if I can figure it out when I have more time. -Phazor 02:24, 27 April 2009 (UTC)
 * Alright, added those that you listed. If you think of or see more, just tell me.  Basically to add the columns I just followed the template that had already been set. -Phazor 03:52, 27 April 2009 (UTC)
 * Oh, Totally Imbalanced. You forgot one of the gifts that you got (you put 10 as the total, but you only put 9 gifts).  I don't know if you remember what that last gift was so that we can get it back to a multiple of 5. -Phazor 01:25, 28 April 2009 (UTC)
 * My bad. Fix'd and updated totals. --Totally Imbalanced 01:44, 28 April 2009 (UTC)

Just post or pre also?

 * is this just post data or do we want pre also here? NCA 23:05, 26 April 2009 (EST)
 * It's just post. You can start one for Pre, though. [[Image:Sunsmoonsig.jpg]] talk & cont  07:04, 27 April 2009 (UTC)
 * Have done so, at Gift of the Huntsman NCA 17:42, 27 April 2009 (EST)

Tempted...
I'm tempted to make a note at the bottom saying to please update the totals and percentages whenever you add your drops/gifts to the table. I've had to correct it three times so far, and it will probably continue. A note might reduce some of that. I won't do anything until given permission, though. -Phazor 03:41, 27 April 2009 (UTC)
 * I personally wasn't certain as to who is doing the updating and such, so left it alone. A note would help a lot. NCA 1:51, 27 April 2009 (EST)
 * Okay, I added the note at the top. If anyone finds the wording to be confusing, please change it so that it is not. -Phazor 23:02, 27 April 2009 (UTC)

My data
I suck at editing tables and really don't know how to go about doing it. Here's what I got from five packages: 5 mysterious summoning stones 5 mysterious tonics 5 cottontail tonics 10 champagne poppers 5 green rock candies
 * Can't do anything with that if you don't sign it. -Phazor 04:02, 28 April 2009 (UTC)

I looked at entering the data and it looked pretty tricky. Would someone be willing to enter? Here's my data: 5 blue rock candies, 10 bottle rockets, 5 crates of fireworks, 5 crates again, 10 jars of honey Truemyths 04:43, 28 April 2009 (UTC)

I added my data, but I'm not 100% sure how to calculate the percentages at the bottom. -Zyanya386 09:16, 30 April 2009 (UTC)
 * do you have a spreadsheet program? I use OpenOffice, but Microsoft Excel should work just as fine. You can just copy and paste the whole table (without sum line) in there, then calculate the new totals and percentages with relative ease. You'll have to copy&paste those values back one by one, but it's still faster than counting it all yourself :) Ailar 16:23, 7 May 2009 (UTC)

Sorry, Also no good at wiki code. 20 Gifts as follows:


 * 4 Mysterious Tonics (20)
 * 3 Mysterious Summoning Stones (15)
 * 2 Champagne Poppers (20)
 * 2 Keg of Aged Hunter's Ale (2)
 * 1 Bottle Rockets (10)
 * 1 Hunter's Ales (10)
 * 1 Jars of Honey (10)
 * 1 Sparklers (10)
 * 1 Aged Hunter's Ale (10)
 * 1 Blue Rock Candies (5)
 * 1 Red Rock Candies (5)
 * 1 Mercantile Summoning Stones (5)
 * 1 Cottontail Tonics (5)

Also planning on buying 200 gifts soon (1 million gold worth @ 5k each) and will post findings once that is done. Thizzzguy 6:30AM PT, 13 July 2009

219 gifts


 * 34 Mysterious Tonics (170)
 * 20 Mysterious Summoning Stones (100)
 * 17 Sparklers (170)
 * 14 Red Rock Candies (70)
 * 14 Green Rock Candies(70)
 * 13 Bottle Rockets (130)
 * 12 Champagne Poppers (120)
 * 12 Cottontail Tonics (60)
 * 11 Honeycombs (110)
 * 11 Mercantile Summoning Stones (55)
 * 11 Jars of Honey (110)
 * 9 Blue Rock Candies (45)
 * 9 Aged Hunters Ale (90)
 * 9 Keg of Aged Hunters Ale (9)
 * 8 Hunters Ale (80)
 * 8 Disco Balls (24)
 * 6 Crates of Fireworks (30)
 * 1 Everlasting Crate of Fireworks (1)

Thizzzguy 14 July 2009 23:36 UTC

Vertical text
The text in top row that say what item each colomn is for, can be vertically written using style="writing-mode:tb-rl; white-space: nowrap;" in the row or in each cell. I'm going to try this on w:c:fr.guildwars:Cadeau du Voyageur/taux de drop... — TulipVorlax


 * Ok, after testing, it need to be putted on each cell :


 * — TulipVorlax 02:23, 28 April 2009 (UTC)

Odds/expecations based drop data
(As of about 15 minutes before this post), there were 1006 entries (on the official site§). And the percentages of drops based on type are as follows:


 * {| class="stdt"

! Type !! %
 * Drunk || 15.71%
 * Mini || 0.40%
 * Other || 0.20%
 * Party || 20.08%
 * Summon Stone || 34.79%
 * Sweet || 23.56%
 * Tonic || 3.58%
 * Weapon || 1.69%
 * }
 * §I used the official wiki's date for three reasons: (a) they had more data, (b) I computed the avgs on my own, (c) I was too lazy to recalculate using the data here.
 * Sweet || 23.56%
 * Tonic || 3.58%
 * Weapon || 1.69%
 * }
 * §I used the official wiki's date for three reasons: (a) they had more data, (b) I computed the avgs on my own, (c) I was too lazy to recalculate using the data here.
 * Weapon || 1.69%
 * }
 * §I used the official wiki's date for three reasons: (a) they had more data, (b) I computed the avgs on my own, (c) I was too lazy to recalculate using the data here.

&mdash; Tennessee Ernie Ford ( TEF ) 18:55, 2 May 2009 (UTC)

(As of about 15 minutes before this post), there 3,424 entries (on the official site§).


 * §I used the official wiki's date for three reasons: (a) they had more data, (b) I computed the avgs on my own, (c) I was too lazy to recalculate using the data here.
 * §§The expected value is based on each gift drop's merch value, gwauctions typical price, or average WTB/WTS prices as seen in the game.
 * &mdash; Tennessee Ernie Ford ( TEF ) 16:30, 2 July 2009 (UTC)

Invalid rows
Currently there are 340 Gifts entered, but the sums of the column totals add up to 346. Originally, there were 6 invalid rows in there, where the sum of the entries was higher than the value in the first column (one of them is off by 2). Somewhat embarassingly, one of the entries was mine :S I've corrected that one, but as I don't know if we'll be able to correct the others, should those rows just be deleted? They're the rows which are signed as follows:
 * --NCA On behalf of a guildie 17:57, 27 April 2009 (EST)
 * -- Zyanya386 09:10, 30 April 2009 (UTC)
 * --GW-Topinambour 15:57, 1 May 2009 (UTC)
 * Yujiko Ineluki 16:20, 2 May 2009 (UTC)
 * Viruzzz 08:39, 3 May 2009 (UTC)


 * I would think that we should separate them from the grand total (either new table or separate section) until/unless the users re-confirm their counts. Doing so will have low impact on total numbers but high impact on the credibility. What do other people think?  &mdash; Tennessee Ernie Ford ( TEF ) 18:38, 7 May 2009 (UTC)


 * Good idea (I'm somewhat late to reply, because I really couldn't be bothered to farm Mandragor Roots last week...). So I started the new section now - currently there's only one faulty row though, looks like someone cleaned up the rest -- Ailar 19:01, 18 May 2009 (UTC)

More confusion
I've been visiting the wiki for going on three years now, yet I am still a complete wikinoob and have no idea how to add to this chart without completely screwing up the data and making it all look like gobbledygook. (On a side note, the Firefox spellcheck apparently liked that word... but not the word "spellcheck"). Anyways, last week, on Sunday June 07, I got: 5 merch stones, 10 bottle rockets, 10 champagne poppers, 5 mysterious summoning stones, and... *drumroll please* an Inscribable IDS! That would be the first to be added to the chart, so I thought it was worth trying to figure out how to put it in. Thanks to anyone that can do this for me. :) 72.68.45.67 22:30, 9 June 2009 (UTC)

Standard Deviation
I've added a standard deviation row to the end of the table, which (if my math is correct) should help to give us a fair measure of how accurate the numbers at the bottom are. If my understating of statistics is correct, then one can expect that ~95% of the time, the actual drop rate will be plus or minus 2 standard deviations from the observed average rate. My understanding of statistics however may be way off base. How I derived the standard deviation: I produce 3 figures for each item, and use them to then derive the fourth:
 * S0 --Sum of packages opened (733 in all cases)
 * S1 -- Sum of instances item was encountered (for merc stone: 42) (Technically, this is rate encountered * packages opened, but bits cancel out leaving this as simply the count of item encountered
 * S2 -- Sum of squares of encoutner rate Sum of: %encounter rate squared for row times number of packages opened for the row.
 * Standard Deviation = (S0*S2-S1*S1)/(S0*(S0-1))
 * Derive square of deviation from average for each entry, multiply bythe weight for the entry (weight = (number of packages^0.5*total entries/total packages) --Eg, if a row had 2 kegs from 10 packages (20%), and the average is 4%, this results in ((4%-20%)^2) * 79/773 -> (-16%^2)*(10^0.5*79/773) -> 2.56% * 3.16.../10.58... ->32.31%
 * Derive the average of those squares for each column (remembering to divide by number of rows minus 1) This is the sample variance.
 * Take the square root of the variance - This is the standard deviation of the sample. (edit -- provided corrected calculation) Yamagawa 18:35, 26 July 2009 (UTC)
 * (One thing this does is weight a given row in the table based on the number of packages that row represents,

I'd appreciate it if someone could vet my math, and if I'm misunderstanding the significance of the deviation, if they could correct me there too. This is fairly shaky ground for me, but heh, I gotta start learning this stuff somewheres.

ALso worth noting, if I recall rightly, that an ideal sample size is in the 15-30 range. Too small and it doesn't give a measure that can be expected to reflect reality. Any larger and the measure's accuracy won't change much by growing it. Yamagawa 05:40, 26 July 2009 (UTC)


 * Bugger, looks like I left out a square-root on my stddev calc... which has the approximate effect of multiplying the values by about 10...  Corrected figures to go in, and it's time I read more on estimating a population from a set of samples... Yamagawa 15:42, 26 July 2009 (UTC)


 * Ok, I've got a 'corrected' standard deviation in place. From reading up on confidence intervals, I find the calculation to be:
 * Confidence interval = Average +/- Standard Deviation/(n^0.5)*(z value for percentile)
 * After some fussing with how I weight my standard deviation calculation for the size of the sample, I am getting some confidence intervals that seem fairly reasonable. Please, someone kick me if I have the math wrong. Yamagawa 18:35, 26 July 2009 (UTC)


 * Updated intervals put into a new table. No corrections to math used, rather I've found that if I pool the results in r rows (where r = n^0.5), I can shrink the confidence intervals.  I'm using the drop rate of mr yakkington (0.14%) plus his confidence interval (0.27) to get a max possible drop(0.41%) rate for items with 0 occurrences reported.  Alternate math suggests that 0.47% may be the correct high-ball estimate for those values (95% confidence), but the two numbers are close enough that I won't worry over a whopping 0.06%  Yamagawa 23:17, 27 July 2009 (UTC)

Excel Code
I put some Excel VBA code on my userpage - First procedure can parse the text from the edit page for Drop Rate Raw Data into Excel where new rows can be added. Second procedure updates totals. Third procedure creates text than can be pasted into (overwriting) the existing text on the Raw Data page. Once I figure out the confidence interval stuff, I will add that. Please send comments/questions/suggestions to me Separ 23:20, 15 August 2009 (UTC)