1. (10%) Using the data provided, select the data corresponding to any country you choose (only one) for the period 1960-2016, and save it in a separate file.
2. (10%) Identify the following variables from the data set:
• Household consumption (real)
• Household consumption (real) per capita
• Real GDP
• Real GDP per capita
• Inflation rate based on the CPI (must be calculated)
3. (30%) For each of the variables above, and the period 1960-2016, do the following:
• A scatter plot diagram (years in the x-axis and the variable in the y-axis) with a linear or exponential trend line (linear for inflation and exponential for real GDP and consumption). Make sure to add the equation of the trend line in your graph.
• Analyze each graph and the meaning of the trend line equation. For the consumption and real GDP graphs, analyze the economic growth rate (total and per capita), identifying periods of recession and the growth rate of consumption. For the inflation rate, identify periods of inflation, deflation, and the total average inflation rate.
4. (30%) Using a scatter plot diagram, draw the relation between real GDP per capita (x-axis) and consumption per capita (y-axis), adding a linear trend line with its corresponding equation. From this graph, identify and analyze the MPC and the multiplier effect.
5. (20%) For the country selected, find the rate of unemployment for the last 20 years (or more if available), and calculate an estimate of the unemployment rate. Present this in a scatter plot diagram, and calculate the cyclical unemployment in, at least, one period of recession that you identify. Note: the data on unemployment is not provided to you. You need to download it from any other source (don’t forget to add the source in your report). One suggestion is to use the World Bank Data website.
• Your report will consist of only one Excel file with all the points mentioned above.
• Make sure to include your name, ID, and section number on top of the first Excel sheet, as well as the country you selected.
• The data should be in a separate Excel sheet.
• Add each point in a separate Excel sheet. Rename your sheets accordingly.
• Make sure to add your analysis below each corresponding graph. If you don’t organize your report in a way that is well presented and easy to read, this will most likely affect your assignment mark.
• The deadline to submit your report is April 08 by 6 PM. You must submit only your Excel file via the assignment link provided in LMS.
This assignment is individual, and as such, it is expected that you abide by the academic integrity policy in terms of plagiarism. Please refer to the syllabus for this.
In order to avoid infringing this policy, make sure that:
• You work alone, and that if you seek help from others for explanations, you don’t copy, under any circumstances, their own work.
• Make sure to include a reference to any additional sources that you use. Especially, do this for the last point of the assignment.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
