Question
Section 1 Creating a research database -- choose ONE of the following scenarios and answer the questions that follow (50% in total). Scenario 1: The
Section 1 Creating a research database -- choose ONE of the following scenarios and answer the questions that follow (50% in total). Scenario 1: The North America Free Trade Agreement (NAFTA) renegotiation is ongoing between Canada, US and Mexico. In order to study the impact of NAFTA on Canada's international trade with the trading partners in the last 25 years in terms of volume, value and type of goods or services traded, you are asked by your supervisor to gather relevant data, design a research database structure and compile a datafile. Scenario 2: Suppose the current federal government is considering a universal drug plan for all Canadians. In order to assess the impact of such a plan on government expenditures and potential impact on taxation, you are asked by your supervisor to gather relevant data, design a research database structure and compile a datafile. Questions: 1. Where would you look for relevant data? Give 3 potential data sources and explain why. (10%) 2. What variables would you select to be included in the database? Give as many variables as you think relevant and explain why. (15%) 3. What would a mock-up database structure look like? List the variables in rows and columns. (15%) 4. What software would you use for creating the datafile for statistical or econometric analysis? (10%)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started