trend

D

Dr. Sachin Wagh

Is there any way in which I could arrive at a trend on reducing percentage
Starting with 13% for 2000 &
Dropping to 8% for 10000
So basically, when I put any value between 2000 & 10000; say, 7569 in c1, I
get the corresponding % in c2
 
M

Max

One way ..

Assume the known data below is in A1:B2

2000 13%
10000 8%

and C1 contains 7569

Put in say, C2: =FORECAST(C1,$B$1:$B$2,$A$1:$A$2)

C2 will return 9.52%
 
M

Max

C2 will return 9.52%

with C2 formatted as percentage (to 2 dp)
(via Format > Cells > Percentage > 2 dp > OK)
 
D

Dr. Sachin Wagh

Thanx a ton Max,

The graph represents a straight line decline; what I had earlier thought
that this might lead to a parabolic curve
..
. .
. .
Any comments

Regards

Sachin
 
M

Max

You're welcome !
Sorry I don't have any further comments to offer
Hang around awhile for better insights from others
 
J

Jerry W. Lewis

With only 2 known data points, you can only fit a straight line, unless
you know from outside sources the specific parametric form (assuming it
is uniquely defined by two data points).

Jerry

Dr. Sachin Wagh said:
Thanx a ton Max,

The graph represents a straight line decline; what I had earlier thought
that this might lead to a parabolic curve
.
. .
. .
Any comments

Regards

Sachin

:
Click to expand...
 
A

AlfD

Hi!

Those values are only half of the information needed. For each of these
x-values you need either a y-value, or a formula to calculate it or a
graph of some sort (drawn or expressed in coordinates, for example)
from which to read it.

You said earlier you had thought "this might lead to a parabolic
curve". What is the "this" and why do you think parabolic?

Alf
 
Top