Question

I need help building this in excel. I cannot come up with the weighted averages.

In this project you are required to do the following 1. Create an Excel spreads heet that will be capable of calculating several Multidimensional Poverty Index (MPI). Data set is at the end of the document. Keep in mind that weighting is involved in determining the Multidimensional Poverty Index (MPI) Your Excel spreadsheet should contain the following: 1 Your name, course name and project name 2. The scores provided on the next page 3. Dimensions and Indicators averages 4. The weights below used to determine the Multidimensional Poverty Index (MPI) 10 Indicators Nutrition School schooling attendance (1/6) Years of Child (1/6) mortality (1/6) (1/6) Health (1/3) Education(1/3) Living Standards (1/3) 3 Dimensions of Poverty 5. A labeled cell with the Multidimensional Poverty Index (MPI) that uses a formula to calculate the weighted average MPI. If a value is changed in your spreadsheet, your final calculation should recalculate. Please limit your use of Excel functions to those used in the course-packet (for a list see the 'Excel Reference sheet' in Ivy Learn's Excel Help' in the Resources Module 6. In addition to correctly calculating the Multidimensional Poverty Index (MPI). your spreadsheet should be easy to read. Make sure the spreadsheet it is well organized, with cle ar labels, and helpful formatting Cooking fuel (1/18) Sanitation (1/18) Drinking water (1/18) Electricity (1/1 8) Assets (1/18

Answer 1

	year
	w	0.166667	0.166667	0.166667	0.166667	0.055556	0.055556	0.055556	0.055556	0.055556	0.055556	1
Bangladesh	2014	25.6	2.3	25.2	9.6	40	30.7	4.3	26.5	38.7	28.3	19.81111
Cambodia	2014	20.4	1.8	21.6	10.8	36.2	30.6	21.3	26.2	21.8	6.6	17.02778

Formulas

	year
	w	=1/6	=1/6	=1/6	=1/6	=1/18	=1/18	=1/18	=1/18	=1/18	=1/18	=SUM(B2:L2)
Bangladesh	2014	25.6	2.3	25.2	9.6	40	30.7	4.3	26.5	38.7	28.3	=SUMPRODUCT($C$2:$L$2,C3:L3)
Cambodia	2014	20.4	1.8	21.6	10.8	36.2	30.6	21.3	26.2	21.8	6.6	=SUMPRODUCT($C$2:$L$2,C4:L4)

Note that $C$2:$L$2 is the cells for weights, which is fixed, you just just have to drag-drop for other rows

I showed it for first two ros as there is large data