Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Law Express Evidence

Authors: Chris Taylor

5th Edition

1292210192, 978-1292210193

More Books

Students also viewed these Law questions

Question

How does aggregate consumption behave over the business cycle?

Answered: 1 week ago

Question

Assess debt ratio.

Answered: 1 week ago

Question

What reward will you give yourself when you achieve this?

Answered: 1 week ago