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

##### New member
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:

#### lev888

##### Junior Member
Excel chart trendline option suggests:

y = 0.8714x1.9553 (power) or

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