Reference no: EM13949217
A consumer products company wants to measure the effectiveness of different types of advertising media in the promotion of its products. Specially, two types of advertising media are to be considered: radio and television advertising and newspaper advertising (including the cost of discount coupons). A sample of 22 cities with approximately equal population is selected for study during a test period of one month. Each city is allocated a specific expenditure level both for radio and television advertising and for newspaper advertising. The sales of the product (in thousands of dollars) and also the levels of media expenditure (in thousands of dollars) during the test month are recorded, with the data set ADVERTISE.XLS. Using EXCEL or PHStat2, answer the following:
|
Sales
|
Radio
|
Newspaper
|
|
973
|
0
|
40
|
|
1119
|
0
|
40
|
|
875
|
25
|
25
|
|
625
|
25
|
25
|
|
910
|
30
|
30
|
|
971
|
30
|
30
|
|
931
|
35
|
35
|
|
1177
|
35
|
35
|
|
882
|
40
|
25
|
|
982
|
40
|
25
|
|
1628
|
45
|
45
|
|
1577
|
45
|
45
|
|
1044
|
50
|
0
|
|
914
|
50
|
0
|
|
1329
|
55
|
25
|
|
1330
|
55
|
25
|
|
1405
|
60
|
30
|
|
1436
|
60
|
30
|
|
1521
|
65
|
35
|
|
1741
|
65
|
35
|
|
1866
|
70
|
40
|
|
1717
|
70
|
40
|
a) State the multiple regression equation.
b) Interpret the meaning of the slopes b1 and b2 in this problem.
c) Interpret the meaning of the regression coefficient b0 in this problem.
d) Predict the average sales for a city in which radio and television advertising is $20,000 and newspaper advertising is $20,000.
e) Set up a 95% confidence interval estimate for the average sales for cities in which radio and television advertising is $20,000 and newspaper advertising is $20,000.
f) Set up a 95% confidence interval estimate for the sales for an individual city in which radio and television advertising is $20,000 and newspaper advertising is $20,000.
g) Determine whether there is a significant relationship between sales and the two independent variables (radio advertising and newspaper advertising) at the 0.05 level of significance.
h) Interpret the meaning of the p-value.
i) Determine the coefficient of multiple determination, r2.
j) Determine the adjusted r2.
k) Perform a residual analysis on your results and determine the adequacy of the fit of the model.
l) Set up a 95% confidence interval estimate of the population slope between sales and radio and television advertising.
m) At the 0.05 level of significance, determine whether each explanatory variable makes a significant contribution to the regression model. On the basis of these results, indicate the independent variables that should be included in this model.
n) Compute the coefficients of partial determination, r2Y1.2.and r2Y2.1.and interpret their meaning.
|
Find the standard error of the estimate
: Determine the coefficient of determination, r2, and interpret its meaning. Find the standard error of the estimate. How useful do you think this regression model is for labor hours?
|
|
Information contained in the articles reliable
: Locate two articles from the University Library or the Internet and discuss the following, in 75 to 100 words per article: Is the information contained in the articles reliable? Explain.
|
|
Did they always interpret biblical texts literally
: Did they always interpret biblical texts literally? What methods did they use? Give one example of each of these methods. Briefly discuss their advantages and disadvantages
|
|
Structure the information and how is it organized
: Reflect on, and write down the purpose of your site and your target audience. What is your goal for the site? That is, how do you want to present yourself to prospective employers, graduate school or online?
|
|
Determine the coefficient of multiple determination, r2
: Determine whether there is a significant relationship between sales and the two independent variables (radio advertising and newspaper advertising) at the 0.05 level of significance. Interpret the meaning of the p-value.
|
|
Question does participation in sports build character
: Write an essay (500-750 words) discussing the question does participation in sports build character? Your opinion needs to be supported by research that you have completed on the topic and the research needs to be sited at the bottom of the paper..
|
|
Belgian chocolate company makes dark chocolate
: Belgian Chocolate Company makes dark chocolate and light chocolate. Both products require cocoa and sugar
|
|
Will increase in sales affect net working capital and npv
: The minimum return that must be earned on a project in order to leave the firm's value unchanged is: The interest rate, the cost of capital, the compound rate, or the internal rate of return?
|
|
Which plan would you recommend to christensen
: If the yield curve is steeply inverted, which financing plan should Christensen choose? Which plan would you recommend to Christensen? Why?
|