Tag Archives: charts

Digging into GroceryCHOICE

8 Replies

Earlier this week, South Australian senator Nick Xenophon raised concerns that the Government’s FuelWatch scheme would lead to higher petrol prices and that small independent petrol retailers were likely to be disadvantaged by the scheme. So it looks likely that the FuelWatch legislation will fail to pass the senate and then fade into oblivion. I can’t say I’m too upset about this as I have been critical of the scheme. Furthermore, falling oil prices have led to a fall of around 20 cents/litre in petrol prices which takes much of the sting out of the issue.

So now I am free to turn my attention to another Australian Government initiative, GroceryCHOICE**. This scheme aims to “[help] consumers find the cheapest supermarket chain in their area without having to compare hundreds of prices”. Every month a survey is conducted of prices on around 500 different grocery items at over 600 supermarkets around the region. These prices are aggregated into “baskets” of goods in the following categories:
Continue reading →

Online Data and Charts with Swivel

13 Replies

I recently came across the OECD Factbook blog written by Jérôme Cukier, who works as a data editor for the OECD. He has an excellent post on publishing charts in blogs.

As regular readers of the Mule will know, I don’t mind posting the odd chart and in the process I have grappled with the less than ideal results that the Excel to image production-cycle can produce. Jérôme’s process discusses these challenges and illustrates the results of different techniques (although I had more luck with copying as a picture and saving to PNG format than he had, so perhaps the choice of picture editor is a factor as well). As far as possible, I try to avoid using Excel altogether for producing charts and instead use the statistical package R, which can produce charts directly to a number of image formats including JPG and PNG. Although Jérôme doesn’t mention R, it does crop up in the first of the comments on his post.

Continue reading →

A Tipping Point for Starbucks?

10 Replies

On 1 July 2008, Starbucks announced the closure of around 600 outlets in the US. More drastically, on 29 July they then announced that 61 of the 84 Australian outlets would be closing.

Over on BeyondDigitalMedia, Chris Bishops posted an interesting examination of the challenges Starbucks has faced in the Australian market and goes on to predict that Gloria Jeans will suffer a similar fate.

Continue reading →

Update on Sydney Petrol Prices

13 Replies

A little while ago I wrote about the relationship between crude oil prices and the price Sydney motorists are paying for petrol at the pump. The Australian Automobile Association (AAA) has now released their price data for June and, not surprisingly, prices continued to track moves implied by rising crude oil prices. The simple regression model suggested that average prices would be up 8 cents/litre. The AAA data shows a rise of 10 cents/litre in the average Sydney price.

Continue reading →

Spam and Social Networks

4 Replies

Social networks have been growing at an extraordinary rate over the last couple of years. The big contest has been between Facebook and MySpace and recently Facebook was reported to have caught up with its older rival. These two social networking giants aim to be walled gardens where users can chat, exchange photos, share music, take quizzes and (more bizarrely) turn each other into virtual vampires.

A more minimalist approach is the microblog. Twitter pioneered the idea of the microblog, asking its users the question “what are you doing”, a question to be answered in 140 characters or less. You are also able to “follow” other twitter users, tracking their posts (or “tweets”) and they may choose to follow you back. Twitter has been growing rapidly over the last year (see chart below) and recently exceeded two million registered users and countless other sites are now following hot on their heels, including jaiku, pownce, identi.ca and kwippy.

Continue reading →

Sydney Petrol Prices

21 Replies

Soaring petrol prices have led to all sorts of calls for action to help reduce prices. The Opposition called for a 5 cents per litre reduction in the excise on petrol, which currently stands at 38.1 cents per litre. (See note below for an explanation of the strike-throughs). the abolition of the double taxation of petrol by eliminating Goods and Services Tax (GST) on petrol excise. Since the excise is currently 38.1 cents per litre, this would save 3.8 cents per litre. One Victorian Liberal MP, Chris Pearce, went further and called for a 10 cent reduction in petrol excise. The Rudd Government initially claimed that there was nothing more that they could do, but then buckled to the pressure and has proposed the introduction of a national FuelWatch scheme aimed at promoting price transparency at the bowser. The Minister for Competition Policy & Consumer Affairs, Chris Bowen, has indicated that this scheme is expected to save around 2 cents per litre. So, what is going on with petrol prices and what are the merits of these proposals?

Continue reading →

Retail Sales in New South Wales

6 Replies

Yesterday the Sydney Morning Herald published an article on the latest retail sales numbers for New South Wales that contrasted the sales growth in take-away food and pubs and clubs with the decline in business for cafes, restaurants and fresh food retailers. This is put in the context of with rising mortgage rates and fuel prices, to suggest that consumer behaviour is starting to shift. The data is published by the Australian Bureau of Statistics, so I decided to dig a little deeper. Prompted by a comment over on the Junk Charts blog, I’ve used a table enriched with spark-lines rather than the heatmap I used in the inflation post.

Continue reading →

Drivers of Australian Inflation

18 Replies

Inflation in Australia has been running well outside the 2-3% range targeted by the Reserve Bank of Australia—the most recent figure was 4.3% for the 12 months to March 2008—which is why interest rates have been on the rise for the last couple of years. So what has been driving prices up in Australia? One useful way to get a sense of what has been happening is to use a type of chart known as a treemap (sometimes called a “Map of the Market”). These charts tend to be pretty busy, but can be a great way to explore a rich set of data.

Continue reading →