Filed under: Photography
In my previous post where I mention that the Internet Archive is using ultra-expensive, 16.7 Megapixel digital cameras, I wondered how long it would be before a 16.7 Megapixel camera dropped to an affordable price. A couple hours later, I have a graph, but no answer. It turns out Barbie was right. Math is in fact hard.
I scraped data for digital cameras off of the excellent Digital Photography Review website. I gathered make, model, introduction date, introduction price, max resolution. From there I calculated the exact number of effective pixels. Then I calculated the dollars/megapixel. (Yes, I realize there is a whole lot more to the quality of a photo than the number of megapixels). I graphed the result Dollars/Megapixel on the Y-axis and Date on the X-axis. Added in a trendline and displayed the equation for the trendline. With this equation I should be able to enter a future date, and have it spit out the approximate cost per megapixel. The only problem, I don’t know how to input a normal date into the equation. I know excel has an understanding of dates, or I could convert all the dates to a Unix epoch (number of seconds from 1970-whatever)… but I’ve been staring at this computer too long and suspect there is an easier way that I’m not aware of.
Here’s the graph as it stands now. Click it for a larger version.
No Comments so far
Leave a comment
Leave a comment
Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>