Question

A factorial experiment was designed to test for any significant differences in the time needed to perform English to foreign language translations with two computerized language translators. Because the type of language translated was also considered a significant factor, translations were made with both systems for three different languages: Spanish, French, and German. Use the following data for translation time in hours.

	Language
	Spanish	French	German
System 1	7	14	15
	11	18	19
System 2	8	13	14
	12	15	20

Test for any significant differences due to language translator system (Factor A), type of language (Factor B), and interaction. Use a =.05.

Answer 1

Enter the given data in Excel as shown below:

Steps to perform ANOVA in Excel:

1. Enter the data in Excel.

2. Go to data , then to "Data Analysis "section , then select "Anova:Two Factor with Replication".

3. Enter the following details in the box shown below:

Results obtained after Data Analysis:

Here ,

p-value for Factor A = 0.850993 is greater than a = 0.05 , so it's concluded that  it is  "INSIGNIFICANT".

p-value for Factor B = 0.027314 is lesser than a = 0.05 , so it's concluded that it is "SIGNIFICANT".

p-value for Interaction = 0.772729 is greater than a = 0.05 , so it's concluded that it is "INSIGNIFICANT".