Question

To study the effect of temperature on yield in a chemical process, five batches were produced at each of three temperature levels. The results follow.

Temperature
	50°C	60°C	70°C
	31	28	24
	21	29	29
	33	32	29
	36	21	31
	29	25	32

1. Construct an analysis of variance table (to 2 decimals, if necessary). Round p-value to four decimal places.
   

   Source of Variation	Sum of Squares	Degrees of Freedom	Mean Square	F	p-value
   Treatments
   Error
   Total

   
   
2. Use a .05 level of significance to test whether the temperature level has an effect on the mean yield of the process.
   
   The p-value is Selectless than .01between .01 and .025between .025 and .05between .05 and .10greater than .10Item 11  
   
   What is your conclusion?
   SelectConclude that the mean yields for the three temperatures are not all equalConclude that the mean yields for the three temperatures are all equalItem 12

Answer 1

We can directly use here one way anova by Excel.

Step1 ) Enter data in Excel.

Step 2) Data >>Data analysis >> One way anova >>Select data >>click on label in first row >>ok

a)

ANOVA
Source of Variation	SS	df	MS	F	P-value
Between Groups	23.33	2	11.67	0.59	0.5680
Within Groups	236	12	19.67
Total	259.33	14

b) P value is 0.5680 > 0.05

Conclude that the mean yields for the three temperatures are all equal Item