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. Group 1 tastes Flavor 1, Group 2 tastes Flavor 2, and Group 3 tastes Flavor 3. Each person is then given a questionnaire that evaluates how enjoyable the beverage was. The scores are shown below. Determine whether there is a perceived significant difference between the three flavorings. Flayor 1 Flavor 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 question is Only for who knows well the answer and the excel formula. I don't need only the filling numbers I need you to give the exact excel formula to answer the question. The correct EXCEL FORMULA. Please don't send a blank page. I had received a blank page before. Thank you!
File
Home
Insert
Draw
Formulas
Data
Review
View
Help
Ø Editing v
Calibri
B
A
$v品 囲、、
...
General
0
00
國、囲v
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.
00
A1
A.
B
C
E
F
G
H
M
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
8.
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 A $v品 囲、、 ... General 0 00 國、囲v 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. 00 A1 A. B C E F G H M 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 8. 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
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
32 Since p-value is
alpha,
do not reject
the null hypothesis.
33
34
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.
35
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 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 32 Since p-value is alpha, do not reject the null hypothesis. 33 34 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. 35 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 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