How to Extrapolate Excel Graph
In this video tutorial we will extrapolate Excel graph to find predicted values.
Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
/ ithowtovids - our feed
/ howtechtv - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+
Extrapolating is one of the weaknesses of Excel when interpreting data. We can find out extended values on a graph by the help of the formula instead of the data.
Follow this easy step by step tutorial to learn how to extrapolate Excel graph and obtain prediction.
Step # 1 -- The graph
Firstly, we will acquire excel graph with very little data values. It can be created by entering a list of values corresponding to any set of measurable items. Then we will select the information and use the insert option to make a graph in excel.
Step # 2 -- The Trendline
Once we have the excel graph, navigate to the tab on the ribbon which is under the chart tools group. Click the Trendline button to view the list of trendlines and click the more trendline options. Select the logarithmic trendline in the popup window. Before leaving the window, adjust the forward period as per requirement.
A trendline then appears on the graph showing estimated extrapolated values.
This is the simplest way to extrapolate excel graph to predict or obtain prediction.
Watch video How to Extrapolate Excel Graph online without registration, duration hours minute second in high quality. This video was added by user Excel, Word and PowerPoint Tutorials from Howtech 27 April 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 315,433 once and liked it 258 people.