Question

8. An experiment is conducted to compare the effects of weathering on paint of three different types. To do so, identical surfaces are coated with some paint of each type that has been exposed to four different environments. Measurements of the degree of deterioration we made for each surface. The data set is uploaded to Moodle. What can you say about the different paint types and different environments and their effects on the paint degradation?

   Deterioration	Paint Type	Environment
   9.42	A	1
   9.14	A	1
   10.82	A	2
   11.82	A	2
   8.51	A	3
   7.4	A	3
   10.08	A	4
   10.11	A	4
   11.37	B	1
   12.43	B	1
   13.56	B	2
   11.31	B	2
   11.14	B	3
   10.55	B	3
   14.7	B	4
   14.35	B	4
   9.85	C	1
   11.84	C	1
   12.13	C	2
   11.34	C	2
   10.09	C	3
   9.03	C	3
   10.87	C	4
   12.7	C	4

   I am trying to do this in Excel but the "Anova: two-factor with replication" test won't work and I can't figure out what I'm doing wrong. I keep getting an error that says "Anova: Two-Factor With Replication - Each sample must contain the same number of rows." Some explanation and help would be greatly appreciated. Thanks.

Answer 1

Excel can only read this form of data which is attached below.

Now, run the test.

The answer is:

Please give me a thumbs-up if this helps you out. Thank you!