How to Extrapolate Excel Graph
на канале: Excel, Word and PowerPoint Tutorials from Howtech
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.
Смотрите видео How to Extrapolate Excel Graph онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel, Word and PowerPoint Tutorials from Howtech 27 Апрель 2013, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 315,433 раз и оно понравилось 258 людям.