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

Trigonometry (MindTap Course List)
8th Edition
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Charles P. McKeague, Mark D. Turner
Chapter3: Radian Measure
Section: Chapter Questions
Problem 1RP
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
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
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
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
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
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,