A marketing company is trying out 4 different commercial advertisements and want to test which one is most effective before adopting it. They want to find out if there is any significant difference between the four commercials and obtain 4 sarmples to view each advertisement. Each group is shown one of the four commercials and asked to rate on a scale of 1-10 how likely they are to buy the product based off the advertisement. The likelihood scores from the individual views for each commercial are givon bolou

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 a different question and this is only for who knows the correct EXCEL FORMULA. Please don't send a blank page. Also please give the correct and exact EXCEL FORMULA to answer the question. Thank you!
Calibri
v 11
Ev ab E-
A v
|、、、国、M< 冷
...
General
$ v 8 00
G42
• X V f
A
B
D
E
F
G
H.
K
L
A marketing company is trying out 4 different commercial advertisements and want to test which one is most effective before adopting it.
They want to find out if there is any significant difference between the four commercials and obtain 4 sarmples to view each advertisement.
2.
3
Each group is shown one of the four commercials and asked to rate on a scale of 1-10 how likely they are to buy the product based off the advertisement.
The likelihood scores from the individual views for each commercial are given below:
4
5.
6.
Commercial 1
Commercial 2 Commercial 3 Commercial 4
8
8
7
8
9
9.
8
8
10
11
4
8
10
12
7
6.
7
13
6.
8
8
14
7
6
8
15
7
6.
9
16
Required:
18 Complete the ANOVA tables below:
17
19
20 SUMMARY
21
Groups
Count
Sum
Average
Variance
フフ
Mathod 1
A Graded Worksheet
Give Feedbac
matic
Workkook Statistics
Transcribed Image Text:Calibri v 11 Ev ab E- A v |、、、国、M< 冷 ... General $ v 8 00 G42 • X V f A B D E F G H. K L A marketing company is trying out 4 different commercial advertisements and want to test which one is most effective before adopting it. They want to find out if there is any significant difference between the four commercials and obtain 4 sarmples to view each advertisement. 2. 3 Each group is shown one of the four commercials and asked to rate on a scale of 1-10 how likely they are to buy the product based off the advertisement. The likelihood scores from the individual views for each commercial are given below: 4 5. 6. Commercial 1 Commercial 2 Commercial 3 Commercial 4 8 8 7 8 9 9. 8 8 10 11 4 8 10 12 7 6. 7 13 6. 8 8 14 7 6 8 15 7 6. 9 16 Required: 18 Complete the ANOVA tables below: 17 19 20 SUMMARY 21 Groups Count Sum Average Variance フフ Mathod 1 A Graded Worksheet Give Feedbac matic Workkook Statistics
D
E
12
G
6
K
13
M.
6.
8
14
6
8
15
5
9
16
17 Required:
18 Complete the ANOVA tables below:
19
20 SUMMARY
21
Groups
Count
Sum
Average
Variance
SS
22 Method 1
23 Method 2
24 Method 3
25 Method 4
26
27 ANOVA
Alpha
0.05
df
F crit
Source of Variation
29 Between Groups
28
SS
MS
P-value
30 Within Groups
31
32 Total
33
A Graded Worksheet +
Calculation Mode: Automatic
Workbook Statistics
Transcribed Image Text:D E 12 G 6 K 13 M. 6. 8 14 6 8 15 5 9 16 17 Required: 18 Complete the ANOVA tables below: 19 20 SUMMARY 21 Groups Count Sum Average Variance SS 22 Method 1 23 Method 2 24 Method 3 25 Method 4 26 27 ANOVA Alpha 0.05 df F crit Source of Variation 29 Between Groups 28 SS MS P-value 30 Within Groups 31 32 Total 33 A Graded Worksheet + Calculation Mode: Automatic Workbook Statistics
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

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