The seven bar charts (one for each day of the week) shows the distribution of ULP prices of all fuel stations in Perth.
The charts are from a live Power bI report, so you can select the Region and the Fuel Product (ULP, Diesel…) you are interested in and the charts will get updated.
The charts above are a live Power BI report.
The charts show ULP prices in the Perth metro area. Further analysis could be focused on other regions and other fuel types. As the charts are a live Power BI you can select different regions and fuel types and see the resulting charts by yourself.
The screenshot below is the distribution for a particular week , in this instance the week from Monday 6 May 2019 to Sunday 12 May 2019.
The distribution is clearly not normal and does not seem to follow other famous distribution either.
It is interesting to note that:
– on Monday, the day of the week to fill your tank with cheap gas, most fuel station offers an attractive price although there is a significant number of petrol station which practices high prices.
– On Sunday, the fuel price distribution is nearly normal, meaning that there a quite a good number of deal around but you will have to be selective.
– on all other days, the distribution is materially skewed to the left meaning high prices in most petrol station. The chart shows that there is a smaller peak in the middle meaning that a non-insignificant number of fuel station offer more decent prices (although still higher than on Monday).
– On any given days it is possible to find a petrol station with a price that is comparable to the best price you can get on Monday.
As a caveat the distribution are for a particular week only, so it would be interesting to confirm these observations hold for any week. It requires a bit of normalisation of the data beforehand and I will come to that later on.