(a) Make an Excel line graph of the data on computer viruses.
(b) Discuss the underlying causes that might explain the trend or pattern.
(c) Fit three trends (linear, exponential, quadratic).
(d) Which trend model is best, and why? If none is satisfactory, explain.
(e) Make a forecast for 2003, using a trend model of your choice or a judgment forecast.
Virus Infections Per Month Per 1,000 PCs
This solution is comprised of step-by-step calculations and detailed analysis of the given problems related to Data Modeling and Forecast and provides students with a clear perspective of the underlying concepts.