Question

WHATS FORMULA MUST BE USED IN EXCEL TO ANSWER THE BELOW QUESTIONS.

In the book Essentials of Marketing Research, William R. Dillon, Thomas J. Madden, and Neil H. Firtle (1993) present preexposure and postexposure attitude scores from an advertising study involving 10 respondents. The data for the experiment are given in Table 10.3.

Subject	Preexposure Attitudes (A1)	Postexposure Attitudes (A2)	Attitude Change (di)
1	50	53	3
2	25	27	2
3	30	38	8
4	50	55	5
5	60	61	1
6	80	85	5
7	45	45	0
8	30	31	1
9	65	72	7
10	70	78	8

1. Set up the null and alternative hypotheses needed to attempt to establish that the advertisement increases the mean attitude score (that is, that the mean postexposure attitude score is higher than the mean preexposure attitude score).
2. Test the hypotheses you set up in part a at the .10, .05, .01, and .001 levels of significance. How much evidence is there that the advertisement increases the mean attitude score?
3. Estimate the minimum difference between the mean postexposure attitude score and the mean preexposure attitude score. Justify your answer.

Answer 1