1. I am mathematically challenged
2. I have a series of numbers such as sales per month for a 60 month period.
From these numbers I have to predict the next month, quarter’s sales. I
have to (1) enter the historic data, (2) prepare a line graph, (3) add a
trend line by choosing one of the regression types (4) set the period and ask
for the r-square value, (5)"zoom in" on the graph to find the value. (6) go
back to the worksheet and plug in the predicted number and the r-square value
and (7) repeat steps 2-6 for each of the remaining 5 regression models.
3. I could enter the formula into the work sheet if I understood it but in
case I forgot to mention it, I am mathematically challenged. This means that
I have to manually go through the process for hundreds of products times the
5 trend line models each month and then manually transfer them to the spread
sheet. Is there an easier way (besides having someone else do it?)

Thanks