Refer to the data (data2.xlsx) of advertising budget (ADEXP), measured in millions of US dollars, of 21 firms for a certain year and millions of impressions retained per week by the viewers of the products of these firms (IMPRESSION).

(a) Plot impressions on the vertical axis and advertising expenditure on the horizontal axis.

(b) Does the graph reveal a linear relationship between the two variables?

(c) Fit a linear regression model and assess the effect of advertising expenditure on impressions.

(d) Fit a quadratic regression model and assess the effect of advertising expenditure on impressions. What are the effects of the first and second million US dollars of ADEXP on IMPRESSIONS? What is the level of advertising expenditure beyond which ADEXP has negative effect on IMPRESSIONS? Is this negative effect reasonable based on the sample of data?

(e) Use the AIC statistic to select between the two models.

IF CAN, THE GRAPH IS MADE BY USING EVIEWS! THANK YOU!

TABLE E3.3 Number of Retained Impressions and Advertising Expenditures \begin{tabular}{lcc} \hline Firm & Amount Spent (Millions) & Retained Impressions per Week (Millions) \\ \hline Miller Lite & 50.1 & 32.1 \\ Pepsi & 74.1 & 99.6 \\ Stroh's & 19.3 & 11.7 \\ Federal Express & 22.9 & 21.9 \\ Burger King & 82.4 & 60.8 \\ Coca-Cola & 40.1 & 78.6 \\ McDonald's & 185.9 & 92.4 \\ MCI & 26.9 & 50.7 \\ Diet Cola & 20.4 & 21.4 \\ Ford & 166.2 & 40.1 \\ Levi's & 27 & 40.8 \\ Bud Lite & 45.6 & 10.4 \\ ATT Bell & 154.9 & 88.9 \\ Calvin Klein & 5 & 12 \\ Wendy's & 49.7 & 29.2 \\ Polaroid & 26.9 & 38 \\ Shasta & 5.7 & 10 \\ Meow Mix & 7.6 & 12.3 \\ Oscar Meyer & 9.2 & 23.4 \\ Crest & 32.4 & 71.1 \\ Kibbles N Bits & 6.1 & 4.4 \\ \hline \end{tabular} TABLE E3.3 Number of Retained Impressions and Advertising Expenditures \begin{tabular}{lcc} \hline Firm & Amount Spent (Millions) & Retained Impressions per Week (Millions) \\ \hline Miller Lite & 50.1 & 32.1 \\ Pepsi & 74.1 & 99.6 \\ Stroh's & 19.3 & 11.7 \\ Federal Express & 22.9 & 21.9 \\ Burger King & 82.4 & 60.8 \\ Coca-Cola & 40.1 & 78.6 \\ McDonald's & 185.9 & 92.4 \\ MCI & 26.9 & 50.7 \\ Diet Cola & 20.4 & 21.4 \\ Ford & 166.2 & 40.1 \\ Levi's & 27 & 40.8 \\ Bud Lite & 45.6 & 10.4 \\ ATT Bell & 154.9 & 88.9 \\ Calvin Klein & 5 & 12 \\ Wendy's & 49.7 & 29.2 \\ Polaroid & 26.9 & 38 \\ Shasta & 5.7 & 10 \\ Meow Mix & 7.6 & 12.3 \\ Oscar Meyer & 9.2 & 23.4 \\ Crest & 32.4 & 71.1 \\ Kibbles N Bits & 6.1 & 4.4 \\ \hline \end{tabular}