Question

Please use excel:

To assess the effectiveness of a cola video ad, a random sample of 38 individuals from a target audience was selected to participate in a copy test. Participants viewed two ads, one of which was the ad being tested. Participants then answered a series of questions about how much they liked the ads. An adindex measure was created and stored in Adindex; the higher the adindex value, the more likeable the ad. Compute descriptive statistics and perform an appropriate test to determine if there is a difference between the two ads. State your hypotheses, your findings and conclusions in a report. (Use the 0.05 level of significance.)

Respondent	Cola A Adindex	Cola B Adindex
1	12	21
2	24	24
3	18	18
4	12	15
5	21	18
6	12	18
7	15	21
8	24	24
9	9	18
10	9	21
11	24	18
12	18	27
13	18	9
14	24	21
15	27	18
16	18	15
17	9	15
18	15	30
19	21	18
20	15	24
21	24	30
22	21	27
23	6	21
24	24	27
25	15	15
26	15	24
27	12	21
28	21	21
29	15	21
30	18	12
31	21	18
32	21	27
33	21	24
34	30	24
35	27	30
36	24	27
37	15	27
38	30	21

Answer 1