Missing Data Generation trai

Question

Hi

I want to generate missing data if data is not contineously missing.........for example

YearCountry1Country2Country31586NullNull2452NullNull3415NullNull4325475Null59588569856Null9549657758Null8568NullNull99192451452456

For country 1 data is missing in between two valid points, so i want to replace with average growth rate in values.

For country 2 data is data is missing for 1,2 &3 year since this data is missing from starting year i do not want to replace it with any value. but for year 7 & 8 data is not missing from starting year then i want jto replace with average growth rate in values.

Similarly for country 3 data is missing from starting year then i do not want to replace it with any value.

binu_acs · Accepted Answer

@awanishyadavv @The country field values are growth rates?

awanishyadavv · Accepted Answer

Growth Per year = (end year - starting year) / starting year.
Average Growth rate = (sum of Growth per year) / no of growth per

Ex-----

YearCountry1Growth rate per year(Country 1)Country2Growth rate per year(Country 2)Country3Growth rate per year (Country 3)1586(452-586)/586Null Null 2452(415-452)/452Null Null 3415(325-415)/415Null Null 4325(958-325)/325475 Null 5958 856 985 6Null 954 965 7758 Null 856 8Null Null 991 9245 1452 456

binu_acs · Accepted Answer

@awanishyadavv I assumed the country fields have the growth rates,