In 2007 Pronto Ltd ascertained the amount spent on advertising and the corresponding sales revenue by seven

Question:

In 2007 Pronto Ltd ascertained the amount spent on advertising and the corresponding sales revenue by seven marketing clients (Table 8.14).

(a) Plot a scatter plot and comment on a possible relationship between sales and advertising.

(b) Use Excel regression functions to undertake the following tasks:

(i) Fit linear model 

(ii) Check model reliability (r and COD)

(iii) Undertake appropriate inference tests (t and F test)

(iv) Check model assumptions (residual and normality checks)

(v) Provide a 95% confidence interval for the predictor variable.

Advertising (000s), x Table 8.14 2 LO 5 4 6 3 7 8 Sales (000s), y 60 100 70 90 80 105 115

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics Using Excel

ISBN: 9780199659517

2nd Edition

Authors: Glyn Davis, Branko Pecar

Question Posted: