Reference no: EM133295879

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 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