For the fluorescence signal from solutions stored under different conditions. From last lecture, which means differ significantly? Treatment/ Group Conditions Replicate Mean A 102 100 101 101 A: Freshly prepared B 101 101 104 102 B: Stored for 1 hr in the dark C: Stored for 1 hr in subdued light D: Stored for 1 hr in bright light 99 97 94 92 Overall mean 98 Anova: Single Factor SUMMARY Groups Count Sum Average Va riance 3 303 101 1 Decision: Since calculated F(20.67) is more than critical F of 4.07 (or since p-value is 0.0004 which is smaller than a =0.05), we reject the null hypothesis. 3 306 102 3 3 291 97 4 3 276 92 4 ANOVA e of Vario df MS F P-value F crit Conclusion: The sample means do differ significantly. Between C 186 3 62 20.66667 0.0004 4.066181 Within Grd 24 8 3 Total 210 11

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

Anova exercise . Show the step and output using Excel.

= Menu v
Home
Insert
Page Layout
Formulas
Review
View
Tools
Q Click to find commands
Data
X Cut
- A A
Calibri
11
General
.00
Paste L copy - Format
BIU- - E -
Merge and
Wrap
AutoSum AutoFilter Sort Format
Conditional
Format as
Painter
Center
Тext
Formatting
Table
P25
® fx
A
В
E
F
G
H
M
N
1
C =
E;ni
Replicate 1 Replicate 2 Replicate 3 Mean
TSS = Eau (Xij – x)² = Eau *ij – C
(E, xij²)
E" n;(X; – x)² = E;
A
102
100
101
101
-
5 В
101
101
104
102
6 с
97
95
99
97
SSB =
- C
nį
7 D
90
92
94
92
SSW = TSS – SSB
df within = df total – df between
Where
.2
X: Overall mean
X;: Mean of group/treatment i
4
Xij: data for treatment i and replicate j
_6
n¡: no of replicates in treatment i
_8
In this eg., i=4 and j=n
20
21
2
Transcribed Image Text:= Menu v Home Insert Page Layout Formulas Review View Tools Q Click to find commands Data X Cut - A A Calibri 11 General .00 Paste L copy - Format BIU- - E - Merge and Wrap AutoSum AutoFilter Sort Format Conditional Format as Painter Center Тext Formatting Table P25 ® fx A В E F G H M N 1 C = E;ni Replicate 1 Replicate 2 Replicate 3 Mean TSS = Eau (Xij – x)² = Eau *ij – C (E, xij²) E" n;(X; – x)² = E; A 102 100 101 101 - 5 В 101 101 104 102 6 с 97 95 99 97 SSB = - C nį 7 D 90 92 94 92 SSW = TSS – SSB df within = df total – df between Where .2 X: Overall mean X;: Mean of group/treatment i 4 Xij: data for treatment i and replicate j _6 n¡: no of replicates in treatment i _8 In this eg., i=4 and j=n 20 21 2
• For the fluorescence signal from solutions stored under different
conditions. From last lecture, which means differ significantly?
Treatment/
Group
Conditions
Replicate
Mean
A
102
100
101
101
A: Freshly prepared
B
101
101
104
102
B: Stored for 1 hr in the dark
C: Stored for 1 hr in subdued light
D: Stored for 1 hr in bright light
97
95
99
97
D
90
92
94
92
Overall mean
98
Anova: Single Factor
SUMMARY
Groups
Count
Sum
Averoge
Voriance
3
303
101
1
Decision: Since calculated F(20.67) is more than critical F
of 4.07 (or since p-value is 0.0004 which is smaller than a
=0.05), we reject the null hypothesis.
B
3
306
102
3
3
291
97
4
D
3
276
92
4
ANOVA
ce of Vario
df
MS
F
P-value
F crit
Conclusion: The sample means do differ significantly.
Between C
186
3
62 20.66667
0.0004 4.066181
Within Gro
24
8
Total
210
11
Transcribed Image Text:• For the fluorescence signal from solutions stored under different conditions. From last lecture, which means differ significantly? Treatment/ Group Conditions Replicate Mean A 102 100 101 101 A: Freshly prepared B 101 101 104 102 B: Stored for 1 hr in the dark C: Stored for 1 hr in subdued light D: Stored for 1 hr in bright light 97 95 99 97 D 90 92 94 92 Overall mean 98 Anova: Single Factor SUMMARY Groups Count Sum Averoge Voriance 3 303 101 1 Decision: Since calculated F(20.67) is more than critical F of 4.07 (or since p-value is 0.0004 which is smaller than a =0.05), we reject the null hypothesis. B 3 306 102 3 3 291 97 4 D 3 276 92 4 ANOVA ce of Vario df MS F P-value F crit Conclusion: The sample means do differ significantly. Between C 186 3 62 20.66667 0.0004 4.066181 Within Gro 24 8 Total 210 11
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Research Ethics
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.
Similar questions
  • SEE MORE QUESTIONS
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