Question

#13

There is an archaeological study area located in southwestern New Mexico. Potsherds are broken pieces of prehistoric Native American clay vessels. One type of painted ceramic vessel is called Mimbres classic black-on-white. At three different sites, the number of such sherds was counted in local dwelling excavations.

Site I	Site II	Site III
64	26	17
39	10	38
24	58	72
11	62	22
81		18
52		13
28

(b) Find SS_TOT, SS_BET, and SS_W and check that SS_TOT = SS_BET + SS_W. (Round your answers to three decimal places.)

SSTOT	=
SSBET	=
SSW	=

Find d.f._BET, d.f._W, MS_BET, and MS_W. (Round your answers for MS_BET, and MS_W to two decimal places.)

d.f.BET	=
d.f.W	=
MSBET	=
MSW	=

Find the value of the sample F statistic. (Round your answer to two decimal places.)


What are the degrees of freedom?

d.f.N	=
d.f.D	=

(f) Make a summary table for your ANOVA test. (Round your answers for SS to three decimal places, your MS and F Ratio to two decimal places, and your P-value to four decimal places.)

Source of Variation	Sum of Squares	Degrees of Freedom	MS	F Ratio	P-Value	Test Decision
Between groups					---Select--- p-value > 0.100 0.050 < p-value < 0.100 0.025 < p-value < 0.050 0.010 < p-value < 0.025 0.001 < p-value < 0.010 p-value < 0.001	---Select--- Reject H0. Do not reject H0.
Within groups
Total

Answer 1

For the given data using Anova single factor in Excel we get output as

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
site i	7	299	42.71429	598.5714
site ii	4	156	39	633.3333
site iii	6	150	25	552.8
ANOVA
Source of Variation	SS	df	MS	F	P-value
Between Groups	1074.689	2	537.3445	0.911258	0.424588
Within Groups	8255.429	14	589.6735
Total	9330.118	16