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. Source of Variation 50°C 60°C 70°C Treatments Error Total Temperature 35 23 35 38 34 70 29 368 31 438 35 23 Construct an analysis of variance table. (Round your values for MSE and F to two decimal places, and your p-value to four decimal places.) 22 24 27 27 29 Sum of Squares 38 Degrees of Freedom 2 2 11 X X 35 Mean Square 18.83 x F p-value Use a 0.05 level of significance to test whether the temperature level has an effect on the mean yield of the process.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

please show me the excel formulas you use if possible 

Find the value of the test statistic. (Round your answer to two decimal places.)
Find the p-value. (Round your answer to three decimal places.)
p-value =
State your conclusion.
Reject Ho. There is not sufficient evidence to conclude that the mean time needed to mix a batch of material is not the same for each manufacturer.
Do not reject Ho. There is not sufficient evidence to conclude that the mean time needed to mix a batch of material is not the same for each
manufacturer.
Do not reject Ho. There is sufficient evidence to conclude that the mean time needed to mix a batch of material is not the same for each manufacturer.
Reject Ho. There is sufficient evidence to conclude that the mean time needed to mix a batch of material is not the same for each manufacturer.
(b) At the a = 0.05 level of significance, use Fisher's LSD procedure to test for the equality of the means for manufacturers 1 and 3.
Find the value of LSD. (Round your answer to two decimal places.)
LSD =
Find the pairwise absolute difference between sample means for manufacturers 1 and 3.
x₁ - x3 =
=
What conclusion can you draw after carrying out this test?
There is a significant difference between the means for manufacturer 1 and manufacturer 3.
There is not a significant difference between the means for manufacturer 1 and manufacturer 3.
Transcribed Image Text:Find the value of the test statistic. (Round your answer to two decimal places.) Find the p-value. (Round your answer to three decimal places.) p-value = State your conclusion. Reject Ho. There is not sufficient evidence to conclude that the mean time needed to mix a batch of material is not the same for each manufacturer. Do not reject Ho. There is not sufficient evidence to conclude that the mean time needed to mix a batch of material is not the same for each manufacturer. Do not reject Ho. There is sufficient evidence to conclude that the mean time needed to mix a batch of material is not the same for each manufacturer. Reject Ho. There is sufficient evidence to conclude that the mean time needed to mix a batch of material is not the same for each manufacturer. (b) At the a = 0.05 level of significance, use Fisher's LSD procedure to test for the equality of the means for manufacturers 1 and 3. Find the value of LSD. (Round your answer to two decimal places.) LSD = Find the pairwise absolute difference between sample means for manufacturers 1 and 3. x₁ - x3 = = What conclusion can you draw after carrying out this test? There is a significant difference between the means for manufacturer 1 and manufacturer 3. There is not a significant difference between the means for manufacturer 1 and manufacturer 3.
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.
Source
of Variation
50°C 60°C 70°C
Error
35
Total
23
35
38
Temperature
34
Treatments 70
29
368
31
438
35
23
22
Construct an analysis of variance table. (Round your values for MSE and F to two decimal places, and your p-value to four decimal places.)
24
27
27
29
Sum
of Squares
38
2
Degrees
of Freedom
11 Xx
X
35
Mean
Square
18.83
X
F
p-value
Use a 0.05 level of significance to test whether the temperature level has an effect on the mean yield of the process.
Transcribed Image Text: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. Source of Variation 50°C 60°C 70°C Error 35 Total 23 35 38 Temperature 34 Treatments 70 29 368 31 438 35 23 22 Construct an analysis of variance table. (Round your values for MSE and F to two decimal places, and your p-value to four decimal places.) 24 27 27 29 Sum of Squares 38 2 Degrees of Freedom 11 Xx X 35 Mean Square 18.83 X F p-value Use a 0.05 level of significance to test whether the temperature level has an effect on the mean yield of the process.
Expert Solution
Step 1

Given data:

  Temperature  
50oC 60oC 70oC
35 29 24
23 31 27
35 35 27
38 23 29
34 22 38

 

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman