We created a trend line graph in excel (no problems there). However, we were posed with a question that seemed like it should be easy, but we were stumped.
How does excel determine what the trend is? What is the logic behind what the graph does? I couldn't find the info in the few books we have on excel or a web search (though a link could be out there somewhere).
If you have any ideas or know the answer, it would be appreciated.