adding forumla for trendline

acapro

New Member
Joined
Jan 11, 2014
Messages
34
Hi,

I want to add a couple of formulas that were provided to me by PGC however I am having trouble working out how to add them

Pcg provided me with the below
Hi

In that case you have a 2nd degree polynomial

y = a * x^2 + b * x + c

You can get the coefficients of the trendline:

a: =INDEX(LINEST($C$3:$C$5,$B$3:$B$5^{1,2}),1)
b: =INDEX(LINEST($C$3:$C$5,$B$3:$B$5^{1,2}),2)
c: =INDEX(LINEST($C$3:$C$5,$B$3:$B$5^{1,2}),3)

and the Xmin

X= -b / (2 * a)


ABCDEFGHIJ
1
2XY
340022210a0.865X Min413.179
442022100b-714.8Y Min22059.757
544022682c169730
6
[Book1]Sheet2

<tbody>
</tbody>

What I have done is provided a link to view the actual sheet that I want to add it to (note the numbers are obviously different than PCGs)

https://jumpshare.com/v/a7G7ZlXjbSx4RDxV1sF3?b=0DdtSYr0hP0c6tGsqjvc

What I want the empty cells on the sheet (f29 and G29) to do is show the numbers that represent the lowest point of the red line (polynomial line) in PGC chart they are H3,I3 and H4,I3

Tanks in advance
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,196,308
Messages
6,014,578
Members
441,828
Latest member
cofracr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top