Question
Discuss the steps used to review and clean the data to ensure it is accurate and of suitable quality/format for analysis. Were there any gaps
Discuss the steps used to review and "clean the data" to ensure it is accurate and of suitable quality/format for analysis. Were there any gaps in data across years? How did you address any gaps? (4 marks) Your original data for your 4 variables for each of your countries should be downloaded in its entirety from 1960 to 2030 and stored in a worksheet called "Raw Data". new worksheet in your Excel file called "Clean Data" organizing your cleaned and formatted dataset based on your decisions about time frame. Hint: the years should be your rows. You would have 6 columns: country, year, 3 numerical variables, one categorical variable. INSERT this table on a single page into your paper. o Do you need to re-code any data? For example, maybe CPI is important. CPI is a measure of inflation. The actual CPI number is not what you need, you need to figure out the rate of inflation each year based on the CPI number. For example, maybe you are tracking a population. Is the actual population important, or is it more important to see how the population is changing each year (which would make it a
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