Harry manages a sales force which sells several products in different sales territories. A random

sample of 25 territories were selected and the data is provided in an Excel worksheet labelled

Harrys. The variables include total sales credited to the sales representative (Sales), the length of

time employed in months (time), the market potential (Poten), the advertising expense for the

territory (AdvExp), the market share (Share), the change in market share over the previous three

years (Change), the number accounts assigned to the sales representative (accounts), an index

representing the workload (work), the rating on the last performance review (rating) and whether it

is a star territory (star territories have performed well in the past).

Using the methods discussed in this class, determine the "best" regression model to predict Sales.

Write a brief report (less than two pages) summarizing your analysis, including key statistical

results, conclusions, and recommendations. Include any appropriate technical material in an

appendix.

Note: Please use linear regression, multiple regression or logistic regression.