Tuesday, May 24, 2016

Gas Prices in Ontario

A friend, Michael Lieff pointed this nice set of data out. It is the price of gas in several Ontario cities going as far back as 1990. This is an interesting data set as the price of gas, in general, increases but you can see that that wasn't always the case (only a few of the cities are shown below).

Analysis

When you go to this website you have several options for prices and you can download a year of data at a time (with a CSV as an option). The obvious choice is regular gasoline but you might want to consider things like comparing regular gas to alternative fuels like propane. For example in this case, you can see that, in general, propane also has risen in price over time but where gasoline seems to fluctuate similarly regardless of the city, propane seems to be more volatile depending on location.

Because of the shear amount of data points possible (you can get a weekly average for the last 25 years for several cities if you want), you may wish to stick to yearly values. Another option is to use some of he weekly values to talk about the dangers of extrapolation



Download the Data

Site http://www.energy.gov.on.ca/en/fuel-prices/
I have also taken the liberty of downloading all of the data for gasoline (all 25 years of it) in weekly, monthly and yearly form. As well as the yearly propane data. You can get it on this Google sheet (note the tabs) or just the gas prices on Fathom

Let me know if you used this data set or if you have suggestions of what to do with it beyond this.

3 comments:

  1. It was an useful post helped in knowing the gas prices in Ontario. The analysis was excellent. Thanks for sharing the post.
    Industrial Gas Suppliers in UAE

    ReplyDelete
  2. Hi author, that's a great post helps me to know the Lpg gas price. Many thanks for sharing with us. It's really a informative blog. Good work keep going!

    ReplyDelete
  3. I came to your website by search about San Francisco Limo services merely would choose to make a enormous thumbs up for that excellent information you may have here for this post. I’ll be returning to your blog for much more soon.

    ReplyDelete