logo

Some more stats




xirax

Some more stats


Tags: casino dev

Published : 8 months, 2 weeks ago (Tue, 28 Oct 2008 00:49:02 PDT)
Searched: casino
http://xirax.livejournal.com/169700.html  0 links
Related posts

SELECT SUM(Stddev/AvP * cnt)/SUM(cnt) FROM (
SELECT Brand, Family, Series, MAX(Price) AS MaxP, AVG( Price ) AS AvP, MIN(Price) AS MinP, STDDEV(Price) AS Stddev, Count(ItemID) AS cnt
FROM training_data
WHERE LENGTH(Series) > 0 AND Series != "XP"
GROUP BY Brand, Family, Series, CPUType, CPUCores, CPUSpeed, RAM, HDD, LCD, OS, Drive, ItemCondition
HAVING (Count(ItemID) > 1)) AS Equivalences

Result:
0.088

Which means the following:
A difference in eBay laptop prices for exactly the same laptops is 8.8%
/>Example:
You sell Dell D600 for $200
You sell exactly the same Dell D600 for $230/>Average is (200+230)/2 = $215./>Standard deviation is sqrt(sqr(200-215)+sqr(230-215)) = 21.21
Standard deviation in terms of average price is 21.21/215 = 0.098 = 9.8%
That's what this huge SQL thing on top measured, for all sets of the same laptops.

xirax


More results for "casino"


This is cached version of livejournal post retrieved by LjSEEK on 2008-10-28 00:49:14 . Post may have changed since that time. Click here for actual post version. LjSEEK.COM is not affiliated with author of this post and is not responsible for its content.
These search terms have been highlighted: casino
Disable Highlighting
xirax's Search:
Get your own code!
Copyright © 2005,2006 ljseek.com This service is not affiliated with LiveJournal.com
Design by Steorra.com