B F rch company tests the effectiveness of three new flavorings for a new sauce using a sar vor 1, Group 2 tastes Flavor 2, and Group 3 tastes Flavor 3. n given a questionnaire that evaluates how enjoyable the beverage was. wn below. Determine whether there is a perceived significant difference between the Elavor 2 Flavor 3

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
This is the second part of the question. Please provide the excel formula, the correct EXCEL FORMULA.
File
Home
Insert
Draw
Formulas
Data
Review
View
Help
Ø Editing v
Calibri
B
v A
$v 囲、ラ、國
...
General
00
00
A1
fx Accessibility tab summary: Given information for this question is presented in rows 2 through 17. Requirement information is presented in rows 20 through 32.
A.
B
E
F
G
H
M
1.
A marketing research company tests the effectiveness of three new flavorings for a new sauce using a sample of 30 people, divided randomly into three groups of 10 people each.
3.
Group 1 tastes Flavor 1, Group 2 tastes Flavor 2, and Group 3 tastes Flavor 3.
4.
Each person is then given a questionnaire that evaluates how enjoyable the beverage was.
5.
The scores are shown below. Determine whether there is a perceived significant difference between the three flavorings.
6.
Flavor 1
Flavor 2
Flavor 3
13
12
9
17
8
19
10
19
6
15
11
11
16
14
12
20
12
10
15
14
16
13
18
10
18
14
9
18
11
15
4
14
16
12
11
11
16
17
18
Transcribed Image Text:File Home Insert Draw Formulas Data Review View Help Ø Editing v Calibri B v A $v 囲、ラ、國 ... General 00 00 A1 fx Accessibility tab summary: Given information for this question is presented in rows 2 through 17. Requirement information is presented in rows 20 through 32. A. B E F G H M 1. A marketing research company tests the effectiveness of three new flavorings for a new sauce using a sample of 30 people, divided randomly into three groups of 10 people each. 3. Group 1 tastes Flavor 1, Group 2 tastes Flavor 2, and Group 3 tastes Flavor 3. 4. Each person is then given a questionnaire that evaluates how enjoyable the beverage was. 5. The scores are shown below. Determine whether there is a perceived significant difference between the three flavorings. 6. Flavor 1 Flavor 2 Flavor 3 13 12 9 17 8 19 10 19 6 15 11 11 16 14 12 20 12 10 15 14 16 13 18 10 18 14 9 18 11 15 4 14 16 12 11 11 16 17 18
A1
fx Accessibility tab summary: Given information for this question is presented in rows 2 through 17. Requirement information is p
B
E
F
18
19 Required:
20 Complete the ANOVA tables below:
21
Groups
Count
Sum
Mean
Variance
SS
22
Flavor 1
23
Flavor 2
24 Flavor 3
25
26 ANOVA
Alpha
0.05
SS
df
MS
P value
F crit
27
Sources
28 Between Groups
29 within Groups
30 Total
31
alpha,
do not reject
the null hypothesis.
32 Since p-value is
33
34
35
36 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work.
37 Nothing in this area will be graded, but it will be submitted with your assignment.
38
A Graded Worksheet
II
Transcribed Image Text:A1 fx Accessibility tab summary: Given information for this question is presented in rows 2 through 17. Requirement information is p B E F 18 19 Required: 20 Complete the ANOVA tables below: 21 Groups Count Sum Mean Variance SS 22 Flavor 1 23 Flavor 2 24 Flavor 3 25 26 ANOVA Alpha 0.05 SS df MS P value F crit 27 Sources 28 Between Groups 29 within Groups 30 Total 31 alpha, do not reject the null hypothesis. 32 Since p-value is 33 34 35 36 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 37 Nothing in this area will be graded, but it will be submitted with your assignment. 38 A Graded Worksheet II
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

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