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
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
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F104d7b9e-f373-4213-a783-db7b5068e15b%2Fcdcaa9a4-ae7a-45a8-ac73-91f3356f7602%2Fcg166nm_processed.jpeg&w=3840&q=75)
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F104d7b9e-f373-4213-a783-db7b5068e15b%2Fcdcaa9a4-ae7a-45a8-ac73-91f3356f7602%2Fw75auq_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Trigonometry (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305652224/9781305652224_smallCoverImage.gif)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
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
![Trigonometry (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305652224/9781305652224_smallCoverImage.gif)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
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](https://www.bartleby.com/isbn_cover_images/9781337798310/9781337798310_smallCoverImage.jpg)
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,