Anova exercise . Show the step and output using Excel.

Big Ideas Math A Bridge To Success Algebra 1: Student Edition 2015
1st Edition
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:HOUGHTON MIFFLIN HARCOURT
Chapter11: Data Analysis And Displays
Section: Chapter Questions
Problem 10CT
icon
Related questions
Question

Anova exercise . Show the step and output using Excel.

= Menu v
Home
Insert
Page Layout
Formulas
Q Click to find commands
Data
Review
View
Tools
3 X Cut
- A A
Σ
Calibri
11
General
e J Copy
BIU- H- 9- Q· A -Q- EE
Merge and Wrap
O - % 000 i 80
AutoFilter Sort Format Fill
Rows and Worksheet Freeze Panes
Format
Conditional Format as
AutoSum
Painter
Center
Тext
Formatting
Table
Columns
A1
® fx
A
B
E
G
H
J
K
L
(Eaxij)?
E;ni
2
C =
Stomach (mg/kg)
Gill (mg/kg)
Muscle (mg/kg)
3
TSS =
-all
Eal (*ij – x)? = Ealij -
4
20
32
26
SSB = E n;(X; – x)² = E;-
(E,xij²)
18
36
30
- C
ni
18
34
14
SSW = TSS – SSB
7
df within
df total – df between
8
Where
10
X: Overall mean
11
12
X;: Mean of group/treatment i
data for treatment i and replicate j
13
Xij:
14
15
n¡: no of replicates in treatment i
16
In this eg., i=4 and j=n
17
18
19
20
Transcribed Image Text:= Menu v Home Insert Page Layout Formulas Q Click to find commands Data Review View Tools 3 X Cut - A A Σ Calibri 11 General e J Copy BIU- H- 9- Q· A -Q- EE Merge and Wrap O - % 000 i 80 AutoFilter Sort Format Fill Rows and Worksheet Freeze Panes Format Conditional Format as AutoSum Painter Center Тext Formatting Table Columns A1 ® fx A B E G H J K L (Eaxij)? E;ni 2 C = Stomach (mg/kg) Gill (mg/kg) Muscle (mg/kg) 3 TSS = -all Eal (*ij – x)? = Ealij - 4 20 32 26 SSB = E n;(X; – x)² = E;- (E,xij²) 18 36 30 - C ni 18 34 14 SSW = TSS – SSB 7 df within df total – df between 8 Where 10 X: Overall mean 11 12 X;: Mean of group/treatment i data for treatment i and replicate j 13 Xij: 14 15 n¡: no of replicates in treatment i 16 In this eg., i=4 and j=n 17 18 19 20
• Concentrations of Zinc in the different tissues of a crustacean are
shown below. Which means are significantly different?
Stomach (mg/kg)
Gill (mg/kg)
Muscle (mg/kg)
20
32
26
18
36
30
18
34
14
(Courtesy of Dr. Harwant Singh, Modified)
Transcribed Image Text:• Concentrations of Zinc in the different tissues of a crustacean are shown below. Which means are significantly different? Stomach (mg/kg) Gill (mg/kg) Muscle (mg/kg) 20 32 26 18 36 30 18 34 14 (Courtesy of Dr. Harwant Singh, Modified)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 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
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning