Head over to our on-demand library to view sessions from VB Transform 2023. Register Here
Geek comic artist Randall Munroe, better known as XKCD’s creator, revealed a little-known Google Spreadsheets secret yesterday. You can plot out the estimated volume of Google search results against different queries.
How do you do it? Alex Chitu at Google Operating System says:
If you are familiar with Google Spreadsheets, try to create a sheet that lets you enter a query like “My IQ is X”, a variable name and the values for that variable. The result should be a graph that shows the number of Google search results for each instance of your query. Use importXML and an XPath expression to find the number of Google search results: “//p[@id=’resultStats’]/b”. Here’s an example.
I’ve had a little fun this morning plotting out search queries against income. There’s not a distinctive trend though, aside from search results topping out at notable benchmarks like $100,000 and $1 million.
VentureBeat's mission is to be a digital town square for technical decision-makers to gain knowledge about transformative enterprise technology and transact. Discover our Briefings.