Download Economic Data using Excel

In this video tutorial, we will explain how to Download Economic Data using Excel in one minute. The data can be downloaded from various sources like World Bank, International Monetary Fund and other data providers through Knoema Addin in Excel. The Knoema addin is one of the best and most easy tool to Download Economic Data using Excel. You can download economic, financial, trade, political and data on other related topics.

Download Economic Data using Excel

Follow these steps to Download Economic Data using Excel from Knoema using Excel.

The following video tutorial is only recorded to help you do the above practical in simple sessions. You can request us for custom download of any Economic and Financial data. We are happy to provide both free and paid support in making data availability from different sources. Watch the video tutorial now.

To request private courses in Data Analysis, click here.

Panel Data, Time Series and Cross Sectional Data

If you have on entity (N=1) like one country, one company, one person etc and you collect data about this entity for many time periods (T=many), it is called Time Series Data. For example if we download data on GDP, Consumption, Investment, Savings, Exports and Imports for from world bank indicators (data.worldbank.org) for Pakistan only and 30 year, this will be N=Pakistan and T=(1970 to 2000) which defines the data is time series data.

If you many entities (N=many) like 10 countries, 100 companies and 1000 persons etc and you collect data about these entities for one time period (T=1), then it is called cross sectional data. Similar to earlier example of (World Bank Data), if we download data for 50 countries for only year 2010, then it becomes cross section data. For example, if I collect data for GDP, Consumption, Investment, Savings, Exports and Imports for Afghanistan, Albania, Algeria, American Samoa, Andorra, Angola, Antigua and Barbuda, Arab World , Argentina , Armenia , Aruba , Australia , Austria , Azerbaijan , Bahamas, The , Bahrain , Bangladesh , Barbados , Belarus , Belgium , Belize , Benin , Bermuda , Bhutan, Bolivia , Bosnia and Herzegovina , Botswana , Brazil , British Virgin Islands, Brunei Darussalam , Bulgaria, Burkina Faso for the year 2010, then it can be cross sectional data.

If you have many entities (N=many) and collect data about these many entities for many time periods (T=many), it is called Cross Sectional Time Series data. So, if we collect data onGDP, Consumption, Investment, Savings, Exports and Imports for Afghanistan, Albania, Algeria, American Samoa, Andorra, Angola, Antigua and Barbuda, Arab World , Argentina , Armenia , Aruba , Australia , Austria , Azerbaijan , Bahamas, The , Bahrain , Bangladesh , Barbados , Belarus , Belgium , Belize , Benin , Bermuda , Bhutan, Bolivia , Bosnia and Herzegovina , Botswana , Brazil , British Virgin Islands, Brunei Darussalam , Bulgaria, Burkina Faso for the year 2000 to 2010, it will be panel data. Note, panel data might include T>N or N>T so selection of a relevant method can decided here:

panel data methods

panel data methods

Note panel data is what entities remains same over the time periods. Logitudinal data might contain some entities to appear only in one or the other time periods.

Free Survey, Free Online Survey, Free Online Survey Questionnaire

LimeSurvey is the best online survey tool, free online survey tool and free online survey questionnaire building tool. We are proud to help you use LimeSurvey for your academic research. We will help you use LimeSurvey online survey tools for free and to the best of its capabilities for data collections. LimeSurvey offers you everything you need for collecting data through online questionnaire with unlimited responses and with all posisble question types. The full features of online survey tools from LimeSurvey can be found here.

Some of the features, online survey tool from LimeSurvey offers include but are not limited to
Unlimited number of surveys at the same time Unlimited number of questions in a survey (only limited by your database), Unlimited number of participants to a survey, Multi-lingual surveys,User-management,28 different question types with more to come,WYSIWYG HTML editor,Quotas management,Integration of pictures and movies into a survey,Creation of a printable survey version,Conditions for questions depending on earlier answers (Skip Logic / Branching),Piping and Micro-tailoring using a powerful expression engine, Re-usable editable answer sets,Ready-made importable questions & surveys,Assessment surveys,Anonymous and Not-Anonymous survey,Open and closed group of participant surveys,Optional public registration for surveys,Sending of invitations, reminders and tokens by email,Option for participants to buffer answers to continue survey at a later time,Cookie or session based surveys,Template editor for creating your own page layout,Extended and user-friendly administration interface,Back-office data entry possibility,Survey expiry dates for automation,Enhanced import and export functions to text, CSV, PDF, SPSS, R, queXML and MS Excel format,Basic statistical and graphical analysis with export facility,Screen Reader Accessiblity,W3C compliance,A detailed manual is available in several languages in our Online Manual.

You can request a free LimeSurvey account with us using our servers for free use for academic research and data collection.

How to Create Effective Online Survey Questionnaire

There is a lot of thinking and work behind creating online questionnaires. We need to create effective online questionnaire for collecting most responses. The user of online surveys should feel the questionnaire is engaging. To create an online survey that demands responses with interest should include the following key points:

1. Clearly explain the objectives of the online survey and select the target audience clearly.
2. Do not include the irrelevant questions and confusing terminologies in the online surveys.
3. Your questions should be grouped and should be specific and closed ended. Do not ask the respondent to do anything before
4. Select the the type of question cleverly on your end and make it simple for respondent. The questions should be consistents within the group. Dont make irrelevant questios a part of a group.
5. Clearly label and make a realistic order of the questions. Dont put random questions. Your questions should all belong to a specific group and all the questions to convicing the audience to respond for the next question interest. This is what we should consider a Logical ordering of the question will play its role in convincing your respondents to happily fill out your questionnaires.
6. Make sure, your questionnaire is technically and academically relevant and correct. It is helpful for you and some respondents might find it flawed so they might not respond. Hence, give a deal of great care for creating your online survey tool as best as it should be academically. You can test the survey tool before publication or some expert opinion from your seniors might help you get the improved questionnaire. This will also add an interest to technically aware respondents about online survey tools.
7. You should carefully select your audience. Send the online survey tool with great care, expectations and ensure the audience is convinced of the tool will help them learn something indirectly. Offer them an aknowledgment in advance and describe your online survey tool and questionnaire in simple and interesting words to make sure the research is unique, interesting and valuable. Dont just request for response but also offer them a summary of statistics for free in return through their contact details. You can send them a copy of interesting results in form of a newsletter if you cannot share your full research.
8. Yes, remind your respondents because some respondents might have missed your earlier communication due to their own reasons. The reminder should be excellently prepared and should not enforce the audience to respond.
These tips have been prepared while working on online survey tools creation, developing customized questionnaire using LimeSurvey for the last Five years. This guide also is motivated by the questions and discussion we have with our research students about their research questionnaires.
Watch the video tutorial to create your first survey after getting your survey account.

[youtube https://www.youtube.com/watch?v=ndpEhC6mysM]