Hey guys,
how can I find the value of "i" within the formula below, with a linear interpolation in Excel?
thx
Tobi
Hey everyone, I am looking to see if you can help me with an obstacle I've encountered.
I want to create a table or algorithm that can predict the energy use of a device given different variables. (please see attachments)
So at any given Amplitude, I want to be able to predict the energy use given the Rate and Pulse Width.
I think I could do this if there were two variables, but since there's three, I wanted to look for some help.
In the tables, you can see that the energy use (the many data points in the middle) are given for a select set of rates or pulse widths. Please help me use interpolation (or absolutely anything else!!!) that can help me estimate other values.
Thanks a million for your help!
I have to calculate interest rates for dates between posted dates
My bank has given me the following.
The rate on 05/17/2017 is 3.7973%.
The rate on 08/15/2017 is 3.7235%.
The requested date is 07/15/2017 and the bank interpolated the rate to 3.7482%.
I need a formula where I have three dates and 2 rates, and I can interpolate the missing rate.
Any clues?
Thanks a lot.
jray
Hi,
I am not sure what formula is best suited for linear interpolation using the formula:
(xmax-xmin)
X=
X min
+
( y -ymin)
X
(ymax-ymin)
X is titer
y is signal
If i use the forecast function using the manually selected x,y max and min values i do get the correct x values using a known y value. Although i would like to interpolate using a range of x values from a signal standard curve and corresponding titer values (1:3, 1:9......) without having to enter the max/min values manually.
Thanks
I am trying to figure out how to interpolate. I know that "TREND" will interpolate between two points, but I want Excel to do something a little more sophisticated. I will explain below with an example.
x y
1 18
10 15
20 12
30 9
40 6
I want to tell excel to give me a y value for any given x. My x could be anything between 1 and 40.
I have heard that there is an ADD-IN in excel that will interpolate. Something along the lines of "INTERPOL". If this is true....could someone tell me how to get this in excel.
Hi All
I have a quarterly US GDP data from 1980 to date. The problem I have is given the data is only produced quarterly I have gaps in the data. This is fine when drawing a chart in excel as you can simply join data points however, an external provider I use to publish charts does not have this feature on its software and I am required to provide a value for every date. I therefore need to interpolate (linear) the values between data points. This is easily done manually on a small data set however I wonder if anyone has a piece of VBA code to speed things up.
Thanks
Hi,
I have a set of data that has monthly (or sometimes biweekly) measurements.
However, I need to interpolate the daily values using the actual consecutive
data. However, I do not want to put a best-fit line or curve through the data
for the whole year. I want the program to pick between two consecutive
values, and depending on their relationship (linear increase or decrease),
fill in the gaps between them and spit out the corresponding values. For
example, I have the following set,
Date Value
Jan. 10 0
Jan. 15 5
what I need is this:
Date Value
Jan. 10 0
Jan. 11 1
Jan. 12 2
Jan. 13 3
Jan. 14 4
Jan. 15 5
However, the next day could be Feb. 2 and the values could be negative and I
want the program start filling the days between Jan. 15 to Feb. 2 without
using the Jan. 10 value. I hope I am making myself clear. I dont know if
there is a program, macro or a function that can do that. I would appreciate
if you could help me.
Thanks in advance,
Taha
I need to create a macro that will perform a interpolation based on a table I have. It needs to read the spread from C10:C16 and YTM from D9:H9 and return the percentage.
YEARS TO MATURITY
SPREAD
1
3
5
10
20
Spread
Maturity
Result
0
2%
2%
4%
4%
4%
200
3
200
3%
3%
3%
3%
3%
500
6%
8%
10%
12%
15%
800
10%
12%
13%
19%
20%
1000
12%
15%
19%
22%
25%
1200
22%
25%
30%
35%
40%
1500
40%
45%
50%
50%
50%
The spread to lookup is in J10, the YTM in K10 and I would like the result to show up in L10.
Creating this has been way over my head, so any help would be greatly appreciated.
Thanks.
I have a time series data set with stock prices like below. I would like to do linear interpolation in the blank cells - how is that possible with an excel command?
Thanks in advance!!
Date Price
02-06-2009 84.8
01-06-2009 86.3
29-05-2009
28-05-2009
27-05-2009 92.67
26-05-2009 92.97
25-05-2009
22-05-2009 87.3
21-05-2009 88.67
20-05-2009
19-05-2009 93.45
18-05-2009 100.63
15-05-2009
14-05-2009 109.97
13-05-2009 112.3
12-05-2009 100.3
11-05-2009 97.63
08-05-2009 93.93
07-05-2009 125.93
06-05-2009 143
05-05-2009 137.9
04-05-2009 136
01-05-2009
30-04-2009 130
