{"id":4481,"date":"2010-01-28T09:11:49","date_gmt":"2010-01-28T09:11:49","guid":{"rendered":"http:\/\/scienceblogs.com\/principles\/2010\/01\/28\/quantization-of-books-4-how-ma\/"},"modified":"2010-01-28T09:11:49","modified_gmt":"2010-01-28T09:11:49","slug":"quantization-of-books-4-how-ma","status":"publish","type":"post","link":"http:\/\/chadorzel.com\/principles\/2010\/01\/28\/quantization-of-books-4-how-ma\/","title":{"rendered":"Quantization of Books 4: How Many Books Is That Again?"},"content":{"rendered":"<p>I&#8217;ve toyed around in the past with ways to use the <a href=\"http:\/\/www.mbeckler.org\/dog_physics\/\">Amazon sales rank tracker<\/a> to <a href=\"http:\/\/scienceblogs.com\/principles\/2009\/12\/quantization_of_books_3_how_ma.php\">estimate the sales numbers<\/a> for <a href=\"http:\/\/dogphysics.com\/\"><cite>How to Teach Physics to Your Dog<\/cite><\/a>. It&#8217;s geeky fun, but not especially quantitative.<\/p>\n<p>Yesterday, though, I found a reason to re-visit the topic: calibration data!<\/p>\n<p><!--more--><\/p>\n<p>OK, &#8220;calibration data&#8221; is probably too strong a description. &#8220;Calibration anecdote&#8221; is more accurate.<\/p>\n<p>Yesterday when I went into work a little after 10, a comment somebody made sent me to the actual <a href=\"http:\/\/www.amazon.com\/How-Teach-Physics-Your-Dog\/dp\/1416572287\">Amazon page for the book<\/a>, where I saw a little note next to the price information saying &#8220;Only 5 left (more are coming)&#8211; order soon!&#8221; That&#8217;s very cool to see&#8211; I don&#8217;t know how many they ordered initially, but retailers selling out their whole stock is always good (for the author, not so much the potential reader).<\/p>\n<p>When I got back from lunchtime hoops, the little message was still there, but the number left had dropped from 5 to 1. Which suggests that four copies sold between 10am ET and 1pm ET, and that provides a way to calibrate the effect of selling a copy on the sales rank.<\/p>\n<p>So, the relevant rankings from the tracker data table are:<br \/>\n2645<br \/>\n2525<br \/>\n2871<br \/>\n2223<br \/>\n(the times in the table are Pacific time, so those are 0700-1000 on 20100127). That suggests that four sales in three hours boosts the rank from 2645 to 2223, or 422 spots. That&#8217;s a change of 16% from the start, or 15% from the peak.<\/p>\n<p>Of course, you might reasonably argue that such a cluster of sales ought to produce a more noticeable change in the rankings, and it wouldn&#8217;t be unreasonable to expect there to be a lag between the actual sale and the change in the ranking. So, what&#8217;s the biggest shift we could see from these data?  If you take the next three points, you get:<br \/>\n2040<br \/>\n1753<br \/>\n1693<br \/>\n(the next point after that goes up again). The largest difference from high to low in this larger data set would be from 2871 (noon ET) to 1753 (3pm ET), a difference of 1118, or 39% of the peak. That would suggest a two-hour lag between the sale of a book and the adjustment of the sales rank, which seems a little big, but not wildly unreasonable.<\/p>\n<p>Of course, this depends on a bunch of information of unknown quality&#8211; for these analyses to make any sense, the number of books listed in the little notice has to be accurate, and not just a sales tactic (later in the afternoon, the &#8220;only 1 left&#8221; notice seemed to disappear then reappear then disappear again, which isn&#8217;t a good sign). The number also needs to reflect the number that have been ordered, and not the shipping of books ordered a day or so earlier.<\/p>\n<p>Assuming those assumptions aren&#8217;t wildly off base, though, this suggests that three hours at a sales rank between 1500 and 3000 equals roughly four books sold. Using that gives a lower bound for Amazon sales at ranks below 3000 of 556 books (417 hours of ranks below 3000 in the dataset). That&#8217;s an extreme lower bound, mind, as 191 of those hours were below a sales rank of 2000, and thus presumably account for more than 1.33 sales\/hour, but it&#8217;s the right order of magnitude, at least.<\/p>\n<p>So, there&#8217;s your fun with numbers item for this Thursday.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve toyed around in the past with ways to use the Amazon sales rank tracker to estimate the sales numbers for How to Teach Physics to Your Dog. It&#8217;s geeky fun, but not especially quantitative. Yesterday, though, I found a reason to re-visit the topic: calibration data!<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"1","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,142,7,51,147,37,143,11],"tags":[155,156,83,157,92,148,158,88,150],"class_list":["post-4481","post","type-post","status-publish","format-standard","hentry","category-books","category-how-to-teach","category-physics","category-physics_books","category-playing-with-graphs","category-pop_culture","category-sales","category-science","tag-amazon","tag-book-sales","tag-books-2","tag-math-2","tag-physics-2","tag-physics-books","tag-sales-rank","tag-science-2","tag-science-books","entry"],"_links":{"self":[{"href":"http:\/\/chadorzel.com\/principles\/wp-json\/wp\/v2\/posts\/4481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/chadorzel.com\/principles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/chadorzel.com\/principles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/chadorzel.com\/principles\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/chadorzel.com\/principles\/wp-json\/wp\/v2\/comments?post=4481"}],"version-history":[{"count":0,"href":"http:\/\/chadorzel.com\/principles\/wp-json\/wp\/v2\/posts\/4481\/revisions"}],"wp:attachment":[{"href":"http:\/\/chadorzel.com\/principles\/wp-json\/wp\/v2\/media?parent=4481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/chadorzel.com\/principles\/wp-json\/wp\/v2\/categories?post=4481"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/chadorzel.com\/principles\/wp-json\/wp\/v2\/tags?post=4481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}