QUESTION 5
a) Briefly describe the stages in data preparation.
(5 marks)
b) The following are results of regression analysis of five (5) independent variables
regressed against sales volume. Interpret the information contained in each of the
following tables, in as much detail as possible.
Table 1 Results of Regression Analysis
Multiple R .55424
R Square .45759
Adjusted R square .45725
Standard Error .42173
DF (5,244)
F 4.578
Sig .000
Variable BETA t Sig t
Products features .33 1.768 .000
Number of salesmen .29 1.55 .000
Population density .09 0.97 .467
Purchasing power .10 1.20 .089
Promotional effectiveness .44 3.54 .000
(12 marks)
c) Based on the results of analysis, give four (4) suitable recommendations.
(8 marks)