Please provide the EXCEL command you use in detail here.

Question 2 Consider Two countries A and B, each with a population of eight individuals. Tables 1 and 2 provide information on income for everyone in countries A and B, respectively. The poverty line is z= $40 Dollars (PPP) per day. Your job is to calculate and report the FGT poverty indexes for each country remembering that:

FGT [(z - vi) NZ i= 1Table 1: Country A Table 2: Country B Person # y Poor (1 if a Poor* Poor* Person # y Poor (1 if a Poor* Poor* household is (z-y) (z-y)2 household is (z-y) (z-y)2 poor, 0 (only if (only if poor, 0 (only if otherwise) (only if poor poor) otherwise) $10 poor) poor $15 2 $25 2 $20 3 $30 $35 4 $45 4 $35 5 $55 5 $60 6 $75 6 $65 7 $85 7 $65 $85 8 $100 Total 410 Total 395