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
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
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)
A B C D E F G H I J 1 2 X Y 3 400 22210 a 0.865 X Min 413.179 4 420 22100 b -714.8 Y Min 22059.757 5 440 22682 c 169730 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