I've created some videos (screen recordings) for my third year taxation course, showing how to download data from CANSIM, adjust it for inflation, and do some other basic analysis.
How to download revenue data from CANSIM
The next one shows how to adjust for inflation
How to adjust for inflation - updated
Numbers on their own are often difficult to interpret, so this is a long (17 minute) video showing how to put data into perspective:
How to put data into perspective
That's my personal favourite, but it may be too long for the average listener.
(Gentle) feedback and suggestions for other video topics welcome. (These were recorded on a mac using QuickPlayer.)
Update: I've removed a couple of videos with adjustments for inflation made with core CPI and updated the post. Also, given the positive reaction and the number of hits the CANSIM video is getting, I've made a follow-up
How to download employment data from CANSIM
Update 2: The latest video shows How to find stuff in CANSIM
This is a really great idea. It's all very well to say "go look it up on Cansim, it's free now!" If you're not used to doing this, you can be easily overwhelmed. It's great to slow it down to the step-by-step level.
Posted by: Stephen Gordon | March 12, 2012 at 08:54 PM
Frances, please tell me you don't mumble! Pulpit Presence, my dear lady, Pulpit Presence!
Posted by: Determinant | March 12, 2012 at 09:00 PM
Oh man - I'm watching you try to get JUST THE DAMN CPI AND NOT EVERY FREAKING COMPONENT.
I would have started ranting angrily at that point.
Posted by: Stephen Gordon | March 12, 2012 at 09:04 PM
Stephen, the updated version is better, I just selected all and then unselected all.
Posted by: Frances Woolley | March 12, 2012 at 09:07 PM
Determinant, you can judge for yourse.f
Posted by: Frances Woolley | March 12, 2012 at 09:07 PM
Stephen, do you think I should take down the video showing core CPI, and only leave up the one with all goods CPI?
Posted by: Frances Woolley | March 12, 2012 at 09:33 PM
I think that might be a good idea. Core is only really used as a predictor of future CPI. It really shouldn't be used to deflate nominal spending (unless you actually are talking about the stuff that's in the core basket).
Posted by: Stephen Gordon | March 12, 2012 at 09:39 PM
The only people who should ever use core are money/macro economists who are trying to decide whether to tighten or loosen monetary policy. You wouldn't (I think) ever use core to adjust anything for inflation.
I'm trying to gather up the courage to watch. Fearing it would only make me feel more incompetent.
Posted by: Nick Rowe | March 12, 2012 at 09:41 PM
Do it! She explains how to use the formula feature in excel!
Posted by: Stephen Gordon | March 12, 2012 at 09:52 PM
Nick, these are for mechanics, not poets.
Posted by: Frances Woolley | March 12, 2012 at 10:04 PM
Thanks a lot. I don't have time to watch right now, but my first attempt to use Cansim resulted in something like 450 tables while trying to find one data series I was interested in (I was trying to find average weekly earnings - or some equivalent income stat - for either Alberta or the Edmonton CMA over time). Needless to say, at this point I gave up trying to use CANSIM. This is a great resource for us armchair nerds that lack any kind of formal research training.
Posted by: Neil | March 13, 2012 at 01:03 AM
Neil, you chose option 2, download the entire table, instead of using add/remove data to select the series you wanted, and then picking option 1. I did that too the first couple of times.
Posted by: Frances Woolley | March 13, 2012 at 07:38 AM
Thanks, this is a very useful set of videos.
Posted by: richard | March 13, 2012 at 09:37 AM
I've added one on how to insert a hyperlink. This was my second attempt, but I'm still not convinced that the font size is big enough to read.
Posted by: Frances Woolley | March 13, 2012 at 09:45 AM
Okay, I've watched now, and this is great stuff. I have no idea what I was doing before, but I don't remember there being a nice drop-down menu and check boxes to select what I wanted.
Posted by: Neil | March 13, 2012 at 10:39 AM
Frances - if I could make a suggestion for the employment numbers: use Table 282-0087 and choose the seasonally-adjusted data. There are very significant seasonal swings in Canadian data - and StatsCan appears to be the leading expert in dealing with it. Their X11 filter (don't ask) is used by statistical agencies around the world.
It didn't matter for the application you chose, but if someone wants the headline numbers, they're in 282-0087.
Posted by: Stephen Gordon | March 13, 2012 at 05:19 PM
Stephen @#%$#@%$#@!!
Thanks, I'll retape it. These are getting way more hits than I thought they would, so it's worth getting it right. I need to re-do the "putting data into perspective" one too.
Posted by: Frances Woolley | March 13, 2012 at 05:51 PM
If you redo them, try hard not to lose that "why isn't that working?" real world freshness. Very endearing - the basis of true classics.
Posted by: Jim Sentance | March 13, 2012 at 07:03 PM
Yes, exactly. Getting those data really is *not* all that obvious. People who are led to believe that "It's as simple as 1-2-3" will be cruelly disappointed.
Posted by: Stephen Gordon | March 13, 2012 at 07:08 PM
Oh my. They have a ways to go yet before it's as good as FRED. And it is a shame they don't offer a programming interface. Then we too could have toys like an Excel addin and mobile apps (for the non-nerds: under the hood, it's the programming interface that makes the toys possible).
Posted by: Patrick | March 14, 2012 at 01:02 AM
Patrick, I thought for a minute you were talking about the videos not CANSIM.
Posted by: Frances Woolley | March 14, 2012 at 07:41 AM
Stephen, I've redone the employment video to use table 282-0087, and included a little gripe about how difficult it is to figure out which numbers to use. The new one is now linked in the update above. I've left the other one up but given it a much less appealing title ("seasonally unadjusted employment data in CANSIM"). Am also repeatedly clicking trying to crank up the page view number for the new video so it overtakes the old one.
Posted by: Frances Woolley | March 14, 2012 at 10:57 PM
Am listening to it now. You do well not to skip quickly through the first parts.
It's always surprising to me just how difficult it can be to find the data behind the headline numbers in the StatsCan Daily releases; it took awhile before I finally found 282-0087. Today's release of the household balance sheets is anther good example. There are the *national* numbers, and the *household* numbers. I had to send an e-mail once to ask where the household numbers were.
Posted by: Stephen Gordon | March 15, 2012 at 12:23 PM
Stephen - I'm glad 282-0087 wasn't obvious to you either!
I was chatting yesterday with someone who works at StatsCan who suggested searching The Daily first to find table numbers, and then going to CANSIM, but that strategy doesn't always work either - e.g. for employment it gives something along the lines of "the information can be found in CANSIM table 282-0001 to 282-0099".
I recorded another one this morning on how to convert quarterly data to annual data using Excel - a nasty little operation that is necessary to, for example, use the most recent government revenue stats, as due to the change over in gov't accounting system the 2010 numbers are only available in the quarterly series. It's still loading. Took 4 or 5 takes - though Jim's comment above gave me courage.
Posted by: Frances Woolley | March 15, 2012 at 12:44 PM
OMG OMG OMG OMG OMG OMG OMG this is awesome. Thank you so much. Time to start forwarding these on to some poeple in need. This is a perfect primer for people working with stats but who don't have a background in economics.
Posted by: Anonymous | March 15, 2012 at 01:22 PM
Anon - thanks for your comments.
The latest one is now up showing how to convert quarterly data to annual data using excel.
Posted by: Frances Woolley | March 15, 2012 at 04:04 PM
Key. Key. Key. Key. Key? Key.
Posted by: K | March 16, 2012 at 10:57 AM
The other "K",
I know it was stupid to ever comment under the pseudonym "K". It's too generic. But I did and I've been doing so on this site for a while now. Could you choose anther name? Please?
Best regards,
K
Posted by: K | March 16, 2012 at 11:57 AM
First K - I don't understand. Are you getting annoyed at the way I say o.k. all the time? Or that I don't describe what keys to use I just hit ctrl-c, ctrl-v or the all-powerful mac F3 key to make things happen?
If the first - well, in life you get what you pay for, k?
Posted by: Frances Woolley | March 16, 2012 at 12:06 PM
Good job. I hope that this is just the beginning of a new tradition to put your education materials on the web.
PS: Just a minor tip, I saw that you expand the formula by copy-pasting it from the cell where you typed it. I find easier to do expansion by dragging that small dot on the lower right corner of the cell around the spread sheet.
Posted by: J.V. Dubois | March 16, 2012 at 12:32 PM
J.V. - thanks. If you have suggestions for other videos, just let me know. They're kind of fun to do - high reward/effort ratio.
Posted by: Frances Woolley | March 16, 2012 at 01:22 PM
That "How to find stuff in Cansim" has some *very* useful tips. I didn't know about the 'Media' tab; a pro tip if there ever was one.
Posted by: Stephen Gordon | March 17, 2012 at 10:33 AM
Stephen - thanks, and thanks for the retweet.
Posted by: Frances Woolley | March 17, 2012 at 11:08 AM