Results 1 to 2 of 2

Thread: Pattern Progression: regression for video-game Price progession from data

  1. #1

    Pattern Progression: regression for video-game Price progession from data

    Hello everyone

    Im working on a spreadsheet that i will use to calculate every possible item that can be generated in a video game which im currently playing. The problem is, i cant figure out the item Price progression. For example, i know that Armors value is based on the Armor Rating of each item, because an item with say, 15 armor, will always have the same value, regardless of level requirement or item type (helm, gloves, chest, boots...).

    So here is the list i compiled by searching in the Game

    Armor Rating Item Value
    1 1
    2 3
    3 7
    4 13
    5 20
    6 29
    7 39
    8 51
    9 64
    10 79
    11 95
    12 113
    13 132
    14 152
    15 174
    16 198
    17 223
    18 249
    19 277
    20 306
    21 336
    22 368
    23 402
    24 437
    25 473
    26 510
    27 549
    28 590
    29 632
    30 675
    31 719
    32 765
    33 813
    34 861
    35 912
    36
    37 1016
    38 1070
    39 1126
    40 1183
    41 1241
    42 1301
    43 1362
    44 1425
    45 1488
    46
    47 1620
    48 1688
    49 1757
    50 1828
    51 1900
    52 1973
    53
    54 2124
    55 2202
    56
    57 2360
    58 2442
    59 2525
    60 2609

    As Armor Rating can get as high as 540, finding and taking notes of such a high number of itens would take foverer.
    Last edited by Rospokadu; 02-28-2018 at 01:15 AM. Reason: grammar

  2. #2
    Junior Member
    Join Date
    Jan 2018
    Location
    Boston
    Posts
    162
    Excel chart trendline option suggests:

    y = 0.8714x1.9553 (power) or

    y = 0.698x2 + 1.7804x - 7.1679 (polynomial)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •