Yeah, I only realised too late that the default colours were put in a bad order, sorry :P
as for my trendlines, I initially started off using high order polynomials, because they had the lowest r^2 value, which for any of us lucky enough to have escaped stats courses is how closely the two sets of data correlate was highest that way. However, that failed miserably when I extrapolated the lines.
As part of my initial assumptions, I stated that I believed the analysts predictions would, as time goes on, tend towards the actual answer. The only trendline that will tend towards a certain value but never reach it (or go past) in excel is exponential for a decay and logarythmic for an increase. The PS3 and 360 both have exponential decay, and the Wii logarythmic increase
And yes, Y axis is marketshare in percent. X axis is time in number of months since 1 month before the first prediction (the 1 month offset was required because without it, excel refuses to use log trendlines - dividing by 0 presumably being the problem)
Existing User Log In
New User Registration
Register for a free account to gain full access to the VGChartz Network and join our thriving community.
