Im wanting to generate a formula to generation regression values, without the need to redo series values in graphs. Values in range (A2:A7) are changeable.
I have a workbook with the following values
A2=10
A3=20
A4=30
A5=40
A6=50
A7=60
A17=10
I’m wanting to generate a formula in cell C17 that will show the best R2 value, either by using Exponential / Linear/ Logarithmic / Polynomial / Power or Moving Average types. This will be obtained from calculating the highest r-squared value for each of the methods.
In D17 I want the test of the equation to be shown
Once the type is determined, in E17, I want to use the equation and the x value from A17 to return the Y value
I have been struggling with this for a while and nobody seems able to assist.
I have a workbook with the following values
A2=10
A3=20
A4=30
A5=40
A6=50
A7=60
A17=10
I’m wanting to generate a formula in cell C17 that will show the best R2 value, either by using Exponential / Linear/ Logarithmic / Polynomial / Power or Moving Average types. This will be obtained from calculating the highest r-squared value for each of the methods.
In D17 I want the test of the equation to be shown
Once the type is determined, in E17, I want to use the equation and the x value from A17 to return the Y value
I have been struggling with this for a while and nobody seems able to assist.
