Question

Can you show me the steps in excel. Thanks.

8.12 Harden College is contemplating opening a European campus where students from the main campus could go to take courses for 1 of the 4 college years. At the moment, it is con- sidering five countries: The Netherlands, Great Britain, Italy Belgium, and Greece. The college wishes to consider eight factors in its decision. The first two factors are given weights of 0.2, while the rest are assigned weights of 0.1. The following table illustrates its assessment of each factor for each country (5 is best).

Answer 1

1. Harden College should choose Great Britain to set up its European Campus because Britain has the highest weighted overall strength rating of 4.6.
2. If “degree to which population can converse in English” would not have been an issue, then also Great Britain would have been the best choice with overall strength rating of 3.6. The Netherlands could have been considered also as its close behind   Great Britain with overall weighted strength rating of 3.5.

To calculate factor scores we multiply factor weights by their respective strength rating. Weighted overall strength rating is the sum of the factor scores of each country.

Factor	Factor Description		Weights	The Netherlands		Great Britain		Italy		Belgium		Greece
				Strength Rating	Score	Strength Rating	Score	Strength Rating	Score	Strength Rating	Score	Strength Rating	Score
1	Stability of government		0.2	5	1	5	1	3	0.6	5	1	4	0.8
														2	Degree to which the population can converse in English		0.2	4	0.8	5	1	3	0.6	4	0.8	3	0.6
3	Stability of monetary system		0.1	5	0.5	4	0.4	3	0.3	4	0.4	3	0.3
														4	Communications Infrastructure		0.1	4	0.4	5	0.5	3	0.3	4	0.4	3	0.3
5	Transportation Infrastructure		0.1	5	0.5	5	0.5	3	0.3	5	0.5	3	0.3
														6	Availability of historical or cultural sites		0.1	3	0.3	4	0.4	5	0.5	3	0.3	5	0.5
7	Import Restrictions		0.1	4	0.4	4	0.4	3	0.3	4	0.4	4	0.4
														8	Availability of suitable quarters		0.1	4	0.4	4	0.4	3	0.3	4	0.4	3	0.3
Sum of Importance weights			1
														Weighted Overall Strength rating					4.3		4.6		3.2		4.2		3.5
Weighted Overall Strength rating if 2nd factor is removed					3.5		3.6		2.6		3.4		2.9