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
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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!

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

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

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

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman