nightsurge said: How exactly are you averaging these things out to get the "Total Weeks of Ownership"? Did you really go through each and every week to update the number of consoles sold per each week and how old they are now? Please go into more detail on how you got the TWO figures. I also do not see how dividing that TWO by the total games sold somehow makes an average weeks between games bought. Seems to me like you would have to account for data involving how many games are out, and again, how many games per single purchase. So in other words, by relying so much on all these different averages, it seems that this graph has a high %error probability. |
Yes, the spreadsheet goes through each and every week using the data from this site. Here is an example using the 360:
Date | Week | Weekly Hardware | TWO | Total Software | WBP |
11/25/2005 | 1 | 352,952 | 352,952 | 1,450,984 | 0.24 |
12/2/2005 | 2 | 94,972 | 800,876 | 1,869,658 | 0.43 |
12/9/2005 | 3 | 333,422 | 1,582,222 | 2,145,203 | 0.74 |
12/16/2005 | 4 | 164,562 | 2,528,130 | 2,413,142 | 1.05 |
12/23/2005 | 5 | 133,939 | 3,607,977 | 2,725,795 | 1.32 |
12/30/2005 | 6 | 95,270 | 4,783,094 | 2,984,774 | 1.60 |
So for week six, the formula for TWO is:
TWO=(352952 x 6)+(94972 x 5)+(333422 x 4)+(164562 x 3)+(133939 x 2)+(95270)=4,783,094
As for your other question, lets say I bought a 360 with 4 games at launch. Let's say I don't buy any other games for a while after that. At the end of the first week, I have owned the console for one week and bought 4 games, so my WBP (Weeks Between Purchases) is 1/4 = 0.25. At the end of four weeks, I have owned the console for 4 weeks, but I have still only bought 4 games. So, my WBP is now 4/4 = 1. It is an average.
This is how it works, it is just for everyone who owns a 360. That is why it is the total number of weeks owned and total amount of software sold.
The error that will be in this graph is going to be the error from the VG Chartz data.
Switch Code: SW-7377-9189-3397 -- Nintendo Network ID: theRepublic -- Steam ID: theRepublic
Now Playing
Switch - Super Mario Maker 2 (2019)
Switch - The Legend of Zelda: Link's Awakening (2019)
Switch - Bastion (2011/2018)
3DS - Star Fox 64 3D (2011)
3DS - Phoenix Wright: Ace Attorney (Trilogy) (2005/2014)
Wii U - Darksiders: Warmastered Edition (2010/2017)
Mobile - The Simpson's Tapped Out and Yugioh Duel Links
PC - Deep Rock Galactic (2020)