How do i make a graph predict the next value from 3 tables with info
eg Table 1 has 5$ profit
Table 2 has 3$ profit
Table 3 has 8$ Profit
how do i make a graph which predicts the next set of values from these values?
How do i make a graph predict the next value from 3 tables with info
eg Table 1 has 5$ profit
Table 2 has 3$ profit
Table 3 has 8$ Profit
how do i make a graph which predicts the next set of values from these values?
The mechanics of getting a chart to predict future values is easy. Chart your data in the desired fashion, Right click on the data series, select "Add Trendline", select the desired trendline, then, under trendline properties, select forecast however far ahead you want.
Depending on what you want to do with these forecasts, sometimes it can be better to use worksheet functions (LINEST, TREND, GROWTH, FORECAST, etc) to predict the data rather than a chart trendline.
The real question, which only you can answer, is how best to forecast the data. A linear fit of all three points? A linear fit of the last two points, or the first and last, or the first two points? A polynomial curve through all three points? Something else? Recognize that there are many hazards in extrapolating data, especially data like your sample that don't show a distinct trend.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks