Given the following sample data, complete parts a and b. Click the icon to view the sample data. a. Based on the computations for the within- and between-sample variation, develop the ANOVA table and test the appropriate null hypothesis using α=0.01. Use the p-value approach. b. If warranted, use the Tukey-Kramer procedure to determine which populations have different means. Use α=0.01.

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
100%

For the third (and hopefully final time), can somebody please break down how to do this in Excel please? I am NOT subscribed to minitab so any explanation in that service is next to useless to me. The decimals need to be rounded to four decimal places. Thank you 

Item
1
234567
Group 1
19.6
27.8
24.6
20.6
25.5
28.3
22.7
Group 2
28.8
26.1
20.1
30.7
30.8
24.8
Group 3
16.4
14.6
17.4
20.4
15.3
Group 4
20.2
24.8
19.4
17.3
Transcribed Image Text:Item 1 234567 Group 1 19.6 27.8 24.6 20.6 25.5 28.3 22.7 Group 2 28.8 26.1 20.1 30.7 30.8 24.8 Group 3 16.4 14.6 17.4 20.4 15.3 Group 4 20.2 24.8 19.4 17.3
Given the following sample data, complete parts a and b.
Click the icon to view the sample data.
a. Based on the computations for the within- and between-sample variation,
develop the ANOVA table and test the appropriate null hypothesis using
α=0.01. Use the p-value approach.
b. If warranted, use the Tukey-Kramer procedure to determine which
populations have different means. Use α = 0.01.
a. Complete the ANOVA table.
Source of Variation
Between groups
Within groups
Total
SS
ANOVA
df
MS
(Round to four decimal places as needed.)
F
Transcribed Image Text:Given the following sample data, complete parts a and b. Click the icon to view the sample data. a. Based on the computations for the within- and between-sample variation, develop the ANOVA table and test the appropriate null hypothesis using α=0.01. Use the p-value approach. b. If warranted, use the Tukey-Kramer procedure to determine which populations have different means. Use α = 0.01. a. Complete the ANOVA table. Source of Variation Between groups Within groups Total SS ANOVA df MS (Round to four decimal places as needed.) F
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 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