1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
Dismiss Notice
Wynncraft, the Minecraft MMORPG. Play it now on your Minecraft client at (IP): play.wynncraft.com. No mods required! Click here for more info...

Guide Overly Specific Prism Skill Point Total Chance Chart + Graph

Discussion in 'Wynncraft' started by Nyam, Mar 13, 2018.

Thread Status:
Not open for further replies.
  1. Nyam

    Nyam egg QA HERO

    Messages:
    216
    Likes Received:
    1,577
    Trophy Points:
    75
    Guild:
    Minecraft:
    I made this impulsively at about 3AM

    [​IMG]

    [​IMG]

    So basically I used Excel's autocomplete thing and copy+paste to make a list of every unique combination of numbers from 1-4
    It didn't take too long since there was only 4^5 = 1024 of them
    I made it calc the sum in another column and then sorted by that sum and grouped them together according to that
    Here are some meaningless row numbers
    [​IMG]
    A few columns across I mathsed out the chances of getting each individual combination
    [​IMG]
    Here are the ID chance thingies I used to calc them
    [​IMG]
    Then I just took the grouped thingies from earlier and got autosum to do the rest + convert to percentages
    [​IMG]
    And woosh
    A chart thing exists

    There's pretty much nothing you can do with this information so here you go

    Edit: I fixed the theme thing so you won't go blind unless you open the spoiler

    Edit 2: I added a slightly fancy graph thing but Desmos doesn't have a dark theme so you're going blind now anyways
     
    Last edited: Mar 14, 2018
  2. Moss

    Moss shoutbox meme supplier

    Messages:
    1,985
    Likes Received:
    6,664
    Trophy Points:
    164
    Guild:
    Minecraft:
    seems ballanced
     
  3. highbread

    highbread highbread HERO

    Messages:
    1,392
    Likes Received:
    7,990
    Trophy Points:
    164
    Guild:
    Minecraft:
    seems pretty inaccurate for me

    compensating for my luck, here is what ive come up with

    5 100%
    6 0%
    7 0%
    8 0%
    9 0%
    10 0%
    11 0%
    12 0%
    13 0%
    14 0%
    15 0%
    16 0%
    17 0%
    18 0%
    19 0%
    20 0%
     
  4. enecks

    enecks Well-Known Adventurer HERO

    Messages:
    553
    Likes Received:
    939
    Trophy Points:
    91
    Minecraft:
    Time to get a 5sp and sell it for 20stacks
     
  5. NicBOMB

    NicBOMB Maker of Builds | Lurks on Forums | 1 Mythic Found CHAMPION

    Messages:
    3,415
    Likes Received:
    2,515
    Trophy Points:
    136
    Guild:
    Minecraft:
    I was trying to find a function that would produce all of the combinations for an item and then do exactly what you have here, but in a way that it'd accept inputs allowing users to find any item's chances if they used the chances from wynndata.
    Another thing that everyone should note:
    Price is not determined by actual chance of an item's roll occuring, because by that line of thinking a 5 SP prism is worth more than a 19 SP prism, which we all know is not true. The prices of items increase from the average value (13 SPs for prisms) to the max value (20) and decrease from the average to the minimum (5). Perfect roll items go for insane amounts because they are about as rare in terms of chance of 'occuring' as a mythic (as in the literal chance of a 20 SP prism), but lower than mythics since you'll have more chances to actually roll the items or find more to reroll.
     
  6. Thega

    Thega ```Interesting flavour text``` CHAMPION

    Messages:
    932
    Likes Received:
    803
    Trophy Points:
    125
    Guild:
    Minecraft:
    You did this in excel right? You should make it into a pretty probability dist graph.
     
    PikaLegend likes this.
  7. PikaLegend

    PikaLegend Shocking VIP+

    Messages:
    523
    Likes Received:
    960
    Trophy Points:
    91
    Minecraft:
    That's a really nice suggestion, numbers going up and down represented as a parabola is always a nice sight to see.
     
  8. Thega

    Thega ```Interesting flavour text``` CHAMPION

    Messages:
    932
    Likes Received:
    803
    Trophy Points:
    125
    Guild:
    Minecraft:
    probably a triangular distribution actually :P
    Edit 2 secs later: lol nvm ur right
     
  9. T-Flex

    T-Flex At the gym HERO

    Messages:
    1,846
    Likes Received:
    4,806
    Trophy Points:
    164
    Guild:
    Minecraft:
    [​IMG]

    I was bored, so graph \o/ not that it servers any purpose or means anything, but what the heck.
     
  10. Stupid Steelpid

    Stupid Steelpid Searches for a Fermion, gets a Stardew instead HERO

    Messages:
    883
    Likes Received:
    505
    Trophy Points:
    97
    Minecraft:
    gib me 5 sp prismie
     
  11. Paks

    Paks Spy Main CHAMPION

    Messages:
    1,230
    Likes Received:
    541
    Trophy Points:
    111
    Guild:
    Minecraft:
    That moment when the shittiest prism possible is rarer than the second best prism possible.
     
  12. Mistrise Mystic

    Mistrise Mystic Surfing winds and chasing windfalls HERO

    Messages:
    7,170
    Likes Received:
    14,371
    Trophy Points:
    217
    Minecraft:
    Why, exactly?
     
  13. Blizzardgale

    Blizzardgale Famous Adventurer VIP

    Messages:
    1,136
    Likes Received:
    2,904
    Trophy Points:
    164
    Minecraft:
    Looks like Prism rolls perfectly match a bell curve.
     
    T-Flex likes this.
  14. Corrupted_Night

    Corrupted_Night No Life Minecraft VIP

    Messages:
    40
    Likes Received:
    45
    Trophy Points:
    51
    Minecraft:
    I cannot even get 5 sp one because I never find a prism in my life ;_;
     
  15. Mandres

    Mandres Well-Known Adventurer

    Messages:
    6
    Likes Received:
    3
    Trophy Points:
    45
    Don't worry, you are not alone :D
     
Thread Status:
Not open for further replies.