Anova tests in excel
 

I'm having difficulty with the Anova tests. In a 1 way Anova sometimes one of
the factors is not a numeric value (eg a geographic location). Excel does not
seem to accept this though. Other than coding the factors (eg 1= paris, 2=
New York) is there any way around this?
The values that I get for the two way Anova in particular do not seem to
replicate the results in MINITAB.
--
rakbhat