Another type of painted ceramic vessel is called three-circle red-on-white ( Mimbres Mogollon Archaeology). At four different sites in the Wind Mountain archaeological region, the number of such sherds was counted in local dwelling excavations. Site I Site II Site III Site IV 15 13 38 15 22 2 20 21 4 31 15 13 15 7 44 34 17 23   12   11   12 Shall we reject or not reject the claim that there is no difference in the population mean three-circle red-on-white sherd counts for the four sites? Use a 5% level of significance. (a) What is the level of significance?   (b) Find SSTOT, SSBET, and SSW and check that SSTOT = SSBET + SSW. (Use 3 decimal places.) SSTOT =   SSBET =   SSW =   Find d.f.BET, d.f.W, MSBET, and MSW. (Use 3 decimal places for MSBET, and MSW.) dfBET =   dfW =   MSBET =   MSW =   Find the value of the sample F statistic. (Use 3 decimal places.) What are the degrees of freedom? ?(numerator) ?(denominator) (c) Find the P-value of the sample test statistic. (Use 4 decimal places.)   (f) Make a summary table for your ANOVA test. Source of Variation Sum of Squares Degrees of Freedom MS F Ratio P Value Test Decision Between groups ? ? ? ? ?  Do not reject H0. Within groups ? ? ?       Total ? ?

PREALGEBRA
15th Edition
ISBN:9781938168994
Author:OpenStax
Publisher:OpenStax
Chapter5: Decimals
Section5.5: Averages And Probability
Problem 400E: The cash register receipts each day last week at a coffee shop were $1,845. $1,520. $1,438, $1,682,...
icon
Related questions
Topic Video
Question

Another type of painted ceramic vessel is called three-circle red-on-white ( Mimbres Mogollon Archaeology). At four different sites in the Wind Mountain archaeological region, the number of such sherds was counted in local dwelling excavations.

Site I Site II Site III Site IV
15 13 38 15
22 2 20 21
4 31 15 13
15 7 44 34
17 23   12
  11   12

Shall we reject or not reject the claim that there is no difference in the population mean three-circle red-on-white sherd counts for the four sites? Use a 5% level of significance.

(a) What is the level of significance?
 
(b) Find SSTOT, SSBET, and SSW and check that SSTOT = SSBET + SSW. (Use 3 decimal places.)
SSTOT =  
SSBET =  
SSW =  

Find d.f.BET, d.f.W, MSBET, and MSW. (Use 3 decimal places for MSBET, and MSW.)
dfBET =  
dfW =  
MSBET =  
MSW =  

Find the value of the sample F statistic. (Use 3 decimal places.)


What are the degrees of freedom?
?(numerator)
?(denominator)

(c) Find the P-value of the sample test statistic. (Use 4 decimal places.)
 
(f) Make a summary table for your ANOVA test.


Source of
Variation
Sum of
Squares
Degrees of
Freedom
MS F
Ratio
P Value Test
Decision
Between groups ? ? ? ? ?  Do not reject H0.
Within groups ? ? ?      
Total ? ?
Expert Solution
Step 1

I am using Excel and the command is as follows 

Data > Data Analysis > Anova : single factor > select the data > ok

==================================================

Anova: Single Factor    
         
SUMMARY      
Groups Count Sum Average Variance
Site I 5 73 14.6 43.3
Site II 6 87 14.5 114.3
Site III 4 117 29.25 194.25
Site IV 6 107 17.83333 74.16667
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Hypothesis Tests and Confidence Intervals for Means
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
PREALGEBRA
PREALGEBRA
Algebra
ISBN:
9781938168994
Author:
OpenStax
Publisher:
OpenStax
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning