Finding Data in an Excel Chart

[Antynwa]

I am trying to find what x is equal to when y is equal to 4500.

 

So

 

X Y

327 2562

??? 4500

660 5846

960 9129

 

I have put the data in a chart on excel and can't seem to find the value of X when Y is equal to 4500.

 

Any tips on how to do this?

[philyhamann]

do you have any more information other than that

[Stu Monty]

Like, presumably, an algebraic formula?

[Stouffer]

[Guest The Big Green Bastard]

so you're studing algebraic equations at degree level but can't be arsed to work it out?

 

negged. lazy student lamo.

[kop]

You need more information.

[philyhamann]

You need more information.

 

yeah, i can't work shit out with just numbers.

[Antynwa]

Thats all the information I've been given.

 

I think I have got the answer anyway

[Lurtz]

Thats all the information I've been given.

 

I think I have got the answer anyway

 

I'd be interested in knowing the answer if you've got it?

[philyhamann]

Its probably something to do with some crazy ass excel feature.

 

I don't remember doing much Maths in my first year, loads in the second which I struggled through but found enjoyable compared to the rest of the course I pissed.

[luna985]

Naturally the easiest way to solve this would be a goal seek. Although this may not be a function on your excel unless you have the add-in pack installed.

 

Although it still requires some sort of algebraic function.

 

Saying that I am having a stab at 542 being the answer!

[Indian Red]

Graph it. Turns out to be linear. Then find the corresponding value at Y= 4500

[Stu Monty]

 

Clearly, Northern red has solved this problem.

[Yerma'satexan!]

Just draw a graph and fit a curve or use one of these attached methods

 

These equations assume that your sheet has two named ranges: x and y.

 

Linear Trendline

Equation: y = m * x + b

m: =SLOPE(y,x)

b: =INTERCEPT(y,x)

 

Logarithmic Trendline

Equation: y = (c * LN(x)) - b

c: =INDEX(LINEST(y,LN(x)),1)

b: =INDEX(LINEST(y,LN(x)),1,2)

 

Power Trendline

Equation: y=c*x^b

c: =EXP(INDEX(LINEST(LN(y),LN(x),,),1,2))

b: =INDEX(LINEST(LN(y),LN(x),,),1)

 

Exponential Trendline

Equation: y = c *e ^(b * x)

c: =EXP(INDEX(LINEST(LN(y),x),1,2))

b: =INDEX(LINEST(LN(y),x),1)

 

2nd Order Polynomial Trendline

Equation: y = (c2 * x^2) + (c1 * x ^1) + b

c2: =INDEX(LINEST(y,x^{1,2}),1)

C1: =INDEX(LINEST(y,x^{1,2}),1,2)

b = =INDEX(LINEST(y,x^{1,2}),1,3)

 

3rd Order Polynomial Trendline

Equation: y = (c3 * x^3) + (c2 * x^2) + (c1 * x^1) + b

c3: =INDEX(LINEST(y,x^{1,2,3}),1)

c2: =INDEX(LINEST(y,x^{1,2,3}),1,2)

C1: =INDEX(LINEST(y,x^{1,2,3}),1,3)

b: =INDEX(LINEST(y,x^{1,2,3}),1,4)

 

Higher Order Polynomial Trendline

Notice the pattern in the two preceding sets of formulas

 

BOOM!