statistics

You are currently browsing articles tagged statistics.

The 9pm Edict

Despite the lag, here is episode 3 of The 9pm Edict. Finally.

You can listen to this episode below. But if you want them all, subscribe to the podcast feed, or even subscribe automatically in iTunes.

If you’d like to comment on this episode, please add your comment below, or Skype to stilgherrian or phone Sydney +61 2 8011 3733.

There will be a special extra episode on Friday 5 March to make up for the one we missed on Monday.

[Credits: The 9pm Edict theme by mansardian, Edict fanfare by neonaeon, all from The Freesound Project. Photograph of Stilgherrian taken 29 March 2009 by misswired, used by permission.]

OK, so I was wrong. Very wrong. And Citi was right, perhaps even conservative with their estimates of Google’s revenue turnaround.

The other day I was sceptical that Citi’s analysis showed Google suddenly reversing three years of declining revenue growth. They predicted that the revenue growth for 2009 Q4 would be 16%.

I scoffed. I figured the fat red line (right) was a more appropriate projection of the data in the graph.

Well, Google’s actual Q4 revenue growth was 17%. That’s the green dot.

Bastards.

Now Bob Bain, who actually knows how to read these numbers, has found a more detailed review. He points out that while net profit was allegedly up fivefold, Google did write off a billion dollars as “impairment of equity investments” last year. I don’t know what that means, but it sure sounds like it’d make last year look a bit wobbly.

Now, check this chart of Google’s share price for the last two years.

Broadly speaking, it shows the share price dropping as the global financial crisis kicked in, and then recovering. Apart from that tiny little downturn in the last week or two, Google’s share price is back up to where it was two years ago.

Lessons?

  1. The stock market is a long term investment, unless you really want to immerse yourself in the crazy world of the day traders.
  2. When it comes to the stock market, I haven’t the faintest fucking idea what I’m talking about, and you should ignore me.

Any questions?

It’s no secret that the high-growth venture-capital-driven Internet industry is a hype-laden circus of misinformation. But today’s Chart of the Day from Silicon Alley Insider (right) really takes the biscuit.

Here we see that since Q3 of 2006, Google’s quarterly revenue growth has steadily declined from a cancerous 70% year-on-year to under 10% for the last three quarters.

Now there’s nothing wrong with an 8% growth rate. That’s pretty much up there with China, for instance. And the only countries growing faster than China are starting from a very low base. Think of such economic powerhouses as Angola, Bhutan, Rwanda and Timor-Leste.

OK, I know countries and companies aren’t the same thing, but that’s not my point.

Look at the bottom right of that first graph.

Citi reckons that Google’s growth in the next two quarters will increase in a more-or-less straight line that’s even steeper than that most recent quarter-on-quarter increase. Based on fucking what, Citi? That’s the only quarter showing growth in the entire chart!

Surely this second graph is a more realistic projection based on the data available.

There’s precisely zero science here. I just grabbed the straight-line tool in my graphics program and drew in a red line by eye. I certainly couldn’t be arsed doing this properly with, you know, mathematics. But…

Honestly, which of these “projections” looks more realistic to you?

As I say, there’s no science here. Perhaps we can add some analysis.

What factors might be affecting Google’s potential for increased revenue growth?

On the plus side:

  • Google is operating in a marketplace which is still growing, and perhaps even growing faster than last year as we emerge from the global financial crisis. Then again, so is everyone else.
  • Google’s got a new product line coming out, those Android phone thingamabobs, and people are wetting themselves to get one. Well, at least until Apple reveals their new toy next week.
  • Google pwns the Internet.
  • What else?

But working against that:

  • Google is subject to increased competition, especially from Microsoft’s Bing and related products and services.
  • Rupert Murdoch is up to something, although admittedly he might not have the faintest idea what he’s doing.
  • Every market eventually reaches a plateau. The key bullshit image of the first dot.com boom was the classic revenue projection of a start-up: exponential growth continuing forever. Well, here in rich white Western countries, all the folks who are using the Internet are pretty much there already. There might be more volume of data, but the amount of attention span you can sell to advertisers ain’t going to rise so much.
  • What else?

We also need to remember that these are revenue figures, not profit. And that’s my core point. Simplistic “Oooh, aah!” gawking over one numerical measure without context is wankery. Why do we let analysts get away with it?

All that said, I’m no financial analyst. What would I know? So if you know better, set me straight. There’s a “Reply” box below…

Oh, and Google’s Q4 revenue figures will be announced tomorrow. So we’ll have one more real data point then. Stand by.

Yesterday I wrote an article for Crikey plus a post here based on Google Trends data which, it now appears, is dodgy.

Google Trends shows a steady decline in traffic to various websites since about September 2008, based on the metric “unique daily browsers”. But I was howled down. Everyone else’s metrics were not showing such a decline.

Indeed many, such as this chart of Nielsen NetRatings’ unique dailies, provided by Andrew Hunter (@Huntzie), Head of News, Sport and Finance at ninemsn, showed the exact opposite.

Nielsen NetRatings unique daily browser chart, showing steady rise in audiences: click to embiggen

For example, news.com.au grew from 250,829 average daily unique browsers (UBs) in July 2008 to 346,367 in October 2009, a 38% increase. Not the roughly 50% drop shown by Google Trends.

Google says:

Trends for Websites combines information from a variety of sources, such as aggregated Google search data, aggregated opt-in anonymous Google Analytics data, opt-in consumer panel data, and other third-party market research. The data is aggregated over millions of users, powered by computer algorithms…

In other words, it’s some Google Secret Sauce. But has the sauce gone off?

Photograph of an angry goose

The Google Trends forum is rather quiet. There were only three questions or comments posted for the whole of September, none of which received a reply, and nothing since. I can’t see that anyone from Google has responded to anything for months and months — I gave up looking back any further. Others have noted that Google Trends data differs wildly from Google’s own Analytics product — usually complaining that it shows significantly less traffic.

Google Trends is a Google Labs product, i.e. an experiment, I’m starting to think that it’s been abandoned and we’re just seeing a slow degradation due to lack of maintenance.

Meanwhile, I have changed my Twitter avatar to a goose for the rest of today.

Google Trends graph showing traffic drop to major Australian news sites

If Google Trends’ statistics are to be trusted, it looks like there’s been a significant decline in traffic to websites over the last year — not just news, but everywhere. Except social network sites.

Following a blog post by Nicholas Moerman, a planning intern with Proximity in London, I checked out the figures for Australia sites. It does indeed look like there’s been a significant drop in daily unique visitors — which is what Google Trends measures, rather than the more common monthly uniques.

Crikey logo

I’ve written more, and provided more graphs, in a piece for Crikey today, Is social media killing the web as we know it?

Oh, and I was also in Crikey yesterday, Baffled by Murdersoft? Making sense of Murdoch and Microsoft, where I look at some of the numbers behind the rumoured deal between News Corporation and Microsoft’s Bing search engine.

Stilgherrian’s links for 08 November 2009 through 18 November 2009:

See what happens when you don’t curate your links for ten days, during which time there’s a conference which generates a bazillion things to link to? Sigh.

This is such a huge batch of links that I’ll start them over the fold. They’re not all about Media140 Sydney, trust me.

Read the rest of this entry »

Stilgherrian’s links for 22 October 2009 through 27 October 2009, published after far too long a break. I really, really do need to work out a better way of doing this…

Stilgherrian’s links for 15 October 2009 through 19 October 2009, gathered with bile and soaked in vinegar:

  • 50 Years of Space Exploration | Flickr: A brilliant infographic summarising interplanetary exploration. In an excellent demonstration of Chaos, the landing on asteroid 443 Eros is accidentally tagged as “443 Eris”. All hail Discordia!
  • They Shoot Porn Stars Don’t They: Susannah Breslin’s fascinating and somewhat challenging feature article on the recession-hit US porn industry.
  • ISP in file-sharing wi-fi theft | BBC News: UK ISP TalkTalk staged a wireless stunt, illustrating why it thinks Lord Mandelson’s plans to disconnect illegal file sharers is “naive”. It’s easy to blame others just by hacking WiFi connections.
  • Prince Philip tussles with technology | ABC News: This story is a few days old, however I found it curious that a perfectly good story about the design of technology was tagged as “offbeat” and the teaser written to make Prince Phillip look like a silly old man.
  • NPR News Staff Social Media Policy: Another example of a good corporate social media policy. There’s plenty of these policies around now, so there’s no excuse for any big organisation not to have caught up.
  • Federal Court of Australia Judgements: Some judgements have been recorded on video. “The Court is keen to continue to improve public access with the use of live streaming video/audio. Further live and archived broadcasts of judgement summaries are posted on this page as they become available.”
  • Televised Patel trial an Australian first | ABC News: The trial of Dr Jayent Patel for manslaughter to be held in a Brisbane court will be shown in Bundaberg, where the deaths happened, via closed-circuit TV. Given this “local interest”, one wonders why it couldn’t also be available anywhere there were interested parties.
  • Vivian Maier – Her Discovered Work: Maier was a Chicago street photographer from the 1950s to 1970s who died earlier this year. Some 40,000 negatives have been found, and they’e now being blogged.
  • 100 years of Big Content fearing technology — in its own words | Ars Technica: Copyright-holders have objected to pretty much every advance in media technology, it seems.
  • Mac Sales Spike When A New Version Of Windows Comes Out | Business Insider: A curious interpretation of the figures, but they reckon that when Microsoft releases a new version of Windows it drives people to buy Macs instead.
  • The Federal Trade Commission’s Coming War on Bloggers | Valleywag: While I normally don’t read Valleyway, I caught someone mentioning this article and was caught by one useful new term: conceptual gerrymandering. If the US FTC wants to give tax breaks to “news organisations” they’ll have to define what they are. Could it be old journalists versus bloggers battle writ large?

Here are the web links I’ve found for 15 October 2009, posted almost automatically. Almost

Stilgherrian’s links for 22 September 2009 through 26 September 2009, gathered intermittently and posted with a lack of attention to detail:

« Older entries