How to Extrapolate in Excel

In the process of calculating values ​​outside a known area of ​​numerical data, Microsoft Excel comes to the rescue. To automate the calculation process, it is enough to take the available data as a basis and perform a few simple steps. Here is a step-by-step instruction with explanations on how to extrapolate data in Excel below.

How to Extrapolate in Excel

Tabular Data Extrapolation

For example, we use the data from the following table, which displays the dependence of the function values ​​on the x argument.

In this case, this is the number of manufactured units of output over a certain time in minutes.

Tabular Data Extrapolation in Excel

As we see, for our example, the number of units of output manufactured every 15 minutes of time from 0 to 120 minutes (2 hours) inclusive is known.

To extrapolate this data in Excel, you must perform the following steps consistently.

  • We determine the x number, in relation to which it is necessary to make a forecast. 

In our case, this is a time period for which it is necessary to determine the number of manufactured products.

For example, we are interested in a period of 5 hours 15 minutes, or 315 minutes. We add the following value of the argument we are interested in: 315 in the “x” column.

We add the following value of the argument: 315 in the “x” column - Extrapolate in Excel
  • Select the cell in which we want to get the desired result, and click on the function wizard icon.
Select the cell in which we want to get the desired result - Extrapolate in Excel
  • Enter “forecast” in the search box of the function wizard, and click on the found function. Press “Enter” or click on the “Insert function” button.
Enter “forecast” in the search box of the function wizard - Extrapolate in Excel

In the window of the function values opened, enter the following data:

  • In the “x” field: the address of the cell with the “x” value of our interest (it is 315 in our case) – for this purpose, we click on the corresponding cell;
Enter the address of the cell with the “x” value - Extrapolate in Excel
  • In the “known_y’s” field, we enter the range of values ​​in the f (x) column (in our case, from 100 to 800 pieces) – by also selecting this range with the mouse;
Enter the range of values ​​in the f (x) column - Extrapolate in Excel
  • In the “known_x’s” field, we enter the corresponding range of values ​​of the “x” column (in our case, from 15 to 120 minutes), as in the previous subparagraph.
Enter the corresponding range of values ​​of the “x” column - Extrapolate in Excel
  • Press “Enter” on the keyboard or click the “Done” button.
  •  And the desired result will appear in the corresponding cell – in our example, this is the number 2,100, i.e. 2,100 units of products will be manufactured in 3 hours 15 minutes using the extrapolation method.
The desired result will appear in the corresponding cell - Extrapolate in Excel
  • In the same way, we can calculate the value of f (x) for any desired value of x. To do this, you should add the known time values ​​(in our case) to the “x” value column, and copy the formula that we entered into the corresponding cell in step 2 into the following cells next to the x values.
Calculate the value of f (x) for any desired value of x - Extrapolate in Excel

So, we figured out how to extrapolate data in Excel. As it turned out, this is not a complex task even for a basic user. It is enough to know the necessary function and have the corresponding numerical data for calculations. Following the steps described above, all the steps for calculating extrapolation in Excel will be simple and straightforward.

Expert
William
43 articles888 likes
0 responses
Sign in to wright a response.
Read this next
Microsoft Excel, a popular spreadsheet program, is equipped with a wide range of tools for creating any and all graphs and charts. With their help, you can visually show the dynamics of various numerical data and the relationship between them. Very often, a standard curve graph is used for these purposes.
William
Microsoft Office Programs
To understand how to calculate the relative frequency in Excel, you should only take a few simple steps. We will also show how to build a colorful and informative histogram based on the data received.
William
Microsoft Office Programs
Why may it become necessary to freeze multiple rows in Excel? For example, to keep column headings always in sight when scrolling. In this article, we’ll tell you how to freeze multiple rows in Excel.
William
Microsoft Office Programs
Reviewed by
William
43 articles888 likes
Do you have any question?
Try to use search or ask your question by clicking the button below
Was this article helpful?
No
We’re so sorry :(
Yes
Thanks a lot :D