# Exponential Interpolation For Different Types Of Curves?

Apr 16, 2014

interpolating numbers in excel for an exponential function. I want to know how to be able to curve a curve in 4 different ways essentially the 2 that make up the two halves of a peak and the 2 that make up the two halves of a trough. I've tried using the LINEST function to create this interpolation and it's good to get 1 of the 4 curves I'm interested in. how to do the other 3? I'm also interested in knowing if these functions "whip the tail up" as in almost like how the tail end of a "sin" function flips back up. here it is.

[URL]

For this example of the exponential function, it creates the curve in one particular direction. I was wondering how I would do it to have it curve in another direction, for example I was testing the same function, but going downwards, and also having the tail curve back up (by hump I mean to simulate a gaussian distribution with the tails) how would I do that. seems like I now have part 1 of 4 aspects of the curve. here's the attached file to show what I mean. I want to get the hump going up and then sort of reflected along the y-axis and then similar features if I were to reflect the curves on the x axis. is it possible with the functions in excel? Linest test.xlsx

## Excel 2007 :: Exponential Interpolation

Dec 12, 2013

I have a frequency table (attached) that I need to be able to interpolate values between the known values on something other than a linear basis (e.g. exponential or logarithmic).

## Comparing To Curves In A Graphic

Aug 16, 2009

I want excel to compare both curves, like the maximun % of difference between them. I dont have to same points for both of the curves so i cant do it manually.

## Averaging Velocity Time Curves

Nov 12, 2008

I have different velocity-time curve. I need to average different curve, but the duration of each set of time series is different (for example one set is 1.8 s, one other is 1.78 s...) I know I will have to interpol the data, but I do not know how to write a macro for that.

## Display Intersect Point On Graph With Two Curves?

Oct 2, 2004

If I have a graph with 2 series of data plotted, how can I display the x-axis' value when these 2 curves intersect each other?

## Exponential Format

Apr 25, 2008

I am working with a program that creates numbers as follows:

Instead of -2.74E-6, the program writes -2.74-6. The E is left off to save space.

When I import this data, Excel automatically "does the math" so the cell reads: -8.74 instead of -2.74E-6.

## Nonlinear Interpolation

Feb 27, 2007

I have data that consists of a set of coordinates that is indirectly related to an angular measurement. The data set that I have consists of four sets of coordinates and four coresponding angles. The data is below.

angle,43.09,34.83,26.8,18.08,
X,174.24,187.45,202.18,213.87,
Y,140.13,121.84,103.3,81.46,

How can I get excel to give me values for X and Y based on an angle that I input, such as 22.45. plotting a graph of the X and Y gives a curved output, so the methods that I know of do not seem to be working.

I have other more complex sets of data with complex curves that I would like to use a similar method to mine data.

## 2D / Bilinear Interpolation

Sep 2, 2008

I have a dataset of 360 columns and 180 rows in Excel 2007 and I want to increase the resolution of the dataset by 2 (i.e. I want to insert a value between each pair of cells, both vertically and horizontally). The calculation (interpolation) need not be complicated - I was thinking along the lines of a simple bilinear interpolation, where each new value is based on an average of the 4 cells surrounding it.

I'm fairly new to this type of operation in Excel, so I'd appreciate it if any responses I receive aren't too vague!

## Linear Interpolation

Feb 10, 2007

need an excel simple formula or function that returns values of y for given x in a two-dimensional array and works in the following way.actually a combination of linear interpolation and lookup/linear search. as in following example

x y
1 10
2 15
3 20

if x=1.5 then y=12.5 (answer available thru FORECAST but incomplete)
if x=2 then y=15 (answer available thru LOOKUP but incomplete)

so for whatever the x i need/get a valid y thru a single formula/method !
sorry m not good in math,

## Exponential Value For Larger Numbers?

Feb 27, 2014

I have the following data

A1 - 65.23
A2 - 1923.52
A3 - 945.18
A4 - 182.54

In column B

B1 =exp(A1)
B4 =exp(A4)

both are fine, however

B2 =exp(A2) - it is showing #NUM
B3 =exp(A3) - it is showing #NUM

Same case for all larger numbers

## Calculate Exponential Forecast

Jun 18, 2008

I have inherited a series of data relating to a change in a specification over a period of time and a number of cycles.

See attached.

There is already a chart which shows the data and has an exponential line.

I want to find the value of Cycles where the Average Flash exponential from the chart line is 0.131.

FYI this is to plot deterioration in a piece of tooling, 0.131 being the accepted warning level. If you feel there is a better statistical model to use for that application then I'm all ears!

## Taking Number In Between For Interpolation

Jun 16, 2014

I need to take number in between cells. For example, I have numbers 1, 2, 3, 4, 5, 6, 7. When I type 5 in a column, I want to have 4 and 6, above and below 5. I am doing this to ease interpolation, so that whenever I want to do interpolation, I just need to type what number, I would like to have to be interpolated.

Attached file is the example : Matic Interpolation.xlsx‎

## Bi-linear Interpolation VBA Code

Feb 10, 2009

I have 3 equations and have created the relevant chart from them. What I would like to do is put in a value of x & y and get result z. Having done a search through previous threads I found some BiLinear Interpolation code that works using the table in a workbook, but what I'd really like is the Interpolation of the formulae rather than the resulting table and for it to be embedded in VBA.

## Interpolation On Multiple Criteria

Jun 30, 2007

Is there a excel spreadsheet function that can be used to interpolate between two columns of data? If not, can you recommend a quick equation to perform interpolation? I tried with "IF(AND" conditions, but we can't use it for more than 7 set of values

## Calculate Linear Interpolation

Oct 4, 2007

In the attached sheet, I have measured data from a device. It shows Input, Output, gain and delta. You can see as input increases, delta comes down. I want to find the output corresponding to delta od -1. In the table, I have enteries for delta of -0.982 then -1.382, not for -1. How to find output corresponding to delta of -1?

## Changing Default Exponential Format

Jan 28, 2014

In excel if it changes number to exponential format it would default to, for example if number is 12345 -> 1.2345e4, 0.012345 ->1.2345e-2

I was wondering it is possible to which a function to change this default format ie for example 0.012345 -> 12.345e-3

I basically want this kind of formatting as its would display information in terms of milli, micro, pico (or the opposite side kilo, mega, giga and so on).

## Avoiding Exponential Numbers During Import

Dec 16, 2008

I have some short code that imports data and account numbers that is "|" delimited. The problem I am having is that during the import, excel converts some of the account numbers to exponential numbers.

e.g. it converts 542690E24 to 5.4269E+29.

Is there a way to avoid this from occuring during the import? I tried to format the destination cells as '000000000' (all accounts are 9 digits) but it didn't work.

## Exponential Weight Volatility Average

Jul 25, 2006

to write a function that will exponentially weight a series of returns by a certain decay factor.

I have excel spreadsheets that can do this over several columns, like this

series of returns... rtns squared
2.50% =2.50%*2.50%
3.50% =3.50%*3.50%
5.00% =5.00%*5.00%
1.01% =1.01%*1.01%
0.75% =0.75%*0.75%
4.01% =4.01%*4.01%
-2.78% =-2.78%*-2.78%

## Find Row Number Of Value From Table For Interpolation?

Feb 13, 2014

which function to use to find the row number of a value for interpolation.If I have a table of 5rows and 5 cols, how to find those rows of those 2 numbers between which my interpolation should be done.

X Y
2.2 3.45
2.9 4.56
3.3 6.2
3.7 7
4 8.1

Now I want to interpolate for 3.1. So how to find the row numbers of 2.9 and 3.3

## Derive Exponential Function From Limited Information

Dec 5, 2009

I've been working on a ss that requires me to create a function to determine a value from a exponential curve where the area of the curve is variable . The terminal points, 0,0 and 100,100 remain constant and the curve is symmetrical at the 45degree angle. How can I derive a function knowing only these things.

Here is an image to crudely illustrate what i mean [url]

The area can be 10, 20, 35% it doesn't matter, I need a way to determine the function from just the area!

## Exponential Trend Line Is Off From Input Data

Dec 6, 2013

I am trying to find the exponential equation from a set of data in excel. The problem is that the graph does not follow the scatter plotted points on the graph. How would you remedy this?

## Code Converting Text To Exponential Notation

Dec 26, 2009

I have a bit of code that is grabbing only the first 9 positions of an alpha-numeric string. The problem I am running into is that when the alpha-numberic value contains an "E", the code turns it into an exponential number in error.

For example, I have the following in column G: 01877E107000. When I run the code, it turns into an alpha-numeric value. The result should be 01877E107 (in column K). I tried using the text function within the code.

## Exponential Number (formatted As Text) Appearance

May 1, 2007

I was wondering if anyone could tell me how to do away with the "Exponential" appearance of numbers (in Excel) when they are formatted as text. I am working with National Stock Numbers and there are no required computations based on them being formatted as a number ... AND ... one of my constraints is that they are required to be formatted as text when imported into an Access database ...

## Write Double Interpolation Formula For Table?

Apr 16, 2014

Power.jpg I must write a double interpolation formula for the table.

## Interpolation Between Values And Return Them To Excel Sheet (using VBA)

Apr 18, 2014

I am looking for a VBA code which can be used to interpolate between values at a given interval and return these values to an excel sheet. I have a list with X and Y values and need to interpolate (linear) between two X points to return intermediate values for Y (interval between values is defined by the user in a userform). The code is to continue with interpolation between two consecutive X points until it has reached the end of the listing. In the example only several points are given, but the list can be longer or shorter than given in the example. The results need to be returned to a new sheet.

## Create Interpolation For Water Flow In Given Area

May 29, 2014

I am trying to create an interpolation for water flow in a given area. Tables below for better understanding:

Inputs Required

Area
3
km2

L
5
km

L2/A (Calculated)
8.3

[Code] ......

The idea is that when I increase the input area, I would like to interpolate between the RFFP frequency for the flow Q50/Q20 that best fits the area and provide me with a peak flow rate.

## Stop Hexadecimal Number Displaying As Exponential & Convert To Decimal

May 31, 2008

I use hex2dec frequently and input with a hex 'E' such as 05e8 is misinterpreted as exponential notation. I can use =hex2dec("05e8") to get the correct value, but when the hex number is in another cell, I get the exponent assumption/ conversion (to 5 x 10e8), or a # NUM error if it is in quotes. This seems like a blatant problem but I've found no mention of it in searches or FAQs.

## Counting TYPES Of Duplicates

May 23, 2014

I have a dataset that has a good number of duplicates, many of which have more than 2 records.

In these sets of duplicates, there are two fields that have many combinations of values.

I would like to find a way to COUNT THE COMBINATIONS in all of the sets of duplicates, as in, every time there is a type of a certain combination of values, create a count for it:

12345 9 9
12345 9 0

123456 9 9
123456 9 0

(Total: 2) For 9/9 and 9/0

12344567 0 0
12344567 0 0
12344567 0 0

12344567 0 0
12344567 0 0
12344567 0 0

(Total: 2) For 0/0 3x

I have attached a listing of types of combinations that I found by scanning the database, but I don't know what formula or functions would do the trick. I don't think there is something in Subtotal or the Count functionality that would apply but I will fumble around.

## Filtering For Multiple Pay Types

Sep 9, 2009

I need to find the total \$ collected on repair orders that contain customer pay and warranty repairs. The problem is that C and W show up on differerent rows, if an RO has 4 lines 3 may be c and 1 line w. I don't know how to use pivit tables to get the info I am looking for, or if that is the best way to fnd my answer.

## Incompatible Data Types

Sep 8, 2009

I have a problem concerning datatypes for an if-loop, the failure message tells me "Datatypes incompatible" for this code-line: