Project Problem Page
TABLE OF CONTENTS
- After I have Replicated the Data,
How do I get a Good theory for my extra work? - CANSIM at UofT won't let me in!
- Extra data not in CANSIM
- Some of my last enteries are blank!
- I can't get CANSIM to accept the Start and End Dates
- My output Doesn't Match Dr. Kamstra's Results
- CANSIM won't let me get any extra variables
- " 'ow do I convert quaterly data to monthly data"
 |
 |
 |
|
 |
 |
Problem #1
At 02:44 PM 10/31/96 -0800, Richard Lipsey wrote:Where do you get a good theory?
Your old Econ texts from your first year courses, the library, your TA, a prof who specializes in an area related to the variable you need to explain.
Problem #2
At 01:04 AM 11/6/96 -0800, Paul Gomme wrote:i had to questions. i was wondering what date we should use for our starting date of the data.i tried to get to the U of T web site from home but it tells me that my server is forbbiden from entering that site, i wanted to know if there was a way around that.
thank you
Paul Gomme
The server at UofT just becomes busy. Use the computers from school, and you should have no troubles.
Good Luck
Rod
|
|
|
|
|
|
Problem #3
At 05:24 PM 11/7/96 -0800, Dennis Maki wrote:
Hi! Rod,
I am working on the project which is about the export of the crude petroleum, and I want to get some pricing information of OPEC (Orgganization of Petroleum Exporting Countries). Would you please tell me how can I get the data from CANSIM? I had looked up hundreds of topics in the matrix list but still cannot find it!!!!! HELP!!!!!
Thanks!!
Dennis
CANSIM is a data base maintained by the Canadian Government. It does not have a great deal of international information. For OPEC data, you may have to go elsewhere.
Rod
Problem #4
At 09:41 AM 11/8/96 -0800, Special Agent Bob Dole wrote:
Rod, I looked at the project's data file and found that the last four or
five observations have "blanks". I believe cpi is one of them. How
should we proceed?
You are not using these observations. Your sample only goes up to 246. The blanks start to occur after that.
I've discussed this with some friends. Should we change the date range
to: Nov 1975 - May 1996 (instead of Jan 1976 - July 1996)?
No. The date range is correct. Carefully think about how the dates works.
Jan 76 to dec 76 is 12 months
Jan 76 to dec 77 is 24 months
Jan 76 to dec 78 is 36 months
Jan 76 to dec 79 is 48 months
Jan 76 to dec 80 is 60 months
Jan 76 to dec 81 is 72 months
Jan 76 to dec 82 is 84 months
Jan 76 to dec 83 is 96 months
Jan 76 to dec 84 is 108 months
Jan 76 to dec 85 is 120 months
Jan 76 to dec 86 is 132 months
Jan 76 to dec 87 is 144 months
Jan 76 to dec 88 is 156 months
Jan 76 to dec 89 is 168 months
Jan 76 to dec 90 is 180 months
Jan 76 to dec 91 is 192 months
Jan 76 to dec 92 is 204 months
Jan 76 to dec 93 is 216 months
Jan 76 to dec 94 is 228 months
Jan 76 to dec 95 is 240 months
6 more months brings the count to 246 observations
The 6th month is June. There is data for June.
Rod
|
|
|
|
|
|
Problem #5
At 02:04 PM 11/8/96 -0800, Rick Harris wrote:Hi Rod,
I was trying to retrieve my data from cansim and when it asked for the dates of my data (197601-199607) I entered it but it gave me an error message that 197601 was an invalid date. Can you help me on this one?
Thanks,
Rick Harris
You must read how to enter a date in the retrieval form.
To do this, go back to the web-page where you got the data. There is a hi-lighted word "date". Click on it and read the instructions on how to enter the dates.
Rod
Problem #6
At 03:50 PM 11/6/96 -0500, Peter Kennedy wrote:Hey Rod! I've typed in all of my data and everything is coming out fine in regards to the variables. Only the data regarding the "lagy" is incorrect. If double checked my input, so that does not seem to be the problem. Any suggestions?
I have just made a web-page to take care of this problem. It seems that CANSIM updated the data after the Instructor made the output handouts.
Rod
|
|
|
|
|
|
Problem #7
At 01:45 PM 15/11/96 -0800, The Student Formally Known as Prince wrote: Rod,I'm having trouble adding variables to my data series. Everytime I add one, my dependant variable disappears and the data does not come up. The new variable's data does come up but then there is an error at the bottom of the data stating that it cannot proceed.
All I am doing is taking the data series numbers that were given to us on the output and I am adding one more to it. How do I do this if my process is incorrect?
Thanks for your help,
"people used to call me Prince"
CANSIM only allows you to get so-much data at a time.
You don't have to get all of your data from CANSIM at the same time. Get the first section and save it to one file, then get another chunk of data and save it to another file. You will then have to open up to seperate workbooks in EXCEL. Import the first file of data into the first workbook. Then, import the second file of data into the second workbook. Then you can use cut&paste to copy the new extra data from the second workbook into the first workbook.
Rod
Problem #8
At 1:44 AM 11/18/96 -0800, Jean Chretien wrote:'ow do I convert da quarterly data to monthly data?
It isn't easy. I strongly suggest that you find a monthly variable, by useing the CANSIM keyword search.
Type key words like
mining monthly
or
wages monthly
or
lumber monthly
or
exports monthly
If you insist on converting, you have to do it manually in EXCEL.
The object of the project is to prove that you can do decent statisitcal analysis. That means that if you spend most of your time doing analysis, your are going to learn more and probably get a better grade than if you spend all of your time trying to get exactly the rigth extra variable. If you get a great extra variable, but you aren't left with time to do analysis, you are going to risk doing very poorly.
For average level or percentage data, just copy out the level for all the periods. So 1st Qtr growth of 12% means that you sub in 12% for Jan, Feb and March.
For totals, you divide them and sub in. For instance is you have a stat saying that total beer sales for 1996 were $12 Billion, then beer sales from each month would be $1. Clearly there will be some problems here, because beer sales are dramatically influenced by the seasons, however there is little you can do.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|